UnitedHealth Group - Eden Prairie, MN

posted about 1 month ago

Full-time - Mid Level
Remote - Eden Prairie, MN
1-10 employees
Insurance Carriers and Related Activities

About the position

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. As a Data Engineer, you will be responsible for the development of complex data sources and pipelines into our data platform (i.e. Oracle) along with other data applications (e.g., GitHub, etc.), automation, and innovation. You will work in collaboration with business analysts and SMEs to ensure that complex processes and calculations are implemented and maintained across several clients. You'll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges. In this role, you will engage in all phases of software engineering including requirements analysis, application design, code development, and testing. You will design and implement product features in collaboration with business and IT stakeholders, and design reusable stored procedures, routines, and functions to perform complex transformations. You will lead technology decisions, drive product implementation and delivery, and troubleshoot production support issues post-deployment. Your responsibilities will also include managing code in Git/GitHub, understanding data requirements, and designing optimal pipelines to fulfill use-cases. You will oversee code deployments to the production environment, troubleshoot production data issues, and model large datasets to maximize performance for our Business Intelligence Team. This position requires solid organizational skills, excellent analytical and problem-solving abilities, and the capacity to work both independently and in a team environment. You will provide support and leadership in critical production support issue resolution and conduct code reviews to ensure high-quality standards are met.

Responsibilities

  • All phases of software engineering including requirements analysis, application design, code development, and testing
  • Design and implement product features in collaboration with business and IT stakeholders
  • Design reusable stored procedures, routines, and functions to perform complex transformations components
  • Lead technology decisions, drive product implementation and delivery
  • Troubleshoot production support issues post-deployment and determine solutions as required
  • Demonstrate substantial depth of knowledge and experience in Oracle PL/SQL, Unix, ETL tools
  • Manage code in Git/GitHub
  • Understand data requirements and design optimal pipelines to fulfill use-cases
  • Understand logical & physical data models to ensure data integrity is maintained
  • Tune and optimize data processes
  • Oversee code deployments to production environment, troubleshoot production data issues
  • Model large datasets to maximize performance for our Business Intelligence Team
  • Provide accurate and timely estimates for tasks
  • Provide support and leadership in critical production support issue resolution
  • Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action plan
  • Work with team to achieve timely resolution of all production issues meeting or exceeding Service Level Agreements
  • Conduct code reviews to ensure the work delivered by the team is of high-quality standards
  • Develop innovative approaches

Requirements

  • 8+ years of data engineering work experience in development, design, test and implementation of complex database programs using Oracle and third-party tools within a distributed, service-based enterprise environment
  • 8+ years of experience writing complex queries in Oracle PL/SQL
  • Proficiency in database design, querying, optimization & troubleshooting with any of the following RDBMS: Oracle, SQL Server, and/or Teradata
  • Demonstrated expertise in a variety of data warehousing and business intelligence concepts, practices, and procedures
  • Solid experience with oracle functions, procedures, triggers, packages & performance tuning
  • Analytical and problem-solving experience applied to large datasets
  • Proven data warehousing principles, architecture and its implementation in large environments
  • Proven knowledge of different data modelling techniques such as Star Schema, Dimensional models, Data vault
  • Experience in code lifecycle management and repositories such as GIT & GitHub

Nice-to-haves

  • Experience working with Airflow
  • Practical experience of developing solutions hosting within key major cloud providers such as OpenShift, Kubernetes, AWS, Google Cloud and Azure
  • Experience working with Snowflake
  • Experience developing optimized data models for Viz tool E.g. Tableau, and PowerBI
  • Exposure and experience in other programming language such as Python, Spark, etc.
  • Understanding of United States Healthcare data and applicable regulations
  • Experience writing and executing functional specifications
  • Experience working with and analyzing healthcare administrative, medical, or pharmacy claims data to support downstream applications, data marts, and end users
  • Analytical approach to problem solving
  • Excellent time management, communication, decision making, and presentation skills
  • Display a solid desire to achieve and attain high levels of both internal and external customer satisfaction
  • Solid experience of operating in a quickly changing environment and driving technological innovation to meet business requirement
  • Proven track record of building relationships across cross-functional teams
  • Initiative-taker. Has grit and can solve problems without management oversight
  • Excellent communication skills - Verbal and Written
  • Experience working in projects working with high performing team(s)

Benefits

  • Comprehensive benefits package
  • Incentive and recognition programs
  • Equity stock purchase
  • 401k contribution
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service