Sign In
 [New User? Sign Up]
Mobile Version

***BI (EDW, ETL, Report) Analyst / Developer / Architect - Telecommute

UnitedHealth Group

Eden Prairie, MN
Job Code:
Apply on the Company Site
  • Save Ad
  • Email Friend
  • Print
  • Research Salary

Job Details

761352 BI EDW ETL Report Analyst Developer Architect Telecommute

***BI (EDW, ETL, Report) Analyst / Developer / Architect - Telecommute (761352)

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)


As a technical developer and consultant, you'll provide services to strengthen and improve health care operations that result in stronger financial returns and help make the health care system work better for everyone. You will be designing, developing, and maintaining data warehouse and analytics architecture to meet an enterprise’s business analysis and reporting needs. You must have a sound understanding of BI best practices, relational structures, dimensional data modeling, structured query language (SQL) and reporting skills and techniques. Working alongside architects and business partners you will fashion out the technical vision for applications in Customer Data Warehouses employing a variety of technologies. Join us and start doing your life’s best work.(sm)


You'll enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges.


Primary Responsibilities:

  • In collaboration with business and technology stakeholders, create star schema data models, perform ETLs, build reports and validate results
  • Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance, communicating functional and technical issues and working with database administrators to ensure that the data warehouse is tuned for optimal performance
  • Providing support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other suitable source systems
  • Designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems as well as ensure proper functioning of analytics, and client’s or third-party’s reporting environments and dashboard
  • Working with business analysts and project managers to develop and refine reporting and analytics requirements. Design and develop reports and analytics capability
  • Managing the database aspects of the reporting and analytics platform(s) to ensure that reporting jobs are successfully run and analytics data aligns to timeliness, completeness of requirements
  • Work with the data quality manager to identify and resolve data issues through data cleansing and de-duplication software
  • Ensure all data warehouse architecture, ETL & reporting codes are maintained in a version control system

Required Qualifications:

  • 4+ years of experience in information technology, data management, and application development
  • 4+ years of experience in designing and building Data warehouse/Data marts / Operational  Data Stores(ODS)
  • 3+ years in application and solution architecture in the Data warehouse/Business Intelligence  domain
  • 3+ years managing projects
  • 3+ years of experience in Data Profiling & data analysis in a DW environment  on Teradata/Oracle/MS SQL Server
  • 3+ years of experience in creating Source to Target Mappings.
  • 3+ years of Data/Dimensional modeling and EDW implementation experience in Teradata/ Oracle/ MS SQL Server
  • 3+ years of ETL build using SSIS/ Informatica/ DataStage or other Data Integration Tools
  • 2+ years client facing consulting experience on large business process or systems integration projects
  • Travel is based on project requirements, 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 option to telecommute from home on Friday

Preferred Qualifications:

  • 4 year College Degree - a Bachelor's Degree or equivalent (Math, Computer Science, Engineering or MIS) 
  • Ability to design and build out reusable components
  • Exceptional experience developing codes, testing for quality assurance, administering RDBMS, and monitoring of database
  • High proficiency in dimensional modeling techniques and their applications
  • Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel
  • Working knowledge of SAS and R code used in data processing and modeling tasks
  • Experience with Microsoft Azure and Amazon AWS computing platforms
  • Understanding and development of application development frameworks and standardization of design patterns
  • Expert Knowledge in creating source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts
  • Agile experience and understanding of transitional strategies from the traditional Waterfall approach to an Agile approach

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)


*All Telecommuters will be required to adhere to UnitedHealth Group's Telecommuter Policy



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 Details

  • Contest Number761352
  • Job Title***BI (EDW, ETL, Report) Analyst / Developer / Architect - Telecommute
  • 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 ]