Sr Data Engineering Specialist

Tech companies are hiring in Ottawa! If you’re looking for your next opportunity in tech, Work in Ottawa can help you build a thriving career in the fast-growing technology industry in Canada’s capital.

As an initiative of the city’s economic development agency, Invest Ottawa, Work in Ottawa helps tech firms fill open positions quickly so they can grow and scale faster.

We are excited to partner with Ross Video on their search for Senior Data Engineering Specialist.

This position is located in our state-of-the-art manufacturing facility in Iroquois, Ontario.

The Senior Manufacturing Data Engineering Specialist will lead the development and optimization of comprehensive manufacturing data systems, ensuring the delivery of insights and real-time data exchanges that drive production performance. This role involves mentoring junior team members, working independently, driving improvements, and providing technical leadership. The successful candidate will collaborate with various departments to ensure timely and accurate data flow and the optimization of manufacturing processes. They will be responsible for selecting technology stacks and developing solutions through third-party technologies and in-house development.

Who you report to: Manager, Manufacturing Data Infrastructure

Work Arrangement: Full-Time - Work From Office 2 Days a week on Site

What we offer:

Ross offers competitive salaries and comprehensive health plans, as well as several perks to help you perform at your best. Some of these perks include flexible hours, generous paid time off, fitness/wellness allowance, employee share ownership program, professional development support and a ton of fun social activities and events!

Best of all, you will be part of the Ross Video team, and we’ve got a pretty energizing environment here.

What the job is all about:

• Data Solutions & Insights: Design and implement comprehensive data solutions to drive production efficiency through real-time data insights.
• Technical Leadership: Lead technology stack and third-party tool decisions.
• Data Pipeline Development: Build and maintain scalable data pipelines from various manufacturing systems.
• Data Centralization: Manage data warehouses/lakes, ensuring accessibility and documentation for all users.
• Automation Tools: Develop web-based tools for automated data collection and reporting, reducing manual efforts.
• Visualization & Reporting: Enable technical staff to create and maintain data portals, dashboards, and performance reports.
• Data Quality: Implement data validation and cleansing processes.
• Cross-Functional Collaboration: Work with engineering, production, operational tech, and QA to align data solutions with needs.
• System Integration: Connect manufacturing systems with ERP and Oracle Agile.
• Continuous Improvement: Stay updated on industry trends to enhance data infrastructure.
• Business Alignment: Focus on practical outcomes that support manufacturing and business objectives.
• Mentorship: Guide junior team members, promoting learning and growth.

Who you are:

• Bachelor’s degree in computer science or a related field, with a specialization in data science/engineering.
• Advanced knowledge of data engineering tools and technologies, such as SQL, Python, ETL processes, BI Tools, and data warehousing solutions.
• Solid and applied knowledge of data modeling for enterprise-wide applications.
• Familiarity with designing and developing basic web-based applications, with a focus on user-friendly interfaces and responsive functionality.
• Familiarity with key manufacturing metrics and operational performance measurements.
• Minimum of 8 years of experience in data engineering.
• Demonstrated experience in developing and managing data pipelines, data integration, and data warehousing solutions, including performance tuning and optimization of existing database systems for efficiency and scalability.
• Minimum of 3 years of hands-on experience in designing and implementing data models for Data Warehousing solutions. Proficiency in developing star and snowflake schemas, optimizing data structures, and ensuring data integrity to support analytics and reporting needs.
• Minimum of 4 years of experience in creating data visualizations and reports using tools like Power BI, Tableau, or similar.
• Exposure to manufacturing systems such as MES, ERP, and SCADA.

Traits:

• Solid problem-solving skills and attention to detail.
• Excellent communication and collaboration skills.
• Ability to manage multiple projects and prioritize tasks effectively.
• Proactive approach to identifying and addressing data-related issues and opportunities.
• Ability to work independently and drive improvements in the role.

Work in Ottawa utilizes a secure, closed AI environment for the initial screening of resumes, ensuring your data remains safe while helping us efficiently identify top candidates. We encourage all applicants to apply, even if you do not meet every requirement if you possess relevant skills, enthusiasm and eagerness to grow, we want to hear from you! To enhance your visibility, consider including relevant keywords in your resume.

If you require any accommodation during the hiring process, please reach out to Talent Acquisition.