Data Analyst 1
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Pattison Food Group is hiring a Data Analyst 1 to support business decision-making through data analysis, reporting, and insight generation. You will build Power BI dashboards, write SQL queries, and collaborate with stakeholders.
Key Skills for This Role
Responsibilities
- Partner with business stakeholders to understand priorities, business questions, processes, and KPIs
- Build reports, dashboards, and visualizations in Power BI that communicate findings clearly and effectively
- Support development of scalable, standardized reporting solutions aligned with Power BI COE principles
- Develop and maintain Power BI solutions using advanced capabilities such as DAX, data modeling, and performance optimization
- Contribute to semantic model and enterprise dataset design to support consistency, usability, and reuse
- Support Power BI Service administration activities such as workspace organization, security access, dataset refreshes, and report lifecycle management
- Monitor and improve report performance, scalability, and usability
- Write SQL queries to extract, manipulate, and prepare data for analysis and reporting
- Use Python and notebook based tools for exploratory analysis, data wrangling, and statistical work where needed
- Validate, troubleshoot, and improve data used in reporting and analysis
- Collaborate with Data Engineering and other technical partners to support data provisioning, model optimization, and reporting readiness
- Support user enablement through documentation, training, and guidance
Requirements
- Degree in a relevant field such as statistics, mathematics, computer science, engineering, economics, or another quantitative discipline
- 3+ years of relevant experience in data analytics, business analytics, reporting, or a related field
- Strong working knowledge of SQL for querying and transforming data
- Hands on experience building dashboards, reports, and visualizations in Power BI
- Experience with advanced Power BI development, including DAX, data modeling, and report performance optimization
- Familiarity with semantic models and enterprise dataset design
- Exposure to Power BI Service administration, including workspaces, security, refresh management, and deployment practices
- Ability to design reporting solutions that are scalable, governed, and aligned with business needs
- Experience working with large or complex datasets in modern analytics environments
- Working knowledge of Python for data analysis (preferred)
- Exposure to user enablement, training, or supporting self service BI (asset)
- Familiarity with cloud and modern data platforms such as Azure Synapse, Databricks, and Microsoft Fabric (asset)
Full Job Posting
Overview
- Pattison Food Group Ltd. is a Jim Pattison business and Canada’s largest Western based provider of food and health products.
- We have an exciting opportunity for a full time Data Analyst 1 to join our Data & Analytics team in Langley, BC.
- Reporting to the Lead Data Analyst, the Data Analyst 1 role supports business decision making through data analysis, reporting, and insight generation.
- This role also supports the Power BI Center of Excellence by contributing to scalable reporting solutions, governance, standardization, and self service BI enablement.
You will be responsible for:
- Partnering with business stakeholders to understand priorities, business questions, processes, and KPIs.
- Building reports, dashboards, and visualizations in Power BI that communicate findings clearly and effectively to stakeholders.
- Supporting the development of scalable, standardized reporting solutions aligned with Power BI COE principles and best practices.
- Developing and maintaining Power BI solutions using advanced capabilities such as DAX, data modeling, and performance optimization.
- Contributing to semantic model and enterprise dataset design to support consistency, usability, and reuse across reporting.
- Supporting Power BI Service administration activities such as workspace organization, security access, dataset refreshes, and report lifecycle management.
- Monitoring and improving report performance, scalability, and usability to support a strong end user experience.
- Writing SQL queries to extract, manipulate, and prepare data for analysis and reporting.
- Using Python and notebook based tools for exploratory analysis, data wrangling, and statistical work where needed.
- Validating, troubleshooting, and improving data used in reporting and analysis.
- Collaborating with Data Engineering and other technical partners to support data provisioning, model optimization, and reporting readiness.
- Supporting user enablement through documentation, training, and guidance that helps strengthen self service BI capabilities across the business.
You have:
- A degree in a relevant field such as statistics, mathematics, computer science, engineering, economics, or another quantitative discipline.
- 3+ years of relevant experience in data analytics, business analytics, reporting, or a related field.
- Strong working knowledge of SQL for querying and transforming data.
- Hands on experience building dashboards, reports, and visualizations in Power BI.
- Experience with advanced Power BI development, including DAX, data modeling, and report performance optimization.
- Familiarity with semantic models and enterprise dataset design.
- Exposure to Power BI Service administration, including workspaces, security, refresh management, and deployment practices.
- The ability to design reporting solutions that are scalable, governed, and aligned with business needs.
- Experience working with large or complex datasets in modern analytics environments.
- Working knowledge of Python for data analysis is preferred.
- Exposure to user enablement, training, or supporting self service BI is an asset.
- Familiarity with cloud and modern data platforms such as Azure Synapse, Databricks, and Microsoft Fabric is an asset.
You are:
- Able to translate business needs into practical data and reporting solutions.
- Able to translate data into clear, practical insights for non technical stakeholders.
- An effective written and verbal communicator.
- Detail oriented and committed to quality, consistency, and governance.
- Able to balance business responsiveness with reporting standards and scalability.
- Comfortable managing multiple priorities in a fast paced environment.
- Self motivated and able to work both independently and collaboratively.
- Curious, proactive, and eager to learn new tools, platforms, and business contexts.
- Committed to enabling users and supporting adoption of self service reporting practices.
What we offer:
- In addition to a highly competitive salary, we offer a great range of benefits, a company pension plan, free parking, exclusive team member offers, and opportunities for development and career progression.
Compensation Details:
- CAD 75,509.00 CAD 94,387.00
- The compensation offered will take into consideration location, education, skills, experience and other factors.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Pattison Food Group
Category Manager, Health and Wellness
Langley, CAN
Pattison Food Group is hiring a Category Manager for Health and Wellness to set strategic direction for the category, focusing on product mix, promotions, and supplier relationships. You will analyze performance, negotia
Data Analyst 1
Langley, CAN
Pattison Food Group is seeking a Data Analyst 1 to join their Data & Analytics team in Langley, BC. The role supports business decision-making through data analysis, reporting, and insight generation, working closely wit
Product Development Manager
Langley, CAN
Pattison Food Group is seeking a Product Development Manager to manage a portfolio of Private Brand products. You will drive sales, marketing, and product development initiatives to increase share and penetration. Ideal