Analytics Engineer

Duarte, CA, US • Posted 2 days ago • Updated 1 hour ago
Full Time
On-site
USD $53.28 - 85.26 per hour
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • LOS
  • Network
  • Analytical Skill
  • Data Analysis
  • Requirements Elicitation
  • Migration
  • Data Modeling
  • Data Warehouse
  • Extract
  • Transform
  • Load
  • Snow Flake Schema
  • Visualization
  • Attention To Detail
  • Analytics
  • Reporting
  • Scripting Language
  • Dimensional Modeling
  • Health Care
  • Microsoft Azure
  • Cloud Computing
  • SQL
  • Tableau
  • Business Intelligence
  • Modeling
  • Microsoft SQL Server
  • Python
  • Scripting

Summary

Join the transformative team at City of Hope , where we're changing lives and making a real difference in the fight against cancer, diabetes, and other life-threatening illnesses. City of Hope's growing national system includes its Los Angeles campus, a network of clinical care locations across Southern California, a new cancer center in Orange County, California, and treatment facilities in Atlanta, Chicago and Phoenix. Our dedicated and compassionate employees are driven by a common mission: To deliver the cures of tomorrow to the people who need them today.

Position Summary:

The fundamental role of the Analytics Engineer is to develop and maintain reusable data products that enable stakeholders to answer their own questions efficiently and effectively. They speak the language of data producers and consumers, translating analytical goals into models powered by the Enterprise Data Warehouse (EDW). Analytics Engineers make use of the EDW to create and maintain reusable data assets that enable self-service analytics across the enterprise.

As a successful candidate, you will:
  • Building data models in the data warehouse using dbt to support data analysis needs, consolidate data sources, and establish a self-service reporting platform
  • Work with Enterprise Data Warehouse team to integrate new data sources into the data warehouse as needed using Python or other EL scripting tools
  • Building data pipelines with a variety of tools
  • Ensure all stakeholders analytics needs are met by scoping projects, gathering requirements and prioritizing overall company needs
  • Migration and automation of legacy reporting tools to a new platform focused on creating a unified data model in the data warehouse

Skills & Technologies:
  • SQL
  • Data warehouse/ETL tooling such as dbt, Airflow/Prefect, Python, and Snowflake
  • Tableau (our current visualization tool) or related BI tool
  • Attention to detail and willingness to learn a variety of analytics and reporting tools
  • Familiarity using a scripting language to manipulate data, Python strongly preferred

Bonus Experience:
  • Experience developing and maintaining custom data pipelines with Python
  • Experience with Kimball style Dimensional Modeling
  • Experience developing unified data models in dbt
  • Healthcare data experience
  • Moving from Microsoft SQL Server to Azure Cloud
  • SQL: 3 years (Required)
  • Tableau or Similar BI Tool: 3 years (Required)
  • Modeling data and Scripting: 3 years (Required)
  • Performs other related duties as assigned or requested.

Your qualifications should include:

Minimum Education:
  • Undergraduate degree

Minimum Experience:
  • 3 years of related experience
  • Experience SQL Server, Python and other scripting languages

City of Hope employees pay is based on the following criteria: work experience, qualifications, and work location.

City of Hope is an equal opportunity employer.

To learn more about our Comprehensive Benefits, please CLICK HERE
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: RTX16118e
  • Position Id: a4dffa2079778179420fcf356f874ec6
  • Posted 2 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Los Angeles, California

Today

Easy Apply

Full-time

$105000 - $115000 per annum

Alhambra, California

Today

Full-time

USD 10,214.44 - 10,678.10 per month

Irvine, California

Today

Full-time

Compensation information provided in the description

Long Beach, California

Today

Easy Apply

Contract

$65.00 - $85.00 per hour

Search all similar jobs