Data Modeler

4 weeks ago

Oakville, Canada FCT Full time
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.

HERE'S HOW YOU'LL CONTRIBUTE:

  • Work closely with business users, BI/Analytics developers, data engineers, and architects to gather requirements and translate them into data models.

  • Design and develop conceptual, logical, and physical data models that integrate data from various sources into BI/Analytics Data marts and OLAP Cubes to support analytics, reporting, and performance metrics.

  • Optimize data models to ensure high performance of queries, reduce data redundancy, and improve overall system efficiency.

  • Collaborate with ETL developers to ensure the accurate and timely loading of data into data marts according to the data model specifications.

  • Create and maintain comprehensive documentation, including data dictionaries, ER diagrams, and data lineage.

  • Ensure adherence to data governance and security policies, including the accuracy, consistency, and integrity of data within the BI/Analytics environment.

  • Support the testing, validation, and troubleshooting of data models to ensure they meet the functional and performance criteria.

  • Stay up to date with industry best practices, tools, and methodologies in data modeling, particularly for BI/Analytics environments.

HERE'S WHAT YOU'LL BRING:

  • Bachelor's degree in computer science, Information Systems, Data Science, or a related field.

  • 3-5 years of experience in data modeling, specifically for BI/Analytics, data warehouses, and/or data marts.

  • Proven experience with data modeling tools such as ER/Studio, Erwin, or equivalent.

  • Experience working with BI tools such as Power BI, Tableau, or Qlik.

  • Knowledge of relational and dimensional database design (star schema, snowflake schema).

  • Strong understanding of SQL and database technologies (e.g., Oracle, SQL Server, MySQL).

  • Previous experience with legacy BI tool migration to Power BI is an advantage.

  • Proficiency in designing data models for data marts and BI/Analytics solutions.

  • Understanding of ETL processes and data integration techniques.

  • Familiarity with cloud-based data storage and warehousing solutions (e.g., AWS Redshift, Google Big Query, Azure Synapse).

  • Familiarity with metadata management and data governance frameworks.

  • Knowledge of scripting languages (Python, R) is a plus.

  • Strong analytical and problem-solving abilities with attention to detail.

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

  • Excellent communication and presentation skills.

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

  • Self-starter 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.

  • Data Modeler

    1 month ago

    Oakville, Canada FCT Full time

    Sommaire de la compagnie Venez travailler pour une entreprise qui est engagée dans la réussite de chacun de ses employés. C’est un milieu de travail où les innovateurs et les collaborateurs se rencontrent et tirent parti des talents de chacun. Un endroit où la diversité est accueillie et célébrée. FCT offre la meilleure assurance titres de...

  • Data Modeler

    4 days ago

    Oakville, Canada FCT Full time

    Sommaire de la compagnie Venez travailler pour une entreprise qui est engagée dans la réussite de chacun de ses employés. C’est un milieu de travail où les innovateurs et les collaborateurs se rencontrent et tirent parti des talents de chacun. Un endroit où la diversité est accueillie et célébrée. FCT offre la meilleure assurance titres de...

  • Data Modeler

    4 weeks ago

    Oakville, Ontario, Canada FCT Full time

    About the RoleFCT is seeking a skilled Data Modeler to join our Business Intelligence team. As a Data Modeler, you will be responsible for designing and developing conceptual, logical, and physical data models that integrate data from various sources into BI/Analytics Data marts and OLAP Cubes to support analytics, reporting, and performance metrics.Key...

  • Data Modeler

    4 weeks ago

    Oakville, Ontario, Canada FCT Full time

    About the RoleFCT is seeking a skilled Data Modeler to join our Business Intelligence team. As a Data Modeler, you will be responsible for designing and developing conceptual, logical, and physical data models that integrate data from various sources into BI/Analytics Data marts and OLAP Cubes to support analytics, reporting, and performance metrics.Key...

  • Data Modeler for Business Intelligence Solutions

    1 day ago

    Oakville, Ontario, Canada FCT Full time

    FCT, a leading provider of title insurance and related services to the Canadian real estate industry, is seeking a skilled Data Modeler to join our team. We offer a competitive salary of $90,000 - $120,000 per year, based on experience.Job DescriptionAs a Data Modeler, you will play a critical role in designing and developing conceptual, logical, and...

  • Intermediate Numerical Modeler and Data Scientist

    5 months ago

    Oakville, Canada Baird & Associates Full time

    **Overview**: W.F. Baird & Associates Coastal Engineers Ltd. (Baird) provides professional engineering and technical services related to the design of coastal structures and marine facilities that interact with the world’s oceans, lakes, and rivers. The company also provides scientific analyses of coastal and riverine processes including studies of waves,...

  • Civil3D Modeler

    4 weeks ago

    Oakville, Ontario, Canada Parsons Corporation Full time

    About the Role:Parsons is seeking a highly skilled Civil3D Modeler to support our team in delivering high-quality infrastructure projects. As a key member of our team, you will work closely with the BIM Manager and Project Delivery Teams to develop and maintain accurate and detailed 3D models of rail and transit infrastructure.Key Responsibilities:Support...

  • Civil3D Modeler

    5 months ago

    Oakville, Canada Parsons Full time

    In a world of possibilities, pursue one with endless opportunities. Imagine Next! When it comes to what you want in your career, if you can imagine it, you can do it at Parsons. Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace where you can be yourself. Where you can thrive. Where you can find your next,...

  • Civil3D Modeler

    1 week ago

    Oakville, Ontario, Canada Parsons Corporation Full time

    Role Summary: Parsons is seeking an experienced Civil3D Modeler to support the development of 3D/2D models for major infrastructure projects. Key Responsibilities: Collaborate with the BIM Manager to develop models for tracks, roads, and utilities. Develop Civil3D templates, subassemblies, and smart blocks. Perform cut and fill analysis and extract...

  • Civil3D Modeler

    5 months ago

    Oakville, Canada Parsons Full time

    In a world of possibilities, pursue one with endless opportunities. Imagine Next! When it comes to what you want in your career, if you can imagine it, you can do it at Parsons. Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace where you can be yourself. Where you can thrive. Where you can find your next,...

  • Civil3D Modeler Intern

    4 weeks ago

    Oakville, Ontario, Canada PARSONS CORPORATION Full time

    Job Description:Parsons is seeking a highly skilled Civil3D Modeler Intern to support our team in developing models for Tracks, Roads, and utilities. The ideal candidate will possess strong computer CAD/BIM and technical skills to produce 3D/2D dimensional models required for model and drawing production, quality checking and control, coordination, and...

  • Civil3D Modeler

    5 months ago

    Oakville, Canada Parsons Corporation Full time

    Description : Parsons is looking for an amazingly talented Civil3D Modeler to join our team! In this role you will get to support the BIM Manager and our Project Delivery Teams todevelop the models for Tracks, Roads and utilities in addition to the extraction of the sheets from the models. The Civil3D Modeler is required to possess strong computer...

  • Student Intern

    2 months ago

    Oakville, Canada Parsons Full time

    In a world of possibilities, pursue one with endless opportunities. Imagine Next! When it comes to what you want in your career, if you can imagine it, you can do it at Parsons. Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace where you can be yourself. Where you can thrive. Where you can find your next,...

  • Data Scientist

    7 months ago

    Oakville, Canada CT Bank Full time

    **What you’ll do** The purpose of the Customer Analytical Center of Excellence of Canadian Tire Bank is to build familiarity with our credit card customers to strengthen the customer relationship with Canadian Tire Corporation. Charged with building and executing statistical models that help predict customer behavior, the Modeling and Analytics department...

  • Civil3D Modeler

    4 weeks ago

    Oakville, Ontario, Canada Parsons Corporation Full time

    About the Role:Parsons is seeking a highly skilled Civil3D Modeler to support our Critical Infrastructure team in developing models for tracks, roads, and utilities. The successful candidate will work closely with the BIM Manager and Project Delivery Teams to create 3D/2D dimensional models for model and drawing production, quality checking, and control.Key...

  • Data Scientist

    5 months ago

    Oakville, Canada CT Bank Full time

    **What you’ll do** The purpose of the Customer Analytical Center of Excellence of Canadian Tire Bank is to build familiarity with our credit card customers to strengthen the customer relationship with Canadian Tire Corporation. Charged with building and executing statistical models that help predict customer behavior, the Modeling and Analytics department...

  • Data Scientist

    5 months ago

    Oakville, Canada CT Bank Full time

    **What you’ll do** - Develop predictive models that will form the basis for information driven strategies in Credit Risk and Marketing - Perform optimization analysis and build supporting component predictions - Create customer segmentation schemes that will provide our analytic teams with insights into our customers - Monitor effectiveness of all...

  • Data Steward

    1 month ago

    Oakville, Canada UCB Full time

    **Make your mark for patients** We are looking for a Data Steward who is analytical, has strong attention to detail and a problem-solver, to join us in our Patient Experience team, based in our Canadian office in Oakville, Canada. **About the role**: The Data Steward role aims to perform various data analytics, financial modelling, reporting, as well as...

  • Financial Data Analyst

    6 months ago

    Oakville, Canada Geotab Full time

    Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work.” We are a company of diverse and talented individuals who work together to help businesses grow and succeed, and increase the safety and sustainability of our communities. Geotab is advancing security, connecting commercial vehicles to the...

  • Data Modeler

    3 weeks ago

    Oakville, Ontario, Canada FCT Full time

    pbJoinacompanythat'scommittedtothesuccessofeachemployeeandofferschallenge,purposeandtheopportunitytogrowbothpersonallyandprofessionallyinateam-orientedenvironment./b/ppFCTisaleadingprovideroftitleinsurance,defaultsolutionsandotherrealestaterelatedproductsandservicestolegal,lending,valuationandrealestateprofessionalsacrossCanada./ppTheidealcandidatewillhavead...