Data Engineer (Semantic Model)

Allata is a fast-growing technology strategy and data development consulting firm delivering scalable solutions to our enterprise clients. Our mission is to inspire our clients to achieve their most strategic goals through uncompromised delivery, active listening, and personal accountability. We are a group who thrive in fast-paced environments, working on complex problems, continually learning, and working alongside colleagues to be better together.
We are seeking a skilled Data Engineer with expertise in maintaining scalable semantic models using AtScale and cloud-based data warehouse platforms.
We at IMRIEL (An Allata Company) are looking for experienced and technically strong Analytics Data Engineers to design, build, and maintain scalable semantic models using AtScale and cloud-based data warehouse platforms. This role involves developing logical cubes, defining MDX-based business measures, and enabling governed, self-service BI consumption for enterprise analytics.
Experience:3 to 5 years.Location: Vadodara & Pune
What you'll be doing:·     Design and implement robust semantic data models using AtScale that abstract curated datasets into business-consumable layers.·     Conduct a comprehensive POC to evaluate three potential semantic layer platforms: AtScale, Microsoft Fabric and Cube.dev. This includes assessing their performance, scalability, and integration with cloud-based platforms like Databricks, Snowflake, etc.·     Develop and maintain logical cubes with calculated measures, dimension hierarchies, and drill-down paths to support self-service analytics.·     Leverage MDX (Multidimensional Expressions) to define advanced business logic, KPIs, and aggregations aligned with enterprise reporting needs.·     Configure and manage aggregate tables using AtScale Aggregate Designer, optimizing cube performance and reducing query latency.·     Integrate semantic models with BI tools such as Power BI, Tableau, and Excel Pivot Tables, ensuring seamless end-user experiences.·    Collaborate with data engineers to align semantic models with curated data sources, transformation views, and data pipelines.·     Apply star and snowflake schema design to model fact and dimension tables, ensuring optimal structure for analytical workloads.·     Implement Slowly Changing Dimensions (SCD Types 1 & 2) and maintain historical accuracy in reporting models.·     Manage row-level security (RLS) and role-based access control (RBAC) policies within semantic layers for governed data access.·     Participate in semantic model versioning, CI/CD-based deployments, and technical documentation.·     Troubleshoot semantic layer performance issues using AtScale query logs, plan analysis, and catching strategies.
What you need:Basic Skills:·     Minimum 3 years of hands-on experience with AtScale, including building and maintaining semantic models, designing logical cubes, and implementing calculated measures using MDX. Proficiency in AtScale interface, modeling best practices, and performance tuning is essential.·     Advanced experience in developing and optimizing DAX expressions for complex calculations in Power BI models, with a proven ability to translate these into new semantic layer technologies like AtScale or Cube.dev. ·     Strong experience with MDX, including creating calculated members, KPIs, and advanced expressions. Excellent SQL skills with the ability to write complex queries using joins, CTEs, window functions, and performance tuning.·     Solid understanding of dimensional modeling. Ability to design fact/dimension tables using star/snowflake schemas, support SCD logic, and maintain model consistency.·     Should be familiar with the Kimball methodology for dimensional modeling, including concepts like conformed dimensions, fact table granularity, and slowly changing dimensions, to design scalable and analytics-friendly data structures.·     Hands-on experience with Snowflake, Redshift, or BigQuery. Familiarity with virtual warehouses, caching, clustering, partitioning, and compute-storage separation.·     Experience implementing RLS and RBAC. Ability to define and enforce granular access controls within semantic models.·     Strong grasp of OLAP concepts like query abstraction, drill-down/roll-up, and cube optimization. Understanding of business logic abstraction from physical data.·     Skilled in using AtScale performance tools such as the Aggregate Designer, log analysis, and query optimization.·     Proficient in managing model development lifecycle using Git, automation tools, and collaboration workflows with data/analytics teams.·     Strong verbal and written communication to document models, explain logic, and coordinate with cross-functional teams.
Responsibilities:·     Own the design, development, deployment, and maintenance of scalable, governed semantic models.·     Implement complex MDX logic and optimized aggregate strategies to meet performance benchmarks.·     Proven ability to design and implement scalable AtScale architectures, including the development of architectural blueprints and data flow diagrams.·     Evaluate and implement the best semantic layer architecture for Power BI by leveraging tools like Microsoft Fabric or other modern BI accelerators to support self-service analytics. ·     Define business measures, hierarchies, and drill-down paths in semantic models aligned with enterprise KPIs.·     Align semantic layers with upstream data transformations, curated datasets, and data warehouse architecture.·     Enforce governance and security through robust RLS and RBAC implementations.·     Continuously monitor, test, and tune semantic model performance using diagnostic tools and AtScale logging.·     Ensure semantic layer reusability, consistency, and business-aligned metric standardization.·     Collaborate with BI developers and analysts to understand reporting needs and validate model outputs.·     Maintain documentation, data lineage, and business glossaries that support transparency and user adoption.·     Contribute to reusable templates, modeling standards, and automation frameworks.
Nice-to-Have to have:·       Experience with AtScale REST APIs for metadata-driven automation and CI/CD pipelines.·       Familiarity with BI visualization platforms such as Power BI, Tableau, Looker, and Excel OLAP integration.·       Scripting experience in Python, Shell, or YAML for configuration management or automation tasks.·       Cloud certifications in Snowflake, Databricks, AWS, Azure, or Google Cloud Platform.·       Exposure to metadata management, data cataloging, or enterprise data governance tools.


At Allata, we value differences.
Allata is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
Allata makes employment decisions without regard to race, color, creed, religion, age, ancestry, national origin, veteran status, sex, sexual orientation, gender, gender identity, gender expression, marital status, disability or any other legally protected category.
This policy applies to all terms and conditions of employment, including but not limited to, recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.