Sr IT Data Analytics Analyst - Eden Prairie, MN - Full-time / Part-time

UnitedHealth Group 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)
 

Summary: In this exciting role, you will participate in the systems development life cycle for new development, enhancements and maintenance projects in Data Warehouse/Data Analytics environment. As a member of the Delivery Management team, you will lead development project teams to design, develop and deploy ETL software needed to support a variety of business needs. The position will report to a resource manager, but will be matrixed to project managers for completion of project activity.

Responsibilities:

• Research, evaluate, identify alternative approaches to support development needs


• Recommend, design and code efficient and effective solutions for challenging problems for medium to large work efforts of medium to high complexity


• Comply with standards and guidelines related to the design, construction, testing, and deployment activities within the Delivery Management environments


• Demonstrate collaborative skills working within a project team of diverse skills


• Bring strong communication skills including oral, written and presentation skills plus creativity, and problem solving skills to a challenging environment


• Act as a Project Development Lead with one or more developers matrixed for the completion of the project


• Provide guidance and direction to less-seasoned staff

Success Factors:

• Ability to deliver functionality in two or more programming languages within a single development environment


• Ability to create high complexity detailed technical design specifications


• Ability to act as project technical lead for high complexity projects


• Ability to act as a lead developer responsible for the planning, completion and coordination of work activity for projects involving more than one developer


• Ability to lead walk though of design documents and provide technical leadership over programming team


• Strong analytical and technical aptitude


• An understanding of a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models


• Effective communications with all levels of internal and external customers and staff, including issue resolution, negotiation of project related priorities, and completion dates

Required Qualifications:

• 8+ years of experience working in a high volume DataStage environment


• Bachelor's degree


• Expert in developing Oracle procedures, functions, packages, database triggers and troubleshooting using PL/SQL and SQL


• Experienced in implementing advanced features of Oracle like Autonomous Transactions, Ref-Cursors, PL/SQL Tables, Table Partitioning, V-Arrays, Materialized Views, Merge statements, SQL*Loader, External Tables, Pipelined/Table functions, Result Cache, With Clause and Multi Table Inserts


• Vast experience troubleshooting performance issues, SQL tuning is a must


• Evaluate and understand a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models


• Develop ETL code meeting 100 percent of technical specifications and business requirements according to the established designs


• 4+ years experience in applications systems analysis and/or development and/or support


• 4+ years experience with multiple file structures and programming languages


• 4+ years experience with high level technical phases of applications systems analysis and programming activities


• 4+ years experience with Oracle, SQL Server in Unix environment


• Experience with any SSH client


• Highly experience with complex shell scripting using Unix, and PERL and crontab


• Experience in converting specifications to programs and data mapping in an ETL  Pentaho and DataStage environment


• Must be able to work in Eden Prairie office

Preferred Qualifications:

• Strong knowledge in data base technologies Teradata, Oracle, SQL Server, DB2, Netezza and GreenPlum


• Deep understanding of Hadoop stack such as Hadoop (Java)


• AIX


• Multiple programming languages (Perl, Shell script, C++)


• Teradata 8.5


• UDB/EEE


• Tivoli (TWS)


• Autosys or equivalent job scheduling tool experience


• Healthcare domain background


• Clinical domain experience


• Knowledge with HIE formats 837 i&p, HL7/ADT


• Mainframe development experience using Cobol, REXX, MVS JCL and OPS

Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world?s large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.SM

Diversity creates a healthier atmosphere: 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.

Job Keywords: IT Data Analytics Analyst, systems development, Data Warehouse, Data Analytics, Eden Prairie, MN, Minnesota