Data Architect

Working HereAt CARFAX Canada, we’re more than just obsessed with cars. We’re obsessed with data and using it to help millions of Canadians buy, sell and maintain cars - but you can learn that on our website. Let’s talk about the sweet perks you’ll get when working here (i.e. what you actually want to know): Some days you’ll be taking in-house leadership training courses, other days you’ll be eating a catered lunch with your team mates. Grab a seat in the state-of-the-art office at 100 Kellogg Lane and collaborate the day away. What’s that, it’s the summer? Well, the 4-day work weeks have kicked in; enjoy those extra paid days off! Why not use one of your paid volunteer days to give back to your community? What else can we list? Competitive wages, amazing benefits like a wellness spending fund, a company-matched pension program, monthly “work from anywhere” days, yearly performance-based bonuses, health and wellness programs, a literal award-winning culture, parental leave top-ups and all kinds of social events. To top all of this off, every day you get to choose how you get to do meaningful work with incredible people. So, looks like we’re obsessed with a few things here – 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 DetailsReporting 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/careers. Applications 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.