Regulatory Reporting Data

Responsibilities

● Develop, maintain, and enhance Nexus workflows to support regulatory reporting automation. Monitor deployment and troubleshoot issues. Also, perform Nexus system administration.

● Collaborate with stakeholders/report owners to gather regulatory reporting requirements.

● Perform data mapping based on requirements, and create or enhance data models within the gold.reg_reporting schema in Snowflake.

● Assist in manual report generation and regulatory reporting-related data sharing requests.

● Ensure timely generation and submission of regulatory reports, including monthly CCRIS LASS report submissions.

● Perform data quality investigations whenever needed for the gold.reg_reporting model and enhance the model if required.

● Perform administrative or ad hoc tasks related to regulatory reporting as requested.

Requirements

● Proven experience in data analysis and report building.

● Strong analytical skills and attention to detail with SQL understanding.

● Good knowledge in Advanced SQL and Data warehousing concepts.

● Excellent problem-solving skills and ability to perform ad hoc tasks effectively.

● Experience in interpreting and implementing regulatory guidelines.

● Solid understanding of dimensional modeling (Star/Snowflake schemas) and

other data warehousing concepts relevant to regulatory reporting.

● Ability to translate regulatory requirements into effective data models within Snowflake.

● Experience in designing and implementing data pipelines that source data from various systems and load it into Snowflake.

● Ability to write efficient and scalable SQL queries to extract, transform, and load data for regulatory reports.

● Experience in data profiling and data quality analysis using SQL.

● Proficiency in using Git for version control of code (SQL, Python for Airflow).

● Knowledge of CI/CD pipelines for data deployments.

● Ability to adapt to evolving regulatory requirements and learn new technologies quickly