Business Intelligence Developer

Are you a seasoned Business Intelligence (BI) Developer looking to make an impact in a dynamic organization? Factors Group is a large manufacturing company and certified B Corp, searching for a confident BI Developer to join our team and lead 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.

Schedule:

Permanent, Full-time

Monday – Friday, 8:00am – 4:30pm (flexible hours)

Hybrid in the office in Coquitlam

In your role, you will be responsible for:

BI Solution Design and Development:

• Our current systems are SSIS, SSRS, SSAS ect. You will manage these, and 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.
• Work alongside the Data Engineer creating ETL processes and ensure efficient data transformation and loading.
  
  

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.
  
  

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 future state:

• Provide coaching and leadership to junior staff.
• Stay updated on trends in new technologies, particularly cloud-based AI technologies.
  
  

You have:

• 7+ years of experience with on-prem BI tools like SSIS, SSRS, and strong SQL Server skills
• Experience with Azure Synapse or Data Factory is a plus, but we’re happy to support learning on the job
• Skilled in Power BI, with strong M, DAX, and MDX knowledge
• Comfortable using Python or R for data analysis or machine learning
• Clear and confident communicator in English, both written and spoken
• Works well with different teams and departments
• Strong at solving problems and analyzing technical issues
• Focused on delivering great service to users and stakeholders
• Can handle multiple projects and prioritize effectively
• Always looking for ways to improve how things are done
• Motivated to learn and grow with new tools and methods
  
  

What’s in it for you:

• Contribute to a company committed to sustainability and continuous improvement.
• Seeing as this is a small team, you will be instrumental in the migration from on-prem to the cloud. Your ideas will be actioned and decisions followed through
• Freedom to research and choose the tools that suit the business best and implement them
• We are a large company with many business units including corporate, logistics, manufacturing, ect. The solutions you can implement are endless!
  
  

You get:

• Health & Wellness Support: Enjoy comprehensive healthcare, personal and health spending accounts, wellness days, employee wellness sessions, and access to the Employee & Family Assistance Program.
• Financial Perks That Grow With You: Company RRSP contributions, loyalty share program or bonuses (for supervisors and above), tuition reimbursement, and referral bonuses.
• Everyday Savings & Rewards: Get a $300 annual credit for company products, employee discounts, exclusive vendor deals, and a free Costco membership.
• Comfort & Convenience: Free onsite parking, bus pass reimbursement, $200 safety boot voucher, and company-provided PPE to keep you safe and comfortable.
• Culture That Celebrates You: From appreciation events and community involvement to core value recognition and fun employee rewards—we make sure your efforts are seen and celebrated.
  
  

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.

FGOffice