Tech Stack
Amazon RedshiftBigQueryCloudPythonSQL
About the role
- The Data and Analytics team is responsible for unlocking the value in Chainalysis’ corporate data and building foundational data products.
- Design, develop, and maintain robust, scalable data models and transformation pipelines using dbt and SQL—with a special emphasis on expert-level data modeling in dbt—to support analytics and business intelligence across the company.
- Collaborate with stakeholders in Finance, Sales, Marketing, and Product to translate business requirements into technical specifications for reliable datasets.
- Apply software engineering best practices, including Git version control, CI/CD, automated testing, and documentation, to ensure data quality and maintainability.
- Own and enhance the data architecture within our cloud data warehouses (Snowflake/Redshift/Databricks), optimizing for performance, scalability, and cost-effectiveness.
- Develop and manage data integrations from source systems (e.g., Salesforce, NetSuite, Pendo) using tools like Fivetran and custom Python scripts.
- Mentor engineers and analysts on advanced dbt data modeling techniques and the effective use of our data stack.
- Contribute to our data governance framework by establishing and enforcing standards for data quality, consistency, and metric definition.
Requirements
- 5+ years of professional experience in analytics engineering, data engineering, or BI development, with a record of shipping data products to production.
- Expert-level proficiency in SQL and deep experience with data modeling techniques, especially building and optimizing complex data models in dbt for scalable analytics use cases.
- Extensive hands-on experience building, testing, and deploying dbt projects in a complex business environment.
- Strong programming skills in Python for data manipulation and automation.
- Experience with modern cloud data warehouses (Snowflake, BigQuery, Databricks).
- Proven ability to work cross-functionally, translating ambiguous business questions into well-defined, quantitative solutions.
- Experience with version control systems such as Git and CI/CD workflows.
- This position is ineligible for visa sponsorship.
- Are you legally authorized to work for any employer in Canada without restrictions? (Application form - required)
- Currently this role is only eligible for hire in Canada in British Columbia, Alberta, or Ontario. Can you please confirm if you currently reside in one of these provinces? (Application form - required)