Data Solutions Engineer - MI Solutions

About Milliman’s MedInsight Team 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.
• Integrate diverse data sources into a unified data repository.
• 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.
• Excellent SQL Skills(T-SQL).
• 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
• Any exposure in HealthCare domain.
• A passion for databases and an understanding of the solutions you implement will affect our entire suite of applications.
• Excellent problem-solving skills.
• Excellent communication 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.