Business Data Analyst

Odlum Brown Limited; Vancouver; On-site; CAD 70,000 - 85,000; Full time

Job summary

Odlum Brown Limited is seeking a Business Data Analyst for its Vancouver office. This role involves bridging data-driven business strategy with quality assurance, utilizing strong analytical skills and ensuring compliance with regulatory standards. The ideal candidate will engage in both business analysis and quality assurance activities, ensuring high-quality deliverables that meet business goals.

Benefits

Competitive total rewards package

Professional development opportunities

Flexible work options

Mentorship programs

Qualifications

• 3+ years of experience in a hybrid Business Analysis/Quality Assurance role or similar.
• Ability to write T-SQL queries.
• Experience in a regulated industry.

Responsibilities

• Gather and document business requirements from stakeholders.
• Develop and execute quality assurance plans.
• Analyze complex datasets for insights.

Skills

Analytical skills

Problem-solving

Communication

Data visualization

Education

Bachelor’s degree in Computer Science, Information Systems, Business

Tools

SQL

Excel

Power BI

JIRA

Job description

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
• 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 Management – Able 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
• 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 [e-mail] 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.