Data Analytics Engineer

The Data Engineering and Architecture (DEA) team is responsible for unlocking the value in Chainalysis’ corporate data. We work with internal stakeholders in HR, Finance, Sales and Marketing as well as partners in Business Technology and Core Engineering to ship data solutions that are trusted, reliable, mature and transformative. Our goal is to accelerate Chainalysis’ growth and empower our employees to do their best work. 

The Data Analytics Engineer will design, build and maintain data integrations and automations between enterprise SaaS platforms and data warehouses. This work will be done in close partnership with colleagues in DEA to spin up and maintain data pipelines that support critical data-driven decisions across the company.

In this role, you’ll: 

• Develop and maintain data integrations and automations encompassing both ETL and Reverse ETL use cases 

• Create and maintain documentation for those data integrations and automations

• Build a data pipeline end to end using Chainalysis’ data stack

• Become comfortable with building custom solutions using cloud services

• Work through a backlog of fixes and enhancements

We’re looking for candidates who have: 

• Hands-on experience using dbt to build models and transformations via source control tools like Git and GitHub

• Ability to write and execute advanced-level SQL queries

• Intermediate knowledge of RDBMS database structures and data formats like JSON

• Experience implementing or working with Type 2 Slowly Changing Dimensions (Kimball)

• Hands-on experience using platforms like Fivetran to build data pipelines using off-the-shelf connectors to platforms like Redshift, Databricks, Salesforce, Workday, and NetSuite

• Hands-on experience connecting data warehousing platforms to BI tools like Tableau

• Obtaining authorization to and utilizing endpoint and resources via REST APIs

• Experience in an Agile-like environment that includes user stories, sprints, grooming and retrospectives

• Minimum 3 years of applicable experience

• U.S. Citizenship Required

This position is ineligible for visa sponsorship

Nice to have experience: 

• Familiarity with orchestration tools like Dagster

• Basic skills with writing procedural code using Python

Technologies we use:

• Dbt

• Databricks

• Fivetran

• Airbyte

• Dagster

• AWS

• Git & GitHub

• Datadog

About Chainalysis

Blockchain technology is powering a growing wave of innovation. Businesses and governments around the world are using blockchains to make banking more efficient, connect with their customers, and investigate criminal cases. As adoption of blockchain technology grows, more and more organizations seek access to all this ecosystem has to offer. That’s where Chainalysis comes in. We provide complete knowledge of what’s happening on blockchains through our data, services, and solutions. With Chainalysis, organizations can navigate blockchains safely and with confidence.

You belong here. 

At Chainalysis, we believe that diversity of experience and thought makes us stronger. With both customers and employees around the world, we are committed to ensuring our team reflects the unique communities around us. Some of the ways we’re ensuring we keep learning are an internal Diversity Committee, Days of Reflection throughout the year including International Women’s Day, Harvey Milk Day, World Humanitarian Day, and UN International Migrants Day, and a commitment to continue revisiting and reevaluating our diversity culture. 

We encourage applicants across any race, ethnicity, gender/gender expression, age, spirituality, ability, experience and more. If you need any accommodations to make our interview process more accessible to you due to a disability, don't hesitate to let us know. You can learn more here. We can’t wait to meet you.