Senior Data Analyst SQL Edit listing

Requirements
- -----------

### Must have:

### - We require a bachelors degree or equivalent experience. - We seek at least 5 years of experience in data analysis or data quality operations. - We need strong knowledge of information access and delivery approaches, analytics applications, and data sourcing and integration methods. - We expect a solid understanding of data warehousing, ETL, data cleansing, and data architecture. - We require advanced proficiency in SQL across common database platforms. - We look for experience with relational databases. - We need the ability to analyze complex SQL statements with confidence. - We value familiarity with data profiling and data analysis best practices. - We seek experience partnering effectively with reporting, operations, and technology teams. - We require strong critical thinking and problem-solving skills. - We expect the ability to work independently with minimal to moderate supervision. - We need excellent interpersonal, verbal, written, and project management skills.

Responsibilities:
- ----------------

- We participate in and lead conversations with business teams to define and document data quality standards. - We write SQL queries from business needs to assess completeness, accuracy, conformity, validity, and timeliness of data. - We use analytical and quantitative techniques to uncover patterns, relationships, and quality issues in large datasets. - We document data quality rules and associated metadata. - We prepare technical specifications for data quality rules developed by offshore teams. - We perform root-cause analysis to identify the source of data defects. - We help drive remediation efforts to resolve data issues. - We build reports and tools to monitor, visualize, and interpret data quality activity using tools such as Tableau, Excel, and SharePoint.
- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Company:
- -------

We are City National Bank, founded in 1954 by entrepreneurs for entrepreneurs, and we continue to build on a legacy of integrity, community, and strong client relationships. We are a subsidiary of Royal Bank of Canada and offer a collaborative, inclusive environment where diversity is valued and supported. This role is based at a designated City National location unless otherwise noted as fully remote. We provide a competitive compensation package with a starting base salary range of $87,000 to $153,000, plus eligibility for bonus and/or commissions, along with comprehensive benefits such as medical, dental, and vision coverage, 401(k) matching, tuition reimbursement, time away benefits, specialized health and family planning support, career mobility assistance, and colleague resource groups.
- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------