Company Summary

Come work for a company thats committed to the success of each and every employee. A place where innovators and collaborators come together and build on each others 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.

Job Summary

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 youll 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.

HERES HOW YOULL CONTRIBUTE

• 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 DataMart 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 schedulewith 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 DevOps-oriented data operations.

HERES WHAT YOULL BRING:

• Bachelors 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 technologiespreferably SQL Server and related Microsoft stack components.
• Experience designing and implementing data models that support Power BI
• Understanding of ETL processes and data integration with the ability to collaborate effectively with ETL developers using tools like Synapse Azure Data Factory Databricks or SSIS.
• Experience with Azure cloud data services such as Azure SQL Database Azure Synapse Analytics Azure Data Lake Storage (ADLS) and Delta Lake.
• Familiarity with metadata management data lineage and data governance frameworks.

Total Direct Compensation:

Any pay range is in $CAD

HERES WHAT SETS US APART:

Through mentoring innovative tools and a variety of programs that engage and reward we empower each employee to be great and drive results.

• Comprehensive benefits that include Employee and Family Assistance Program (EFAP) and Wellness Essentials

• Group retirement savings plan with company match

• Paid holidays and generous paid time off

• Hybrid work arrangements

• Paid volunteer opportunities and charitable donation matching

• Employee recognition programs that include referral incentives

• Potential for performance-based incentives

• The opportunity to participate in our stock purchase plan

• And more!

*As per terms of the employment agreement

The Great Place to Work Institute has named FCT one of Canadas Top 50 Best Workplaces Best Workplaces in Canada for Financial Services & Insurance Best Workplaces in Canada for Women Best Workplaces in Canada for Inclusion and Best Workplaces in Canada for Mental Wellness. Were also one of Achievers 50 Most Engaged Workplaces in North America.

By joining us you will not only be part of an award-winning organization you will be part of a workforce that is engaged and empowered to succeed.

Thank you for considering FCT. We look forward to meeting you.

In accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act a request for accommodation will be accepted as part of FCTs hiring process.

To avoid any delays in the recruitment process if you require accommodation to apply please provide your accommodation needs in advance. You may also be required to submit adequate medical/other documentation to Human Resources to support your request for accommodation.

FCT is an equal opportunity employer and is committed to an active nondiscrimination program. All recruitment hiring placements transfers promotions training compensation benefits discipline and other terms and conditions of employment will be on the basis of the qualifications of the individual regardless of race colour place of origin ethnic origin citizenship handicap (including mental and physical disability) sex sexual orientation gender identity and expression creed (religion) marital status family status (being in a parent/child relationship) age or any other basis prohibited by the applicable provincial or federal human rights legislation.