Sign In
 [New User? Sign Up]
Mobile Version

SSIS Developer - Telecommuter

UnitedHealth Group


Location:
Eden Prairie, MN
Date:
11/21/2017
2017-11-212017-12-20
Job Code:
710669
Apply on the Company Site
  •  
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

710669 SSIS Developer Eden Prairie MN or Telecommute

SSIS Developer - Telecommuter (710669)

Position Description

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 environment

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

Job Details

  • Contest Number710669
  • Job TitleSSIS Developer - Telecommuter
  • Job FamilyOptumInsight Consulting
  • Business SegmentOptumInsight

Job Location Information

  • Eden Prairie, MN
    United States
    North America

Additional Job Detail Information

  • Employee StatusRegular
  • ScheduleFull-time
  • Job LevelIndividual Contributor
  • ShiftDay Job
  • TravelYes, 75 % of the Time
  • Telecommuter PositionYes
  • 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 ]