Data Solutions Engineer - MI Solutions

Milliman Ireland; Gurgaon; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A healthcare consulting firm in Gurgaon is seeking a Data Engineer to develop and maintain ETL processes and data models. This role requires 3+ years in Data Engineering, experience with Azure Data Bricks, T-SQL, and hands-on skills in SSIS and Azure Data Factory. The candidate should possess a degree in a relevant field or have significant experience. Join us in delivering solutions that impact healthcare operations significantly.

Qualifications

• 3+ years in Data Engineering.
• Experience in Azure Data Bricks with Spark SQL, Scala/Python.
• Good understanding of PowerBI and Analytical services.

Responsibilities

• Develop and maintain efficient ETL processes.
• Create and manage data models aligning with business requirements.
• Implement data processing tasks using Azure Data Brick.

Skills

Data Engineering

Azure Data Bricks

T-SQL

PowerBI

Spark

Education

BE/B.Tech/BCA/MCA/MS preferred

Tools

SSIS

Azure Data Factory

Azure DevOps

Git

Job description

The Milliman MedInsight practice has assisted many healthcare organizations in evaluating and developing solutions to complex business problems. Our consultants are experienced in the key issues related to healthcare operations and the use of technology to support those operations. Because of our focus on those unique technology and operations issues facing the healthcare industry, we are uniquely qualified to assist organizations in solving complex business problems. Our Health IT software team has been developing and selling data warehousing solutions for over twelve years.

Job Description

Job Duties:

• Develop and maintain efficient ETL processes for seamless data flow.
• Create and manage data models aligning with business requirements.
• Develop and optimize T‑SQL queries to ensure efficient data manipulation and retrieval.
• Implement and manage data processing tasks using Azure Data Brick for large‑scale data analytics.
• Design, develop, and maintain ETL workflows within Azure Data Factory for seamless data integration.
• Collaborate with stakeholders to understand and implement business requirements using T‑SQL, SSIS, Azure Data Brick, and Azure Data Factory.
• Troubleshoot and optimize performance issues in T‑SQL scripts, Azure Data Brick processes, and Azure Data Factory pipelines.
• Design and develop PowerBI report aligning with business requirement.

REQUIREMENTS:

• 3+ years in Data Engineering.
• Experience in Azure Data Bricks - have experience on spark SQL, Scala/Python.
• Good Understanding of Spark.
• Good Understanding of PowerBI and Analytical services.
• Hands on experience in SSIS/Azure Data Factory.

NICE TO HAVE :

• Experience with Azure DevOps.
• Experience with Azure Functions.
• Experience with C#/ OOPS.
• Experience with Git.
• Experience in Spark
• A passion for databases and an understanding of the solutions you implement will affect our entire suite of applications.
• Excellent problem‑solving skills.
• Performance oriented mindset.

Educational Requirements:

BE/B.Tech/ BCA/ MCA/ MS preferred. Candidates not having either of these degrees should have strong work experience of at least 2+ years.