Analytics Solutions Manager - Data Modeling

Role Overview :

We are looking for an experienced Analytics Solutions Manager to join our Analytics Solutions & Delivery team. The role is focused on analytics engineering, enterprise data modelling, and development of governed analytical data solutions that enable Business Intelligence (BI), reporting, and self-service analytics.

The successful candidate will work closely with business stakeholders, data engineers, analytics teams, and technology partners to translate complex business requirements into scalable dimensional data models, semantic layers, and high-quality analytical datasets.

The candidate should have strong hands-on expertise in SQL, dimensional modelling, data transformation, analytical data platforms, and cloud data technologies such as Snowflake and/or Databricks.

Key Responsibilities :

• Design and develop scalable dimensional data models supporting enterprise analytics and BI.

• Develop advanced SQL queries, transformations, and data pipelines for analytical use cases.

• Develop and maintain semantic layers that provide consistent definitions of business metrics and KPIs.

• Establish and implement data-quality checks, validation rules, and reconciliation processes.

• Design and optimise analytical models using Snowflake and/or Databricks.

• Work directly with business and technology stakeholders to understand analytical requirements.

• Identify opportunities to improve data-model performance, scalability, quality, and usability.

Required Technical Skills :

• Advanced SQL, Dimensional Data Modelling, Fact and Dimension Modelling, Conformed Dimensions, Slowly Changing Dimensions (SCD), Entity and Grain Definition, KPI and Metric Design, Semantic Layer Development, Data Transformation and Aggregation, Structured and Semi-Structured Data, JSON / Nested Data, NoSQL concepts, Snowflake and/or Databricks, Practical Python, Data Quality, Reconciliation, and Validation, Analytical Data Warehousing concepts.

Experience & Education :

• 6+ years of relevant experience in analytics engineering, data engineering, business intelligence, data warehousing, enterprise data modelling, or a closely related field.

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, Data Science, Analytics, Mathematics, Statistics, or a related discipline.