Analytics Engineer

%3Cp style=%22font-family:Arial;%22%3EJoin the transformative team at %3Ca href=%22https://www.cityofhope.org/about-city-of-hope%22 target=%22_blank%22 rel=%22noopener%22%3ECity of Hope%3C/a%3E, where we%27re 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.%26nbsp;%3C/p%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:4.0pt;page-break-after:avoid;%22%3E%3Cb style=%22mso-bidi-font-weight:normal;%22%3E%3Cstrong%3EPosition Summary:%3C/strong%3E%3C/b%3E%3C/p%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EThe 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.%3Cspan style=%22mso-spacerun:yes;%22%3E%26nbsp; %3C/span%3EThey speak the language of data producers and consumers, translating analytical goals into models powered by the Enterprise Data Warehouse (EDW).%3Cspan style=%22mso-spacerun:yes;%22%3E%26nbsp; %3C/span%3EAnalytics Engineers make use of the EDW to create and maintain reusable data assets that enable self-service analytics across the enterprise.%3C/p%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;page-break-after:avoid;%22%3E%3Cb style=%22mso-bidi-font-weight:normal;%22%3E%3Cstrong%3EAs a successful candidate, you will:%3C/strong%3E%3C/b%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EBuilding data models in the data warehouse using dbt to support data analysis needs, consolidate data sources, and establish a self-service reporting platform%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EWork with Enterprise Data Warehouse team to integrate new data sources into the data warehouse as needed using Python or other EL scripting tools%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EBuilding data pipelines with a variety of tools%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EEnsure all stakeholders analytics needs are met by scoping projects, gathering requirements and prioritizing overall company needs%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EMigration and automation of legacy reporting tools to a new platform focused on creating a unified data model in the data warehouse%3C/p%3E%3C/li%3E%3C/ul%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:3.0pt;page-break-after:avoid;%22%3E%3Cb style=%22mso-bidi-font-weight:normal;%22%3E%3Cstrong%3ESkills %26amp; Technologies:%3C/strong%3E%3C/b%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3ESQL%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EData warehouse/ETL tooling such as dbt, Airflow/Prefect, Python, and Snowflake%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3ETableau (our current visualization tool) or related BI tool%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EAttention to detail and willingness to learn a variety of analytics and reporting tools%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EFamiliarity using a scripting language to manipulate data, Python strongly preferred%3C/p%3E%3C/li%3E%3C/ul%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:3.0pt;page-break-after:avoid;%22%3E%3Cb style=%22mso-bidi-font-weight:normal;%22%3E%3Cstrong%3EBonus Experience:%3C/strong%3E%3C/b%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EExperience developing and maintaining custom data pipelines with Python%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EExperience with Kimball style Dimensional Modeling%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EExperience developing unified data models in dbt%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EHealthcare data experience%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EMoving from Microsoft SQL Server to Azure Cloud%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3ESQL: 3 years (Required)%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3ETableau or Similar BI Tool: 3 years (Required)%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3EModeling data and Scripting: 3 years (Required)%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;%22%3EPerforms other related duties as assigned or requested.%3C/p%3E%3C/li%3E%3C/ul%3E %3Cp style=%22font-family:Arial;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cstrong%3EYour qualifications should include:%26nbsp;%3C/strong%3E%3C/span%3E%3C/p%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:2.0pt;page-break-after:avoid;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cb style=%22mso-bidi-font-weight:normal;%22%3E%3Cstrong%3EMinimum Education:%3C/strong%3E%3C/b%3E%3C/span%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EUndergraduate degree%3C/span%3E%3C/p%3E%3C/li%3E%3C/ul%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:2.0pt;page-break-after:avoid;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cb style=%22mso-bidi-font-weight:normal;%22%3E%3Cstrong%3EMinimum Experience:%3C/strong%3E%3C/b%3E%3C/span%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E3 years of related experience%3C/span%3E%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height:107%;margin-bottom:6.0pt;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3EExperience SQL Server, Python and other scripting languages%3C/span%3E%3C/p%3E%3C/li%3E%3C/ul%3E%3Cp style=%22font-family:Arial;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cstrong%3ECity of Hope employees pay is based on the following criteria: work experience, qualifications, and work location.%3C/strong%3E%3C/span%3E%3C/p%3E%3Cp style=%22font-family:Arial;%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cstrong%3ECity of Hope is an equal opportunity employer.%3C/strong%3E%3C/span%3E%3C/p%3E%3Cp style=%22font-family:Arial;%22%3E%3Cspan style=%22color:#236fa1;font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cstrong%3ETo learn more about our Comprehensive Benefits, please%3C/strong%3E%3C/span%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cstrong%3E %3C/strong%3E%3C/span%3E%3Ca href=%22https://www.cityofhope.org/careers/wellness-and-benefits/benefits%22 target=%22_blank%22 rel=%22noopener%22%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cstrong%3ECLICK HERE%3C/strong%3E%3C/span%3E%3C/a%3E%3Cspan style=%22font-family:Arial, Helvetica, sans-serif;font-size:14px;%22%3E%3Cstrong%3E.%3C/strong%3E%3C/span%3E%3C/p%3E Job Details Primary Location: United States-California-Duarte Job: Enterprise Data Management & Analytics Work Force Type: Onsite Shift: Days Job Posting: Sep 11, 2026 Minimum Hourly Rate ($): 53.287400 Maximum Hourly Rate ($): 85.260200