Business Analyst

Insight Global is seeking a Business Analyst for a Large retail client in North Vancouver BC. This Business analyst will join a newly formed financial squad within their Data and Analytics group. They will be spending 30% of their time on product roadmapping, and 70% of their time supporting the Product Manager on discovery and intakes for new requests from the finance stakeholders.

In addition, the BA will:
Partner with PMs on product discovery: clarify problem statements, assess feasibility, size effort, and shape the MVP for finance analytics products.
Refine requirements: run stakeholder interviews/workshops, translate business needs into clear PRDs, user stories, and acceptance criteria.
Model the data with our architects/engineers: contribute to fact/dimension design and source-to-target mapping; review technical specs for feasibility and completeness.
Hands-on build: create and iterate Power BI datasets/models/reports (DAX, Power Query/M), publish to workspaces
SQL analysis & validation: write queries to profile data, reconcile metrics, and debug issues across sources; document assumptions and edge cases.
Quality & UAT: define test cases and run functional/data validation
Light production support: monitor refreshes during business hours, investigate anomalies, and coordinate fixes with the team.
User engagement: demo increments, gather feedback, write user guidance/how-tos, deliver short training sessions, and collect adoption/usage feedback

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form. The EEOC "Know Your Rights" Poster is available here.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Must-have skills & experience

- 3-5 years of Business Analyst work within a data centric teams
- Ability to perform dimensional modelling such as writing PRDs, user stories, acceptance criteria; running discovery workshops; facilitating UAT.
- Strong Power BI Skills and a proven ability to perform full scale report development DAX, Power Query/M, data modeling, report design, publishing.
- Strong SQL skills for power bi work and for data validation and analysis
- Jira/ Agile skills within backlog management, sprint ceremonies, and incremental delivery
- Strong Excel skills with Power Pivot and complex formulas for quick analysis and stakeholder-ready views.

HIGHLY PREFFERED: Finance domain familiarity (FP&A, revenue, margin, period closes) as context for metrics and workflows.
Retail background
Azure data stack exposure (Databricks, Data Factory)
Basic observability for BI assets (simple data checks, alerting patterns) and performance tuning awareness.

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.