Job Description:

About the Role:

As an Analytics Engineer on the Data Transformations team, you’ll deliver fresh, documented, and tested data tables that meet the needs of our reporting, analytics and data science teams.

By applying software engineering principles such as version control, continuous integration and development, and orchestration to analytics code, you’ll create an environment in which stakeholders are able to easily navigate the database, locate a relevant table, and understand the transformation producing it.

As a generalist, you’ll contribute to each of our three focus areas: data quality, modeling, and infrastructure. Working across our stack, you’ll explore data sources in BigQuery, develop analytic transformations using dbt, and support downstream data products, which range from dashboards in Looker and features in Commons (our web app) to machine learning models and actuarial reports. In addition, you’ll work to ensure that data assets are reliably refreshed and tested for quality, and you’ll make data freshness and test results visible to end users.

In this role, you’ll report to a tech lead manager and partner closely with our product managers, and work alongside teams of data and software engineers. For specific projects, you’ll also collaborate with data analysts, data scientists, and actuaries.

Responsibilities:

• Design and build efficient, scalable SQL models to test, clean, and integrate Cityblock member data from a variety of sources, including managed care organizations, electronic health records, and care management platforms

• Orchestrate data transformation workflows and provide troubleshooting support

• Contribute to a healthy analytics infrastructure, promoting modularity, reusability, data traceability, and clear documentation
  

Requirements:

• Bachelor’s degree (preferably in a technical field)

• 2+ years of experience in healthcare data analysis, management, and/or warehousing

• Demonstrated ability to explore, transform, and analyze data with SQL (dbt experience preferred)

• Familiarity with foundational programming concepts (variables, data structures, control structures, functions; Python experience a plus)

• Ability to clearly communicate technical topics to a range of audiences

• Experience managing time in an autonomous environment

We take into account an individual’s qualifications, skillset, and experience in determining final salary. This role is eligible for health insurance, life insurance, retirement benefits, participation in the company’s equity program, paid time off, including vacation and sick leave. The actual offer will be at the company’s sole discretion and determined by relevant business considerations, including the final candidate’s qualifications, years of experience, skillset, and geographic location. The expected salary range for this position is:

$120,000 - $130,000 Annually

Cityblock values diversity as a core tenet of the work we do and the populations we serve. We are an equal opportunity employer, indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.

We do not accept unsolicited resumes from outside recruiters/placement agencies. Cityblock will not pay fees associated with resumes presented through unsolicited means.