Analytics Engineer
Role details
Job location
Tech stack
Job description
The Data team sits within the Office of the COO and builds the models and frameworks that translate raw data into company-wide KPIs. We sit at the intersection of engineering and analytics, ensuring that data is transformed into the metrics Finance, Product, and Leadership need to operate - and to file for IPO with confidence.
What you'll do
- 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., In the rapidly evolving Web3 space, we believe that everyone is a builder. This expansive paradigm requires a range of backgrounds, talents, skills, and experiences to influence and shape the future. At Consensys, this diversity fuels our ability to shift control and redefine the realm of possibility. We are committed to ensuring that our technology empowers people and communities with economic and political agency through decentralized technologies. We welcome the range of perspectives and differences and celebrate them. We're excited to see how your unique skills as a builder can contribute to our vision, drive innovation, and help us shape a more inclusive Web3.
Requirements
- 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).
Don't meet all the requirements? Don't sweat it. We're passionate about building a diverse team of humans and as such, if you think you've got what it takes for our chaotic-but-fun, remote-friendly, start-up environment-apply anyway, detailing your relevant transferable skills in your cover letter. While we have a pretty good idea of what we need, we're ready for you to challenge our thinking on who needs to be in this role.