Data Analyst, Finance

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.

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

The Finance Data Analyst will be responsible for collecting, organizing, and analyzing data, troubleshooting data issues, developing reports, communicating results, driving key projects, and drive process optimization. This role will collaborate with partners across the organization and the US parent to support key initiatives or to function as a liaison to drive system updates or process changes.

HERE’S HOW YOU’LL CONTRIBUTE:

• Function as a Power BI and SQL query expert, translating business requirements into effective reports, data visualizations, queries/stored procedures, key performance indicators (KPIs), data analysis/interpretation to support financial reporting and decision-making processes.

• Support the development and maintenance of sophisticated advanced financial models for budgeting, forecasting, scenario analysis, and project assessments, collaborating closely with cross-functional teams to refine assumptions and guide strategic financial planning.

• Perform data quality checks to ensure accuracy, completeness, and reliability of financial data.

• Collect, clean, and analyze data from various sources to identify trends, patterns, and insights.

• Develop and maintain visually compelling and interactive BI reports, dashboards, and visualizations.

• Develop and maintain documentation for BI reports, dashboards, and data models.

• Ensure accuracy and consistency of data used in reports and dashboards.

• Function as a subject matter expert for our finance system, understanding transactional level processing to provide back-up support to our systems team and support on various data related requests.

• Identify opportunities for automation, process enhancement and spearhead the development of scripts or workflows to streamline routine tasks, significantly improving overall operational efficiency.

• Respond promptly to ad-hoc requests for financial analysis, delivering timely and insightful reports that support decision-making at various organizational levels.

HERE’S WHAT YOU’LL BRING:

• Bachelor’s degree in data science or business administration with a specialization in Finance

• 4+ years of experience in data analysis, business intelligence, or a related field.

• Significant experience with MS Power BI and strong SQL skills and experience with querying databases.

• Data modelling and data mining

• Advanced proficiency in MS Excel including VBA programming and macro creation.

• Strong analytical skills and attention to detail.

• Ability to translate complex data into clear, actionable insights.

• Strong communication skills, both verbal and written.

• Capable of working in fast-paced environments with tight deadlines and changing requirements.

• Strong time management and ability to prioritize work during demanding periods.

• Naturally curious with an ability to formulate questions at varying depths to uncover needs, hunt for misalignment, and grow an understanding of our business.

• Initiative-taker and can work independently to achieve desired business outcomes.

• Ability to work in a team with varied skill sets and experience.

• Positive mindset and willingness to learn on the job.

HERE’S 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 virtual healthcare and an Employee & Family Assistance Program

• 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 Canada’s 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. We’re 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 FCT’s 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.