Business Intelligence Engineer - 3 month contract

The Business Intelligence (BI) Engineer will be responsible for developing, managing, and deploying
various business intelligence solutions that will enable the business to transform data into meaningful
insights. The BI Engineer’s role is to assimilate data from multiple sources into consumable data
solutions as well as assist with the development, governance, and management of various data
platforms. The BI Engineer must be capable of networking with business stakeholders regularly to
gather data requirements, provide necessary guidance, offer recommendations, and translate end user needs into technical specifications.

This role requires you to attend the office 4+ days per week.

Responsibilities

Collaborate with stakeholders to understand their data requirements and translate them into effective data solutions
Provide technical design, coding, testing, implementation, maintenance, system, and technical support for BI initiatives
Develop and maintain reports, dashboards for cross-functional groups including but not limited to Finance, Inventory Management, IT, Operations, Sales, and Manufacturer Relations
Develop and maintain automated data pipelines, relational and multidimensional data models
Ensure that applications are following best data engineering practices
Design and develop analytical data solutions and efficient data visualizations leveraging business intelligence tools (i.e., Power BI) to enable value-add decision making by various business units
Collaborate with business partners and technical teams to ensure data accuracy, integrity,
consistency, and security
Liaise with other business intelligence colleagues, including your manager, to explore new prospective opportunities with data products and services that will benefit the organization
Identify, design, and implement internal process improvements: automating manual processes, redesigning existing reports for greater scalability, etc.
Support self-service reporting and resolve issues in a timely fashion towards a stable BI environment
Develop and update technical documentation
Stay up to date with best data engineering practices

Requirements

Degree in Computer Science, Information Technology, or related discipline
3-7 years of hands-on experience in a data-related role
Experience in data modelling, data pipelines and reports development
Strong T-SQL skills
Solid knowledge of database fundamentals and performance tuning
Solid knowledge of relational and dimensional modelling concepts
Experience with Microsoft suite – SSIS, SSRS, SSAS, Power BI
DB2 knowledge an asset
Cognos knowledge an asset
Understanding of supply chain industry
Knowledge in the healthcare industry an asset
Experience with various data types and associated lifecycles
Knowledge of Azure data services and applications an asset
Knowledge of Dynamics and applications an asset
Demonstrated and well-developed analysis and analytical skills

Apply to Business Intelligence Engineer - 3 month contract