Sign In
 [New User? Sign Up]
Mobile Version

Teradata Data Warehouse Architect – State of Michigan

UnitedHealth Group

Lansing, MI
Job Code:
Apply on the Company Site
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

730392 Teradata Data Warehouse Architect State of Michigan

Teradata Data Warehouse Architect – State of Michigan (730392)

Position Description

Optum gives you the opportunity to showcase your passion and technical expertise, to transform health care, as we change the way our businesses and consumers engage with technology.
With a technology career at Optum, you have an amazing power to transform the health care industry and improve peoples' lives. We are a top notch health care company that is driven by the latest technology enabling us to significantly improve the quality of health care and improve the lives of tens of millions. This is a unique opportunity for you to make an impact by utilizing your technical expertise to help people live healthier lives. This is where you will work with the best and the brightest and together make positive change a reality. This where you will do your life's best work.SM

This candidate will be part of a 40 person team made up of Project Managers, Teradata and Web Developers, Data Modelers, DBAs, Business Analysts and Report Analysts.  This candidate will be responsible for the design, implementation, support and maintenance of all functions of Teradata relational database systems, including:  database access, creation/maintenance of conceptual, logical and physical data models, and database solution design.  In this role you will recommend and monitor overall standards and procedures, provide solution design guidance to other technical staff, and assist in integrating various systems.  You will also consult with users, determine requirements, and recommend database establishment and utilization.

Required Qualifications: 

5+ years Teradata v14+ experience as an Architect or Data Modeler
5+ years logical and physical data modeling experience

5+ years ETL using Teradata Utilities in a Unix/Linus environment

5+ years performance tuning in a large database (>5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans

5+ years with ERWin or other data modeling software

5+ years working with technical developers to strategize solutions to align with business requirements

3+ years working with end users/customers to understand requirements for technical solutions to meet business needs

3+ years identifying and initiating resolutions to customer problems and concerns associated with a data warehouse

3+ years analyzing project requirements and developing detailed specifications

3+ years defining standards and best practices and conducting code reviews

3+ years developing service and adhoc oriented data models

Bachelor’s degree or equivalent work experience


Preferred Qualifications: 

Experience as a Teradata DBA

Teradata v14/15 certification

Experience working with Data Modelers and developers, facilitating modification of the logical design to create a physical design most suited to the reporting needs of the customer
Ability to design applications taking into consideration data reconciliation, (to the source system) query/reporting performance, and analytical business value.

Meet with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan.

Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations.

Experience in a state government environment

Medicaid/Medicare or Healthcare industry experience
Experience with Teradata SQL Assistant

Experience facilitating meetings and providing presentations to customers and senior leaders

Experience with the State of Michigan PMM/SUITE methodology

Experience with Agile methodologies

Experience with Teradata Aster

Experience with Hadoop       

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: 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.

Job Details

  • Contest Number730392
  • Job TitleTeradata Data Warehouse Architect – State of Michigan
  • Job FamilyInformation Technology
  • Business SegmentOptumInsight

Job Location Information

  • Lansing, MI
    United States
    North America

Additional Job Detail Information

  • Employee StatusRegular
  • ScheduleFull-time
  • Job LevelIndividual Contributor
  • ShiftDay Job
  • TravelNo
  • Telecommuter PositionNo
  • Overtime StatusExempt

UnitedHealth Group is the most diversified health care company in the United States and a leader worldwide in helping people live healthier lives and helping to make the health system work better for everyone.

Powered ByLogo

Featured Jobs[ View All ]

Featured Employers [ View All ]