Sr. Data Engineer

  • 1090 Don Mills Rd, North York, ON M3C 3R6, Canada
  • Full-time

Company Description

We are innovative data and analytics professionals who accelerate the data agenda of our clients. We make data come to life in marketing automation, algorithms, insights, and visualizations. We are a lean, fast partner alternative to other professional service consulting firms.

Job Description

We are looking for a Sr. Data Engineer to join our growing team. You will support the team across our three areas of focus: insights, analytics, and data. Across these three functions your area of focus will be in data strategy, analysis, data integration and data management.

We are looking for someone who has a solid foundation in technology, who can use data methodologies, solutions and tools to optimize performance by managing, sorting and filtering large volumes of data while extracting meaningful value from these large volumes of data. You will have exceptional analytical and problem-solving skills as well as a desire to learn new technologies.

  • Design and develop data ingestions within cloud environments (AWS, GCP, Azure)
  • Integrate and operationalize data feeds (API and file-based) into cloud-based data warehouses
  • Design high performing data schemas to support dashboard reports
  • Design and build marketing databases and reporting/BI datamarts
  • Develop data automation and monitor scripts
  • Develop ETL scripts to perform data transformations
  • Perform data profiling and data QA
  • Review data for inconsistencies or anomalies
  • Create documentation and data dictionaries to support end-users of data systems
  • Perform business analysis and requirements gathering to support a variety of data projects
  • Provide guidance/direction, best practices, code review with other data engineer team members

Qualifications

  • 5+ years of experience in data engineering
  • Experience with cloud platforms (Azure, AWS, GCP)
  • Hands on experience with cloud warehouse technologies: Snowflake, Redshift, etc
  • Strong understanding of data modelling concepts
  • Advanced skills in data scripting and database development technologies (SQL, C#, Python, Powershell, Ruby, R)
  • Experience with Airflow, Talend, FiveTran, Matillion or similar tools
  • Experience designing and building marketing databases and designing a high performing data schema
  • Experience integrating new data feeds into a cloud-based data warehouse
  • Ability to work with ambiguity, translate high-level direction to specific deliverables and effectively plan self-assigned tasks efficiently in complex work streams
  • Ability to take business requirements and create technology solutions
  • College or University degree (or relevant work experiences)

Experience with some or all of the following technologies would be an asset:

  • Reporting / Visualization tools like Tableau and Power BI
  • Machine learning algorithms
  • CRM / Marketing Automation Systems like Salesforce, Exact Target, Marketo, Eloqua
  • Web development experience

Additional Information

  • A criminal and background check will be required