BI Engineer (SQL)

About The Office of the CTO (Product Technology)

The Office of the CTO engages in activities to help the whole of ConsenSys. We help build out infrastructure to support innovation, incubate projects, and identify problems that ConsenSys is uniquely positioned to solve. We've got a great team of people who get to work across the organization to find ways to get the best impact. We value independent flexible thinking people who can work together with others to help ConsenSys build the software that powers Ethereum.

What you’ll do

As an Analytics Engineer with ConsenSys Data, you sit uniquely poised to help the company and our product teams unpack and understand our raw data. You'll help provide guidance and analytics on datasets from Infura, MetaMask, Swaps, QBS, and more.

As an early hire, you'll set the shape of Analytics Engineering at ConsenSys moving forward. We welcome your expertise on best practices for dbt, data warehousing, and analytic capability.

Would be great if you brought this to the role

• 2+ years of writing SQL - able to write structured and efficient queries

• 2+ years working business visualization tools and designing intuitive dashboards 

• Experience with LookML (Tableau good too!)

• Experience with BigQuery (Redshift or Snowflake good too!)

• Experience with ETL/ELT tools

• Experience with analyzing Blockchain on/off chain Data

• Expert in database table design, data warehouse concepts, and analytics platforms

• Experience in working with git workflows and structuring projects with DBT

• Create testing to ensure data quality and catalog documentation for stakeholders 

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. 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.

ConsenSys is an equal opportunity employer. We encourage people from all backgrounds to apply. We are committed to ensuring that our technology is made available and accessible to everyone. All employment decisions are made without regard to race, color, national origin, ancestry, sex, gender, gender identity or expression, sexual orientation, age, genetic information, religion, disability, medical condition, pregnancy, marital status, family status, veteran status, or any other characteristic protected by law. ConsenSys is aware of fraudulent recruitment practices and we encourage all applicants to review our best practices to protect yourself which can be found https://consensys.net/careers/best-practices-to-avoid-recruitment-fraud/.