IT-Lead Software Engineer/29/TEC133

Post Date

Dec 27, 2022


Eden Prairie,

ZIP/Postal Code

Aug 13, 2024 Insight Global

Job Type



Information Technology

Req #


Pay Rate

$68 - $82 (hourly estimate)

Job Description

*** 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.?

  • 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
  • Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.