Business Data Analyst (16-Month Contract)

THE OPPORTUNITYWe have an opportunity for a Business Data Analyst to join our award-winning firm in the Vancouver YOULL DOReporting 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 is a 16-month on-site contract opportunity to provide paternal leave coverage offering the chance to make an immediate impact while gaining valuable experience within our Analysis:Gather and document business requirements from stakeholdersAnalyze complex datasets to uncover trends patterns and insights that inform business decisionsWork with our team to translate business requirements into specifications for the data team for creating reports and processesCollaborate 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 strategiesQuality Assurance:Develop and execute detailed quality assurance plans test cases and scriptsImplement automated testing processes where appropriate to ensure actual outcomes match expected outcomesPerform manual and automated testing of our main corporate and data warehouse databases to ensure quality and accuracyPerform manual and automated testing of systems reports and processes to ensure functional and performance standards are metIdentify document and track defects and issues working closely with development teams for resolutionVerify that solutions meet user expectations business requirements and compliance standardsCOMPETENCIESAnalysis Assess quantitative and qualitative data information or situations to understand the most important details identify patterns or meaning and translate it into useful recommendations decisions or actionsAutomation and Scripting Envision create and deploy automated processes to increase efficiency accuracy and consistency in computational tasksCustomer Service Determine needs capture relevant information apply internal policy or regulation and escalate and prioritize the requests of customers to answer inquiries fulfill transactions or resolve issuesData Governance Establish policies practices processes systems and standards to ensure data integrity quality and complianceProcess Improvement and Documentation Uncover understand document optimize and communicate processes to make them more efficient effective and consistentQuality Assurance and Testing Assess audit evaluate and test products applications processes or systems to ensure they meet quality standards and user requirementsRequirements Gathering Discover identify document and validate business needs to inform system or vendor selection solution development and/or project planningKNOWLEDGE AND EXPERIENCEBachelors degree in Computer Science Information Systems Business or a related field3 years of experience in a hybrid Business Analysis/Quality Assurance role or similarStrong 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 requiredExperience with querying normalized and denormalized data modelsExperience with QA tools and methodologies (e.g. JIRA tSQLt)Excellent communication skills with the ability to translate complex data into actionable insightsExperience in a regulated industry or working with compliance frameworksKnowledge of development methodologies (Agile waterfall etc.)Knowledge of Extract-Transform-Load processesFamiliarity with data governance and quality management principlesKnowledge of the Investment industry would be an assetFamiliarity with Dataphile and Azure would be an assetWHAT WE OFFERA 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 values each individuals offer a competitive and equitable total rewards package including mentorship programs and professional development opportunities to support your continued growth. This expected salary range for this role is $70000 - $85000 per year plus eligibility for a performance-based team is growing and we have room for one more exceptional individual. If this opportunity aligns with your experience and career goals we invite you to submit a cover letter and resume by May 4 must be legally eligible to work in Canada. Any employment restrictions must be disclosed at the time of application with supporting documentation provided prior to a potential offer of are committed to fostering an inclusive and accessible workplace where all team members feel valued and supported. If you require accommodation during the recruitment process please email us at appreciate your interest and thank you for taking the time to consider this opportunity. We will contact candidates whose qualifications most closely align with the requirements of role.