ETL Developer, Data Warehouse, Denver Health Medical Plan

Full Time

    Job Description

    We are recruiting for a ETL Developer, Data Warehouse, Denver Health Medical Plan to join our team!

    We are here for life's journey.
    Where is your life journey taking you?

    Being the heartbeat of Denver means our heart reflects something bigger than ourselves, something that connects us all:

    Humanity in action, Triumph in hardship, Transformation in health.

    Managed Care Administration

    Remote opportunity for residents of Colorado, Illinois, Kentucky, Ohio, Pennsylvania, South Carolina, Texas, Utah, Virginia, Washington, and Wisconsin.

    Job Summary

    Under minimal supervision, the Data Warehouse / Business Intelligence Developer participates in the systems development life cycle for new development, enhancements and maintenance projects in a Data Warehouse / Advanced Analytics Environment, works closely with business leaders, end users and other technical resources to design and implement data and analytic solutions to enhance the business decision making process. The position will work with project teams to design, develop and deploy ETL software needed to prepare and deliver data in support a variety of business needs. The developer will leverage development, database, reporting, analytic, business intelligence and customer service skills across a diverse data landscape to meet a variety of business needs.

    Essential Functions:

    • Design, develop, test and support end to end Data Warehouse, Business Intelligence and Advanced Analytics solutions for analytics and management teams. (25%)
    • Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, analytic marts and analytics environments, and other critical data pipelines. (20%)
    • Collaborates with business partners such as analysts, management, architects and other developers to clarify program objectives, determine scope, identify problems and recommend data solutions. (20%)
    • Collaborates with the business analyst, user community, and other technical resources, to thoroughly document requirements and detailed technical designs for software solutions based on functional requirements from the different business users. (15%)
    • Studies and understands the company's business processes and applications, including their effect on data and analytics, and applies the knowledge gained in designing solutions to meet analytics needs. (10%)
    • Interact closely with members of both IT and the business. (10%)

    • Bachelor's Degree Required

    Work Experience:
    • 1-3 years of progressive experience working in large relational databases or in a large data warehouse environment Required and
    • 1-3 years Experience working with production operations teams Required and
    • 7-9 years In lieu of a Bachelor's degree, must have 9 years development experience. Required


    Knowledge, Skills and Abilities:
    • Excellent communication skills both written and verbal.
    • Ability to adapt and excel in an evolving technical environment.
    • Strong analytical and technical aptitude.
    • Strong experience with SQL programming.
    • Strong background in data warehousing and business intelligence.
    • Experience with multiple programming languages, both design and development.
    • Experience on agile development teams.
    • Experience / Knowledge with commercial ETL tools, SSIS, Python, HDFS, Hive, Spark, R, Tableau


    Work Type

    $93,000.00 - $139,600.00 / yr

    • Competitive pay
    • Outstanding benefits
    • Education opportunities
    • Shared leadership and advancement opportunity
    • State-of-the-art facilities
    • Immediate retirement plan matching
    • Professional clinical advancement program
    • Participation in evidence-based projects
    • Public Service Loan Forgiveness (PSLF) eligible employer
    • National Health Service Corps (NHCS) and Colorado Health Service Corps (CHSC) eligible employer

    Our Values
    • Respect
    • Belonging
    • Accountability
    • Transparency

    All job applicants for safety-sensitive positions must pass a pre-employment drug test, once a conditional offer of employment has been made.

    Denver Health is an integrated, high-quality academic health care system considered a model for the nation that includes a Level I Trauma Center, a 555-bed acute care medical center, Denver's 911 emergency medical response system, 10 family health centers, 19 school-based health centers, Rocky Mountain Poison & Drug Safety, a Public Health Institute, an HMO and The Denver Health Foundation.

    As Colorado's primary, and essential, safety-net institution, Denver Health is a mission-driven organization that has provided billions in uncompensated care for the uninsured. Denver Health is viewed as an Anchor Institution for the community, focusing on hiring and purchasing locally as applicable, serving as a pillar for community needs, and caring for more than 185,000 individuals and 67,000 children a year.

    Located near downtown Denver, Denver Health is just minutes away from many of the cultural and recreational activities Denver has to offer.

    We strongly support diversity in the workforce and Denver Health is an equal opportunity employer (EOE).

    Denver Health values the unique ideas, talents and contributions reflective of the needs of our community. For read more about our commitment to diversity visit: