Job Title: Senior Business Data Analyst
Location: Oakville, ON (Hybrid)
Estimated Duration: Fulltime
Client: Canadian Tire
About Us
Canadian Tire Corporation, Limited (“CTC”) is one of Canada’s most admired and trusted companies. With more than 90 Owned Brands, 1,700 retail locations, financial services, exemplary e-commerce capabilities, and exciting market-leading merchandising strategies. We dream big and work as one to innovate with purpose for our customers at every level of our business, investing in new technologies and products, and doubling down on top talent to drive the company forward. We offer competitive salaries and wages to CTC employees, as well as store discounts, supported learning through our Triangle Learning Academy, Canadian Tire Profit Sharing, and retirement and savings programs for eligible employees. As part of our enhanced flex benefits program, we offer mental health benefits in the amount of $5,000 per year for benefits-eligible employees and their families, including total well-being, and mental health tools and resources for all employees. Join us in helping to make life in Canada better through living and working our Core Values: we are innovators and entrepreneurs at our core, outcomes drive us, inclusion is a must, we are stronger together and we take personal responsibility. It is an especially exciting time to join CTC and its family of companies where career opportunities are wide-ranging! Join us, where there's a place for you here.
What You'll Do
- Establish and implement data governance and data management standards, policies, procedures and controls which include adhering to privacy, compliance and legal requirements for sensitive data
- Continuously assess the current state of our data environment to identify process improvement opportunities such as inefficient table structures, ineffective load processes, R.O.T. or metadata and reference data enhancements
- Proactively monitor data, metadata and reference data and lead continuous data quality improvements while supporting the data stewardship community in resolving identified data quality and data integrity concerns
- Create and maintain data models and conceptual architecture as well as metadata and documentation such as data glossaries and catalogs, data mappings, data lineage and data classifications
- Lead data integration efforts and enable collaboration between I.T., business data ownersstewards and SMEs while conducting data profiling and data discovery to support these efforts
- Lead data object designs and ensure best practices are followed and supporting documentation can be maintained
- Experiment with emerging technologies to understand how they may impact what comes next and provide thought leadership in areas of advanced data techniques
- Maintain open communication between all data stakeholders, from producers to consumers, and remain an active enabler of effective data management and the overall data governance structure of the Bank
What you bring?
- Post-secondary education in Computer Science or related program
- Proven experience in the delivery of data solutions
- Advanced PLSQL combined with 5+ years experience with Oracle or comparable structured data environment
- Working experience in modern data warehousing techniques and cloud technology platform solutions such as Azure or GCP
- Experience with processes supporting data transformation and clear understanding of data ingestion protocols and ETL
- Exposure to the following tools or technology: Hadoop, Hive, Python, R, Shell Scripting, SAS, basic Linux commands, Databricks
- Proven work experience with data in a corporate environment and supporting cross-functional data governance including monitoring data quality, recommending improvements in data, data modeling, data classification and data governance capabilities
- Analytical mindset for metadata and data investigation and troubleshooting
- Advanced working knowledge of Microsoft tools including Visio, PowerPoint and Excel
- Good understanding of emerging technologies, JSON and modern integration frameworks and API development considered an asset
- Working experience with Google Big Query and Digital Data, such as clickstream, considered a strong asset
- Experience with data governance or curation platforms considered an asset
- CDMP certification considered a strong asset
We are committed to fostering an environment where belonging thrives, and diversity, inclusion and equity are infused into everything we do. We believe in building an organizational culture where people are consistently treated with dignity while respecting individual religion, nationality, gender, race, age, perceived ability, spoken language, sexual orientation, and identification. We are united in our purpose of being here to help make life in Canada better.
Accommodations
We stand firm in our Core Value that inclusion is a must. We welcome and encourage candidates from equity-seeking groups such as people who identify as racialized, Indigenous, 2SLGBTQIA+, women, people with disabilities, and beyond. Should you require any accommodation in applying for this role, or throughout the interview process, please make them known when contacted and we will work with you to help meet your needs.