Sr Principal Data Engineer – San Antonio, TX or Eden Prairie, MN

UnitedHealth Group
UnitedHealth Group

Job Overview

Functions may include databasearchitecture, engineering, design, optimization, security, and administration;as well as data modeling, big data development, Extract, Transform, and Load(ETL) development, storage engineering, data warehousing, data provisioning andother similar roles. Responsibilitiesmay include Platform-as-a-Service and Cloud solution with a focus on datastores and associated eco systems.Duties may include management ofdesign services, providing sizing and configuration assistance, ensuring strictdata quality, and performing needs assessments. Analyzes current businesspractices, processes and procedures as well as identifying future businessopportunities for leveraging data storage and retrieval system capabilities.Manages relationships with software and hardware vendors to understand thepotential architectural impact of different vendor strategies and dataacquisition. Design schemas, write SQL, orother data markup scripting and helps to support development of Analytics and Applicationsthat build on top of data.**Data Engineering Capabilities**+ Interactedand coordinated between end-users, expert team, development and QA team andsuggesting key enhancements and changes to the business rules.+ Serveas a Subject Matter Expert on business data and consult with business owners onthe characteristics, attributes and limitation of the data.+ Leadthe projects for complete SDLC with in depth new and existing BusinessIntelligence capabilities.+ Databasecleansing and migrating between different versions of SQL DBs, worked with rawdata to analyze before migration.+ Technicallyskilled (backed by continuous hands on experience) in developing globalwarehouse architectures, policies, Security procedures and integrating the in-flightprojects to leverage existing technology investments.+ DataWarehouse development working with Data Migration, Data Conversion, andExtraction/Transformation/Loading using SQL Server.+ Robustexperience in Enterprise Data Warehouse Architecture, Dimensional Modeling,Data Quality and various estimations (Space, Efforts, and Hardware etc)involved to setup enterprise warehouse Extensive experience in preparingBusiness & functional requirement documents.+ Managedthe evaluation of ETL and OLAP tools and recommended the most suitablesolutions depending on business needs.+ Strongexperience in reviewing and recommending documentation of test cases. Expertisein designing and developing test plans.+ Strongproblem solving, logical/rational thought processes and demonstrated analyticalabilities**Primary Responsibilities:**+ Optimizationand scalability analysis+ Assess,analyze and design data flows+ Designdata models+ Writecode for design changes, data migration, and reference data+ Deploycode using standard and non-standard methodology+ Collaboratewith business partners to ensure data standardization+ Design/definedata validation rules+ Adherenceto data management processes and capabilities+ Ensureproper data lineage/mapping from source to target within transactional systems+ Assistwith mapping and lineage issues downstream+ Workwith database teams to evaluate and establish physical database requirements+ Ensurethat technical specifications/design documents optimize database performance+ Ensureinclusion of appropriate data recovery strategies in technicalspecifications/design documents+ Provideknowledge transfer changes through release deployment to productionsupportYou’ll be rewarded andrecognized for your performance in an environment that will challenge you andgive you clear direction on what it takes to succeed in your role as well asprovide development for other roles you may be interested in.**Required Qualifications:**+ 8+years of experience in MS SQL Server including 2 years exp with version 2016+ 6+years of experience with the analysis, design, and development of databasestructures and ETL processes within an enterprise database management system(e.g. MS SQL Server, Oracle, etc.)+ 5+years of experience with MS SSIS+ 5+experience in any of the following: EnterpriseData Warehouse Architecture, Dimensional Modeling, Data Quality and variousestimations (Space, Efforts, and Hardware etc.) involved to setup enterprisewarehouse+ 5+years of experience in Development of technical requirements+ 3+years of experience in performance tuning and optimizations**Preferred Qualifications:**+ Experiencewith loading large, analytical and operational data structures including datarequirements, data mapping, requirements and specification, data delivery andperformance tuning+ Experienceworking with a structured application development process in the health careindustry+ Experiencein a data integrations development and operations department+ Experiencewith healthcare data, applications, business processes and best practices**Careers with WellMed.** Our focus is simple. Were innovators inpreventative health care, striving to change the face of health care forseniors. Were impacting 380,000+ lives, primarily Medicare eligible seniors inTexas and Florida, through primary and multi-specialty clinics, and contractedmedical management services. Weve joined Optum, part of the UnitedHealth Groupfamily of companies, and our mission is to help the sick become well and tohelp patients understand and control their health in a lifelong effort atwellness. Our providers and staff are selected for their dedication and focuson preventative, proactive care. For you, that means one incredible team and asingular opportunity to do **your lifes best work.(sm)**_Diversity creates a healthier atmosphere: UnitedHealth Group is anEqual Employment Opportunity / Affirmative Action employer and all qualifiedapplicants 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, maritalstatus, genetic information, or any other characteristic protected by law.__UnitedHealth Group is a drug-free workplace. Candidates arerequired to pass a drug test before beginning employment._Job Keywords: SSIS; SQL; ETL; Data Warehouse; BI; TX, Texas, San Antonio,Eden Prairie, Mn, Minnesota

View More
Job Detail
Shortlist Never pay anyone for job application test or interview.