Job Title: Business Analyst II (Audit/Data Attestation)
Job ID: 5845
Location: Montreal, QC or Mississauga, ON
Job Type: Contract
Pay Rate: $600/day
Work Authorization: You must be eligible to work in Canada without sponsorship.
Positions Available: 1
Required Experience: 7+ years
Principal Duties and Responsibilities:
- Document and evaluate existing data controls.
- Obtain Critical Data Elements and Data Quality requirements from business users.
- Based on data lineage documentation, reach out to control owners (IT and Business) to understand and 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 with the frequency 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 a suitable course of action (tactical and/or strategic remediation).
- Assign appropriate team(s) to handle the remediation activities.
- Follow up with control 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 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 PowerPoint.
- Detail-oriented, organized, and thorough.
- Ability to thrive in a team-based environment.
Industry: Financial Services
Job Category: Data Analysis / Audit