Consensys is the leading blockchain and web3 software company, pioneering technological developments within the web3 ecosystem. The Senior Analytics Engineer will design, build, and maintain data models, collaborating with various stakeholders to transform raw data into actionable business metrics and KPIs.
Responsibilities:
- Design, build, and maintain reliable data models that transform raw data into business-ready datasets
- Collaborate closely with analysts, data scientists, and business stakeholders to understand requirements and translate them into actionable metrics, KPIs, and dashboards
- Develop and maintain metrics definitions, semantic layers, and data documentation to ensure consistency across teams
- Build, optimize, and test dbt models to deliver clean, reliable, and trusted data
- Ensure data quality, accuracy, and governance are embedded in all models and pipelines
- Create dashboards, reports, and visualizations that empower business users to make data-driven decisions
- Work with SQL and transformation frameworks to write efficient queries and maintain performant models
- Partner with data engineers to ensure smooth data ingestion and availability for analytics
- Continuously improve processes and workflows to increase efficiency, reliability, and scalability
Requirements:
- Design, build, and maintain reliable data models that transform raw data into business-ready datasets
- Collaborate closely with analysts, data scientists, and business stakeholders to understand requirements and translate them into actionable metrics, KPIs, and dashboards
- Develop and maintain metrics definitions, semantic layers, and data documentation to ensure consistency across teams
- Build, optimize, and test dbt models to deliver clean, reliable, and trusted data
- Ensure data quality, accuracy, and governance are embedded in all models and pipelines
- Create dashboards, reports, and visualizations that empower business users to make data-driven decisions
- Work with SQL and transformation frameworks to write efficient queries and maintain performant models
- Partner with data engineers to ensure smooth data ingestion and availability for analytics
- Continuously improve processes and workflows to increase efficiency, reliability, and scalability
- Over 6 years of experience as a Analytics Engineer
- Previous experience developing and tracking KPIs for public companies
- Expert-level SQL skills with experience writing complex queries and optimizing performance
- Hands-on experience with dbt for data transformation and modeling
- Strong understanding of data modeling concepts (e.g., star schema, snowflake schema, dimensional modeling)
- Familiarity with BI and dashboarding tools (e.g., Looker, Superset, Tableau, Power BI)
- Experience defining KPIs and metrics for business stakeholders
- Comfort with Python or other scripting languages for lightweight data transformations and automation
- Knowledge of data governance, lineage, and documentation tools (e.g., DataHub, Great Expectations)
- Understanding of cloud data warehouses (e.g., Snowflake, BigQuery, Redshift)
- Collaborative mindset and ability to work closely with both technical and non-technical stakeholders
- Experience with version control and CI/CD practices in analytics workflows (e.g., GitHub Actions)