Senior Data Engineer - UHC M&R IS - Horsham, PA at Optum (Philadelphia, PA)

| Philadelphia, PA
Sorry, this job was removed at 5:11 p.m. (CST) on Thursday, July 28, 2022
Find out who's hiring in Philadelphia, PA.
See all Data + Analytics jobs in Philadelphia, PA
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
UnitedHealthcare is a company that's on the rise. We're expanding in multiple directions, across borders and, most of all, in the way we think. Here, innovation isn't about another gadget, it's about transforming the health care industry. Ready to make a difference? Make yourself at home with us and start doing your life's best work.(sm)
Functions may include database architecture, engineering, design, optimization, security, and administration; as well as data modeling, big data development, Extract, Transform, and Load (ETL) development, storage engineering, data warehousing, data provisioning and other similar roles. Responsibilities may include Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems. Duties may include management of design services, providing sizing and configuration assistance, ensuring strict data quality, and performing needs assessments. Analyzes current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities.
Primary Responsibilities:
  • Senior SQL Report Developer
  • Gather and analyze business requirements
  • Design and create Report/Dashboards/Documents using various Data Warehouses
  • Develop technical specifications and design documents
  • Develop, enhance, integrate Business Intelligence Solutions
  • Test Report/Dashboards/Documents from Data Warehouses/Data Marts
  • Operations and Maintenance support activities
  • Report documentation and report testing
  • Perform data analysis

You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.
Required Qualifications:
  • Undergraduate degree or equivalent experience
  • 5+ years of IT work experience in Report Development using any Business Intelligence tool
  • 5+ years of IT work experience to write/analyze/test/debug code in Oracle PL/SQL
  • 5+ years of IT work experience to analyze and gather business requirements
  • 5+ years of experience in understanding data flow diagrams, data model diagrams and performing data analysis
  • Proficient in using Microsoft Office products
  • Solid experience in writing SQL and good working knowledge of Oracle database
  • Develop SQL scripts for various reporting and ad-hoc analysis
  • Ability to write custom SQL using joins, group functions, inline views, sub queries to troubleshoot complex data issues
  • Full COVID-19 vaccination is an essential job function of this role. Candidates located in states that mandate COVID-19 booster doses must also comply with those state requirements. UnitedHealth Group will adhere to all federal, state and local regulations as well as all client requirements and will obtain necessary proof of vaccination, and boosters when applicable, prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation.

Preferred Qualifications:
  • Healthcare industry experience
  • Familiarity with Informatica ETL tools; Tableau; MicroStrategy
  • Exposure to Big Data / Hadoop Report development
  • Exposure with Teradata and / OR Neteeza appliance technologies
  • Good understanding of Data Warehousing design and concepts
  • Good documentation and application development testing skills

To protect the health and safety of our workforce, patients and communities we serve, UnitedHealth Group and its affiliate companies require all employees to disclose COVID-19 vaccination status prior to beginning employment. In addition, some roles and locations require full COVID-19 vaccination, including boosters, as an essential job function. UnitedHealth Group adheres to all federal, state and local COVID-19 vaccination regulations as well as all client COVID-19 vaccination requirements and will obtain the necessary information from candidates prior to employment to ensure compliance. Candidates must be able to perform all essential job functions with or without reasonable accommodation. Failure to meet the vaccination requirement may result in rescission of an employment offer or termination of employment
Careers at UnitedHealthcare Medicare & Retirement. The Boomer generation is the fastest growing market segment in health care. And we are the largest business in the nation dedicated to serving their unique health and well-being needs. Up for the challenge of a lifetime? Join a team of the best and the brightest to find bold new ways to proactively improve the health and quality of life of these 9 million customers. You'll find a wealth of dynamic opportunities to grow and develop as we work together to heal and strengthen our health care system. Ready? It's time to do your life's best work.(sm)
Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.
UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • SqlLanguages
    • JenkinsLanguages
    • HadoopFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • KafkaFrameworks
    • LinuxFrameworks
    • KubernetesFrameworks
    • DockerFrameworks
    • SnowflakeDatabases
    • Google AnalyticsAnalytics
    • SmartsheetManagement

An Insider's view of Optum

How would you describe the company’s work-life balance?

Many companies have a standard 8-hour day, but we don’t. Optum is a global company, so we recognize that working hours are different for everyone depending on their situation. Optum has implemented flexible working policies that allow employees to work from home in addition to the traditional office setting with virtual tools to support everyone.

Rachel

Chief of Staff

What projects are you most excited about?

My teams work on Digital Benefits where our mission is to deliver benefit clarity, cost transparency, and guidance towards increasing healthy outcomes for our members! One exciting project that we just finished was the Mental Health Hub, where we worked to spotlight member's mental health benefits offered by their United Healthcare health plans.

Tim

Senior Software Engineering Manager

How does the company support your career growth?

At Optum the ideal of helping people live healthier lives transcends the healthcare industry and applies to our employee experience. Through meaningful mentorships and participation in holistic leadership development programs, I have been empowered to show up as the best version of my authentic self at home and at work to pursue my life’s purpose.

Kat

Technology Product Director

How does the company support your career growth?

I started with the company 12 years ago and have been promoted 5 times. As an analyst, I provided leaders with meaningful analytics needed for decision-making. Now as a Director, I’m the one making the decisions. I’m responsible for creating effective business strategy, executing tactical plans, and helping drive patent culture transformation.

Komal

Director, UHG Invention Program

What are Optum Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Employee Stock Purchase Plan
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Perks & Discounts
Casual Dress
Parking
Relocation Assistance
Fitness Subsidies
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Continuing Education stipend
Online course subscriptions available

More Jobs at Optum

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Optum's full profileSee more Optum jobs