dbt Analytics Engineer
Tucows (NASDAQ:TCX, TSX:TC) is possibly the biggest Internet company you’ve never heard of. We started as a simple shareware site in 1993 and have grown into a stable of businesses; mobile, internet and domains.
We embrace a people-first philosophy that is rooted in respect, trust, and flexibility. We believe that whatever works for our employees is what works best for us. It’s also why the majority of our roles are remote-first, meaning you can work from anywhere you can connect to the internet!
Today, close to a thousand people work in over 16 countries to help us make the Internet better. If this sounds exciting to you, join the herd!
This is a completely remote opportunity within Canada and USA.
Tucows is looking to add an Analytics Engineer to our data engineering team which is part of the wider Analytics, Insights and Reporting (AIR) team. Together, we’re responsible for all of the reporting, analytics, data flows, visualization, and related business intelligence operations within our quickly growing company. We’ve got a lot of data, and we’re looking for someone to help us get the most out of it.
You and the data analysts will work with business, product, and engineering stakeholders to understand their needs and priorities, as well as to collaborate and ensure that their reporting requirements are captured in the development process. You’ll then work with data engineers to build data pipelines, acquiring data from source systems and moving it through our data hierarchy, from messy and raw to clean, aggregated and documented. You’ll train analysts and business stakeholders on how to use the data sets you create.
Responsibilities include but are not limited to:
- Use DBT to deliver and maintain clean, transformed data models ready for analytics
- Understand business needs and technical requirements to meet those needs
- Troubleshoot variances in reports, and strive to eliminate them at the source
- Document your data models and provide training as needed
- Incorporate engineering best practices on version control, testing, CI/CD
Key Skills and Experience:
- Solid experience with DBT for data transformation, testing and maintainable lineage
- Top-notch communication (verbal and written) and interpersonal skills
- Excellent problem solving skills
- 3+ years experience handling, manipulating, and documenting data
- Strong expertise in SQL, data warehouse design and data lake architectures
- Basic python programming
- Familiarity with linux commands and version control tools
Nice to Have:
- Experience with Airflow
- Experience with Docker
- Experience with Looker
Education:
- Post-secondary education in a technical field, or B.S./M.S.