Analytics Engineer 1

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.

About Us:

Cityblock Health is the first tech-driven provider for communities with complex needs—bringing better care to where it’s needed most, block by block. Founded in 2017 on the premise that “health is local” and based in Brooklyn, we are backed by Alphabet’s Sidewalk Labs along with some of the top healthcare investors in the country.

Our mission is to improve the health of underserved communities. Importantly, our solutions are designed specifically for Medicaid and lower-income Medicare beneficiaries, and we meet our members where they are, bringing care into the home and neighborhoods through our community-based care teams and Virtual Care offerings.

In close collaboration with community-based organizations, local providers, and leading health plans, we are reorganizing the health system to focus on what matters to our members. Equipped with world-class, custom care delivery technology, we deliver personalized primary care, behavioral health, and social services to deliver a radically better experience of care for every member and community we serve.

Over the next year, we’ll grow quickly to bring better care to many more members and their communities. To do this, we need people who, like us, believe that everyone should have good care for what matters to them, in their community.

Our work is grounded in a belief in the power of a diverse community. To close gaps in care and advance equity in the communities we serve, we have to start with making our own team diverse and inclusive. Our ways of working are characterized by creativity, collaboration, and mutual learning that comes from bringing together a community from diverse backgrounds and perspectives. We strive to ensure that every person on the Cityblock team, and every Cityblock member, feels supported and included as a part of our community.

Our Values:

Aim for Understanding

Be All In

Bring Your Whole Self

Lean Into Discomfort

Put Members First

About our Team:

We employ a field-based, home-based care model and are committed to meeting members where they are--in their homes, in their community, and in our Hubs. We will go above and beyond to connect with Cityblock members in a non-judgmental, respectful and empathic manner, to meet their needs, and to provide feedback to the system as a whole as we strive to do better every day.