Senior Data Analyst - 2324383 - 2324383

Senior Data Analyst )

EMPLOYER: Optum Services Inc.

LOCATION: 1 Optum Circle, Eden Prairie, MN 55344 (Telecommuting available from anywhere in the U.S.)

DUTIES

Develop and implement a set of techniques or analytics applications to transform raw data into meaningful information using data-oriented programming languages and visualization software. Duties include gathering business requirements for the data warehouse; analyzing existing design; recommending best practice design for optimal performance and maintenance; applying Full Software Development Life Cycle (SDLC) experience, including analysis, design and review of business and software requirement specifications, and development and testing as per the SDLC waterfall methodology; participating in project meetings/design groups as a team member with other Data Analysts to design, engineer and develop solutions; using Informatica Power Center client tools, Metadata Manager, and Informatica Analyst; developing, maintaining, and supporting application, business glossary, business intelligence, data integration, data modeling, and database management resources in Metadata Manager; working on given timelines to ensure delivery; assisting Project Manager/Team lead in providing estimation of project status; analyzing requirements to develop test plans, cases, scripts, use cases and test strategies; performing regression, integration, functional, system, database, end‑to‑end testing, volume, and stress testing; creating ETL test data for all ETL mapping rules; testing the ETL DataStage, Informatica mappings and other ETL processes (data warehouse testing); and working with the team and data modelers to facilitate modification of the logical design to create a physical design best suited to the business needs of the customer.

REQUIREMENTS

Employer will accept a Master's degree in Computer Science, Information Technology, Information Technology Management, or a related field and one (1) year of experience in the job offered or in a computer-related occupation. Position requires one (1) year of experience in the following:

• Information Technology including Data Warehouse development and testing using ETL Informatica technologies across various projects;
• Full Software Development Life Cycle (SDLC);
• Developing the ETL code using Power Center to load large volumes of data into the data warehouse;
• Creating ETL test data for ETL mapping rules to test the functionality of the DataStage and Informatica;
• Testing the ETL DataStage, Informatica mappings and other ETL Processes (Data Warehouse Testing);
• Developing Test plans, Test cases, Test Scripts, Use Cases and Test strategies using DevSuite;
• Implementing Change Data Capture (CDC) & slowly changing dimensions – SCD Type 1 & 2;
• Teradata Utilities BTEQ, M‑Load, F‑load, TPT and F‑Export in combination with Informatica for better load into Teradata Warehouse;
• Using control M scripts for scheduling ETL jobs.

RATE OF PAY

$115,315 - $163,000 per year

Please apply via careers.uhg.com and search for job # .

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)

UnitedHealth Group offers a full range of comprehensive benefits, including medical, dental and vision, as well as matching 401k and an employee stock purchase plan.

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.