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 will be responsible for managing and optimizing our data warehouse infrastructure, ensuring its reliability, scalability, and efficiency. This individual will be working closely with our finance and data analysts, and will play a key role in designing, implementing, and maintaining 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. This individual will play an integral role in upholding and overseeing the ongoing maintenance, optimization, and management of our database infrastructure. This role will encompass tasks such as ensuring data integrity, implementing performance enhancements, managing access controls, and overseeing backups and disaster recovery procedures.
KEY DUTIES AND RESPONSIBILITIES
Data Integration, Analysis and Management

• Implement robust ETL (Extract, Transform, Load) processes to integrate data from various sources into the data warehouse.
• Ensure data quality, consistency, and integrity through data validation, cleansing, and normalization techniques.
• Optimize data warehouse performance by fine-tuning queries, indexes, and database configurations.
• Scale data infrastructure to accommodate growing data volumes and evolving analytical needs while maintaining performance and reliability.
• Implement caching mechanisms and data partitioning strategies to improve query performance and resource utilization.
• Develop interactive dashboards and visualizations using tools like Tableau and Power BI

Database Administration

• Install, configure, and maintain database management systems (DBMS), ensuring optimal performance and reliability.
• Implement backup and recovery strategies to protect against data loss and minimize downtime in case of system failures or disasters.
• Monitor database performance metrics and system health indicators, identifying and addressing issues to maintain data warehouse availability and performance.

AI Model Development

• Experiment with various AI and machine learning models to extract preliminary insights, identify patterns, and explore predictive capabilities within the initial datasets.
• Work closely with data owners to prototype AI models using techniques such as regression, classification, clustering, and shallow learning algorithms.
• Iterate on model development based on feedback, performance evaluation, and early-stage experimentation to refine the approach.
• Deploy AI models into production environments and integrate them with existing systems for real-time data analysis and decision-making.

Data Governance and Compliance

• Establish data governance frameworks and policies to ensure data quality, security, and regulatory compliance.
• Define data access controls, encryption standards, and audit trails to protect sensitive information and mitigate risks.
• Conduct regular audits and assessments to monitor compliance with data governance standards and industry regulations.

Collaboration and Knowledge Sharing

• Collaborate with cross-functional teams including data analyst, business analysts, and IT professionals to understand business requirements and deliver data-driven solutions.
• Share expertise and best practices with team members through training sessions, documentation, and knowledge sharing sessions.
• Stay abreast of emerging technologies, industry trends, and best practices in data warehousing, AI, and analytics to drive innovation and continuous improvement.

QUALIFICATIONS, SKILLS, AND EDUCATIONAL REQUIREMENTS

• Bachelor's degree in computer science, information systems, or a related field; or equivalent work experience.
  
• Proven experience in designing and implementing an operational production grade large-scale data solution on Snowflake.
• Proficiency in SQL and experience with relational database management systems (e.g. SQL Server, Informix).
• Familiarity with ETL tools and processes such as SSIS and Azure Data Factory.
• Familiarity with AI and machine learning concepts and frameworks, including supervised and unsupervised learning, regression analysis, and neural networks.
• Experience with programming languages such as Python, R, or Java for data analysis, scripting, and automation tasks.
• Demonstrated expertise in writing complex T-SQL scripts to perform data manipulation, retrieval, and transformation tasks.
• Knowledge of data visualization tools (e.g., Tableau, Power BI) is desirable.
• Excellent analytical, problem-solving, and troubleshooting skills.
• Strong communication and collaboration abilities, with the ability to work effectively in a cross-functional team environment.
• Strong analytical skills, ability to interpret business requirements and produce functional and technical design documents.
• Good time management skills – Ability to prioritize and multi-task, handling multiple efforts at once.

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.

Powered by JazzHR

P17YTCfQpz