Add office photos
Engaged Employer
i
This company page is being actively managed by
IMRIEL Technology Solutions Private Limited Team. If you also belong to the team, you
can get access from
here
All Filters
5 IMRIEL Technology Solutions Private Limited Jobs
Data Engineer Business Intelligence
IMRIEL Technology Solutions Private Limited
posted 2mon ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
If you are a smart & passionate team player then this Data Engineer Business Intelligence opportunity is for you!
At IMRIEL , we are seeking a technically skilled Data Engineer with deep expertise in Business Intelligence (BI) concepts, 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!
3 to 7 years. 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
- 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 SQL Server and SSAS data models to Databricks, ensuring that the transition to new architectures is seamless and performance optimized.
- Conduct a technical evaluation of Microsoft Fabric, AtScale, and Cube.dev for use as new semantic layers. Provide insights and recommendations on which platform is best suited for the business based on scalability, performance, and cost-efficiency.
- Build comprehensive star schema models to support multi-dimensional analytics, ensuring data is structured for optimal performance in reporting and business intelligence.
- Continuously monitor and optimize DAX and T-SQL queries to ensure that both query response times and resource consumption are minimized in the new semantic layer.
- Migrate large-scale datasets from Azure Analysis Services (AAS) in Power BI to the new semantic layer, maintaining data integrity and ensuring system scalability.
- Work closely with BI developers, data engineers, and business analysts to integrate the new semantic layer into existing workflows, ensuring that business requirements are met efficiently and effectively.
- Experience with Power BI, particularly in migrating models from Azure Analysis
- Services (AAS) to alternative platforms like Microsoft Fabric, AtScale, or Cube.dev.
- Certifications in platforms like Databricks, Snowflake, or Microsoft Fabric.
- Prior experience in large-scale cloud-native data migration projects, particularly in Azure, Snowflake, or Databricks environments.
- Experience conducting Proof of Concept (POC) evaluations for BI platforms, with a focus on assessing their performance, integration capabilities, and scalability.
- Strong English communication skills, with the ability to explain complex technical details to both technical and non-technical stakeholders.
- A strong problem-solving approach with a focus on optimizing data architecture and ensuring the performance of new solutions.
- Precision in translating existing data models and calculations into new platforms while maintaining data integrity and accuracy.
- Ability to work effectively within cross-functional teams, manage multiple tasks simultaneously, and deliver results within project timelines.
- Enthusiasm for learning new technologies and staying updated with trends in data engineering, BI, and analytics.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Business Intelligence Engineer roles with real interview advice
People are getting interviews at IMRIEL Technology Solutions Private Limited through
People are getting interviews through
(based on 2 IMRIEL Technology Solutions Private Limited interviews)
Referral
50%
50% candidates got the interview through other sources.
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
What people at IMRIEL Technology Solutions Private Limited are saying
What IMRIEL Technology Solutions Private Limited employees are saying about work life
based on 32 employees
Flexible timing
Monday to Friday
No travel
IMRIEL Technology Solutions Private Limited Benefits
Submitted by Company
5 days’ work & flexible working hours 25 paid leaves in one year (along with 10 other festive holidays) + Leave encashment Good Medical insurance covering spouse and kids Maternity & Paternity leave benefits Wellness program and counselling
Submitted by Employees
View more benefits 
Compare IMRIEL Technology Solutions Private Limited with
TCS
Compare
Infosys
Compare
Wipro
Compare
HCLTech
Compare
Tech Mahindra
Compare
LTIMindtree
Compare
Mphasis
Compare
Hexaware Technologies
Compare
KPIT Technologies
Compare
Maxgen Technologies
Compare
VDart
Compare
ANR Software Private Limited
Compare
Magic Edtech
Compare
Value Point Systems
Compare
F1 Info Solutions and Services
Compare
Polestar Solutions & Services India
Compare
JoulestoWatts Business Solutions
Compare
SS Supply Chain Solutions
Compare
Jumio
Compare
Saama Technologies
Compare
Similar Jobs for you
IMRIEL Technology Solutions Private Limited Pune Office Location
Pune, Maharashtra Office
Office No: 1A, 2nd Floor, Tower B-3, Cerebrum IT Park, Kalyani Nagar,
Pune, Maharashtra
411014
411014
Software Test Engineer (Jira, Selenium, Cypress, API, BDD, SQL)
2-5 Yrs
Pune
Share an Interview