Business Intelligence Developer

As a leading manufacturer of nutritional supplements and other health-building products, we are dedicated to enhancing the wellbeing of our customers - through research, development and delivery of effective nutritional products. It is our mission to contribute to the lives of our customers, employees, suppliers and the communities we serve, in a cooperative and sustainable manner.

Are you a seasoned Business Intelligence (BI) Developer looking to make an impact in a dynamic organization? We are seeking a talented BI Developer to join our team and participate in the design, development, maintenance, and enhancement of our enterprise BI products, with a strong focus on migrating from on-premise solutions to Azure cloud-based services.

You’re good at:

Cloud Migration:

• Lead the migration of on-premise BI solutions (SSIS, SSRS) to Azure cloud-based platforms such as Azure Synapse Analytics and Azure Data Factory.
• Ensure seamless data flow and integration with existing databases and data warehouses.

BI Solution Design and Development:

• Design and implement BI systems to support current and future business requirements.
• Collaborate with data analysts and end users to create and manage data models.
• Maintain databases and storage solutions, ensuring performance, reliability, and security.
• Work alongside the Data Engineer creating ETL processes and ensure efficient data transformation and loading.

AI and Data Analysis:

• Manage infrastructure for effective AI deployment and develop AI algorithms to enhance data analysis capabilities.
• Perform data analysis, profiling, and cleansing.
• Team and Client Interaction:
• Manage client interactions and requests with support from teammates.
• Provide coaching and leadership to junior staff.
• Stay updated on trends in new technologies, particularly cloud-based AI technologies.

Compliance and Policies:

• Adhere to all safety policies and follow given instructions, including Work Procedures (WP), Standard Operating Procedures (SOPs), and current Good Manufacturing Practices (cGMP).
• Perform other duties as assigned.

You have:

• Bachelor’s degree in Computer Science, Information Technology, or a related discipline.
• Minimum 8 years of experience with on-premise BI solutions (SSIS, SSRS) and advanced Transact-SQL skills for Microsoft SQL Server.
• Minimum 3 years of experience with cloud platforms for data warehousing and analytical services (e.g., Azure Synapse Analytics, Azure Data Factory).
• Experience with data visualization tools such as PowerBI and advanced skills in M language, DAX, and MDX.
• Knowledge of programming languages such as Python or R for data analysis and machine learning models.
• Excellent communication skills (verbal, written, and presentation) in English.
• Strong interpersonal skills and ability to work productively with cross-functional colleagues.
• Skilled in problem-solving and technical analysis.
• Strong customer service orientation.
• Ability to manage multiple projects simultaneously with appropriate prioritization.
• Proactive attitude with motivation to improve business processes.
• Self-motivated and eager to learn new technologies or business methods.

What’s in it for you:

• Contribute to a company committed to sustainability and continuous improvement.
• You will be one of a small team leading the migration from on prem to the cloud
• Freedom to choose the tools that suit the business best and implement them

You get:

• Great healthcare benefits (including health and personal spending accounts)
• Vacation and wellness days
• Employee appreciation events
• $200 per year to spend on company products
• Employee discount pricing on company products
• Employee assistance program
• RRSP contributions
• Optional access to your pay as soon as you earn it (at no additional cost or fees)

FGOffice

This position is open to all qualified applicants who are legally entitled to work in the country in which this job is located. Only electronic applications can be accepted. This position will close when a competitive candidate pool has been identified. We thank you all for your applications and a member of our team will contact you soon. All the best!

All Internal applicants will be given priority for consideration for the first five business days that this position is posted. After that five days, Internal applicants will be considered along with all other applicants; however, are guaranteed at minimum a call from the Talent Acquisition team.