Data Engineering Consultant ETL, Azure Data Factory and SQL

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.

A Data Engineering Consultant role specializes in designing and implementing data solutions for Business in OptumHealth Division of Optum. The role will be responsible for understanding and translating business requirements into scalable and efficient data architectures.

Primary Responsibilities:

• Collaborate with clients to understand their business requirements and data needs
• Data Design and Management – Design and develop scalable and efficient data architectures, including data pipelines, data lakes, and data warehouses. Applies engineering principles to create databases that optimize the ability to extract, store and manipulate data for consumption by other applications
  • Develops and implements scripts for maintenance, monitoring and performance tuning of database
  • Understand data structures and common methods to transform data for further analysis
  • Use modern tools and techniques
  • Leverage modern technologies, e.g., AI/ML
  • Design scalable Extract, Transform and Load (ETL) packages
  • Define and build enterprise-wide standard data models
  • Normalize data across different domains/systems
• Engineering Principle – Designs, builds, tests and adapts solutions that optimize environment and meet evolving needs of customers and business, leveraging and anticipating modern technologies, e.g., AI/ML, to support the transition to fullstack proficiency
  • Support continuous integration; continuous delivery environment (CICD)
  • Focus on customer and desired business outcomes in the design and build of solutions
  • Consider security, scalability, reliability & feasibility in solution design
  • Consider integrations and impacts on other systems in deployment of solutions
  • Continually seek out opportunities to automate solutions
  • Write, debug, test and deploy code to create working solution
• Technology Acumen – Seeks out and applies the standards, concepts & functionality of all technology /systems within domain including the relationship and interdependencies between technologies
  • Possess breadth of knowledge spanning all bodies of technologies, e.g., databases, middleware, OS, etc.
  • Consider interdependencies of various technologies in analyses and solutions
  • Research industry trends and impact on function/business
  • Earns credibility and enables communication with employees
  • Possess basic understanding of data science concepts and their use in solution
• Data Integration – Demonstrates ability to build business value focused solutions that enable actionable insights from data
  • Find new avenues for data to be used
  • Recommend ways to improve data efficiency
• Technology Security Standards – Understands and applies the protocols, procedures, processes and techniques to prevent the unauthorized access to and protection of systems and data and complies with applicable contractual, regulatory, statutory, and company policies
  • Comply with enterprise security protocols
  • Recognize applicable standards for data under own control
  • Consider security implications in activities and designs
  • Use approved security tools
• Work with stakeholders to define data governance and data management best practices
• Conduct data profiling and analysis to identify data quality issues and recommend solutions
• Optimize and tune data pipelines and queries for performance and scalability
• Stay up to date with emerging technologies and industry trends in data engineering and analytics
• Provide guidance and mentorship to junior data engineers and team members
• Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to ensure successful implementation of data solutions
• Communicate complex technical concepts to non-technical stakeholders in a clear and concise manner
• Ability to work in multiple platforms
• 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 degree in computer science, Engineering, or a related field (Master’s degree is a plus) 
• Proven experience as a Data Engineer or similar role, with a focus on designing and implementing data solutions with minimum 7+ years experience in Data Engineering
• Experience with cloud-based data technologies, such as Azure, AWS, or Google Cloud Platform 
• Experience on data warehouse concepts and technologies, such as Snowflake, Redshift, or BigQuery 
• Experience with Agile development methodologies and project management tools, such as JIRA or Trello 
• Solid expertise in data modeling, data integration, and ETL processes using Microsoft SSIS
• Proficiency in SQL, and/or other programming languages commonly used in data engineering 
• Knowledge of big data technologies, such as Hadoop, Spark, or Kafka 
• Solid problem-solving and analytical skills, with the ability to troubleshoot and resolve complex data issues 
• Proven excellent communication and interpersonal skills, with the ability to work effectively with clients and stakeholders 

Preferred Qualification:

• Good knowledge of data governance and data management best practices

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.