Data Analyst

POSITION SUMMARY

We are looking for an analytical problem-solver to bridge the gap between our Distribution operations and Marketing strategy. In this role, you will be responsible for the integrity of our data within the SAP environment and will lead the initiative to transition our reporting into Power BI.

You will move beyond simple data entry to become a data architect—building models, resolving complex allocation (TRAC) coding issues, and designing visual dashboards that provide actionable insights for leadership.

ESSENTIAL DUTIES AND RESPONSIBILITIES

1. Dashboard Development & Visualization

• Lead the Transition:
  Spearhead the development of Power BI dashboards from the ground up to replace static reporting.
• User Requirements:
  Collaborate with cross-functional teams to gather requirements and translate business needs into clear, visual, and interactive reports.
• Maintenance:
  Design and maintain data models to ensure reports run efficiently and accurately.

2. Data Integrity & SAP Management

• Quality Assurance:
  Perform rigorous data validation and quality checks to ensure accuracy across the Distribution department.
• Troubleshooting:
  Investigate and resolve data discrepancies, with a specific focus on
  TRAC (Canadian Allocation Coding)
  mapping issues.
• Optimization:
  Manage data inputs within the SAP environment to optimize storage and retrieval.

3. Analysis & Strategy

• Actionable Insights:
  Conduct comprehensive analysis to support the Director of Marketing in identifying trends, inventory bottlenecks, and opportunities.
• Process Improvement:
  Recommend and implement data management best practices to improve efficiency.
• Testing:
  Support testing activities to verify the functionality and performance of new data models.

QUALIFICATIONS

To perform this job successfully, the candidate must possess a blend of technical expertise and business acumen.

Education:

• Bachelor's degree in data Analytics, Computer Science, Business, Supply Chain, or a related field (or equivalent experience).

Experience & Technical Skills:

• Experience:
  1–2+ years of professional experience as a Data Analyst.
• Visualization (Required):
  Proven experience building dashboards and reports in
  Power BI
  (or Tableau/Looker). You must be comfortable creating visualizations from scratch.
• Excel (Required):
  Advanced proficiency in Microsoft Excel (Power Query, Pivot Tables, XLOOKUP, Nested Formulas).
• ERP Systems:
  Experience working within
  SAP
  is highly preferred; experience with other ERPs is an asset.
• Data Manipulation:
  Basic coding skills in SQL or Python for data automation is an asset.

CORE COMPETENCIES

Communication & Data Storytelling

• Ability to "translate" complex data into plain English for non-technical stakeholders.
• Excellent written and verbal communication skills for presenting findings in one-on-one and small group settings.

Analytical Logic & Reasoning

• Strong critical thinking skills with the ability to solve practical problems involving multiple variables.
• Ability to apply common sense understanding to carry out instructions and independently troubleshoot data anomalies.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• While performing the duties of this job, the employee is regularly required to sit, use hands and fingers, handle or feel, and talk or hear.
• The employee is occasionally required to stand, walk, or reach with hands and arms.

LANGUAGE SKILLS

Ability to read and comprehend instructions, correspondence, and memos. Ability to write correspondence. Ability to effectively present information in one on one and small group situations to internal and external customers.

MATHEMATICAL SKILLS

Ability to add, subtract, multiply and divide in all units of measure, using whole numbers, common fractions and decimals.

REASONING ABILITY

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.