Data Engineer - (Snowflake + BI)

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.

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!

What you'll be doing:

• 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
  
  
  

What you need:

Basic Skills:

• 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
  
  
  

Responsibilities:

• 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 large-scale datasets from Azure Analysis Services (AAS) to Snowflake, ensuring data integrity, maintaining historical data accuracy, and improving system scalability
• Collaborate with BI developers, data engineers, and analysts to integrate Power BI with Snowflake, streamline data pipelines, and ensure business users have timely access to actionable insights
• Implement data governance, access control, and performance monitoring within Snowflake to support secure, reliable, and efficient data operations for enterprise-level reporting in Power BI
  
  
  

Good To Have:

• Certifications in Snowflake and Business Intelligence.
• Cloud Certifications. (Azure, AWS, GCP) Knowledge
• Knowledge of data visualization platforms such as Power BI, Tableau, or Looker for integration purposes
  
  
  

Personal Attributes:

• Ability to identify, troubleshoot, and resolve complex data issues effectively
• Strong teamwork, communication skills and intellectual curiosity to work collaboratively and effectively with cross-functional teams
• Commitment to delivering high-quality, accurate, and reliable data products solutions
• Willingness to embrace new tools, technologies, and methodologies
• Innovative thinker with a proactive approach to overcoming challenges
  
  
  

Just a heads-up before you apply — the shift for this role runs from 3:00 PM to 12:00 AM IST.

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.