Business Data Analyst

Odlum Brown Limited
$70,000 - $85,000 a year
Vancouver, British Columbia
3 weeks ago

WHO WE ARE
Anchored in our purpose to help clients achieve their financial goals, Odlum Brown has remained an independent,
full-service investment firm for over 100 years. Wholly owned by its team members, the firm continues its tradition
of leadership in the financial community as one of BC’s most respected investment firms.

We are honoured to be nationally recognized as one of Canada’s Best Managed Companies and one of Canada’s
Most AdmiredTM Corporate Cultures, and to share the achievement of a century in business with our valued team
members, clients, and communities.

CULTURE AND VALUES
Guided by a set of timeless core values – Clients First, People, Accountability, Independence, Integrity, and
Community – we are very proud of the vibrant, ever-evolving culture that we have built over the years. These values
are the cornerstone of our culture and the principles that provide a compass for our actions and unify us as a team.

PEOPLE
We have skiers, mountain bikers, hockey players, runners, volleyball players, movie buffs, bookworms, animal lovers,
musicians, yogis, world travelers – all with diverse backgrounds and experiences to share from around the globe. You
will work with really interesting people and make great friends, too.

COMMUNITY
We are serious about supporting the communities where we live and work. A recipient of a Canada’s Volunteer
Award from the Government of Canada, we are committed in heart and mind to everything we do in the community,
and we work hard to inspire passion and fun while doing it.

PROFESSIONAL DEVELOPMENT
Continuous learning matters. We are committed to providing career-long support for learning and growth.

THE OPPORTUNITY
We have an opportunity for a Business Data Analyst to join our award-winning firm in the Vancouver office.

WHAT YOU’LL DO
Reporting to the Supervisor, Database Development and Administration, this role will bridge the gap between data-
driven business strategy and quality assurance, ensuring that decisions are informed by robust analytics and that
systems, products, and processes consistently meet the firms’ standards and regulatory requirements. The ideal
candidate will be skilled in both business analysis and quality assurance, using data to drive insights and
improvements, while also designing and executing testing protocols to validate the integrity and performance of
deliverables.

RESPONSIBILITIES
Business Analysis:

  • Gather and document business requirements from stakeholders
  • Analyze complex datasets to uncover trends, patterns, and insights that inform business decisions
  • Work with our team to translate business requirements into specifications for the data team for creating

reports and processes

Suite 1100 – 250 Howe Street | Vancouver, BC V6C 3S9

Main 604 669 1600 | Toll Free 1 888 886 3586 | Fax 604 681 8310

VANCOUVER KELOWNA VICTORIA CHILLIWACK COURTENAY LANGLEY Member-Canadian Investor Protection Fund

ODLUMBROWN.COM

  • Collaborate with product owners, developers, and other stakeholders to align data-driven strategies with
business goals, sourcing information for new reports and processes to drive those strategies


Quality Assurance:

  • Develop and execute detailed quality assurance plans, test cases, and scripts
  • Implement automated testing processes where appropriate to ensure actual outcomes match expected
outcomes
  • Perform manual and automated testing of our main corporate and data warehouse databases to ensure
quality and accuracy
  • Perform manual and automated testing of systems, reports, and processes to ensure functional and
performance standards are met
  • Identify, document, and track defects and issues, working closely with development teams for resolution
  • Verify that solutions meet user expectations, business requirements, and compliance standards


COMPETENCIES

  • Asset ManagementAble to oversee the lifecycle of assets, ensuring optimal value, lifespan, and readiness,
develop and implement strategies to manage and maintain assets efficiently, and balance budgets and align
asset management practices with business needs
  • Coordination Able to coordinate complex activities, aligning people, resources, and timelines to achieve
goals efficiently, manage competing priorities, ensuring clarity, accountability, and timely completion of
tasks, and proactively identify and resolve barriers that impact coordination or goal achievement
  • Customer Service Able to manage diverse and complex customer needs, ensuring accurate, timely, and
policy-compliant resolutions, identify underlying customer concerns and recommend proactive solutions or
improvements, and balance multiple customer priorities, maintaining high levels of satisfaction and efficiency
  • IT Management Able to design and oversee IT strategies that align with business objectives, optimize IT
systems for performance and scalability, and manage complex IT projects involving multiple stakeholders and
systems
  • Knowledge Management Able to develop advanced knowledge management systems to improve efficiency
and learning, integrate diverse knowledge sources into cohesive repositories, and align knowledge sharing
with organizational goals and needs
  • Product Knowledge Able to apply advanced product knowledge to solve client or customer challenges,
provide insights on optimizing product or service for specific needs, and collaborate with teams to improve
or expand product or service offerings based on feedback
  • Troubleshooting and Problem Solving Able to drive troubleshooting and problem-solving strategies for the
firm, mentor others in advanced diagnostic techniques, and establish frameworks for efficient and effective
problem resolution

KNOWLEDGE AND EXPERIENCE
• Bachelor’s degree in Computer Science, Information Systems, Business, or a related field
  • 3+ years of experience in a hybrid Business Analysis/Quality Assurance role or similar
  • Strong analytical and problem-solving skills with proficiency in SQL, Excel, and data visualization tools (e.g.,
Power BI, SQL Server Reporting Services)
  • Ability to write T-SQL queries to perform data analysis and data validation data is required
  • Experience with querying normalized and denormalized data models
  • Experience with QA tools and methodologies (e.g., JIRA, tSQLt)
  • Excellent communication skills with the ability to translate complex data into actionable insights

Suite 1100 – 250 Howe Street | Vancouver, BC V6C 3S9

M ain 604 669 1600 | Toll Free 1 888 886 3586 | Fax 604 681 8310
VANCOUVER KELOWNA VICTORIA CHILLIWACK COURTENAY LANGLEY Member-Canadian Investor Protection Fund

ODLUMBROWN.COM

  • Experience in a regulated industry or working with compliance frameworks
  • Knowledge of development methodologies (Agile, waterfall, etc.)
  • Knowledge of Extract-Transform-Load processes
  • Familiarity with data governance and quality management principles
  • Knowledge of the Investment industry would be an asset
  • Familiarity with Dataphile and Azure would be an asset


WHAT WE OFFER
A culture of openness, collaboration and respect is foundational to our firm. We are a diverse, driven group of
individuals who genuinely care about one another and encourage and appreciate each other’s contributions. We
believe in rewarding team members and do this by providing a competitive total rewards package that is fair and
equitable; mentorship programs; flexible work options; and a variety of professional development opportunities to
expand your career. This role has an expected salary of $70,000 - $85,000/year, plus the potential for bonuses.

Our team is growing, and we’ve got room for one more if you’re interested. If this sounds like the environment you’d
like to work in and you have the credentials and experience for this role, we invite you to submit a cover letter and
resume to careers@odlumbrown.com by June 27, 2025.

Candidates must be legally eligible to work in Canada. Full disclosure of any restrictions must be disclosed at the time
of expressing interest and supporting evidence provided prior to any potential offer of employment.

We appreciate your interest and thank you for taking the time to consider this opportunity. We will be in touch with
individuals whose profiles most closely match what’s needed to be successful in this role.

Apply
Other Job Recommendations:

Data Acquisition Analyst, Data for AI/ML

Autodesk
  • Content characterization of data; gathering key insights...
  • Prototype and measure the quality and effectiveness of new...
1 week ago

Research Data Quality Analyst GEMINI Data Ops

Unity Health Toronto
Toronto, Ontario
$40 - $50 an hour
GEMINI (www.geminimedicine.ca) is a unique big data platform in the Canadian healthcare landscape using advanced methods and...
2 weeks ago

Principal Data Analyst, Data Analytics

Autodesk
Toronto, Ontario
$86,112 - $109,037 a year
  • Work closely with product, engineering, and business teams...
  • Create clear and impactful data visualizations using tools...
3 weeks ago

Business Data Analyst, Retro Admin, North America Life

PartnerRe
Toronto, Ontario
  • Document all TAI processes and procedures put into...
  • Adhere to all IT controls and security established by IT...
3 days ago

Business Data Analyst

E-Solutionts
Toronto, Ontario
$90,000 - $110,000 a year
  • Azure experience/certification
  • 8+ years relevant experience
  • Preference given to candidates who have experience working...
3 weeks ago