DATA QUALITY ANALYST
WHAT IS THE OPPORTUNITY?
The Data Quality Analyst will be responsible for testing data accuracy and performing data analysis and record keeping in order to improve quality of data on key reports, data sets and databases. The Analyst works with reporting teams, business and IT to identify and document quality rules, requirements and lineage of data for various reports. The Analyst will be responsible for design and execution of necessary tests in diverse development platforms and computing environments including MS SQL, Oracle, Informatica, Excel VBA, and third party application.
Governance, Risk and Controls (GRC)
Be part of City National’s U.S. Governance, Risk and Controls (GRC) Office. This group’s focus is on enhancing our risk management and regulatory compliance capabilities to ensure the bank is well-positioned for future opportunity and sustainable growth.
WHAT WILL YOU DO?
- Participate in and leading discussions with cross-functional teams to identify and document data quality rules for critical reports and data sets.
- Deconstruct complex Excel workbooks and SQL scripts to identify data lineage, transformations and dependencies.
- Profile data manually and also setting up profiling tasks in Informatica or other tools.
- Write SQL queries to test data based on various dimensions (i.e., Completeness, Accuracy, Conformity, Precision, Validity, Uniqueness, Timeliness)
- Draft SQL rules (in Oracle, Informatica or other tools), and create test case.
- Validate existing Data Quality rules to ensure they meet Data Governance requirements.
- Review the transformation specifications written by various work streams to propose additional DQ rules.
- Identify Data Quality issues and escalate issues to the Remediation team.
WHAT DO YOU NEED TO SUCCEED
Must-Have*
- Minimum 3 years of experience with data quality testing;
- Minimum 5 years of experience with data analysis and reporting;
- Minimum 3 years of experience with writing SQL statements
Skills and Knowledge
- Bachelor’s Degree preferably in Information Systems. Master’s Degree in a related field is strongly desired.
- Knowledge of information access and delivery methods, analytics applications and tool portfolio, data sourcing and integration methods. Understanding of data warehouse, ETL, data cleansing, and architecture.
- Ability to write SQL queries independently.
- Knowledge of advanced formulas & pivot tables in excel.
- Ability to understand financial institutions Regulatory initiatives like – Basel II, Basel III, Dodd Frank and CCAR.
- Proficient in MS Office applications; MS Project, MS Visio, MS PowerPoint, MS Excel, MS Access.
- Knowledge of working on Informatica would be an added advantage. Experience in any data quality and reporting tools/applications is highly desired (tools like: Informatica, Collibra, IBM Analytics)
- Ability and knowledge for effectively interacting with data users, managers, and other stakeholders. Experience working and effectively collaborating with reporting, operations and technology teams.
- Strong critical thinking ability and problem resolution skills.
- Ability to work independently with light to moderate supervision in various areas of responsibility
Compensation
Starting base salary: $87,027 – $138,965 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.
*To be considered for this position you must meet at least these basic qualifications
The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.
Benefits and Perks
At City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues. Get an inside look at our Benefits and Perks.
INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT
City National Bank is an equal opportunity employer committed to diversity and inclusion. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or any other basis protected by law.
ABOUT CITY NATIONAL
We start with a basic premise: Business is personal. Since day one we’ve always gone further than the competition to help our clients, colleagues and community flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues to drive phenomenal growth today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies.
Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled