Data Engineer - (Snowflake + BI)

AllataPune, India | MaharashtraHybrid, Onsite

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!

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.Apply for this job

Life at Allata

Thrive Here & What We ValueAllata 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.</s> | Collaborative environment | Emphasis on innovation and creativity | Opportunities for growth and development | Flexible work arrangements | Positive and supportive work culture</s> | Allata values differences and is 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.</s> | 1. Agile, crossfunctional teams work closely with clients to deliver measurable results and build lasting partnerships. | 2. Empowers clients to unlock data value through analytics and visualization and leverages artificial intelligence to automate processes and enhance decisionmaking. | 3. Collaborative mindset and strong leadership skills. | 4. Focus on defining business vision, optimizing processes, and creating engaging digital experiences. | 5. Strong internal controls and compliance with GAAP principles.</s> | 1. Agile, crossfunctional teams working closely with clients | 2. Emphasis on building lasting partnerships | 3. Focus on delivering measurable results | 4. Collaborative and efficient work environment | 5. Commitment to continuous improvement</s> | Allata is an equal opportunity employer | Allata celebrates diversity and is 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</s> | Allata is a global consulting and technology services firm that helps organizations accelerate growth, drive innovation, and solve complex challenges by combining strategy, design, and advanced technology. They empower clients to unlock data value through analytics and visualization and leverage artificial intelligence to automate processes and enhance decisionmaking. Allata's 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.</s> | Collaborative culture that prioritizes team well-being | Positive organizational culture promoting values of collaboration, innovation, and inclusivity | Environment where team members feel valued and motivated</s> | 1. Collaborative and supportive environment | 2. Opportunities for growth and professional development | 3. Flexible working hours and remote work options | 4. Recognition and rewards for outstanding performance | 5. Positive and inclusive workplace culture</s> | Leverages artificial intelligence to automate processes and enhance decision-making.</s> | Allata is an equal opportunity employer that values differences and is committed to creating an inclusive environment for all employees. | At Allata, we celebrate diversity and are committed to creating an inclusive environment for all employees.</s> | 1. Allata values differences and is committed to creating an inclusive environment for all employees. | 2. 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.</s>