Data Engineer

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.