Data Architect

by CARFAX Canada

Position Type: Regular, Full-time
Remote work options: No
Location: London, Ontario
Date Posted: Jan 19, 2025
CARFAX Canada

Job Description

Working HereAt CARFAX Canada, we’re more than just obsessed with vehicles. We’re obsessed with data and it’s potential to help millions of Canadians in buying, selling, and maintaining vehicles. But here’s what you really want to know about: the perks. Our team members enjoy weekly, free catered lunches at the office, flexible work that allows us to prioritize work-life balance, 4-day summer work weeks, and a state-of-the-art collaborative environment at our head office at 100 Kellogg Lane, London Ontario. Carfax Canada also offers competitive wages, exceptional benefits and employee wellness funding, a company matched pension program, parental leave top-up benefits, paid volunteer days, and the list goes on! Ultimately, every day at CARFAX Canada provides you with the opportunity to engage in meaningful work alongside incredible colleagues. It’s clear—we’re passionate about data and our people! Key InformationEmployment Status: Full time, permanentJob Type: On-SiteLocation: London, Ontario*Please note that we have two operating entities in Canada, CARFAX Inc., and CARFAX Canada. This position is with CARFAX Canada.
Job Details
Reporting into the Solutions Architect, the Data Architect will conceive a vision for our data environment that will sustain our growth and product directions and create a detailed and aligned plan to achieve that vision. The Data Architect should consult with stakeholders to understand current state and recommend solutions to improve new and existing databases. The Data Architect should provide thought leadership in data management, they must be hands on and help build our data environment. The Data Architect will be expected to: 
  • Develop and maintain data models to explain the data landscape of our organization.
  • Document new and existing schema objects.
  • Assist the Data team by providing recommendations and optimization techniques to optimize their reports.
  • Assist with investigating and implementing an ETL solution to improve the reliability of ingesting data into our databases.
  • Implementing data governance policies and standards, such as data quality rules, data lineage tracking, and data classification.
  • Collaborate with stakeholders, such as data owners, data stewards, and IT teams, to ensure that the organization meets data governance requirements.
  • Ensure compliance with industry regulations and privacy laws by designing data architecture that adheres to these requirements.
Position Responsibilities 
  • Deliver scalable and reliable data solutions leveraging Azure, Snowflake, traditional RDBMS, and BI tools.
  • Translate strategic requirements into a usable data architecture, which includes data model, associated metadata, data linage, and taxonomies to guide product development.
  • Ensure data is organized, and structured in a way that promotes data quality, security, and accessibility, which are essential aspects of data governance.
  • Collaborate with stakeholders, such as data owners, data stewards, and IT teams, to ensure that the organization meets data governance requirements.
  • Ensure compliance with industry regulations and privacy laws, such as PIPEDA, by designing data architecture that adheres to these requirements.
  • Provide guidance and assist in implementing data governance best practices, and procedures.
  • Document data frameworks, principles, and standards.
  • Act as a high-level decision maker for data related technical direction and standards relating to data related projects.
  • Provide technical leadership for the implementation and development team.
  • Present the solutions and investigate technology options.
  • Actively consult on the implementation of solutions, explaining the rationale behind choices, and make amendments to the solution as required.
  • Perform research to find solutions to data related problems by distilling information in the form of technical documents, and meetings.
Education and Experience Required Hard Skills
  • 8+ years expertise designing technology solutions that optimize, and advance business function.
  • Cloud knowledge preferably Azure
  • Experience in modern database systems (i.e. MS SQL Server, Mongo DB, Cosmos DB, etc.)
  • Strong Data Modeling, Data Lake, and Data Warehouse experience, and skills.
  • Experience designing/implementing star and/or snowflake schema.
  • Extensive knowledge of security, privacy, and data governance best practices, and how to properly implement and review.
  • Experience with design modeling standards such as Entity Relationship diagrams
  • Experience with data migration projects
  • Experience with data ingestion, standardization, transformation, and consumption
  • Knowledge of Performance, CI/CD, automated testing, and quality methodologies
Soft Skills
  • Exceptional skills in spoken, written, and graphical communications.
  • Superior organizational and planning skills
  • Strong leadership skills are required to infuse and align cross-functional teams with a common vision and to motivate them to support the proposed solution.
Equal Opportunity EmployerCARFAX Canada is an equal opportunity employer, and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law.  We’re committed to providing accommodations by request for candidates taking part in all aspects of the recruitment and selection process. For a confidential inquiry or to request an accommodation, please contact your recruiter or email hr@carfax.ca. If you are interested in applying for this position, please visit our website https://www.carfax.ca/careersApplications will be accepted until a suitable candidate is hired.   We thank all applicants for their interest; however only those selected for an interview will be contacted.  About UsCARFAX’s mission is to help millions of people shop, buy, service and sell used cars with more confidence. As a leader in vehicle history and valuation, CARFAX provides impartial and comprehensive information for consumers and the automotive industry. CARFAX‘s Canadian headquarters in London, Ontario supports Canadian and U.S. markets, drawing on billions of data records from thousands of sources, enabling used vehicle buyers and sellers to make informed decisions. CARFAX is consistently recognized as a top employer and business. CARFAX is a part of S&P Global (NYSE: SPGI). Find out more at www.carfax.ca and connect with CARFAX on Instagram, Facebook and LinkedIn.  Our values serve as the foundation of our culture by helping inform the actions and behaviours that make us successful. We strive to integrate these values into how we collaborate, navigate challenges, and make decisions daily. Objective – Guided by facts, driven by results.Transparent – Clarity through open and honest communication.Customer advocate – Putting the customer at the center of everything we do.Solutions oriented – Turning challenges into opportunities.Integrity – Where honesty meets action.