Data Warehouse Specialist

3 weeks ago

Golden Horseshoe, Canada Mevotech Full time
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. 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 #J-18808-Ljbffr

  • ERP System Specialist

    2 weeks ago

    Golden Horseshoe, Canada Tayco Full time

    Tayco is seeking an enthusiastic and detail-orientated ERP System Specialist to join our Operations Team. We are looking for someone who is aligned with our core values of Ownership, Progressive, Efficient and Enjoyable Experiences. THE OPPORTUNITY: The ERP System Specialist is responsible for creating and designing software systems to streamline processes...

  • ERP System Specialist

    2 weeks ago

    Golden Horseshoe, Canada Tayco Full time

    Tayco is seeking an enthusiastic and detail-orientated ERP System Specialist to join our Operations Team. We are looking for someone who is aligned with our core values of Ownership, Progressive, Efficient and Enjoyable Experiences. THE OPPORTUNITY: The ERP System Specialist is responsible for creating and designing software systems to streamline processes...

  • ERP System Specialist

    2 weeks ago

    Golden Horseshoe, Canada Tayco Full time

    Tayco is seeking an enthusiastic and detail-orientated ERP System Specialist to join our Operations Team. We are looking for someone who is aligned with our core values of Ownership, Progressive, Efficient and Enjoyable Experiences. THE OPPORTUNITY: The ERP System Specialist is responsible for creating and designing software systems to streamline processes...

  • Senior Workday Specialist

    3 weeks ago

    Golden Horseshoe, Canada Yoush Consulting Full time

    Welcome to Yoush Consulting. Are you an independent IT Consultant, or do you wish to become one? Yoush Consulting provides project management and information technology expertise to help our clients deliver their projects.We are looking for one person to do Workday modeling and extensions as well as support integration with Dynamic 365.Workday Specialist...

  • Senior Workday Specialist

    3 weeks ago

    Golden Horseshoe, Canada Yoush Consulting Full time

    Welcome to Yoush Consulting. Are you an independent IT Consultant, or do you wish to become one? Yoush Consulting provides project management and information technology expertise to help our clients deliver their projects.We are looking for one person to do Workday modeling and extensions as well as support integration with Dynamic 365.Workday Specialist...

  • Senior Workday Specialist

    3 weeks ago

    Golden Horseshoe, Canada Yoush Consulting Full time

    Welcome to Yoush Consulting. Are you an independent IT Consultant, or do you wish to become one? Yoush Consulting provides project management and information technology expertise to help our clients deliver their projects.We are looking for one person to do Workday modeling and extensions as well as support integration with Dynamic 365.Workday Specialist...

  • RQ00074 Senior Privacy Specialist

    2 weeks ago

    Golden Horseshoe, Canada Randstad Full time

    This is a contract position for a Senior Privacy Specialist for our public sector client. Work location: North York Duration: Twelve Months 7.25 hours/day This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.) Advantages Good...

  • RQ00074 Senior Privacy Specialist

    2 weeks ago

    Golden Horseshoe, Canada Randstad Full time

    This is a contract position for a Senior Privacy Specialist for our public sector client. Work location: North York Duration: Twelve Months 7.25 hours/day This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.) Advantages Good...

  • RQ00074 Senior Privacy Specialist

    2 weeks ago

    Golden Horseshoe, Canada Randstad Full time

    This is a contract position for a Senior Privacy Specialist for our public sector client. Work location: North York Duration: Twelve Months 7.25 hours/day This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.) Advantages Good...

  • Bilingual Human Resources Specialist

    4 weeks ago

    Golden Horseshoe, Canada Red Label Vacations Full time

    Bilingual Human Resources Specialist - Etobicoke, Canada - Red Label Vacations Description**Position**: Bilingual HR Specialist**Status**:Permanent, Full-Time**Department**: Human Resources**Reports to**: HR Business Partner**Location**: Hybrid**The Opportunity**The Bilingual HR Specialist will play a vital role in overseeing the day-to-day Human Resources...

  • Bilingual Human Resources Specialist

    4 weeks ago

    Golden Horseshoe, Canada Red Label Vacations Full time

    Bilingual Human Resources Specialist - Etobicoke, Canada - Red Label Vacations Description**Position**: Bilingual HR Specialist**Status**:Permanent, Full-Time**Department**: Human Resources**Reports to**: HR Business Partner**Location**: Hybrid**The Opportunity**The Bilingual HR Specialist will play a vital role in overseeing the day-to-day Human Resources...

  • Bilingual Human Resources Specialist

    4 weeks ago

    Golden Horseshoe, Canada Red Label Vacations Full time

    Bilingual Human Resources Specialist - Etobicoke, Canada - Red Label Vacations Description**Position**: Bilingual HR Specialist**Status**:Permanent, Full-Time**Department**: Human Resources**Reports to**: HR Business Partner**Location**: Hybrid**The Opportunity**The Bilingual HR Specialist will play a vital role in overseeing the day-to-day Human Resources...

  • Bilingual Human Resources Specialist

    1 day ago

    Golden Horseshoe, Canada Red Label Vacations Full time

    Bilingual Human Resources Specialist - Etobicoke, Canada - Red Label Vacations Description**Position**: Bilingual HR Specialist**Status**:Permanent, Full-Time**Department**: Human Resources**Reports to**: HR Business Partner**Location**: Hybrid**The Opportunity**The Bilingual HR Specialist will play a vital role in overseeing the day-to-day Human Resources...

  • Bilingual Human Resources Specialist

    23 hours ago

    Golden Horseshoe, Canada Red Label Vacations Full time

    Bilingual Human Resources Specialist - Etobicoke, Canada - Red Label Vacations Description**Position**: Bilingual HR Specialist**Status**:Permanent, Full-Time**Department**: Human Resources**Reports to**: HR Business Partner**Location**: Hybrid**The Opportunity**The Bilingual HR Specialist will play a vital role in overseeing the day-to-day Human Resources...

  • RQ06753 Information Management Specialist

    2 weeks ago

    Golden Horseshoe, Canada Randstad Full time

    This is a contract position for a Information Management Specialist for our public sector client. Work location: North York Duration: Twelve Months 7.25 hours/day This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.) ...

  • RQ06753 Information Management Specialist

    3 weeks ago

    Golden Horseshoe, Canada Randstad Full time

    This is a contract position for a Information Management Specialist for our public sector client. Work location: North York Duration: Twelve Months 7.25 hours/day This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.) ...

  • RQ06753 Information Management Specialist

    2 weeks ago

    Golden Horseshoe, Canada Randstad Full time

    This is a contract position for a Information Management Specialist for our public sector client. Work location: North York Duration: Twelve Months 7.25 hours/day This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.) ...

  • RQ06753 Information Management Specialist

    3 weeks ago

    Golden Horseshoe, Canada Randstad Full time

    This is a contract position for a Information Management Specialist for our public sector client. Work location: North York Duration: Twelve Months 7.25 hours/day This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.) ...

  • Senior Post Sales Storage Specialist

    1 week ago

    Golden Horseshoe, Canada EMETemployment Full time

    Senior Post Sales Storage Specialist (Remote) Job Order ID: 7668 Employment Type: Yearly Salary Web Publication Date: 5/15/2024 Number of Positions: 1 Job Location: North York Brief Description: Our employer is an enterprise systems, and managed services solutions provider looking for an IT / Storage Specialist to support their Post Sale projects as well as...

  • Senior Post Sales Storage Specialist

    1 week ago

    Golden Horseshoe, Canada EMETemployment Full time

    Senior Post Sales Storage Specialist (Remote) Job Order ID: 7668 Employment Type: Yearly Salary Web Publication Date: 5/15/2024 Number of Positions: 1 Job Location: North York Brief Description: Our employer is an enterprise systems, and managed services solutions provider looking for an IT / Storage Specialist to support their Post Sale projects as well as...