Analytics Engineer
Location | Dar es Salaam, Tanzania, United Republic of |
Date Posted | May 1, 2024 |
Category | Engineering IT / Information Technology |
Job Type | Full-time |
Currency | TZS |
Description
About the job
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.
About Marketing
Creatives at Consensys make work that moves the crypto industry forward, spreading our leading-edge products far and wide into the world and pushing for the adoption of Web3 technology. We’re an ambitious team, using our unique point of view to create work that infiltrates crypto culture, influences mindsets, and prizes ourselves on being defiantly optimistic.
What you’ll do
We are seeking an Analytics Engineer to join our Marketing Analytics & Measurement team. In this pivotal role, you will help to build out our data warehouse and establish trusted sources for all of our most important Marketing data sets. Your mandate will be to break down data silos and, together with our marketing analysts, to improve the decision velocity of the entire Marketing org with improved access to reliable, user-friendly data and reporting.
You will act as a primary interface between the Marketing and Data org and will influence the ongoing evolution of our best-in-class analytics capabilities. This is a unique opportunity to have an outsized impact in a dynamic company and a rapidly evolving web3 ecosystem.
- Work with marketing analysts, product marketing managers and other Marketing stakeholder groups to understand their data needs and translate those into technical requirements
- Partner closely with our MarTech team to provide subject matter expert on all our Marketing data sources including Google Analytics, Segment, HubSpot, and Sprinklr
- Interface with the Product org and the Data Platform team to understand product data sources (e.g. event logs) for use in Marketing pipelines
- Design, develop, and maintain fact, dimension and aggregate tables in the Marketing data mart within our data warehouse for attribution, site analytics, and other marketing use cases
- Set up staging tables and encode transformation logic as performant SQL data models in DBT
- Help analysts to pull data warehouse tables into Looker as views and explores for self-serve dashboarding
- Collaborate closely with the Data Platform team on data governance, including CI/CD testing, to ensure data reliability and consistency with other trusted sources (e.g. other data marts)
- Create and maintain documentation for all Marketing data models in YML
- Continuously monitor and report on the costs and performance of the Marketing data mart
Would be great if you brought this to the role:
- Resourceful, persistent, and creative problem solver who enjoys hacking on wicked problems
- Must have experience delivering data models in DBT for the purposes of attribution.
- Solid understanding of dimensional data modeling and agile data warehouse design
- Conversant in attribution, identity resolution and other core concepts from marketing analytics and site analytics
- Mastery of SQL and prior experience with ETL tools and processes (e.g. FiveTran, Spark, Airflow, Hightouch, etc.); dbt and LookML experience highly desirable
- Proficiency with Git and CLI (show us your repos!)
- Demonstrated interest in on-chain data and blockchain technology (show us your Dune dashboards!)
- Strong communication skills to effectively collaborate with both technical and non-technical stakeholders
- Track record of proactively identifying and addressing challenges; ability to work independently and manage multiple tasks simultaneously
- Bachelor’s degree in Software Engineering, Computer Science, Information Systems, or another quantitative discipline
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.