No industry is moving faster than health care. And no organization is better positioned to lead health care forward. We need attention to every detail with an eye for the points no one has considered. The rewards for performance are significant. You'll help improve the health of millions. And you'll do your life's best work.(sm) The primary role of the developer is to take the design and technical specifications and develop effective and high quality technical solutions that meet the business requirements. The technical domain of the ETL Developer includes understanding Data Integration (DI) best practices, tools and technologies, security in the environment, understanding of different data warehousing and dimensional modelling concepts, DI development, performance tuning and support system testing. **Typical travel scenario - Travel is based on project size, scope and location. Projects may require up to 80% travel. If travel is required , typical travel schedule is out early Monday, back late Thursday with telecommute from home on Friday. Primary Responsibilities:Ability to work closely with Business Analysts and SMEs to understand business requirements Perform Data profiling and analysis of structured and unstructured data Define new interface layouts (custom or healthcare industry standards) for integrating into the Data warehouse Create source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts Validate the ETL design and ensure that technical specifications are complete, consistent, concise, and achievable. Create ETL Processes and reports using Microsoft SQL Server Suite (SSIS, SSRS, SSAS) and other data integration tools like Data Stage, Informatica, Ab initio Develop ETL code as per the technical specifications and business requirements according to the established designs Familiarity with reporting tools like Cognos, Business Objects , Microstrategy Proficient in leading and managing the development resources Create Process Flows using Visio Create Dimensional models using ERWIN or other data modeling tools Create/maintain design related artifacts i.e. data models , Mapping documents, architecture diagrams, data flow diagrams Performance tuning of ETL processes Well versed with Automation tools like Tivoli Maestro Ability to work in a matrixed team environment with distributed responsibility across different teams Ability to work and deliver in a very high paced environment with limited information at times to support business needs Experienced in delegating and coordinating development and testing in an onsite-offshore delivery model Experienced in working with sensitive/de-identified data environments Experience in working with encrypted and secure data transfers Proactive and diligent in identifying and communicating scope, design, development issues and recommending potential solutions. Participate in ETL architecture design reviews. Conduct ETL unit testing and code reviews. Participate in system and integration test; identifies and remedies solution defects. Create other technical artifacts needed for project implementation
Required Qualifications: Bachelor's in Computer Science, Information Technology or related area 5+ years of Data Integration/ETL development experience, preferably in healthcare domain. 3+ years of ETL design using Microsoft SSIS 3+ years of SQL Server Experience with versions 2008 and/or 2012 Excellent SQL skills and ability to create T-SQL/stored procedures Configuration Management using Microsoft Team Foundation Server and/or other version control tools Understanding of Enterprise Data warehouse data models and dimensional modelling concepts, source to target mapping and Data Integration architecture Demonstrated ability to meet tight deadlines, follow development standards and effectively raise critical issues with the client Excellent oral and written communication skills Travel required **(see note above)Preferred Qualifications:Experience in developing reports using SQL Server Reporting Services (SSRS) Experience in creating Source to Target Mappings Experience in Data Profiling & data analysis in a DW environment on Teradata/Oracle/MS SQL Server Performance Tuning of ETL processes in large scale data warehouse environment Knowledge of Cisco Data Virtualization Platform Knowledge of a Data Modeling Tool like Erwin Knowledge of other databases like Teradata, Oracle, SQL Server Knowledge of MS SQL Server Suite (SSIS, SSRS, SSAS) and other ETL tools like Informatica, Data Stage Knowledge of Testing and Defect tracking tools like HP ALM/QC MS Office Suite, MS Visio Knowledge of end to end SDLC from project inception to deployment Experience in different project management methodologies i.e. Agile and Waterfall Healthcare Payer/PBM domain knowledge in a data warehouse environmentCareers 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 Keywords: Job Keywords: Data Integration/ETL, Microsoft SSIS, SSRS, SSAS, SQL, T-SQL/stored procedures, Configuration Management, Enterprise Data warehouse, data models, dimensional modeling, Data Integration architecture, Eden Prairie, MN, Minnesota, telecommute, telecommuter, telecommuting, remote, work from home, optuminsight
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.