Data Engineer

Job Description

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