Sr Analyst, Data Analysis / Science - Denver Health Medical Plan (* Weekly Hybrid Schedule *)

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, participates in the systems development life cycle for new development, enhancements and maintenance projects in multiple Data Warehouses, 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 and data visualization software needed to prepare and deliver information in support a variety of business needs. The role will leverage a broad range of development, database, reporting, analytic, and business intelligence skills across a diverse data landscape to meet a variety of business needs.

Essential Functions:

• Develop 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 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%)
• Designs relational, dimensional and analytical models in accordance with best practices. (10%)
• Perform code reviews, data validation, and system testing for data warehouse changes while establishing system documentation and ensuring it is continually sustained (10%)
• Interact closely with members of both IT and the business. (10%)

Education:

• Bachelor's Degree Information Technology, Computer Science, or related field required

Work Experience:

• Seven year's experience in the analysis, design, implementation, and support of complex applications
• 4-6 years BI Solutions

Licenses:
Knowledge, Skills and Abilities:

• Expertise with Microsoft BI stack, including SQL Server 2008/2008R2, SSIS, SSRS, SSAS, Performance Point, Power Pivot, Share Point, Report Builder, and MDX.
• Other data warehousing and business intelligence skills desired: master data management, data modeling, hardware/software architecture, data cleansing and quality, dashboard and scorecard development, third-party reporting platforms, and performance tuning.

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.

Denver Health is an equal opportunity employer (EOE). We value the unique ideas, talents and contributions reflective of the needs of our community.

Applicants will be considered until the position is filled.