POSITION DESCRIPTION

POSITION: Data Engineer DATE: August 2026

DEPARTMENT: Information Technology FLSA: Exempt

REPORTS TO: Senior Manager, Data & Platform Engineering

SUMMARY OF POSITION

The Data Engineer will serve as the Office of Finance's subject matter expert on a multitude of data engineering methods, data integration and data management technologies. This is a highly technical role responsible for leading the data engineering lifecycle across the organization's data planes - from raw data ingestion through data cleansing, data standardization, data transformation, data modeling, and data delivery. The scope of the role spans data integration with on-premises source systems through cloud-based data processing, data storing, and works in tandem with other teams who support data serving and data delivery layers.

The Data Engineer works collaboratively across internal data stakeholders and data consumers to identify, prove and implement opportunities to improve data discovery, data collection, data transformation, data standardization, data storage, and data quality. The Data Engineer assists data stakeholders in maintaining an enterprise view of the organization's data assets, and works with Product Owners/Leaders to consider opportunities to enhance both the organization and the FHLBanks System at large via compelling data products.

PRINCIPAL RESPONSIBILITIES

• Design and implement data ingestion, integration, and transformation solutions thatconsolidateenterprise data from multiple sources.
• Develop and implement data pipelines to cleanse, standardize,validateand enrich data to ensure data accuracy, consistency, and fitness for downstream use.
• Apply data profiling and statistical analysis techniques to characterize data distributions,identifyanomalies, detect structural problems, and support overall data quality.
• Implement and automate data quality controls andmonitoringtoidentify, prevent, and remediate data issues throughout the data lifecycle.
• Build dimensional models, fact tables, and semantic layers that support downstream analytics and reusability of business data.
• Assistdata stakeholders in documenting data assets including lineage, data dictionaries, and ownership through the enterprise data catalog.
• Monitor ETL/ELT data pipeline health and data quality metrics through observability and quality tools, taking proactive steps to address data quality issues before theyimpactdownstream consumers.
• Participate in on-call rotation as needed for support of data products and pipelines.
• Assistwith other job duties as assigned.

PRINCIPAL REQUIREMENTS

• Bachelor's degree inComputer Science,Statistics, Mathematics, Finance, Financial Engineering, Quantitative Finance, Information Science, Data Engineering, or a related quantitative field. Master's degree or above preferred.A combination of advanced education anddirectly relatedexperience may be combinedtodemonstratedsubject matterexpertise, provided education is a graduate or terminal degree.
• Subject matterexpertisein the following areas:

• At least 5-7 years of data engineering experience withdemonstratedownership of Production data pipelines.
• At least 5-7 yearsdemonstratedexperience in applied exploratory data analysis, descriptive statistical analysis, and inferential statistical analysis in the development and delivery of enterprise data products and data visualizations.
• At least 3-5 years of hands-on experience with ETL/ELT including job design, dataflow optimization, and integration.
• At least 3-5 years of experience with industry leading analytical data platforms, (e.g., Azure Data Factory, Synapse, Databricks, Azure Data Lake Storage, Delta Lake, Spark SQL, and Unity Catalog, or other comparable Azure cloud data services.)
• Prior experience in financial services, capital markets, or government sponsored entities strongly preferred.

• Technical skills:

• Programming/Scripting: Python (pandas,PySpark, SQL Alchemy or other similar data engineering scripting tooling), SQL (proficient), Bash (optional)
• Data Integration: Azure Data Factory, Azure SynapsePipelinesor other comparable tooling
• Storage: Azure Data Lake Storage or comparable, PostgreSQL (Familiar), SAP ASE (Optional)
• Analytics Engineering: Azure Synapse Analytics, Delta Live Tables, Apache Spark, or other comparable tooling
• BI/Reporting: Power BI (proficient), SAP BusinessObjects (optional)
• DevOps: GitHub Enterprise, CI/CD pipelines
• Data Governance: Microsoft Purview or comparable, Data lineage, cataloging, access control
• Observability: Datadog, Grafana, Prometheus, or comparable tooling

• Ability to develop and refine an evolving understanding of business requirements and needs.
• Ability to rapidly iterate upon ideas as on-going mechanism to progressivelyvalidatebusiness value and seek clarity in desired business outcomes.
• Ability to communicate well, both orally and in writing, including producing thorough documentation of all work.
• Ability to conduct independent technical research and share results with management and/or peers.
• Ability to listen and integrate ideas from different views, build andmaintainrespectful relationships, collaborate with others, and resolve conflicts constructively.
• Proof of eligibility to work in the United States.

This position has an annualized salary range of $138,375 - $212,218. The final salary offered within this range is dependent on various factors, including but not limited to the responsibilities of the position, the experience, skill set and other relevant qualifications of the applicant and internal pay equity.