Data Warehouse Optimization Specialist

1 month ago


Toronto, Ontario, Canada Mevotech Full time
Key Responsibilities

Data Warehouse Specialist CoPilot Job Description at Mevotech.

As a Data Warehouse Specialist CoPilot at Mevotech, you will be responsible for managing and optimizing our data warehouse infrastructure. This involves ensuring its reliability, scalability, and efficiency. You will work closely with our data engineers and analysts to design, implement, and maintain CoPilot data warehouse solutions that support our organization's data-driven initiatives.

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.

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.
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.

About 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 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.

Why Work at Mevotech

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.

  • Toronto, Ontario, Canada Mewar Info Tech Limited Full time

    About the Role:We are seeking a highly skilled Senior Data Infrastructure Specialist to join our team at Mewar Info Tech Limited. This role will play a crucial part in designing, building, and maintaining our data infrastructure.As a Senior Data Infrastructure Specialist, you will work closely with data scientists, analysts, and engineers to extract,...


  • Toronto, Ontario, Canada Foilcon Full time

    Job Description:Foilcon is seeking a highly skilled Data Engineer to join our team. As a key member of our organization, you will be responsible for designing, developing, and implementing data warehouse solutions that meet the needs of our clients.About the Role:We are looking for an experienced Data Engineer with a strong background in data modeling,...


  • Toronto, Ontario, Canada The Home Depot Canada Full time

    About The Home Depot CanadaThe Home Depot Canada is a leading home improvement retailer offering a wide range of products and services. As an Optimization Execution Specialist, you will be part of a team that drives business growth through efficient product data management.Salary: CAD $85,000 - $110,000 per year, depending on experienceJob Description:We are...


  • Toronto, Ontario, Canada BMO Full time

    About UsBMO Financial Group is a leading financial institution driven by a shared purpose: Boldly Grow the Good in business and life.Job SummaryWe are seeking a skilled Business Optimization Specialist to join our team. In this role, you will investigate and identify strategies to optimize business operations and services, informing business decisions with...


  • Toronto, Ontario, Canada Scotiabank Full time

    Unlock Your Potential as a Business Systems Optimization SpecialistScotiabank is seeking an experienced Business Systems Optimization Specialist to join our team.About the RoleThis is a challenging and rewarding role that requires strong analytical skills, excellent communication abilities, and a passion for process improvement. As a Business Systems...


  • Toronto, Ontario, Canada Foilcon Full time

    Foilon Career OverviewAt Foilcon, we're dedicated to innovation and excellence in the field of data integration. Our team is passionate about creating seamless solutions that meet the evolving needs of our clients.About This RoleWe're seeking a highly skilled Senior Data Integration Specialist to join our team! As a key member of our data engineering group,...


  • Toronto, Ontario, Canada Scotiabank Full time

    Scotiabank Data Warehouse Architect Job DescriptionLocation: Canada, Ontario, TorontoAbout the RoleWe are seeking a skilled Data Warehouse Architect to join our team at Scotiabank. As a key member of our data management team, you will be responsible for designing, developing, and deploying large-scale data warehouse projects.Job ResponsibilitiesDesign and...


  • Toronto, Ontario, Canada HR770 Full time

    **Company Overview:** At HR770, we are seeking a reliable and skilled Warehouse Logistics Specialist to join our team. This is a fantastic opportunity for someone who enjoys working in a fast-paced environment and has experience with warehouse operations. **Estimated Salary:** $45,000 - $65,000 per year, depending on experience. **Job Description:** The...


  • Toronto, Ontario, Canada Park Place Technologies Full time

    Job Description:We are seeking a highly skilled Warehouse Specialist to join our team at Park Place Technologies.Job Summary:The ideal candidate will be responsible for the timely and accurate issuance, processing, and management of part orders as well as all other assigned warehouse duties. These duties will include inventory, receiving, locating, picking,...


  • Toronto, Ontario, Canada TOMATO PRODUCE Full time

    We are seeking a Data Warehouse Professional to join our team at TOMATO PRODUCE. In this role, you will be responsible for collecting data to identify areas for improvement within our organization's IT infrastructure.Responsibilities:Collect data to identify areas for improvement within an organization's IT infrastructureDocument customers' requirements for...


  • Toronto, Ontario, Canada Cementation Canada Full time

    Role SummaryWe are seeking a highly skilled Performance Optimization Specialist to join our team at Cementation Canada. This exciting opportunity will involve analyzing data to determine how the project is performing relative to expectations and producing quality reports to communicate performance information.The ideal candidate will have a strong...


  • Toronto, Ontario, Canada Publicis Worldwide Full time

    Job Title: Data EngineerAbout the Role:We are seeking a highly skilled Data Engineer to join our team at Publicis Canada. As a Data Engineer, you will play a crucial role in designing, building, and maintaining our data infrastructure. You will work closely with data scientists, analysts, and other stakeholders to ensure that our data pipelines are...


  • Toronto, Ontario, Canada State Street Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team and contribute to the design, development, and deployment of cloud-based data warehouse solutions. This role requires expertise in Snowflake Data Engineering, Azure Services, and DevOps pipelines.Key ResponsibilitiesDesign and build end-to-end data pipelines, including data...


  • Toronto, Ontario, Canada Altis Recruitment Full time

    Altis Recruitment is seeking a highly skilled Data Operations Manager to lead the development and maintenance of data architecture, including Enterprise and Research Data Warehouses, MLOps, infrastructure, and dashboard/visualization systems.This role will oversee a team of ETL, OLAP, and SSRS developers to design, model, and implement data systems and...


  • Toronto, Ontario, Canada NTT DATA Full time

    Job Title: Chief Data Analytics StrategistJob Summary:NTT DATA is seeking a Chief Data Analytics Strategist to design and implement tailored data solutions that meet customer needs and use cases. The ideal candidate will have expertise in Google Cloud Platform and a proven track record of success in developing and delivering detailed presentations to...


  • Toronto, Ontario, Canada Halff Full time

    Data Architect SpecialistHalff is a mid-sized, employee-owned firm that designs, engineers, and plans innovative solutions for people. Our diverse team of professionals collaborates to tackle tough challenges in creative ways. With over 70 years of experience, we've consistently been named a Top Workplace in America.The ideal candidate is a skilled Data...


  • Toronto, Ontario, Canada Atlantic Full time

    Atlantic Packaging is a leading provider of packaging solutions in North America.Job SummaryWe are seeking a highly skilled Data Engineer to join our Data Analytics team. As a Data Engineer, you will be responsible for developing and administrating databases across the organization, helping us build a data lake and transform raw data from multiple source...


  • Toronto, Ontario, Canada Deliverect Full time

    Revolutionizing Customer Experience at DeliverectWe're seeking a skilled Business Operations and Chatbot Optimization Specialist to join our team at Deliverect. As a rapidly scaling global SaaS unicorn, we're at the forefront of revolutionizing technological solutions for the hospitality and Q-commerce sectors.About the RoleThis position plays a critical...


  • Toronto, Ontario, Canada Index Exchange Full time

    Unlocking Efficiency at Index ExchangeAs a leading global advertising exchange, Index Exchange is committed to pushing the boundaries of innovation and technology. We're on a mission to revolutionize the ad tech industry by harnessing the power of data science and optimization.We're seeking a highly skilled Senior Data Scientist to join our team of experts....


  • Toronto, Ontario, Canada Intact Financial Corporation Full time

    At Intact Financial Corporation, we're shaping the future of insurance with cutting-edge technology. As a Senior Data Integration Specialist, you'll play a pivotal role in transforming our customer experience for millions of Canadians.About the RoleWe're seeking a seasoned expert to lead our data integration efforts, leveraging expertise in Informatica...