Senior Business Analyst in St. Thomas at Masco Canada

Date Posted: 8/25/2019

Job Snapshot

Job Description

Job Description

Working closely with multiple teams and individuals, including subject matter experts, across a wide variety of functions, (e.g. Engineering, Finance, Product Management, Sales, Operations) you will support the company’s business intelligence, data warehouse and reporting needs across all business systems including JD Edwards, SQL Server warehouse and Cognos BI.

What you will do:

  • Provide analytical and technical expertise by gathering requirements and delivering versatile data models and reporting solutions.
  • Deliver expert business analysis skills with a strong technical aptitude.
  • Partner with technical team experts to determine and document the optimal design (performance and recovery).
  • Apply proven analytical approaches to identify errors or limitations in data and implement processes to improve data validity.
  • Develop, train and support users in the use of analytic dashboards and reports.
  • Collaborate with business users on the execution of larger projects.
  • Assist in documentation of requirements and specifications.
  • Perform other Month End and Ad Hoc reporting as requested or directed.

What you will bring:

  • MBA or Bachelor’s Degree (Business Admin, Computer Science, Science or Data Analytics) and/or an equivalent combination of experience and education is required.
  • At least 5 - 7 years hands on experience in a senior business analyst position in a mid-sized organization (preferably manufacturing environment)
  • Experience working with OLAP reporting tools such as Cognos, Microsoft Power BI, etc.
  • 3 to 5 years’ experience creating reports from centralized datasets that contribute to the company’s decision-making process.
  • Solid understanding of relational database structures and strong SQL query writing capabilities.
  • Experience creating or working with automated ETL pipelines.
  • Experience with SSAS/SSIS.
  • Experience building content and dashboards in business intelligence (Cognos BI or similar) and data visualization tools.

Additional Requirements:

  • Knowledge of various SDLC and process methodologies (e.g. Agile, Waterfall)
  • JD Edwards or similar ERP experience.
  • Strong desire to innovate and advance internal technologies and processes.
  • Proficiency with Microsoft Office applications.
  • Continuous improvement approach following best practice analytic principles.
  • Understanding of Project Management and Change Management principles and methodology

•         Ability to travel to our Mississauga location (10%)

Who you are:

  • A collaborative team player with strong communication and influencing skills, who builds relationships easily
  • Thorough knowledge of finance with a high degree of business acumen.
  • Highly developed problem solver with analytical skills
  • Willing to work a flexible schedule including potentially extended hours during month end reporting and other key times during the fiscal year

Masco Canada (the “Company”) is an equal opportunity employer and we want to have the best available persons in every job. The Company makes employment decisions only based on merit. It is the Company’s policy to prohibit discrimination in any employment opportunity (including but not limited to recruitment, employment, promotion, salary increases, benefits, termination and all other terms and conditions of employment) based on race, color, sex, sexual orientation, gender, gender identity, gender expression, genetic information, pregnancy, religious creed, national origin, ancestry, age, physical/mental disability, medical condition, marital/domestic partner status, military and veteran status, height, weight or any other such characteristic protected by federal, state or local law. The Company is committed to complying with all applicable laws providing equal employment opportunities. This commitment applies to all persons involved in the operations of the Company regardless of where the employee is located and prohibits unlawful discrimination by any employee of the Company.

No visa sponsorship is available for this position, unless specified within the job description.