Data Warehouse Architect /Team Lead - Eden Prairie, MN
December 23, 2017
Eden Prairie, Minnesota
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) This is a mixed leadership and technical role that will require oversight and direction that comes from intimate knowledge of hands-on coding, data manipulation, and report creation. The Data Architect/Team Lead will need to have an extensive background designing and developing data warehousing environments, familiarity with ETL architectures, leveraging multiple sources (including MDM), as well as making enhancements to processes. The candidate should have a deep understanding of Kimball dimensional modeling, OLTP and OLAP database designs and implementation strategies. This position will also require extensive hands-on experience with Business Objects platforms leveraging SQL Server as a data warehouse. Enough additional experience with Integration and ETL tools such as Mulesoft, SAP Data Services Microsoft SSIS/DTS to facilitate architectural alignment with warehouse integrations. Primary Responsibilities: Participates in the definition, development and implementation of data warehouse and data mart databases and their content Translate requirements, source mapping documents and models into solutions Work with the larger Growth Technology Systems team to help develop and uphold data governance policies and procedures to ensure standardized data naming, establish consistent data definitions and monitor overall data quality for assigned data entities Ensure that data management methodologies include the steps, activities, and deliverables required to consistently achieve high quality data Ensure that the applications adhere to defined data management practices, policies and procedures Coordinate with and support ETL processes and practices in a high availability VLDB data warehousing and data mart environments Plan and coordinate API, and database roll-outs with project team members, development and database engineers Understanding of API based integration solutions which may consist of transactional/real-time integrations, workflow processes, and related functions and various scripting tasks
Required Qualifications:5-7 years of extensive hands-on experience with designing, developing, and ongoing support of a data warehouse environments 3-5 years of deep understanding of Kimball dimensional modeling, OLTP and OLAP database designs and implementation strategies 3 years of practical hands-on experience with Business Objects Data Integrator and reporting platform 2-3 years of experience with metadata based API processes, and the design and implementation of metadata driven solutions 1-3 years of familiarity with ETL tools such as SAP Data Services. Microsoft SSIS/DTS, Data Stage, Informatica Must be able to work in Eden Prairie office, relocation will not be offeredPreferred Qualifications: Familiarity with Agile methodologies such as Scrum or Kanban and working in an iterative delivery model Strong customer relations and ability to deliver business value with technical excellence Understanding of in-memory, highly parallel, columnar based data platforms Understanding of Data Lakes, Hadoop Experience with migrating classic data warehouse platforms to cloud based data warehouse and data lake platforms 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: Team Lead, Architect, Data Warehouse, SAP Data Services, Business Objects, MDM, Reltio, ETL, SSIS, Mulesoft Eden Prairie, MN, Minnesota
Our mission is to help people live healthier lives and to help make the health system work better for everyone.- We seek to enhance the performance of the health system and improve the overall health and well-being of the people we serve and their communities. - We work with health care professionals and other key partners to expand access to quality health care so people get the care they need... at an affordable price. - We support the physician/patient relationship and empower people with the information, guidance and tools they need to make personal health choices and decisions.