Data Engineer roles are based in Toronto at the Toronto HQ. Full-time position with posting recently updated. Location: Toronto HQ (3381 Steeles Ave E).
Position Description
The Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and infrastructure that enable TTI Canada to leverage data for analytics, reporting, and decision-making. This individual will ensure data is accurate, reliable, and efficiently accessible by developing robust ETL / ELT processes, integrating diverse data sources, and supporting BI and analytics teams with clean and well-structured data. The successful candidate must demonstrate strong technical expertise, problem-solving skills, and a collaborative mindset, while being eager to learn and adapt to emerging cloud and data technologies.
What You Will Do
- The Data Engineer will lead the delivery of scalable and high-impact data infrastructure solutions from concept to deployment. In this position, the Data Engineer will:
- 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.
What You Will Bring
- 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.
What You Will Benefit From
- 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
Diversity, Equity, and Inclusion
Diversity, equity, and inclusion are at the core of our values at TTI. We foster an inclusive environment where diversity is valued and where all employees feel safe to contribute their ideas and solve problems as one team. We actively support and accommodate the diverse needs of our team, creating an empowering space where everyone can thrive.
J-18808-Ljbffr