Data Engineer

AgencyAnalytics Inc; Snowflake (AZ); Remote; CAD 90,000 - 136,000; Full time

Job summary

An established industry player seeks a skilled Data Engineer to join their dynamic team. In this role, you will be pivotal in building and maintaining a robust data warehouse and BI platform, enabling data-driven decisions across the organization. You will collaborate closely with data analysts and operational teams, ensuring high-quality data integration and developing insightful dashboards and reports. This is a fantastic opportunity to shape the data culture in a growing team and make a significant impact on how data is utilized within the company. If you're passionate about data engineering and looking for a role where your contributions matter, this position is for you.

Qualifications

• 4+ years in data engineering with strong Snowflake experience.
• Expertise in building scalable data pipelines and using SQL and Python.

Responsibilities

• Collaborate with teams to build and maintain data pipelines.
• Design and implement data models for analysis and reporting.

Skills

Data Engineering

SQL

Python

Building Data Pipelines

Data Warehousing

ETL/ELT Processes

Communication Skills

Collaboration

Google Cloud Platform

Metabase

Tools

Snowflake

Metabase

BigQuery

Job description

Data Engineer

Department: Operations

Employment Type: Permanent

Location: Remote Canada

Reporting To: Dan Marco

Compensation: $90,100 - $135,200 / year

Description

At AgencyAnalytics, we empower marketing agencies with cutting-edge tools to streamline their reporting processes and elevate their client relationships. As a leading B2B SaaS company, we specialize in providing automated reporting software tailored to the unique needs of marketing professionals worldwide. Our mission is to revolutionize how agencies analyze and communicate data, ultimately helping them drive better results for their clients.

• As a Data Engineer, you will be a key driver of enabling analytics through building and maintaining our data warehouse (Snowflake), our BI platform (Metabase) and supporting data analysts in accessing and cleaning data. You will play a crucial role in designing, developing, and maintaining metrics, data pipelines, dashboards as well as other self-service data tools to drive business decisions.
• Reporting to the Director, Data & Insights, you will be part of a growing data team, currently composed of yourself and two data analysts. This is an opportunity to get in on the ground floor of a new team and help build the data culture at AgencyAnalytics.

Key Responsibilities

• Collaborate with data analysts, engineering leads, and operational teams to drive data efforts, build and maintain pipelines, and enable operational tools.
• Ensure seamless integration of various data sources, maintaining high quality and consistency.
• Design and implement data models that facilitate data analysis, reporting, and business intelligence needs.
• Optimize the performance and costs of Snowflake, ensuring that we get the full potential from the platform while also balancing spend.
• Create a culture of documentation among the data team, including processes, definitions, and table/field descriptions.
• Develop and maintain dashboards, reports, and visualizations to effectively communicate key findings and trends to stakeholders.

Skills, Knowledge & Expertise

• Experience: 4+ years of experience in data engineering, with direct experience with Snowflake.
• Building Data Pipelines: Demonstrated expertise in building highly scalable, high performance, and reliable data pipelines.
• Technical Expertise: Advanced proficiency in SQL and strong experience with Python. Strong familiarity with data warehousing, data modelling, and ETL/ELT processes. Familiarity with BigQuery and Metabase is a bonus.
• Cloud Platforms: Experience with public cloud platforms, especially Google Cloud Platform (GCP).
• Communication: Strong communication skills, with the ability to explain complex technical concepts for both technical and non-technical audiences.
• Collaboration: Excellent interpersonal skills and an ability to work cross-functionally with a wide range of stakeholders.

Compensation

Our base salary for this role ranges from $90,100 - $135,200 / year CAD. Compensation is determined by factors such as market salary data within Canada, technical skills, previous work history, and internal pay equity. Many positions also include additional variable compensation, which our Talent Acquisition team will discuss with you during the interview process.