Data Engineer

Federal-Home-Loan-Banks-Office-of-Finance; Reston (VA); On-site; USD 138,000 - 212,000; Full time

Job summary

The Data Engineer at Federal Home Loan Banks Office of Finance will serve as the subject matter expert for data engineering across the organization, leading the lifecycle from raw ingestion to data delivery. You will work with on‑premise and cloud platforms to design, implement, and optimize data pipelines and data products that enable accurate analytics and reporting.

Collaborating with data stakeholders, you will drive data discovery, governance, and quality initiatives, build scalable data

Qualifications

• Bachelor’s degree in a quantitative field and 5–7 years of data engineering experience.
• Experience with ETL/ELT design and data quality controls.

Responsibilities

• Design and implement data ingestion, integration, and transformation solutions across sources.
• Develop data pipelines to cleanse, standardize, validate and enrich data for downstream use.
• Monitor data quality and observability tools to prevent issues before they impact consumers.
• Build dimensional models and semantic layers to support analytics.
• Document data assets, lineage, and ownership in the enterprise data catalog.

Skills

Python

SQL

Bash

Data modeling

ETL/ELT

Communication

Data governance

Observability

Education

Bachelor’s degree in Computer Science or related field

Master’s degree preferred

Tools

Azure Data Factory

Azure Synapse

Databricks

Azure Data Lake Storage

Delta Lake

Spark SQL

Power BI

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Reston, VA, US

5 days ago Requisition ID: 1350

FEDERAL HOME LOAN BANKS OFFICE OF FINANCE

POSITION DESCRIPTION

POSITION: Data Engineer DATE: August 202 6

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.

We’re proud of the way our teammates have a positive impact on everything we do. Our employees are committed to and exemplify our Core Values:

• Integrity through accountability, consistency,transparencyand trust
• Agility through adaptability, continuous improvement,expertise, and flexibility
• Partnership through collaboration, communication, leadership, and teamwork
• Inclusivity through diversity, relationships, respect, and support

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 and directly related experience may be combined to demonstrated subject matter expertise , 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
• 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.

EQUAL EMPLOYMENT OPPORTUNITY:

The Federal Home Loan Banks Office of Finance is committed to equal employment opportunity without regard to race (including traits historically associated with race, such as hair texture, hair type and protective hairstyles), color, religion, sex, pregnancy (including childbirth, lactation, and related medical conditions), national origin or ancestry, ethnic origin, age, physical or mental disability, veteran status, uniformed service member status, military status, sexual orientation, gender identity, status as a parent, marital status, genetic information (including testing and characteristics), citizenship or immigration status, or any other characteristic protected by applicable federal, state, or local law.