Analytics Services, Data Engineer - Sr. Consultant
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. 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. The Sr. Consultant, Data Engineer - Analytics Services positions in this function are predominantly involved in developing business solutions by creating new and modifying existing software applications. Primary contributor in designing, coding, testing, debugging, documenting and supporting all types of applications consistent with established specifications and business requirements to deliver business value. You'll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges. Responsibilities • Solid organizational skills and focus on accuracy and attention to detail • Excellent analytical, problem solving and troubleshooting abilities • Self-motivated with the ability to work both independently and in a team environment • Providing 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 review to ensure the work delivered by the team is of high quality standards • Work with business to prioritize production issue resolution • Develops innovative approaches Requirements • 6+ years of data engineering work experience • 6+ years of ETL development experience • 6+ years previous SDLC experience • 6+ years of experience writing advanced complex queries, code optimization with SQL • 3+ years of experience with Cloud environments, such as Snowflake, Azure and/or Databricks Nice-to-haves • 3+ years of experience in Python • Experience developing ETL Processes using Microsoft SQL Server Integration Services (SSIS) • Demonstrated proficiency in database design, querying, optimization & troubleshooting with any of the following RDBMS: Oracle, SQL Server, and/or Teradata • .Net development experience • 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 Benefits • Comprehensive benefits package • Incentive and recognition programs • Equity stock purchase • 401k contribution Apply tot his job