Senior Data Operations & BI Developer

Overview

We are committed to providing a barrier‑free recruitment process. If you require accommodation at any step in the process, we will work with you to meet your needs – simply contact a member of the HR team with your request. Thank you for your application to Holstein Canada. Due to the volume of applications, only selected candidates will be contacted.

WEB | www.holstein.ca

CAREERS

Senior Data Operations & BI Developer – Brantford, ON

HOLSTEIN CANADA is the largest dairy breed association in Canada, serving our membership of almost 9,200 active dairy producers since 1884. With dynamic leadership and a clear vision, we are building an exciting, tech‑friendly future. We offer a strong team‑oriented workplace that supports personal and professional growth, remote working opportunities, a comprehensive benefits package, and the chance to participate in meaningful projects for the Canadian dairy industry.

Responsibilities

• Design, develop, and maintain SSIS packages, SSRS reports, and SSAS models to support enterprise data integration, reporting, and analytics requirements.
• Co‑lead the modernization of departmental reporting by designing and developing interactive Power BI dashboards, including KPI reports tailored for department managers, and collaborate with stakeholders to integrate data from multiple systems.
• Own and manage daily automated SSIS processes by monitoring performance, reporting issues, and resolving data‑related problems to ensure SLA compliance.
• Present and document complex data models, including historical data structures, to support transparency, maintainability, and knowledge transfer.
• Work closely with developers, business and system analysts to understand existing data models and develop ad hoc queries that fulfill business queries and reporting requirements.
• Maintain comprehensive documentation on data processes, including data dictionaries, workflow diagrams, and troubleshooting guides, to facilitate transparency and knowledge transfer.
• Perform rigorous quality assurance checks on data to uphold integrity and compliance with organizational standards and regulatory requirements, mitigating risks associated with inaccurate or incomplete data.
• Collaborate closely with cross‑functional teams, including developers, analysts, and business stakeholders, to understand data requirements and develop solutions aligned with business needs.
• Proactively seek opportunities to improve data processes and systems, leveraging new technologies and best practices to enhance data quality, efficiency, and reliability, driving continuous optimization across the organization.

Requirements

Deep expertise in MS SQL Server and SQL Server Management Studio, including :

Hands‑on experience with modern Microsoft data tools, including :

Page : 2 of 2

#J-18808-Ljbffr