Enterprise Risk Management Data and Systems Engineer I

Compensation Grade:

11

BASIC PURPOSE:

Design, build, and maintain critical data pipelines that move and transform financial data supporting the QRM Framework, Management Repository, Enterprise Risk Management and the Office of the Chief Executive Officer. Ensure reliable, accurate, and timely data integration across systems by applying advanced technical skills in Python, SQL, and modern ETL tools, delivering the foundation for risk modeling, reporting and analytics.

ESSENTIAL FUNCTIONS:

• Design, develop, and maintain ETL/ELT data pipelines using the QRM Framework, QRM Management Repository (MR), Python, and SQL Server to source data from the Enterprise Data Warehouse into QRM testing and production environments.

• Supports the operational processes required to model and price the Bank’s balance sheet in the QRM.This includes generation and validation of input data, aggregation and storage of output data, model validation and reviews, change control, reporting and other tasks as needed.

• Build and optimize data extraction processes from the QRM Management Repository into SQL databases that serve as sources for Risk reporting.

• Implement automated data workflows and scheduling using a combination of scripting languages and QRM Process Control Panel workflows.

• Collaborate with upstream data providers to troubleshoot data delivery issues, schema changes, and data quality concerns.

• Ensures data integrity and minimizes the potential risk to the Bank.Develop and maintain automated data validation tests and monitoring systems to identify data anomalies, missing values, duplicates, and format inconsistencies. Works closely with other departments including Accounting and Treasury to confirm the correct course of action.

• Perform data analysis and root cause analysis on data quality issues, working with business stakeholders to implement corrective measures.

• Support QRM model promotions, patching, and version upgrades by ensuring data compatibility and performing regression testing on data flows.

• Develops and maintains reporting dashboard for all reporting needs utilizing Python or appropriate tools while complying with End User Computing and Scripting policies.

• Document data flows, pipeline architecture, transformation logic, and metadata in accordance with internal governance and regulatory standards.

• Work closely with other departments to ensure the data needs of ERM are fulfilled.Serves as a liaison between the ERM business unit and IT technical support for the QRM system.

• Supports the production team in their creation of reports for the Enterprise Risk Management (ERM) group, Asset/Liability Committee, Data Governance Committee, the Federal Housing Finance Agency, and compliance requirements.

• Maintains and develops the data infrastructure tools within the ERM department such as QRM Management Repository.

• Institutes best practices in data governance and database management in new and legacy systems.

KNOWLEDGE, SKILLS, ABILITIES: 

Python programming: Advanced proficiency in Python with experience in data processing libraries (Pandas, NumPy, SciPy) and development of production-grade data pipelines.

SQL Expertise: Strong command of SQL for complex querying, data manipulation, stored procedures, and performance optimization across various database systems.

Database systems: Experience with relational databases, including data modeling and performance tuning.

Data Quality Tools: Familiarity with data profiling, validation, and quality assessment technique and tools.

Advanced knowledge of SQL, Python, Microsoft Excel,Word, Power BI, and Oracle.

Experience in QRM modeling, QRM Management Repository architecture, and knowledge of financial systems is preferred.

Experience working with financial data including an understanding of regulatory filings, risk metrics, and market data.

Understanding of data governance principles, lineage tracking and metadata management.

Familiarity with Git, Jira, and Confluence for code, project, and documentation management respectively.

Knowledge of data warehousing concepts, dimensional modeling, and data architecture principles.

Must have strong risk identification and control skills; and familiarity with balance sheets, pricing, financial and capital markets.

Excellent oral and written communication.

MINIMUM REQUIREMENTS:

A minimum of an Undergraduate degree, Master’s preferred, in business, data analytics, computer science, software development, information technology, or related field.At least two years of experience is preferred in data engineering, financial data modeling, financial analysis, or database management, or the equivalent combination of education and experience is necessary.

Work Location: This individual must reside within commuting distance from our Atlanta, GA office. This position may not be filled in New Jersey, either in-person or remotely.

Work Schedule: Onsite with an opportunity to work remote partially.

Visa Sponsorship: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

We are an equal opportunity employer.