IT-Lead Software Engineer/29/TEC133

*** Cannot provide sponsorship upon conversion.

What is the maximum bill rate for this position? 115

What is the specific title of the position? Lead Data Engineer

Work location specify UHG/UHC/Optum location or remote/telecommute? Preferred Locations - MA or MN UHG facilities. 100 telecommute is also considered.

Work hours ex. 9am-5pm day/night shifts rotating shifts etc? 9-5

Please provide a summary of the project/initiative that this candidate will be working on?
We are establishing Agile Data Warehouse in cloud and many new AI practices to enable personalization in various capabilities to improve employee experience.

Please describe the team the candidate will be working with - how many members? 10 - 12 team members
What is the break-down of the teams skill sets ex: 1 PM 4 Developers etc.?
1 PM 3 Product owners
2 Sprint teams consisting - 1 Scrum Masters and 12 developers

What are the top 5-10 responsibilities for this position please be detailed as to what the candidate is expected to do or complete on a daily basis?

Identify opportunities for Data Engineering and AI to enhance the core product platform select the best machine learning techniques to the specific business problem and then build the models that solve the problem.

Architect and design DW and Analytics solutions and cloud services

Own the end-end process from recognizing the problem to implementing the solution.

Establish DataOps principles and best practices

What does the ideal candidate background look like ex: healthcare specific background specific industry experience etc.?
Responsibilities:

Design develop implement and maintain scalable ETL processes on Azure Cloud using Azure Synapse

implement systems and processes to monitor data quality

Ad hoc analyses troubleshooting data-related issues

Develop and maintain propriety data warehouse tools

Offer technical guidance to internal teams and business partners

Work with offshore team business analysts and other data engineering team members to ensure alignment of requirements methodologies and best practices

Participate in scrum process and deliver stories/features according to the schedule

Participate in product support activities as needed by the team

Individual contributor and Technical lead for Data Engineering - Data pipelines Data modelling and Data warehouse

Requirements :

Undergraduate degree or equivalent experience.
BE/BTech or equivalent experience
BE/BTech or equivalent experience in Data engineering

Advanced SQL knowledge capable to write optimized queries for faster data workflows.

Proven work experience in Python SQL Any RDBMS.

Experience in designing solutions for multiple large data warehouses with a good understanding of cluster and parallel architecture as well as high-scale or distributed RDBMS

Must be extremely well versed with handling large volume data and work using different tools to derive the required solution.

To be able to work in a fast-paced agile development environment.

Nice to have

5 years of hands-on software engineering experience.

Strong knowledge of Azure Data Lake Synapse ADF Power BI.

Strong knowledge of Data Modelling techniques like Data Vault 2.0

Understanding of CI/CD framework is an added advantage.

Experience with Git / Azure DevOps

Ability to interpret/write custom shell scripts. Python scripting is a plus.

What skills/attributes are preferred what will set a candidate apart?

Experience with AzureML

Expert in Azure Synapse Azure Container Registry Azure App services

Of the required skills listed which would you consider the top 3? Please list your expectations regarding years of experience for each requirement.
a. AI/ ML Solution design
b. Strong problem solving and troubleshooting skills with the ability to exercise mature judgment.
c. MLOps

What will the interview process look like? Video phone or in person? How many rounds? How technical will the interviews be?
a. How many rounds? 2-3
b. Video vs. phone? Video
c. How technical will the interviews be? Mostly technical