Financial Risk Management Data and Systems Engineer
- Hiring from
- United States
- Work type
- Hybrid
- Posted
623,633 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
Compensation Grade:
11BASIC PURPOSE:
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.
About Us
FHLBank Atlanta is committed to recruiting uniquely talented and innovative individuals who have the vision, skills, background, and desire to succeed in a challenging environment. Whether you're at the beginning of your career or making a career change, the Bank offers a number of rewarding opportunities.
In addition to an excellent work environment, the Bank offers its employees a flexible, highly competitive benefits package. For more information, please download our Summary of Benefits.
