Database Warehouse Specialist CoPilot

North York, ON, Canada

Full Time

Experienced

Take your Career to the next Level with MEVOTECH.

Mevotech is a trusted North American aftermarket auto parts leader that specializes in the engineering, design and distribution of driveline, steering and suspension parts (branded and private label). With over 600 Canadian and U.S. team members, we can attribute our continued success to the passion, spirit and dedication of our employees. Mevotech was recognized with a 2023 Canada’s Best Managed Companies award for its industry-leading performance, global business practices, and sustained growth. Check out our career website to learn about our amazing culture and our commitment to employee wellness and engagement. https://www.mevotech.com/about-us/careers/

JOB PURPOSE

Reporting directly to the Manager, BI & Analytics, the Data Warehouse Specialist CoPilot will be responsible for managing and optimizing our data warehouse infrastructure, ensuring its reliability, scalability, and efficiency. Working closely with our data engineers and analysts, you will play a key role in designing, implementing, and maintaining CoPilot data warehouse solutions that support our organization’s data-driven initiatives. This position requires a strong understanding of data warehousing principles, experience with relevant technologies and the ability to collaborate effectively with cross-functional teams.

KEY DUTIES AND RESPONSIBILITIES

Data Warehouse Management:
Manage and maintain our data warehouse infrastructure, including monitoring system performance, troubleshooting issues, and optimizing resource utilization. Implement, configure CoPilot features as Mevotech’s subject matter expert. Post set-up support of Microsoft 365 Copilot required

Data Modeling:
Design and implement efficient data models to support reporting, analytics, and business intelligence needs.

ETL Development:
Develop and maintain ETL processes to extract, transform, and load data from various sources into the data warehouse.

Performance Optimization:
Identify opportunities to optimize data warehouse performance, such as query tuning, indexing strategies, and data partitioning.

Data Governance:
Ensure data quality, integrity, and security within the data warehouse environment, adhering to best practices and compliance requirements.

Collaboration:
Collaborate with data engineers, analysts, and business stakeholders to understand data requirements and deliver effective solutions that meet business objectives.

Documentation: Document data warehouse architecture, processes, and procedures to facilitate knowledge sharing and maintain system documentation.

Continuous Improvement: Stay informed about industry trends, emerging technologies, and best practices in data warehousing, and contribute to continuous improvement initiatives.

QUALIFICATIONS, SKILLS, AND EDUCATIONAL REQUIREMENTS

Bachelor’s degree in computer science, Information Systems, or a related field; advanced degree preferred or equivalent working experience
Proven experience in data warehouse design, development, and implementation, preferably in a cloud-based environment.
Proven experience working with Microsoft 365 Copilot features and requirements.
Provide experience providing recommendations & guidance on how to optimize Microsoft 365 environment
Ability to implement, configure and support the use of CoPilot within the organization.
Proficiency in database technologies such as SQL, Oracle, PostgreSQL, or MySQL.
Experience with ETL tools such as Informatica, Talend, or SSIS.
Strong understanding of data modeling concepts, dimensional modeling techniques, and data warehousing best practices.
Familiarity with business intelligence and analytics tools such as Tableau, Power BI, or QlikView.
Excellent problem-solving skills and attention to detail.
Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform is a plus.
Knowledge of big data technologies such as Hadoop, Spark, or Kafka is desirable but not required.

Diversity & Inclusion

At Mevotech, diversity goes beyond demographics. We embrace unique perspectives and voices in our culture. We actively seek out different viewpoints and incorporate them into our organization.

Accessibility Accommodations

Mevotech provides accessibility accommodations during the recruitment process. If you require accommodations, please let us know, and we'll work with you to meet your needs.

Apply for this position

Required*

Apply with

First Name*

Last Name*

Email Address*

Phone*

Address

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

What's your citizenship / employment eligibility?*

Are you 18 years of age or older?*

Do you have prior experience working with AI or Microsoft CoPilot?*

Are you comfortable working 3 days on site as per our company hybrid policy?*

Are you comfortable undergoing a background and reference check as part of our recruitment process?*

Please select your salary expectations.*

Human Check*

Submit Application