Business Analyst (Audit / Data Attestation)
Job Title : Business Analyst (Audit / Data Attestation)
Location : Montreal, QC or Mississauga, ON Hybrid
Exp : 7+ years
No. of positions : 1
Local candidates only
Principal Duties and Responsibilities
Document and evaluate existing data controls
Obtain Critical Data Elements Data Quality requirements from Business Users
Based on Data Lineage documentation, reach out to control owners (IT and Business) to understand & obtain documentation on existing controls
Document existing controls along with evidence for their existence and execution (system procedure / user documents, controls run reports, etc.)
Assess :
- Control design
- Control effectiveness based on the data quality requirements (Is it the right control? is it being run on the frequency which is relevant to the end report? etc.)
Document gaps between existing controls design & effectiveness vs. data quality requirements by the business users
Incorporate gaps into the Bank's Data Quality Issue Management framework
Conduct root cause analysis of identified issues
Understand appropriate team to designate as issue remediation owner
Reach consensus on suitable course of action (tactical and / or strategic remediation)
Assign appropriate team(s) to handle the remediation activities
Follow up with controls owners to obtain remediation plans and track them until required new controls are established and gaps in existing controls are remediated
Track remediation activities to issue resolution, report, and escalate as necessary
Work collaboratively with the Bank's Data Quality Pillar, , Data Stewards, Business Users, IT teams, and Data Owners.
Qualifications
- At least 7+ Years working experience in the U.S. Financial Industry as a business or data analyst
- Strong knowledge of Banking and Investment products
- Ideal : Experience with Data Attestation process, inclusive of evaluating data controls, and / or former Audit experience
- Strong communication skills : Both written and oral with technical and non-technical staff
- Familiarity with issues workflow management tools such as JIRA
- At least 3+ Years working with Databases such as SQL Server & Oracle
- Experience working with a Data management team and monitoring data quality and / or performing data quality issue remediation activities, inclusive of conducting root cause analysis
- Advanced Excel skills, familiarity with Visio and Power Point
- Detail oriented, organized, and thorough
- Ability to thrive in a team-based environment