Remote or if in the the DE area then they can be hybrid. Can work either PST or EST.**
This position will serve as Subject Matter Expert to validate data, challenge the state of data quality, and continuously drive improvements through better and higher definition data analysis. The Data Governance team's goal is the continuous measurement of data quality, quicken the pace of anomaly detection, and drive data quality improvements at the source resulting in faster cycle times for data remediation.
What you will do
Create pipelines and processes to import large, complex data sets into cloud (snowflake) environment
Develop algorithms to transform, compare and analyze data into useful, actionable insights
Identify, design and implement process improvements for faster repeatable reporting process
Develop and implement data analyses, data collection systems and other strategies that optimize statistical efficiency and quality
Develop checks for staging and loading data
Assist with data-related technical issues
Acquire data from various sources and reload updated data into the databases
Participate in central data cleansing activities to accelerate data quality remediation
Participate in data quality improvement initiatives and projects.
Attend meetings with various data governance groups and Subject Matter Experts (SME) from RBC and Enterprise Risk Management (ERM)
Skilled in communicating on complex topics and solutions and must be open to ideas from others
Ability to build and optimize data sets, big data data pipelines and architectures
Well versed in SQL, and Snowflake environments. Able to create repeatable data load and ETL processes using python scripts
Perform root cause analysis on processes and data
Excellent analytic skills working on unstructured datasets
Ability to build processes that support data transformation, workload management, data structures, dependency & metadata
Excellent interpersonal, verbal, and written communication skills
Must have working knowledge of bank processes and controls
Experience working in a formal risk controls environment with strong understanding of scheduled deliverables
Well versed in a collaborative/ team-focused environment directly communicating with Managers and peers daily
Experience with programming, technology, and tooling such as R, Python, SQL, Snowflake, Azure, Git, Informatica IICS, Tableau, Power BI, Business Objects
Emphasis in Regulatory Reporting experience preferred
Ability to understand the business context and regulatory requirements in order to define data quality functional requirements and standards
OCR experience preferred but not required •
Last updated on Oct 20, 2023