Data Engineer

AgencyAnalytics; Canada; Remote; CAD 90,000 - 136,000; Full time

Job summary

An established industry player seeks a talented Data Engineer to join their innovative team. In this remote role, you will be instrumental in building and maintaining a robust data warehouse, optimizing data pipelines, and supporting data analysts in delivering actionable insights. This opportunity allows you to contribute to a growing data culture, ensuring high-quality data integration and documentation practices. If you are passionate about data engineering and eager to make a significant impact in a forward-thinking environment, this role is perfect for you.

Qualifications

• 4+ years of experience in data engineering with Snowflake.
• Expertise in building scalable and reliable data pipelines.
• Strong proficiency in SQL and Python.

Responsibilities

• Collaborate with teams to build and maintain data pipelines.
• Design and implement data models for analysis and reporting.
• Develop dashboards to communicate key findings to stakeholders.

Skills

Data Engineering

Snowflake

SQL

Python

Data Pipeline Development

ETL/ELT Processes

Google Cloud Platform (GCP)

Communication Skills

Collaboration Skills

Tools

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

• You will be collaborating with data analysts, engineering leads, and operational teams to drive data efforts, build and maintain pipelines, and enable operational tools.
• You will ensure seamless integration of various data sources, maintaining high quality and consistency
• You will design and implement data models that facilitate data analysis, reporting, and business intelligence needs.
• You will be responsible for optimizing the performance and costs of Snowflake, ensuring that we get the full potential from the platform while also balancing spend.
• You will help create a culture of documentation among the data team, including processes, definitions, and table/field descriptions.
• You’ll be responsible for developing and maintaining 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 $90100 - $135200 / 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.