About the position
Our client is seeking an experienced Data Modeller to design, develop, and optimise enterprise-scale analytical data models. The ideal candidate will possess strong expertise in Microsoft SSAS Tabular, cube development, semantic modelling, and business intelligence solutions. The role requires close collaboration with business stakeholders to translate complex business requirements into scalable and high-performing data models.
Key Responsibilities
- Design and develop enterprise data models to support reporting, analytics, and decision-making.
- Build and maintain SSAS Tabular models and multidimensional/tabular cubes.
- Develop semantic layers that align technical data structures with business requirements.
- Create and optimise DAX measures, calculated columns, and KPIs.
- Ensure model accuracy, consistency, and alignment with business processes.
- Analyse and improve model performance, scalability, and query response times.
- Collaborate with data engineers, BI developers, and business users to define data requirements.
- Support data governance, data quality, and metadata management initiatives.
- Troubleshoot and resolve data modelling and performance-related issues.
Mandatory Skills
- Advanced expertise in Microsoft SSAS Tabular.
- Strong experience in Cube Development.
- Deep understanding of Semantic Data Models.
- Proficiency in DAX Measures and Calculations.
- Experience in Model-to-Business Alignment.
- Strong knowledge of Performance Optimisation and Tuning for analytical models.
- Experience with SQL and relational database concepts.
- Understanding of dimensional modelling techniques such as Star Schema and Snowflake Schema.
Educational Qualification
Bachelor's degree in Computer Science, Information Technology, Data Science, or a related discipline.
Preferred Skills
- Exposure to Azure Data Platform services.
- Experience with Power BI and enterprise reporting solutions.
- Knowledge of data warehousing concepts and ETL processes.
- Experience working in cloud-based data platforms and migration initiatives.
Key Competencies
- Strong analytical and problem-solving skills.
- Excellent stakeholder communication abilities.
- Ability to translate business requirements into technical solutions.
- Strong attention to detail and commitment to data quality.
Success Criteria
- Deliver high-quality, scalable data models.
- Improve analytical query performance and reporting efficiency.
- Ensure business-friendly semantic models that support enterprise analytics and decision-making.
- Client Emphasis: Candidates must demonstrate hands-on expertise in MS SSAS Tabular and Cube Development, as these skills were explicitly highlighted as critical requirements for the role.
Desired Skills:
- Systems Analysis
- Complex Problem Solving
- Programming/configuration
- Critical Thinking
- Time Management
