Senior Data Engineer
D2L
AWSETLPythonSQLSSISTerraform
Data Engineer
Top Hat
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇨🇦 Canada
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
AirflowAmazon RedshiftAWSAzureBigQueryCloudETLGoogle Cloud PlatformKafkaNeo4jPythonScalaSQL
About the role
- Play a central role in building robust BI (dimensional) and ER models that power analytics, reporting, and product-facing features
- Contribute to medallion-style architecture as a layered approach to data delivery
- Design & Model Data: Build and optimize BI-oriented dimensional models (star/snowflake) and ER data models
- Develop and maintain reliable, scalable ETL/ELT pipelines using SQL, Python/Scala, and orchestration tools (e.g., Airflow, MWAA)
- Implement validation frameworks, manage access controls, and handle PII data responsibly
- Transform and optimize structured and semi-structured data (JSON, Avro, Parquet)
- Apply graph database concepts (e.g., Neo4j) for lineage, metadata, or relationship-driven use cases
- Partner with analytics, product, and data science teams to translate requirements into robust and accessible datasets
Requirements
- 3+ years building production-grade pipelines and data assets
- Solid understanding (Intermediate) in layered/medallion architectures and entity modelling
- Strong proficiency in SQL query tuning and optimization
- 3-4 years using Python (or Scala) for production-grade transformations
- Hands-on with at least one or multiple cloud platforms (AWS, GCP, or Azure)
- Practical experience with Athena, Redshift, BigQuery, Snowflake, or Databricks
- 3+ years using orchestration frameworks (Airflow, MWAA, Dagster, etc.)
- Working familiarity and optimization of structured & semi-structured data
- Proven experience implementing governance, access controls, and PII handling (Senior)
- 1–2 years experience with graph modelling and query optimization
- Expected 2–3 years for Event-Driven Architectures (Kafka, Kinesis, Pub/Sub)
Benefits
- Competitive health benefits that start on day one
- Flexible, remote first work environment
- Professional learning and development for all role levels
- Innovative PTO policy with lots of time and space for self-care
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLPythonScalaETLELTdata modelingquery optimizationgraph modelingevent-driven architecturedata transformation
Soft skills
collaborationcommunicationproblem-solvinganalytical thinkingattention to detail
