Data Engineer Snowflake + BI

Allata is a global consulting and technology services firm with offices in the US, India, and Argentina. We help organizations accelerate growth, drive innovation, and solve complex challenges by combining strategy, design, and advanced technology. Our expertise covers defining business vision, optimizing processes, and creating engaging digital experiences. We architect and modernize secure, scalable solutions using cloud platforms and top engineering practices.

Allata also empowers clients to unlock data value through analytics and visualization and leverages artificial intelligence to automate processes and enhance decision-making. Our agile, cross-functional teams work closely with clients, either integrating with their teams or providing independent guidance—to deliver measurable results and build lasting partnerships.

If you are a smart & passionate team player, then this Data Engineer – Business Intelligence opportunity is for you!

We at IMRIEL (An Allata Company) are seeking a technically skilled Data Engineer with deep expertise in Business Intelligence (BI) concepts, Power Bi, including Star Schema, Hierarchies, Dimensions, Facts, Metrics, and Calculations. If you are passionate about data engineering, experienced in DAX, T-SQL, and platforms like Snowflake
, Databricks, and Microsoft Fabric, this opportunity is for you!

• Lead the migration of our existing SQL Server backend and SSAS (SQL Server Analysis Services) models to Databricks, ensuring smooth system integration and minimizing downtime.
• Conduct a comprehensive POC to evaluate three potential semantic layer platforms:
  Microsoft Fabric, AtScale, and Cube.dev. This includes assessing their performance, scalability, and integration with Databricks.
• Convert complex DAX (Data Analysis Expressions) calculations from existing Power BI models into the new semantic layer technology, ensuring consistency in data performance and accuracy.
• Architect and implement scalable Star Schema structures to support advanced reporting and analytics, focusing on creating and optimizing Hierarchies, Dimensions, Facts, and Metrics.
• Develop and optimize ETL (Extract, Transform, Load) pipelines to integrate and load data into the new semantic layer, ensuring smooth transitions from legacy systems.
• Fine-tune and optimize complex DAX and T-SQL queries, ensuring that the new semantic layer platform delivers high-performance querying and analytical capabilities.

• Expertise in BI concepts, including Star Schema, Hierarchies, Dimensions, Facts, Metrics, and Calculations as applied to large-scale data warehousing and analytics systems.
• 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 proficiency in T-SQL for querying, manipulating, and transforming large datasets. Experience in writing complex SQL queries involving joins, subqueries, and window functions.
• Hands-on experience with modern data platforms like Snowflake, Databricks, or Microsoft Fabric, with a focus on system migration, performance tuning, and building robust data architectures.
• In-depth understanding of ETL pipelines, with experience in data integration, transformation, and loading into semantic layers for scalable, high-performance analytics.

• Lead the migration of data models from SQL Server and SSAS to Snowflake, ensuring seamless transition, high performance, and cost optimization in the cloud environment.
• Evaluate and implement the best semantic layer architecture for Power BI, leveraging Snowflake's native capabilities, and tools like Microsoft Fabric or other modern BI accelerators to support self-service analytics.
• Design and build robust star schema and dimensional models within Snowflake to support advanced analytics and reporting needs in Power BI, ensuring scalability and efficiency.
• Optimize Power BI datasets and reports, including DAX expressions and T-SQL/Snowflake SQL queries, to improve performance, reduce load times, and manage compute usage effectively.
• Migrate…