Business Intelligence Developer (On-site)

Mastronardi Produce pioneered the commercial greenhouse industry in North America, and we’re now the leading greenhouse vegetable company on the continent. Our award-winning, flavorful produce is packed under the SUNSET® brand and is available at leading grocery retailers across North America. Family owned for over 65 years, we pride ourselves on having the most flavorful products and the best people in the industry. We are constantly pushing boundaries to be a leader in fresh produce innovation. We seek individuals that demonstrate our PRIDE values (Passion, Respect, Innovation, Drive, Excellence) to help us fulfill our mission to inspire healthy living through WOW flavor experiences.

 

Our Headquarters in Kingsville, ON is seeking an experienced Business Intelligence (BI) Developer to join our Information Technology team!  The BI Developer’s role is to work closely with our BI Analyst to strategically design and implement BI software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users. The BI Developer is also responsible for ensuring high levels of BI availability through support functions and in-depth testing.

 

Values:

To perform the job successfully, the incumbent’s behavior must be consistent with the PRIDE values expected of all Mastronardi Produce employees: be Passionate; have Respect; be Innovative; be Driven and strive for Excellence.

 

Primary Responsibilities: 

• You will continue the evolution of our BI platform(s) by developing and supporting our enterprise BI platform.
• Translate business needs to technical specifications.
• Design, develop, deploy, and maintain Power BI & other reporting solutions.
• Subject Matter expert developing Power BI reporting for Inventory, Production/Operations, Finance, Accounts Receivable, Accounts Payable, Sales, Supply Chain, and Executive Management.
• Connect to data sources, import data, and convert data for BI.
• Create reports, dashboards, KPIs, and visualizations from Mastronardi’s data.
• Integrate Power BI reports into other software.
• Test BI Reports for accuracy prior to being deployed to Production.
• Set up implementations, think of new approaches, and recommend best mix of reports and dashboards.
• Schedule data report refreshes.
• Build Analysis Services reporting models.
• Design methodology and project documentation.
• Develop tabular and multidimensional models that are compatible with warehouse standards.
• Develop and maintain BI infrastructure architectural design and technical configurations.
• Set up documentation for policies, best practices, standards and procedures (workflows) for reporting systems and services.
• Understand data standards and identify data abnormalities. Instill data quality in all solutions delivered.
• Develop overall project technical design and build custom elements of a project.
• Create new reports or modify existing reports using industry standards and best practices.
• Engage with IT to understand impact of new system development or changes to reporting.
• Interact with other reporting teams and SME(s) to ensure collaboration.
• Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.
• Provides production support for business intelligence solutions. Activities include problem analysis, break/fix, design/modeling, implementation/coding, and testing.
•   

Position Requirements: 

• Bachelor's degree in Computer Science or Information Systems. 
• At least 6 years work experience as a BI Developer with strong delivery skills.
• Experience/Certification in Agile SDLC methodologies.

 

Knowledge & Experience:

• Experience with tier-one BI applications. Preference given to Power BI, Anaplan, Targit, DeFacto.
• Experience in performance tuning of Power BI reports/dashboards, scheduling Reports/Direct query etc.
• Knowledge of Power BI set up and deployment architecture design. Gateway administration
• In-depth experience with Microsoft analytics Stack (SQL Server, SSAS Tabular, SSRS, Power BI, Power Query, DAX, SQL and T-SQL) including M language
• Experience in Extraction, Transformation and Loading (SSIS)
• Experience in Tabular/OLAP Model (Microsoft SSAS), Azure Analysis Services
• In-depth experience with Associated Development Tools - Visual Studios Data Tools, SQL Server Management Studio, SQL Server Data Tools, Microsoft TFS
• Implementation of access control and knowledge of security mechanisms for report access
• Experience with cube development using SSAS
• Understanding of Azure and its data services. Cloud and on-premise understanding
• Proficiency required with Microsoft Flow and Microsoft Power Apps setup and usage
• Knowledge of dimensional modelling and data warehousing concepts
• Proficient in Microsoft Office Suite and O365
• Superior documentation and organizational skills. Must be detail oriented
• Excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources
• Must possess and demonstrate excellent verbal, written, and interpersonal communications skills

 

Personal Attributes:

• Excellent analytical and problem-solving skills
• Ability to work with and appropriate communicate with all levels of staff from shop floor workers to executive management team.
• Self-motivated and desire to learn/acquire new skills
• Excellent communication & interpersonal skills, utilizing data to tell a story.
• Top-notch work ethic and customer service orientation.
• A high degree of integrity, confidentiality and commitment.
• Experience in working in team/collaborative environment
• Ability to work independently and meet deadlines in a fast-paced environment.
• Courtesy, respect, and thoughtfulness in teaming with colleagues and other stakeholders

 

Please note: Mastronardi Produce has accommodation processes and policies in place and provides accommodation for employees with disabilities. If you require a specific accommodation because of a disability or documented medical need, please contact the Human Resource office so that arrangements can be made for the appropriate accommodation to be put in place.