
Data Engineer
- Toronto, ON
- Permanent
- Full-time
- Design, develop, and maintain efficient data pipelines to support analytics and BI needs.
- Ingest and integrate data from multiple sources, including on-premises SQL Server, cloud platforms, APIs, and flat files.
- Implement data transformation logic to clean, enrich, and prepare data for reporting and advanced analytics.
- Collaborate with Data Analysts, BI Developers, Data Scientists, and business stakeholders to understand requirements and translate them into technical solutions.
- Ensure data integrity, consistency, and accuracy through validation, monitoring, and governance practices.
- Optimize ETL/ELT processes for performance, scalability, and cost-effectiveness.
- Work with cloud-based data platforms (e.g., Azure, Snowflake, Databricks) to modernize TTI Canada’s data ecosystem.
- Support the development of a centralized data lake/data warehouse architecture.
- Implement best practices for data security, access control, and compliance.
- Monitor pipelines and troubleshoot ingestion or transformation failures.
- Create and maintain technical documentation for data pipelines, workflows, and architectures.
- Contribute to continuous improvement initiatives by evaluating and implementing emerging data engineering tools and practices.
- Legally entitled to work full-time in Canada and able to travel to the United States.
- Bachelor’s Degree in Computer Science, Information Systems, Engineering, or related field.
- 3–5 years of experience as a Data Engineer, Database Developer, or related role.
- Strong SQL skills and experience working with relational databases (e.g., SQL Server, Oracle, PostgreSQL).
- Proficiency with ETL/ELT tools and data pipeline orchestration (e.g., Azure Data Factory, dbt).
- Experience with cloud platforms such as Microsoft Azure, Snowflake, or Databricks.
- Strong programming skills in Python or Scala for data processing and automation.
- Familiarity with big data file formats (e.g., Parquet, ORC, JSON) and distributed processing frameworks (e.g., Spark).
- Understanding of data modeling, data warehousing, and dimensional design principles.
- Knowledge of data governance, security, and compliance best practices.
- Excellent problem-solving abilities, attention to detail, and communication skills.
- Ability to work collaboratively in cross-functional teams and adapt to a fast-paced environment.
- Extensive health benefits, including vision and dental care
- Retirement Savings Plan with Employer Matching Contributions
- Competitive Base Salary
- iPhone, and laptop
- Paid time off and employee discount programs
- Annual $500 Wellness Program allowance