Hiring.Camp

Financial Risk Management Data and Systems Engineer

Fhlbatl

·

Yesterday

Location
Atlanta Office, United States of America
Workplace
Hybrid
Type
Full-time
Department
Engineering
Seniority
Mid
Education
Bachelor
Visa
Not sponsored
Source
Workday

Description

Compensation Grade:

11

BASIC PURPOSE:
 

Designs, builds, and maintains critical data pipelines that move and transform financial data supporting the QRM Framework, QRM Management Repository, Financial Risk Management (FRM), and the Quantitative Modeling and Analytics department. Implements automated data workflows, database extraction routines, and automated validation tests to ensure reliable, accurate, and timely data integration across systems, delivering the foundational data required for risk modeling, balance sheet analytics, and regulatory reporting.

ESSENTIAL FUNCTIONS:

  • Designs, develops, and maintains ETL/ELT data pipelines using the QRM Framework, QRM Management Repository (MR), Python, and SQL Server to extract, transform, and load source data from the Enterprise Data Warehouse and core systems into QRM testing and production environments.
  • Executes automated data validation tests and reconciliation routines across model inputs and outputs, identifying data anomalies, schema mismatches, duplicate records, and format inconsistencies, and tracking issues through resolution under established data quality standards.
  • Builds, tunes, and optimizes data extraction processes from the QRM Management Repository into SQL database staging layers that serve as the single source for FRM and risk reporting dashboards.
  • Implements and monitors automated batch data workflows, schedules, and process sequences utilizing Python scripts, SQL Server Agent, and QRM Process Control Panel.
  • Supports the monthly, daily, and ad-hoc production run cycles, executing scheduled data flows and pipeline runs to ensure the timely generation of risk and balance sheet analytics.
  • Executes data regression testing scripts and validates data flow compatibility in support of QRM model promotions, patching, software version upgrades, and model change implementations.
  • Collaborates with upstream data providers and IT data teams to troubleshoot data delivery exceptions, investigate feed delays, and document schema modifications.
  • Develops and maintains dynamic risk reporting dashboards and automated data delivery tools utilizing Python, SQL, and Power BI while adhering to End User Computing and scripting governance policies.
  • Maintains technical documentation of data pipelines, source-to-target mappings, ETL workflows, transformation logic, and data dictionaries in accordance with internal governance, model risk, and audit standards.
  • Provides operational and technical support for departmental data infrastructure and database repositories, troubleshooting pipeline errors and escalating critical production incidents to the Senior Engineer and Director.

KNOWLEDGE, SKILLS, ABILITIES: 

  • Strong proficiency in Python, including standard data processing libraries (Pandas, NumPy) and the development of maintainable, production-ready data pipelines.
  • Solid command of SQL for complex querying, view creation, stored procedures, data transformation, and performance optimization across relational database systems (SQL Server, Oracle).
  • Familiarity with ETL/ELT architecture, data warehousing concepts, dimensional modeling, and relational database schema design.
  • Hands-on experience with data quality principles, automated validation checks, reconciliation techniques, and anomaly detection.
  • Familiarity with financial data structures, balance-sheet instruments, and asset/liability management concepts, with exposure to QRM modeling or QRM Management Repository architecture preferred.
  • Practical experience utilizing Git for version control, code collaboration, and pull-request workflows, along with familiarity with Jira for task management and Confluence for technical documentation.
  • Proficiency with Microsoft Office suite (advanced Excel) and Power BI for data analysis and visualization.
  • Demonstrated problem-solving capabilities, attention to detail, and sound risk and data control awareness.
  • Strong interpersonal, verbal, and written communication skills with the ability to collaborate effectively across technical and analytical teams.

MINIMUM REQUIREMENTS:

  • An undergraduate degree in business, data analytics, computer science, software engineering, information systems, or related quantitative field. Master's degree preferred.
  • A minimum of two years of professional experience in data engineering, financial data modeling, database development, or financial systems operations, or the equivalent combination of education and experience.
  • Demonstrated hands-on experience building, executing, and troubleshooting automated data pipelines, ETL workflows, and validation tests within a production database environment.
  • Experience with financial risk management, balance sheet analytics, or Asset/Liability Management (ALM) systems (e.g., QRM), along with familiarity with financial institution regulatory requirements, Model Risk Management (MRM) practices, and End User Computing (EUC) controls preferred.

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.

Skills

PythonSQLOracleSQL ServerPandasNumPyData EngineeringETLGitJiraConfluenceExcelPower BIRisk Management

Similar Jobs

30

Financial Risk Management - Senior Manager

Pwc·Boston, Massachusetts +4

5d ago

Internship 2027 for PET Financial Risk Management, PETRONAS Group Risk Management, Petroliam Nasional Berhad (PETRONAS), PETRONAS Holding Company, (Bachelor's in Finance/Accounting)

PETRONAS·Malaysia

6d ago

Manager, Internal Controls and Risk Management – Financial Services (Bilingual FR/EN)

Pwc·Montréal, Quebec

1w ago

Senior Associate, Internal Controls and Risk Management – Financial Services (Bilingual FR/EN)

Pwc·Montréal, Quebec

1w ago

Senior Financial Risk Specialist – Financial Risk Management (w/m/d)

Ing·Berlin, State of Berlin·Hybrid

1w ago

Internship: Group Risk Management, Group Non-Financial Risk Management, ORM Central Programme & Systems Management [Dec26 to May27]

Ocbc·Singapore·Hybrid

1w ago

Director, Global Financial Risk Management

Transamerica·Baltimore, Maryland +1·Hybrid

3w ago

Senior Manager, Financial Risk Management

Foresters Financial·Toronto, Ontario·Hybrid

3w ago

Director, Global Financial Risk Management

Transamerica·Baltimore, Maryland +1·Hybrid

3w ago

Financial Risk Management - Risk Data Transformation Senior Associate

Pwc·Boston, Massachusetts +4

3w ago

Financial Risk Management - Risk Data Transformation Senior Manager

Pwc·Boston, Massachusetts +4

3w ago

Financial Risk Management - Risk Data Transformation Senior Manager

Pwc·Boston, Massachusetts +4

3w ago

SVP, Head of Non-Financial Risk Management, Global Delivery and Investment Services

Statestreet·London, England

3w ago

Financial Risk Management - Risk Data Transformation Director

Pwc·Boston, Massachusetts +4

3w ago

Financial Risk Management - Risk Data Transformation Director

Pwc·Boston, Massachusetts +4

3w ago

Risk Manager, Non-Financial Risk Management

Open Positions·UK - 135 Bishopsgate - London, UK·Hybrid

3w ago

Risk Associate, Non-Financial Risk Management

Open Positions·UK - City Quays 3 - Belfast, UK·Hybrid

4w ago

Head of Non-Financial Risk Management, Markets & Corporate Functions (SVP)

Statestreet·Boston, Massachusetts

4w ago

Vice President, Non-Financial Risk Management (NFRM), GCIB APAC

Mufgub·Singapore Office Marina One

1mo ago

Analyst Financial Risk Management - Actuarial

Deloitte Netherlands·Amsterdam, North Holland

1mo ago

Internship: Group Risk Management, Group Non-Financial Risk Management, Group Operational Risk Management (Implementation) [Jan to May 2027]

Ocbc·Singapore·Hybrid

1mo ago

Senior Manager - Financial Risk Management

Pwc·Kuala Lumpur, Malaysia

2mo ago

AVP, Non-financial Risk Management

Mufgub·Canada

2mo ago

Internship: Group Risk Management, Group Non-Financial Risk Management, Group Operational Risk Management [Jan to May 2027]

Ocbc·Singapore·Hybrid

2mo ago

Officer, Insurance Risk & Financial Management

Prudential·PHKL, One Island East 59

2mo ago

Specialist, Non-Financial Risk Management

NT Careers·Chicago, Illinois·Hybrid

2mo ago

Financial Risk Management Consultant

Pwc·Bangkok, Thailand

2mo ago

Experienced Associate - Financial Risk Management

Pwc·Kuala Lumpur, Malaysia

3mo ago

Valuation Manager – Treasury & Financial Risk Management (m/f)

Pwc·Bratislava, Bratislava Region

3mo ago

Enterprise Risk Management (Financial Risk) Audit, Officer

Statestreet·Mumbai, Maharashtra·Remote, Hybrid

3mo ago