ETL Developer, Data Warehouse, Denver Health Medical Plan

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.

Department

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

Education:

• Bachelor's Degree Required

Work Experience:

• Three 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
• In lieu of a Bachelor's degree, must have 9 years development experience required.

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

Shift

Work Type

Salary

Benefits

• Outstanding benefits including up to 27 paid days off per year, immediate retirement plan employer contribution up to 9.5%, and generous medical plans

• Free RTD EcoPass (public transportation)

• On-site employee fitness center and wellness classes

• Childcare discount programs & exclusive perks on large brands, travel, and more

• Tuition reimbursement & assistance

• Education & development opportunities including career pathways and coaching

• Professional clinical advancement program & shared governance

• Public Service Loan Forgiveness (PSLF) eligible employer+ free student loan coaching and assistance navigating the PSLF program

• 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 more about our commitment to diversity visit:

Applicants will be considered until the position is filled.