Data Modeler, Data

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.

As Data Modeler

HERES HOW YOULL 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.

HERES WHAT YOULL BRING :

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

Total Direct Compensation :

97200 - 118800

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!

• A s 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.

Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

Employment Type : Full-Time

Experience : years

Vacancy : 1