Business Intelligence Analyst
At Caldic we are continually developing our capabilities and we strive to become better every day, with the goal to build long-term relationships.
To add value to our company, and to our inspiring solutions we are currently looking to add to our team. Are you a natural leader with a proven track record in the industrial market?
Do you have the drive to succeed in a moving fast forward company? Then we are looking for you!
Position function : Reporting to the Business Intelligence Manager of Caldic Canada Inc., the individual is an analytical professional who has experience with analysis and reporting in a fast paced organization.
The individual will primarily be responsible for supporting the business by assisting in the creation of custom reports and tools using a variety of technologies, and utilizing the information presented to provide meaningful insight to drive business decisions.
Scope : The Business Intelligence Analyst's role is to liaise with the Subject Matter Experts and the business users within the organization.
The individual will be responsible for the design, validation, and implementation of custom reports and solutions based on user specifications.
The results are to be analyzed for trends and variances and presented to stakeholders. The individual will also be responsible for supporting various business requirements as they arise which directly relate to data, to ensure the accuracy and completeness of information sources.
Major tasks and duties :
- Work with Subject Matter Experts to document detailed report specifications
- Assist in the creation and development of custom reports using varying technologies
- Confirm and reconcile report results against information sources, to ensure proper control, reconciliation of systems, and accuracy
- Access queries, perform regular entries on the internal spreadsheets and / or database systems and provide analytical support to various internal user-groups
- Assist in identifying opportunities in the business by analyzing and organizing data to produce impactful analysis
- Assist with data cleansing and mapping exercises
- Develop business solutions ranging from developing reports to building automatons aimed at improving productivity
- Conduct testing on various business processes
- Complete other tasks as requested
- Represent Caldic and its interests when dealing with vendors
- Work with and train other IT team members to deliver the best support possible.
- Ensure compliance with all health and safety regulations, GMP’s and HACCP requirements
Knowledge / Skills & Experience
- Experience with SQL queries or reporting against a Relational Database
- Experience with Reporting software (Crystal reports, SSRS, Visual Studios, Power BI, Snowflake, etc...) and report development is an asset.
- Understanding of Business Intelligence methodologies
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
- Experience in an analyst role
- Post-Secondary Degree required (IT or related preferred)
- Proficient in using MS Office Suite of products
- Advanced Excel skills required
- Good communication and presentation skills and full command of the English Language (Written / Spoken)
- Application development and D365 knowledge and experience is an asset.