· Design and document dimensional, analytical, and reporting data models aligned to business requirements and best-practice modelling standards.
· Design clear mapping specifications from source systems to target dimensional models.
· Create high quality ETL connectivity and data flow diagrams
· Perform testing, reconciliation, and validation of new models and pipelines to ensure data correctness and completeness.
· Collaborate with Data Engineers, BI Developers, and business stakeholders to ensure models support analytical, reporting, and operational needs.
· Collaborate with cross-functional teams to design and optimize data management solutions
· Support the wider project team with documentation, data lineage, definitions, and modelling artefacts.
· Contribute to improving modelling standards, governance, and data quality across the project.
Stay up to date with the latest industry trends and technologies to continuously enhance our data architecture
Must-have Skills:
● Strong understanding of data modelling principles (e.g., Kimball, dimensional modelling, analytical modelling).
● Proven experience delivering or contributing to a data warehouse build or migration project.
● Hands-on experience designing analytical and reporting data models.
● ETL/ELT development experience, including analysis of existing transformation logic.
● Strong SQL skills, comfortable writing complex queries for transformation, validation, and reconciliation.
● Experience validating data pipelines and performing reconciliation testing between legacy and new environments.
● Ability to translate business requirements into robust data model designs.
● proven experience in data system design covering ingestion, staging layer design, conformed layer design and a distinct appreciation for data exploitation.
● strong inclination and experience of all aspects of Data Management: MDM, Metadata management, Cataloguing and Data Quality Management
Nice-to-have Skills:
● Experience with dbt for transformation modelling.
● Experience working within the Telecoms sector.
● Experience with AWS data platform services.
● Familiarity with BI/reporting tools and how data models support downstream consumption.
● Knowledge of data governance, metadata management, and data lineage practices.
● Experience with / knowledge of: AWS, Azure, GCP, Snowflake
● Has 10–14 years of professional experience, including significant leadership in technical delivery and strategy.
● Proactive, dynamic, and driven by delivering quality work, with a great eye for detail
● Takes accountability and ownership of tasks, and finds the best way to solve problems
● An excellent communicator who can make sense of and communicate complex ideas
● Ability to quickly understand client context and demonstrate expertise in their business
● A relationship builder, with the ability to motivate and engage effectively to build trust with clients and colleagues Enjoys working in a pragmatic, people-first environment, no corporate politics, no unnecessary processes, just smart people solving real problems together.
● An interest in industry trends, emerging technologies, and client’s businesses
Job Type: Full-time
Pay: ₹1,800,000.00 - ₹3,000,000.00 per year
Work Location: In person
