Data Engineer

APGFCU•Edgewood, MD
•$91,600 - $155,600

About The Position

The Data Engineer designs, builds, and maintains the data architecture, pipelines, and integration frameworks that provide reliable, secure, and timely access to enterprise data across cloud-based and on-premises sources. The role creates a foundation for business intelligence, advanced analytics, artificial intelligence, and data-driven decision-making. Working within the Emerging Technologies Group, the Data Engineer partners with technology teams, business stakeholders, data analysts, third-party vendors, and subject matter experts to transform data from disparate operational systems into trusted, accessible, and actionable information. The position uses software engineering and data management skills, with a focus on the Microsoft data ecosystem, and supports operational efficiency, financial oversight, member experiences, and future innovation. The role encompasses data architecture and modeling; development and operation of data pipelines; platform performance, reliability, and support; Microsoft data platform and business intelligence enablement; and data quality, governance, and financial controls. The Data Engineer monitors and improves pipelines and platforms, prepares documented datasets for reporting and analytics, and maintains engineering documentation and operational procedures.

Requirements

  • Bachelor’s degree in computer science, Information Systems, Data Engineering, Software Engineering, or a related technical discipline; equivalent relevant experience may be considered.
  • Seven or more years of experience in data engineering or a related discipline such as data science, data governance, or data analytics.
  • Practical experience with SQL Server, T-SQL, Azure SQL, Azure Data Factory, Azure Synapse Analytics, and/or Microsoft Fabric.
  • Experience building ETL/ELT pipelines, integrating APIs and disparate systems, and working with structured, semi-structured, and unstructured data.
  • Knowledge of relational and dimensional modeling, data warehouses, data lakes, and lakehouses, and preparing governed datasets for Power BI and analytics.
  • Ability to develop production-quality SQL.
  • Strong attention to data integrity, reconciliation, metadata, lineage, privacy, access controls, and financial-services compliance.
  • Strong analytical and troubleshooting skills, ownership of deliverables, and ability to explain technical concepts and trade-offs to technical and nontechnical audiences.
  • Ability to monitor and improve data reliability, performance, resource use, recovery, and operating costs, and to support tested, documented, version-controlled delivery.

Nice To Haves

  • Experience within financial services, banking, fintech, or regulated industries.
  • Familiarity with source control, testing, Azure DevOps, or Terraform.

Responsibilities

  • Build and maintain scalable cloud data platforms, including data lakes, data warehouses, and lakehouse architectures.
  • Develop and maintain data models for operational reporting, financial analysis, enterprise analytics, and self-service business intelligence; apply dimensional, relational, and other appropriate modeling principles.
  • Promote consistent data definitions, structures, transformation logic, and integration standards across data products and platforms.
  • Design data solutions that balance performance, scalability, maintainability, security, and cost; partner with technology leadership on data-estate modernization and engineering priorities.
  • Support a data foundation for future analytics, automation, and AI initiatives.
  • Design, develop, deploy, and maintain data pipelines integrating internal applications, databases, cloud platforms, APIs, and third-party providers.
  • Build and optimize ETL/ELT processes using Microsoft Azure data services, including Azure Data Factory, Azure Synapse Analytics, and Microsoft Fabric, as appropriate.
  • Develop reusable ingestion and transformation frameworks for structured, semi-structured, and unstructured data.
  • Implement full and incremental loading, Change Data Capture, historical data preservation, and other appropriate data movement patterns.
  • Develop batch and, when warranted by business requirements, event-driven and near-real-time data processing capabilities.
  • Integrate data from core financial systems, lending and deposit applications, digital banking platforms, CRM systems, and other enterprise sources.
  • Establish reusable integration patterns, coding standards, and engineering practices that improve maintainability, consistency, and delivery speed.
  • Monitor pipelines, scheduled jobs, integrations, and supporting infrastructure to maintain reliability and meet service-level expectations.
  • Identify and resolve bottlenecks in query performance, pipeline execution, resource utilization, data availability, and processing costs.
  • Develop alerting, logging, retry mechanisms, and failure recovery procedures; troubleshoot production and non-production issues, perform root-cause analysis, and implement corrective and preventive measures.
  • Implement automated testing for data ingestion, transformation logic, data quality rules, and pipeline execution.
  • Participate in production deployments, release management, incident resolution, and platform improvements; maintain operational procedures, support documentation, and recovery processes.
  • Develop and maintain data solutions using the organization's Microsoft technology stack, including Azure SQL, SQL Server, Azure Data Factory, Azure Synapse Analytics, and Microsoft Fabric, as applicable.
  • Write and optimize complex T-SQL queries, stored procedures, and data transformation logic.
  • Prepare curated, documented datasets for Power BI reporting, semantic models, and enterprise analytics.
  • Collaborate with BI developers and business analysts on dimensional models and reusable data structures that support consistent reporting and KPI definitions.
  • Troubleshoot data discrepancies and work with report developers and business stakeholders to identify root causes.
  • Support integration between enterprise data platforms and approved Microsoft analytics, automation, and AI services; identify opportunities to simplify data movement, reduce redundant processing, and improve access to trusted data.
  • Implement automated data validation, cleansing, completeness, accuracy, consistency, and integrity checks throughout the data lifecycle.
  • Develop reconciliation processes to verify data transferred between source systems, pipelines, analytical platforms, and downstream consumers is complete and accurate.
  • Establish interface controls, exception handling, error logging, and monitoring to identify and resolve discrepancies.
  • Support financial data controls, including transaction balancing and general ledger reconciliation, where applicable.
  • Collaborate with business and technology stakeholders to define data quality expectations, ownership, standards, and remediation procedures.
  • Maintain metadata, technical documentation, data lineage, and transformation logic for traceability and auditability; contribute to responsible data governance practices.
  • Work with analysts, BI developers, application teams, business stakeholders, vendors, and technology leadership to clarify needs and deliver solutions.
  • Maintain data models, architecture diagrams, lineage, and operating procedures, and recommend improvements to performance, reliability, and cost efficiency.

Benefits

  • Medical insurance (shared expense)
  • Dental insurance (shared expense)
  • Vision insurance
  • 401(k)
  • Life insurance
  • Disability insurance
  • Flexible spending account
  • Employee assistance program
  • Referral program
  • Educational assistance
  • Holidays
  • Annual leave
  • Sick leave
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service