Senior BI/Data Analyst

IKO Industries Ltd. is a market leader in the manufacturing of roofing and building materials. IKO is a Canadian owned and operated business with production facilities worldwide and has many years of unparalleled success in the roofing materials industry. Quality, integrity, and trustworthiness are the values that underlie this success, and we have built this company by hiring people who hold these values. People like you!
 

Job Description

Position Title:    Senior BI/Data Analyst
Location:            Minnesota Office, Mississauga Ontario

Compensation: $110,000 - $135,300

Benefits

• Health Insurance (includes Virtual Health, and HCSA)
• Dental Insurance
• Vision Insurance
• Life Insurance
• Long-term Disability
• Short-term Disability
• RRSP Match
• Paid Vacation
• Floating Days
• Employee Assistance Program
• Employee Engagement Events
• Awards and Recognition
• Tuition reimbursement
• Service Awards
• Employee Perks & Discounts

Background:

The Senior BI/Data Analyst works collaboratively with the business and technology teams to gather and document detailed requirements and being responsible for the analysis stages for all the BI projects. The focus is to:

• Requirements Gathering and Analysis
• Implementation of BI dashboards using Power BI.
• Data Analysis for BI solutions
• BI Projects support.
• Coach and mentor intermediate team members.

Requirements Gathering and Analysis

• Work with the business owners, BI developers, BI architect, PMs, and other BAs to break down the designed solutions into detailed business requirements.
• Conduct workshops and meetings to gather requirements.
• Conduct process mapping.
• Document business processes and rules from a user perspective and identify the gaps and be responsible for recommendation of process optimization.
• Own capturing the data flow mapping across various business and system processes and interpreting the value offerings and validations.
• Collaborate with stakeholders to gather and document business requirements for new projects or enhancements to existing processes. Document current business processes using tools such as flowcharts or diagrams to identify all areas.
• Create and maintain documentation related to business requirements, process flows and system configurations.
• Own the creation and maintenance of Business Requirements Documents (BRD).
• Communicate effectively with stakeholders at all levels of the organization to gather requirements, provide updates, and facilitate decision-making processes.
• Work closely with business and IT stakeholders. Understands the business requirements, application systems, limitations and constraints, company’s policies.

Implementation of BI dashboards using Power BI

• Support the implementation of BI dashboards using Power BI.
• Build and review simple to medium-complexity Power BI semantic models.
• Collaborate with the Analytics and Data teams to build high-complex Power BI semantic models.
• Build and review simple to medium-complexity Power BI dashboards and reports.
• Collaborate with the Analytics and Data teams to build high-complex Power BI dashboards and reports.
• Ensure BI dashboards are aligned to business requirements.

Data Analysis for BI solutions

• Analyze data in BI solutions (reports, dashboards, etc.) and provide suggestions for KPIs.
• Analyze current KPIs and provide insights based on KPI results.
• Analyze different databases to know how to retrieve data.
• Collaborate with the Data team to support the building of data pipelines.
• Be able to analyze data directly in the databases by creating SQL queries.
• Present data analysis before creating KPIs in BI solutions.

BI Projects support

• Support business case development and presentation for steering meetings.
• Contribute to high-level technical solutions discussions.
• Support organization change management, training, and related document creation.
• Build and review test plans and ensure test strategies.
• Ensure test cases align to document business and solution requirements.
• Ensure BI projects are aligned to business requirements.
• Provide support to defect review and resolution.
• Participate and monitor QA activities, SIT activities.
• Lead UAT sessions with stakeholders.

Coaching and Monitoring

• Collaborate closely with the other members of the Business Intelligence and Analytics team and ensure effective implementation of all Business Intelligence and Analytics projects to achieve all client’s objectives playing the role of the most senior business analyst position on the team.
• Keep project team informed of problems, issues, and resolutions, being the liaison between the BI team and business users.
• Provide Business Intelligence and Analytics training to the business users and IT teams.

Requirements and Qualifications

• Bachelor’s degree in business, computer science, computer engineering, electrical engineering, system analysis or a related field of study, or equivalent experience.
• Minimum of 10 years of overall IT experience as a Business Analyst with focus on Business Intelligence, Analytics and Data Warehouse related projects.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with mindfulness and accuracy.
• Proficiency in business analysis tools and techniques, such as process mapping, data analysis, and requirement gathering.
• Experience with project management methodologies and tools.
• Experience with Power BI would be an asset.
• Ability to develop and prepare technical specifications and documentation.
• Experience working with the manufacturing and/or building industries is desired.
• Excellent analytical, planning, and organizational skills.
• Excellent written, verbal, communication, and presentation skills with the ability to articulate innovative ideas and concepts to technical and nontechnical audiences.
• Organizationally savvy, with situational and contextual intelligence of the political climate of the enterprise and how to navigate obstacles and politics.
• Rapidly comprehends the functions and capabilities of modern technologies.

#LI-LS1

We may use artificial intelligence (AI) tools on a limited basis to assist in initial assessment, identification, and review of candidates. AI is used only to support our recruiting and hiring team, and decisions are always made by the recruiting and hiring team. Absolutely no applicant data is sent or provided externally through these AI tools.

Benefits of Employment: IKO recognizes that its success is due to the strength of its employees. A primary goal of IKO is to promote individual employee's sense of accomplishment and contribution so that employees enjoy their association with IKO. The Company invests in its employees so that they are the most knowledgeable in the industry, and undertakes great efforts to nurture loyalty to, and teamwork at, IKO. We are pleased to offer competitive compensation, health care, a progressive and challenging workplace and a commitment to teamwork and integrity.
 

Diversity and Equal Opportunity Employment: IKO Industries Ltd. is an equal opportunity employer. We are committed to diversity and inclusion and are pleased to consider all qualified applicants for employment without consideration to race, religion, creed, color, national origin, age, gender, sexual orientation, marital status, veteran status or disability. IKO Industries Ltd. encourages and welcomes applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.