Senior Data Architect (Modeling Specialist)

About the Role

• Lead the design and evolution of enterprise data architecture with a model-first approach.
• Define scalable, high-performance data structures that support operational and analytical business needs.
• Serve as the primary architect for conceptual, logical, and physical data models across the organization.
• Drive data strategy, governance, and modernization initiatives while reducing technical debt.
• Partner with Engineering, Product, and Business teams to build sustainable and future-ready data platforms.

Job Description

• Design and maintain enterprise-wide conceptual, logical, and physical data models.
• Define data architecture standards, integration patterns, and storage strategies.
• Balance normalized and dimensional data models to optimize operational integrity and analytical performance.
• Develop and maintain metadata repositories, data dictionaries, and lineage documentation.
• Provide technical leadership and architectural guidance to engineering and product teams.
• Lead modernization and refactoring initiatives for legacy data platforms and schemas.
• Drive data quality, consistency, scalability, and governance across the enterprise ecosystem.

Apply Now

Qualifications

Educational Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field.
• Master’s degree in Data Science, Computer Science, or a related discipline preferred.
• Professional certifications in Data Architecture, Cloud Platforms, or Database Technologies are advantageous.

Experience

• 4+ years of experience in Data Engineering, Data Architecture, or related disciplines.
• Minimum 5 years of focused experience in enterprise data modeling and architecture.
• Proven experience designing OLTP and OLAP data models for large-scale enterprise environments.
• Experience architecting cloud-native data platforms using Snowflake, BigQuery, Redshift, or similar technologies.
• Hands-on experience leading data modernization and schema optimization initiatives.
• Experience collaborating with business, product, and engineering stakeholders to define data solutions.

Skills

• Expertise in Conceptual, Logical, and Physical Data Modeling methodologies.
• Strong proficiency in Relational (OLTP) and Dimensional (OLAP) modeling techniques.
• Deep understanding of 3NF, Star Schema, Snowflake Schema, and Slowly Changing Dimensions (SCD).
• Knowledge of advanced modeling approaches such as Data Vault 2.0 and Wide-Column architectures.
• Expert-level experience with data modeling tools such as ER/Studio, Erwin, Lucidchart, or dbdocs.
• Advanced SQL expertise including query optimization, stored procedures, triggers, and performance tuning.
• Strong knowledge of ETL/ELT architectures, data integration patterns, and data lifecycle management.
• Experience with indexing strategies, partitioning, execution plan analysis, and database optimization.
• Strong metadata management, data lineage, and data governance capabilities.
• Ability to translate complex business requirements into scalable Entity Relationship Diagrams (ERDs).
• Excellent analytical, problem-solving, stakeholder management, and technical leadership skills.

Perks and Benefits

• 2-way cab pick-up and drop-off facility for a stress-free commute.
• One complimentary meal provided during the shift.
• Exposure to multiple functional areas, enhancing your professional growth.
• Supportive work environment focused on learning and development.

Training Support

• Comprehensive project-specific training will be provided to help you succeed in your role.