Senior Developer, Software; ETL

Company Summary

Come work for a company that’s committed to the success of each and every employee. A place where innovators and collaborators come together and build on each other’s talents. Where diversity is welcomed and celebrated.

FCT provides industry-leading title insurance, default solutions and other real estate related products and services to legal, lending, valuation and real estate professionals across Canada. With FCT, you will have the opportunity to build a meaningful career. Join us as we continue to do exciting work and make a big impact on our colleagues, customers and communities.

We are continually searching for great talent; individuals who possess a deep commitment to the customers and markets we serve. If you would like to join a company that is committed to the success of each employee and offers challenge, purpose and the opportunity to grow both personally and professionally in a team-oriented environment, you ll enjoy a career with us!

We understand that fostering a diverse and inclusive environment is critical for the success of our business, and we actively work towards it every day.

We are seeking a high-performing ETL Developer who thrives in a fast-paced BI/Analytics environment and takes pride in building reliable, scalable, and efficient data pipelines. In this role, you will work closely with Data Modelers, BI developers, data engineers, and business stakeholders to operationalize high-quality data solutions that support enterprise reporting, analytics, and decision-making.

You will play a critical role in designing, developing, optimizing, and maintaining ETL processes across both Azure cloud environments and on-premises database systems. The ideal candidate is hands-on, detail-oriented, and committed to continuous learning and improvement. High expectations come with this opportunity—you will be entrusted with complex data integration workflows, performance tuning, and delivering consistent, well-engineered pipelines that support enterprise-wide Data Marts and analytics platforms.

• Design, build, and maintain end-to-end ETL workflows across Azure (ADF, Synapse, Databricks) and on-premises database environments, ensuring performance, reliability, and scalability.
• Work closely with the Data Modeler to understand data structures, business rules, and integration needs, ensuring that all ETL processes align with Data Mart and data model specifications.
• Manage and support on-premises SQL Server environments, including database jobs, stored procedures, performance tuning, and ensuring high-availability of data processing activities.
• Implement complex business logic through data validation, transformation, enrichment, and orchestration across cloud and on-prem systems.
• Optimize pipelines to support high-volume data processing, monitoring performance, identifying bottlenecks, and proactively implementing improvements.
• Ensure data quality and integrity, applying robust error-handling, auditing, metadata tracking, and data reconciliation processes.
• Collaborate with BI/Analytics and Data & Analytics teams to ensure data is delivered accurately, consistently, and on schedule—with transparency into lineage and operational performance.
• Document ETL architecture and workflows, including data flows, schedules, dependencies, and operational procedures.
• Stay current with industry trends and best practices in ETL engineering, Azure data services, automation, and Dev Ops-oriented data operations.

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field.
• 5+ years of hands-on data modeling experience in BI/Analytics, data warehouses, or data marts.
• Proven experience using data modeling tools such as ER/Studio, Erwin, or equivalent.
• Strong knowledge of relational and dimensional modeling (star/snowflake schemas) and best practices for scalable BI/Analytics data structures.
• Advanced SQL skills and a solid understanding of database technologies—preferably SQL Server and related Microsoft stack components.
• Experience designing and implementing data models that support Power BI
• Understanding of ETL…