Database Warehouse Specialist CoPilot

3 weeks ago

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

Summary

Reporting to the Director, Continuous Improvement, the Operations Excellence Manager is responsible for the optimization of the warehouse space for approximately 75,000 product SKUs at our 3 distribution facilities. The incumbent will guide the optimization of the space and products by engineering efficiencies and implementing past experiences and best practices. Optimizing our space and operations will be crucial to the business going forward.

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

  • Specialist, Database Administrator

    3 weeks ago

    Toronto, Canada Miller Thomson LLP Full time

    As a recognized national business law firm, we support, grow, and impact our communities through our work. We help entrepreneurs, companies, and professionals shape and build the Canadian economy. When you start a career with Miller Thomson, you join a firm that puts its people first. We provide the opportunity to influence the course of your career,...

  • Specialist, Database Administrator

    3 weeks ago

    Toronto, Canada Miller Thomson LLP Full time

    As a recognized national business law firm, we support, grow, and impact our communities through our work. We help entrepreneurs, companies, and professionals shape and build the Canadian economy. When you start a career with Miller Thomson, you join a firm that puts its people first. We provide the opportunity to influence the course of your career,...

  • Specialist, Database Administrator

    3 weeks ago

    Toronto, Canada Miller Thomson LLP Full time

    As a recognized national business law firm, we support, grow, and impact our communities through our work. We help entrepreneurs, companies, and professionals shape and build the Canadian economy.When you start a career with Miller Thomson, you join a firm that puts its people first. We provide the opportunity to influence the course of your career,...

  • Specialist, Database Administrator

    3 weeks ago

    Toronto, Canada Miller Thomson LLP Full time

    As a recognized national business law firm, we support, grow, and impact our communities through our work. We help entrepreneurs, companies, and professionals shape and build the Canadian economy.When you start a career with Miller Thomson, you join a firm that puts its people first. We provide the opportunity to influence the course of your career,...

  • Data Modeling Specialist

    4 weeks ago

    Toronto, Ontario, Canada Procom Full time

    Data Modeling Specialist - Financial Systems On behalf of our client in the Financial Services Sector, PROCOM is looking for a Data Modeling Specialist - Financial Systems. Data Modeling Specialist - Financial Systems - Job DescriptionDesign and implement data models and schemas to support analytical reporting requirements, reports, and dashboards, manage...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Database Administrator - Senior** **Location: 595 Bay Street,, Toronto, Ontario** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS 11-12 in a Windows environment and SQL Server RDBMS 2008-2019 - Database installation, upgrade, monitoring, troubleshooting,...

  • Inventory & Warehouse Specialist

    1 day ago

    Toronto, Canada Black & McDonald Full time

    Black & McDonald’s Southern Ontario Utilities team is growing! If you are an independent, enthusiastic, and driven professional searching for an opportunity to build a solid foundation for your career, this position is for you. The Inventory Specialist is located on site and typically reports directly to the Project Manager. Inventory & Warehouse...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Job Title: Database Administrator - Senior** **Location: Toronto, Ontario (Onsite)** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS...

  • Database Analyst

    3 days ago

    Toronto, Canada Property.ca Realty Inc. Full time

    Education: College/CEGEP - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration...

  • Database Administrator

    1 week ago

    Toronto, Canada iPartner Staffing Full time

    Role: Database Administrator - Senior Location: Toronto, ON Contract **Must-haves**: - More than 10 yrs Oracle DBA experience - Approved experience of Oracle 12c AND 19c using multi-tenant architecture - Oracle 12c and 19c RAC - Grid infrastructure/ASM - RMAN backup and Restore - Data Encryption using ASO/TDE - Oracle Dataguard Physical/Logical...

  • BI Specialist/etl Specialist

    4 weeks ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Business Intelligence Specialist - Senior **for one of our clients. **Position: Business Intelligence Specialist - Senior** **Location: 315 Front St. West, Toronto, Ontario (Hybrid)** **Hybrid - 3 days on site and 2 days remote** **Duration: Long Term Contract** **MUST...

  • Aws Aurora/postgres Database Specialist

    4 weeks ago

    Toronto, Canada AstraNorth Full time

    The AWS Aurora/Postgres Database Specialist with expertise will set up, maintain and monitor Aurora/Postgres database or other database systems, as required. **Knowledge & Skills** - 5+ years of experience in managing and maintain Aurora/Postgres databases on AWS - 5+ years of experience implementing and managing backups, restoration, replications, and...

  • Database Analyst

    5 days ago

    Toronto, Canada VRIZE CANADA INC. Full time

    Work Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Consulting firm **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management...

  • Senior Database Administrator

    1 week ago

    Old Toronto, Canada Eastlink Full time

    Designated office: 6080 Young Street, Halifax, NS This position is: Hybrid, at least 3 days per week in office Eastlink is a family owned, entrepreneurial and innovative company headquartered in Halifax, Nova Scotia. We take great pride in being a leader in delivering creative competitive, customer focused telecommunications solutions, and connecting...

  • Senior Database Administrator

    1 week ago

    Old Toronto, Canada Eastlink Full time

    Designated office: 6080 Young Street, Halifax, NS This position is: Hybrid, at least 3 days per week in office Eastlink is a family owned, entrepreneurial and innovative company headquartered in Halifax, Nova Scotia. We take great pride in being a leader in delivering creative competitive, customer focused telecommunications solutions, and connecting...

  • Senior Database Administrator

    1 week ago

    Old Toronto, Canada Eastlink Full time

    Designated office: 6080 Young Street, Halifax, NS This position is: Hybrid, at least 3 days per week in office Eastlink is a family owned, entrepreneurial and innovative company headquartered in Halifax, Nova Scotia. We take great pride in being a leader in delivering creative competitive, customer focused telecommunications solutions, and connecting...

  • Senior Database Administrator

    6 days ago

    Toronto, ON, Canada Eastlink Full time

    Designated office: 6080 Young Street, Halifax, NS This position is: Hybrid, at least 3 days per week in office Eastlink is a family owned, entrepreneurial and innovative company headquartered in Halifax, Nova Scotia. We take great pride in being a leader in delivering creative competitive, customer focused telecommunications solutions, and connecting...

  • Warehouse Specialist

    4 weeks ago

    Toronto, Canada Canadian Tire - Lakeshore & Leslie (store #654) Full time

    **Canadian Tire Lake Shore & Leslie - Store 654** This high profile and growth-oriented Toronto store has a constructive and goal-oriented culture for the staff. Management is focused on building a high-performance team that strives for being productive and efficient in all routines, projects, and customer service. The vision and culture is to have a team...

  • Database and Content Specialist

    1 week ago

    Toronto, Canada Manulife Full time

    **_Are you looking for a supportive, collaborative workplace with great teams and inspiring leaders? You’ve come to the right place. We’re looking for ambitious people who share our values and want to make every day better for people around the world. If this sounds like you, and the career below sounds exciting, we’d like to hear from you....

  • Warehouse Specialist

    3 weeks ago

    Toronto, Canada Canadian Tire - Lakeshore & Leslie (store #654) Full time

    Canadian Tire Lake Shore & Leslie – Store 654This high profile and growth-oriented Toronto store has a constructive and goal-oriented culture for the staff. Management is focused on building a high-performance team that strives for being productive and efficient in all routines, projects, and customer service. The vision and culture is to have a team that...