Senior Data Engineering Consultant – SQL, Python and Cloud

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together

As a Senior Data Engineering Consultant, you will be responsible for designing, developing, and maintaining data processing systems and solutions. You will work closely with data analysts, consultants and other stakeholders to ensure data is accessible, reliable, and optimized for various analytical and operational needs.

Senior Data Engineer/ Analyst, People Analytics will be responsible for building and maintaining data pipelines from enterprise Human Capital systems (Oracle). Person may also interact with Domo/ Power BI dashboards. Role will require the person to work closely with consultants to get requirements for new dashboard and enhancements to existing dashboards. Analyst should be able to work and excel in dynamic ever-changing environment. Analyst should possess a solid working knowledge of ETLs and creating pipelines. Analysts must possess a very solid understanding of data and human capital domain knowledge would be a plus.

Positions in this function are responsible for the management and manipulation of mostly structured data, with a focus on building business intelligence tools, conducting analysis to distinguish patterns and recognize trends, performing normalization operations and assuring data quality. Depending on the specific role and business line, example responsibilities in this function could include creating specifications to bring data into a common structure, creating product specifications and models, developing data solutions to support analyses, performing analysis, interpreting results, developing actionable insights and presenting recommendations for use across the company. Roles in this function could partner with stakeholders to understand data requirements and develop tools and models such as segmentation, dashboards, data visualizations, decision aids and business case analysis to support the organization. Other roles involved could include producing and managing the delivery of activity and value analytics to external stakeholders and clients. Team members will typically use business intelligence, data visualization, query, analytic and statistical software to build solutions, perform analysis and interpret data. Positions in this function work on predominately descriptive and regression-based analytics and tend to leverage subject matter expert views in the design of their analytics and algorithms. This function is not intended for employees performing the following work: production of standard or self-service operational reporting, casual inference led (healthcare analytics) or data pattern recognition (data science) analysis; and/or image or unstructured data analysis using sophisticated theoretical frameworks.

Primary Responsibilities:

• Data Pipeline Development: Design, build, and maintain scalable data pipelines to process large volumes of data from various sources
• Data Integration: Integrate data from multiple sources, ensuring data quality and consistency
• Database Management: Develop and manage databases, data warehouses, and data lakes
• Data Governance: Implement data governance practices to ensure data security, privacy, and compliance
• Collaboration: Work with cross-functional teams to understand data requirements and deliver solutions that meet business needs
• Manage code repositories using Git, ensuring proper version control and collaboration
• Write efficient, reusable, and scalable Python code for data processing and analysis
• Ensure code quality through rigorous testing and code reviews
• Design and manage complex workflows using Apache Airflow
• Develop and maintain DAGs (Directed Acyclic Graphs) for orchestrating data pipelines
• Performance Optimization: Optimize data processing workflows for performance and scalability
• Technical Leadership: Provide technical guidance and mentorship to junior data engineers
• Documentation: Create and maintain documentation for data engineering processes and systems
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field
• 5+ years of experience in data engineering or a related field
• Tools: Experience with cloud platforms (AWS, Azure, GCP) and data warehousing solutions (Snowflake, Redshift, BigQuery)
• Technical Skills: Proficiency in SQL, Python, and data processing frameworks such as Apache Spark or Hadoop
• Soft Skills: Solid problem-solving skills, excellent communication, and the ability to work collaboratively in a team environment

Preferred Qualification:

• Relevant certifications in data engineering or cloud platforms

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone – of every race, gender, sexuality, age, location and income – deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes – an enterprise priority reflected in our mission.