Is it time to build on your skills and knowledge in a setting that makes the most of both? We can challenge you in ways that require you to bring it all, every day. Optum, part of the UnitedHealth Group family of businesses, has more technology, greater data resources and far broader expertise than any competitor anywhere. We're creating hundreds of custom applications and manage thousands of hardware components. And that complexity is where you come in. In this role, you'll be involved in architecting and designing data warehouse solutions. You will be a primary contributor in developing, testing and deploying key data warehouses, data marts and will be working with cutting edge technology. You'll find yourself stretching, learning and expanding your impact. The Associate Data Modeler will be a part of our Product Engineering division of Optum working on our Data Warehousing team optimizing the reporting function for the Claims Manager and Claims Edit System products. Primary Responsibilities:Gather and analyze business requirements Architect/Design Data Warehouse infrastructure and solutions Develop technical specifications and design documents Develop, enhance, integrate, test and deploy Data Warehouses/Data Marts and Business Intelligence SolutionsKnow that this opportunity comes with big potential and big challenges. It takes an ability to solve technical and strategic challenges using innovative approaches. You'll be using complex data to support business decisions and you'll need to demonstrate collaborative, creative and conceptual thinking.
Required Qualifications:3+ years of data modeling experience 3+ years developing with BI Tools Experience in building complex, large scale schema 3+ years of experience with star schema databases 3+ years of experience using ETL to populate star schema databases from relational production data sources Experience in Data Architecture and Database design Experience with database technologies (e.g. Oracle, SQLServer, NoSQL, Hadoop) Bachelor's degree or equivalent experiencePreferred Qualifications:Experience in Healthcare DataOptum is a diversified health services and innovation company where data, technology, people and action combine to make great things happen every day. Join us. Learn more about how you can start doing 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 Keywords: associate data modeler, data modeling, star schema, database, data warehouse design, data warehouse architecture, Oracle, SQL Server, Hadoop, NoSQL, ETL, healthcare data, BI, business intelligence, Tableau, PowerBI, Pentaho, Optum, West Valley City, UT, Utah, Salt Lake City, SLC
Internal Number: 751768
About UnitedHealth Group
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.