- Designing and developing data processing infrastructure.
- Developing new and improving existing data pipelines, extracting from external API sources or internal events.
- Developing self-serve data solutions, self-correcting robust ETL pipelines.
- Continuously improving monitoring and alerting coverage.
- As a Sr. Engineer, this role will provide mentorship to colleagues in/outside of the immediate team.
- Self-driving proof of concept for new technologies, new patterns and writing technical specifications for data architecture projects.
- Identifying complex scaling bottlenecks and how to prevent them, and communicating updates to stakeholders.
- Performing maintenance of existing infrastructure, investigating issues and failures.
- Conducting SQL data investigations, and optimizations.
- Participate in peer code reviews and produce high quality documentation.
- Bachelor's or Master's degree in Computer Science/Engineering.
- Very strong SQL proficiency, and SQL query optimization experience is required.
- Extensive expertise in Python programming is required. Scala, Java experience is a bonus.
- Excellent communication skills.
- Proponent of strong software production engineering practices, version control, code peer reviews, automated testing, and CI/CD.
- Experience in AWS cloud is required. GCP, Azure are preferred.
- Proficiency with one of the Cloud data-warehouses / data-lakes like Snowflake, Google BigQuery, AWS Redshift, Azure Synapse, Databricks.
- Hands-on experience with modern orchestration platforms, such as Airflow.
- Experience in relational databases like Postgres, MySQL, Oracle or SQL Server required.
- Experience in non-relational technologies like MongoDB, Redis, DynamoDB or Cassandra is preferred.
- Applications and data-flow development in the Hadoop ecosystem is a plus.
- Deep understanding of data engineering fundamentals, ELT / ETL, latency, observability, lineage, distributed storage and distributed computing.
- Excellent data modeling skills, database design, relational/non-relational.
- Very comfortable with exploring new technologies, leveraging new patterns, designing new data architectures, and creative problem solving.
- Familiarity with docker, kubernetes containerization strategies and optimization is preferred.
- Working knowledge of dbt and jinja macros, dbt docs, dbt test is preferred, but not required.
- Any experience collaborating with business intelligence, data analytics, data science stake-holders is a strong plus.
- Strong Linux skills.
- Competitive salary + bonus + equity
- Generous PTO + 11 company holidays
- Open sick time
- Medical, Dental & Vision
- RRSP w/matching
- Paid professional development
- Leadership & growth opportunities
- Virtual company and team building events The base salary range in Canada for this full-time position is $127,000 - $159,000 + bonus + equity + benefits. Our salary ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all and Canada locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Your recruiter can share more about the specific salary range for your preferred location during the hiring process.Canada - System1's headquarters is located in Marina del Rey, CA with additional offices in Bellevue, WA and Guelph, ON, Canada. Employees near office locations are returning to the office. Location-specific policies and available accommodations will be discussed during the interview process.#BI-Hybrid#LI-Hybrid#LI-AW1
-
Data engineer
1 week ago
Société Financière Manuvie Waterloo, ON, CanadaNous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...
-
REMOTE - SQL Data Engineer/Python/SQL
1 week ago
Société Financière Manuvie Waterloo, ON, CanadaNous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...
-
Senior Data Engineer
4 days ago
System1 Guelph, ON, CanadaSystem1 is one of the largest customer acquisition companies in the world whose growth depends heavily on a very talented data engineering team. · The Data Engineering team at System1 is focused on building data assets, catalog, frameworks, and automation to ensure smooth runnin ...
-
Data Engineer III
7 hours ago
System1 Guelph, Canada Full timeSystem1 is one of the largest customer acquisition companies in the world whose growth depends heavily on a very talented data engineering team. The Data Operations team at System1 is an engineering team that is focused on building processes, procedures and automation to ensure s ...
-
789403 - Intern - Gis
6 days ago
Geosyntec Consultants Guelph, Canada**ESSENTIAL DUTIES AND RESPONSIBILITIES** · Is this the right position to help you achieve your professional goals? Some of the key responsibilities for position include: · - Producing routine data visualization outputs using ArcGIS, ArcGIS Online, Microsoft Excel, Microsoft Acce ...
-
Intern - Gis
6 days ago
Geosyntec Consultants, Inc. Guelph, Canada**ESSENTIAL DUTIES AND RESPONSIBILITIES** · Is this the right position to help you achieve your professional goals? Some of the key responsibilities for position include: · - Producing routine data visualization outputs using ArcGIS, ArcGIS Online, Microsoft Excel, Microsoft Acce ...
-
Intermediate Systems Performance Analyst
5 days ago
Canadian Solar Guelph, CanadaCanadian Solar Inc. is one of the world's largest solar modular producers. Our mission is to power the world with solar energy and create a better and cleaner Earth for future generations. As a leading vertically integrated provider of ingots, wafers, solar cells, solar modules, ...
-
Process Excellence Specialist
2 days ago
Gay Lea Foods Guelph, Canada**Department**: Process Excellence · **Reports to**: Director, Engineering and Process Excellence · **Job Scope**: · Reporting to the Director, Engineering and Process Excellence, this position serves as a team lead for targeted continuous improvement initiatives and change manag ...
-
Compliance Coordinator
4 days ago
Envirosearch Operations Inc. Guelph, CanadaWHO WE ARE · Envirosearch Operations was created in 2001 to specialize in providing water and wastewater operations services to non-municipal owners of water and wastewater treatment facilities in the Province of Ontario. At our heart, we believe in teamwork between Owners, Regul ...
-
Compliance Specialist
3 days ago
Envirosearch Operations Inc. Guelph, CanadaWHO WE ARE · Envirosearch Operations was created in 2001 to specialize in providing water and wastewater operations services to non-municipal owners of water and wastewater treatment facilities in the Province of Ontario. At our heart, we believe in teamwork between Owners, Regul ...
-
Coordinator - System
5 days ago
Linamar Corp Guelph, CanadaCoordinator - System · QUALIFICATIONS: · - Must have knowledge of the ISO/TS 16949, ISO 14001 and OHSAS 18001 Standard Requirements · - Must be able to work in a computerized environment - Word, Excel · - Minimum three years experience in a quality or manufacturing environment. · ...
-
838339 - Gis / Data Management Specialist
5 days ago
Geosyntec Consultants, Inc. Guelph, CanadaOverview: · If you're looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you We are seeking a **GIS / Data Management ...
-
System Analyst, Intermediate
3 days ago
Linamar Corp Guelph, Canada**Systems Analyst, Intermediate** · **Performance Expectations**: · - System Analysis and Evaluation: · - Collaborate with business stakeholders to understand their needs and requirements. · - Analyze existing systems, processes, and data flows to identify inefficiencies and area ...
-
Cad Drafter
3 days ago
Linamar Corp Guelph, Canada**CAD Drafter** · The CAD Drafter position, under general supervision, will be responsible for carry out drafting assignments of a routine to moderately complex nature. Primarily accountable for converting product design sketches into working documents by digitizing with Computer ...
-
Clerk - Quality
4 days ago
Linamar Corp Guelph, CanadaClerk - Quality · The Clerk - Quality position is responsible for ensuring daily and monthly data entry and reporting is up to date. In addition, assist Q. Manager, Q. Supervisor, and Quality personnel in correspondence, internal and customer related reports. · Powering Vehicles, ...
-
Ergonomic Consultant
2 days ago
Options Incorporated Guelph, CanadaPosted on January 19, 2023 by TT · Options Incorporated is an ergonomics consulting firm based in Guelph, Ontario. We do not have any job openings at present, however the nature of professional consulting is that change is ever-present. With this knowledge we're always looking fo ...
-
Geochemistry Professional
4 days ago
SLR Consulting Guelph, CanadaProvide technical expertise, guidance, and oversight on small and large-scale geochemisty projects with varying degrees of complexity · - Opportunity to support growth and expansion of geochemical and multidisciplinary project delivery in strategic markets across Canada · - Close ...
-
Junior Environmental Technician
3 days ago
Matrix Solutions Inc. Guelph, Canada**Junior Environmental Technician** · **(4 or 8-month Co-op or Summer Student Position starting May 2023)** · At Matrix Solutions we collaborate across services, disciplines, and geographies to deliver responsive, locally connected, and scalable solutions customized to our client ...
-
Cmm Operator
14 hours ago
CGL MANUFACTURING INC. Guelph, Canada**Company Introduction**: · **Arrow Machine and Fabrication Group** is an engineering-focused solution provider of machined castings, fabrications, and assemblies. · We serve OEM customers in the rail, material handling, mining, defense, heavy truck, agriculture, power systems, c ...
-
Environmental Project Coordinator
6 days ago
Triton Environmental Consultants Guelph, CanadaWhat if you could work alongside inspiring scientists, managers, and thought leaders, using state-of-the-art equipment, with diverse people working toward a common goal? Are you looking for a place where you can be you, a place where you can thrive? Triton might be just what you' ...
Senior Data Engineer - Guelph, Canada - System1
Description
System1 is one of the largest customer acquisition companies in the world whose growth depends heavily on a very talented data engineering team. The Data Engineering team at System1 is focused on building data assets, catalog, frameworks, and automation to ensure smooth running data pipelines and infrastructure. We process billions of records per day, for the benefit of multiple business functions like business intelligence, data analytics, data science & machine learning, traffic quality and serving optimizations.You would be working in a fast-paced environment where data system scalability, reliability, usability, efficiency and data quality are the goals. Come join usThe Role You Will Have:
What You Will Bring:
What We Have to Offer: