About The Company
Our client is a leading organization within the financial services and banking industry, renowned for its innovative approach to managing complex data initiatives. Committed to excellence and integrity, the company provides a dynamic work environment that fosters professional growth and development. With a focus on leveraging cutting-edge technology and data-driven strategies, the organization aims to deliver exceptional value to its clients and stakeholders. Its commitment to diversity, inclusion, and equal opportunity makes it an employer of choice for professionals seeking impactful careers in the financial sector.
About The Role
The Business Information Management Specialist IV / Data Analyst is a pivotal role within a project-based team supporting sophisticated data initiatives. Located in Toronto, ON, this hybrid role requires working onsite four days a week, with a schedule from Monday to Friday, 9:00 AM to 5:00 PM. The position involves translating complex business requirements into practical data solutions, validating data integrity, and investigating intricate data issues within the financial services environment. The successful candidate will utilize advanced SQL and Python skills to analyze enterprise datasets, support large-scale data projects, and ensure the successful delivery of data initiatives related to Treasury investments, hedging portfolios, and financial products. This role provides an excellent opportunity to collaborate with cross-functional teams, contribute to enterprise data management strategies, and support innovative financial data solutions.
Qualifications
- Minimum of 5+ years of experience in data analysis, data management, or related disciplines
- Extensive experience with advanced SQL for data profiling, reconciliation, validation, and complex investigations
- Proficiency in Python for data analysis and validation tasks
- Solid background in banking or financial services data initiatives
- Deep understanding of banking products and Treasury domains, including investment products and hedging portfolios
- Experience with enterprise data management concepts such as data onboarding, integration, source-to-target mapping, and data quality assurance
- Proven track record in project testing, including test planning, case design, defect management, and regression testing
- Ability to translate business requirements into effective data solutions
- Strong communication skills and stakeholder management abilities
- Excellent attention to detail and organizational skills
Responsibilities
- Facilitate review and clarification of business and data requirements with internal stakeholders to ensure alignment
- Translate business needs into practical, measurable data solutions and outcomes
- Perform advanced data analysis, profiling, reconciliation, validation, and investigation using SQL and Python
- Analyze enterprise datasets across sourcing, onboarding, integration, lineage, and mapping processes
- Validate data transformation rules, mapping, controls, and reconciliation results to ensure accuracy
- Investigate data quality issues, perform root-cause analysis, and collaborate with technology teams to resolve defects
- Support and maintain modern cloud-based data platforms, including Databricks environments, ensuring data integrity and flow
- Develop and execute disciplined testing practices for large-scale data initiatives, including test plans, cases, and validation activities
- Coordinate test execution, manage defect triage, and oversee regression testing processes
- Ensure requirements are properly implemented, tested, validated, and delivered within project timelines
- Collaborate with cross-functional teams to ensure project milestones are met and data solutions are aligned with business objectives
- Identify data and process issues, communicate findings effectively to stakeholders, and recommend improvements
- Support Treasury and financial product data initiatives involving investment and hedging portfolios
Benefits
- Competitive salary package commensurate with experience
- Comprehensive health and dental benefits
- Opportunities for professional development and career advancement
- Flexible work arrangements with a hybrid work model
- Engagement in innovative and impactful financial data projects
- Supportive and collaborative team environment
Equal Opportunity
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status. We are committed to fostering a diverse and inclusive workplace where everyone has the opportunity to succeed.