BI Engineer (SQL)

Remote, Global, Corporate Operations/Office of the CTO Team, Full Time

Our mission is to unlock the collaborative power of communities by making Web3 universally easy to use, access, and build on.

Working with ConsenSys puts you at the forefront of an evolving paradigm, transforming our society for the better. We fundamentally believe blockchain is the next generation of technology that can lay the foundation for a more just and equitable society. 

Blockchain tech is just over 10 years old. Ethereum itself is still a toddler and we’re far from reaching our full potential. You’ll get to work on the tools, infrastructure, and apps that scale these platforms to billions of users. 

You’ll be constantly exposed to new concepts, ideas, and frameworks from your peers, and as you work on different projects — challenging you to stay at the top of your game. You’ll join a network of entrepreneurs and technologists that reaches the edge of our ecosystem. ConsenSys alumni have moved on to become tech entrepreneurs, CEOs, and team leads at tech companies. 

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

#LI-Remote #LI-EC1