Data Analyst 2 – National Remote

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. 

 

You will enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges. 

Primary Responsibilities:

• Use Informatica PowerCenter to Extract, Transform, and Load (ETL) source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files and the addition to the EDW of any new fields requested via the change request process
• Automate the staging of data by scheduling scripts to run at optimal times enhancing overall system performance and efficiency
• Create, maintain, and support an ETL/Informatica architectural and system environment for development and production
• Implementing ETL jobs by creating mappings, mapplets, sessions, and workflows
• Working with different ETL transformations including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter
• Scheduling and monitoring ETL/Informatica jobs in a development, system testing, and production environment
• Developing proactive processes for monitoring capacity and performance tuning
• Supporting and advising the development teams on technical issues
• Troubleshoot production support issues post release deployment and come up with solutions
• Developing and maintaining complex SQL queries and/or scripts used to create data marts in Teradata
• Participating in project discussions to document and recommend alternative technical solutions or requirements
• Participating in unit, integration, and system testing
• Maintaining effective communication and relationships with all individuals involved with the project
• Learning new technologies as needed to be able to perform job duties effectively
• Providing status progress and meeting deliverables to leadership and to customers

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:

• Bachelors Degree (or higher) in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business
• 3+ years of Informatica PowerCenter / ETL Experience
• 3+ years of Complex SQL and Performance Tuning Experience
• 3+ years of Teradata experience including Teradata Utilities
• 2+ years of experience working with unstructured X12 files – 837, 834, 277U
• 2+ years of experience working with Informatica B2B
• 6+ months of experience with State Medicaid / Medicare / Healthcare applications

Preferred Qualifications:

• 2 + years of experience working with Python
• Experience in Informatica Data Quality (IDQ), Address Doctor
• ETL/Informatica or SQL or BI or Teradata Certification
• Experience working in Agile
• Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems

Soft Skills:

• Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills
• Strong organization skills and ability to set priorities and schedule work deadlines 

*All Telecommuters will be required to adhere to UnitedHealth Group’s Telecommuter Policy.

 

 

California, Colorado, Nevada, Connecticut, New York, New Jersey, Rhode Island, Hawaii, Washington, or Washington, D.C. Residents Only: The hourly range for California, Colorado, Nevada, Connecticut, New York, New Jersey, Rhode Island, Hawaii, Washington or Washington, D.C. residents is $70,200 to $137,800 per year. Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. UnitedHealth Group complies with all minimum wage laws as applicable. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you’ll find a far-reaching choice of benefits and incentives. 

 

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. 

 

Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants. 

 

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.

 

 

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.

 

 

#RPO, #green