Job description
We are recruiting for a ETL Developer, Data Warehouse 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.
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:
Education:
Work Experience:
Licenses:
Knowledge, Skills and Abilities:
Shift
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:
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
Managed Care Administration
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:
- 1-3 years 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 and
7-9 years 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
Regular
Salary
$93,000.00 - $139,600.00 / yr
Benefits
-
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
-
Excellence– We are better every day
-
Compassion– We care for everyone
-
Relentlessness– We fight for everyone
-
Stewardship– We use resources responsibly
-
Learning– We educate the next generation
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 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:
https://www.denverhealth.org/for-professionals/careers/diversity-and-inclusion
jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.