Data Engineer

Where Banking Feels Like Belonging

At APGFCU, our values are at the heart of everything we do, empowering us as leaders in the credit union movement. We prioritize purpose and connection in how we serve our members, co-workers and communities - helping to navigate life's little and big moments.

Who we are:

As a member-owned, not-for-profit credit union, APG Federal Credit Union (APGFCU®) empowers our members with financial products and services to support them at every stage of their financial lives, helping them become money smart and financially independent. We proudly serve people in:

• Harford County

• Cecil County

• Baltimore County

• Baltimore City

We believe banking should feel personal, supportive, and human. That goes for our members and our employees. Here, you’re not just filling a role — you’re making a difference in your community.

Our team lifts each other up and our leaders invest in your growth. We celebrate wins, recognize and value contributions, and support each other through challenges. We strive for meaningful connections across our teams, because that’s what belonging is all about.

Let’s build something meaningful together.

Role Summary:

The Data Engineer is responsible for designing, building, and maintaining the data architecture, pipelines, and integration frameworks which enable reliable, secure, and timely access to enterprise data across cloud-based and on-premises data sources. This role establishes the foundation for business intelligence, advanced analytics, artificial intelligence, and data-driven decision-making across the organization.

Working within the Emerging Technologies Group, the Data Engineer partners with technology teams, business stakeholders, data analysts, third-party vendors, and other subject matter experts to transform data from disparate operational systems into trusted, accessible, and actionable information.

The ideal candidate combines strong software engineering and data management skills with practical experience in the Microsoft data ecosystem. Success in this role requires an ownership mindset, attention to data integrity, and an understanding of how well-engineered data platforms enable improved operational efficiency, financial oversight, member experiences, and future innovation.

Key Responsibilities:

Data Architecture, Storage, and Modeling (25%):

• Build and maintain scalable cloud data platforms, including data lakes, data warehouses, and lakehouse architectures.
• Develop and maintain data models that support operational reporting, financial analysis, enterprise analytics, and self-service business intelligence.
• Apply dimensional modeling, relational modeling, and other appropriate data design principles to meet business and analytical requirements.
• 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 to identify opportunities to modernize the data estate and align engineering investments with business priorities.
• Support the development of a well-structured data foundation that can accommodate future analytics, automation, and AI initiatives.

Data Engineering and Pipeline Development (25%):

• Design, develop, deploy, and maintain reliable, scalable data pipelines that integrate data from 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 to the organization's architecture.
• Develop reusable data ingestion and transformation frameworks for structured, semi-structured, and unstructured data.
• Implement full and incremental data loading, Change Data Capture (CDC), historical data preservation, and other appropriate data movement patterns.
• Develop batch and where business requirements warrant, 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.
  

Performance, Reliability, and Operational Support (20%):

• Monitor data pipelines, scheduled jobs, integrations, and supporting infrastructure to maintain reliability and meet established service-level expectations.
• Identify and resolve bottlenecks affecting query performance, pipeline execution, resource utilization, data availability, and processing costs.
• Develop alerting, logging, retry mechanisms, and failure recovery procedures to improve operational resilience.
• 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 ongoing platform improvements.
• Maintain appropriate operational procedures, support documentation, and recovery processes.

Microsoft Data Platform and Business Intelligence Enablement (15%):

• 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, well-documented datasets for Power BI reporting, semantic models, and enterprise analytics.
• Collaborate with BI developers and business analysts to implement 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.
• Evaluate opportunities to simplify data movement, reduce redundant processing, and improve the usability of trusted data.

Data Quality, Governance, and Financial Controls (15%):

• Implement automated data validation, cleansing, completeness, accuracy, consistency, and integrity checks throughout the data lifecycle.
• Develop reconciliation processes to verify that data transferred between source systems, integration pipelines, analytical platforms, and downstream consumers is complete and accurate.
• Establish appropriate 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 to the organization's business processes.
• Collaborate with business and technology stakeholders to define data quality expectations, ownership, standards, and remediation procedures.
• Maintain appropriate metadata, technical documentation, data lineage, and transformation logic to support traceability and auditability.
• Contribute to data governance practices that promote trusted, consistent, and responsibly managed enterprise data.

Physical Demands: Most of your time will be spent working at a computer, collaborating in meetings, and connecting with colleagues and stakeholders. Occasionally, you may attend events, move between workspaces or travel for business. We’re committed to providing reasonable accommodation to support employees in performing the essential responsibilities of the role.

A Typical Day in the Role:

• Build and Maintain Pipelines: Develop and improve data ingestion, transformation, and integration processes across enterprise sources.
• Model and Prepare Data: Create reliable data structures and curated datasets for reporting, analytics, and approved AI initiatives
• Validate and Reconcile Data: Investigate data quality issues, implement controls, and verify that information is complete and accurate.
• Monitor Platform Health: Review pipeline runs, scheduled jobs, query performance, alerts, and resource utilization; resolve issues and identify root causes.
• Partner Across Teams: Work with analysts, BI developers, application teams, business stakeholders, vendors, and technology leadership to clarify needs and deliver solutions.
• Improve and Document: Maintain data models, architecture diagrams, lineage, operating procedures, and recommendations for better performance, reliability, and cost efficiency.

Qualifications:

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 and related discipline such as data science, data governance, or data analytics.

• Experience: 7+ years of experience in data engineering or related discipline. Experience within financial services, banking, fintech, or regulated industries is preferred.
• Microsoft Data Technologies: Practical experience with SQL Server, T-SQL, Azure SQL, Azure Data Factory, Azure Synapse Analytics, and/or Microsoft Fabric.
• Data Engineering: Experience building ETL/ELT pipelines, integrating APIs and disparate systems, and working with structured, semi-structured, and unstructured data.
• Data Modeling and BI: Knowledge of relational and dimensional modeling, data warehouses, datalakes, lakehouses, and preparing governed datasets for Power BI and analytics.
• Programming and Delivery: Ability to develop production-quality SQL; familiarity with source control, testing, Azure DevOps, or Terraform.
• Quality, Security, and Controls: Strong attention to data integrity, reconciliation, metadata, lineage, privacy, access controls, and financial-services compliance.
• Problem Solving and Communication: Strong analytical and troubleshooting skills, ownership of deliverables, and ability to explain technical concepts and trade-offs to technical and nontechnical audiences.
• What Success Looks Like:
• Reliable, Timely Data: Pipelines and integrations deliver trusted data within established service-level expectations.
• Improved Data Quality: Automated validation and reconciliation reduce discrepancies and improve completeness, accuracy, and consistency.
• Useful Analytics Foundations: Well-modeled, documented datasets enable consistent Power BI reporting, semantic models, KPIs, and enterprise analytics.
• Secure and Auditable Operations: Data access, movement, and transformation follow security requirements and support traceability, audits, and financial controls.
• Stable and Efficient Platforms: Query performance, pipeline execution, resource use, recovery, and operating costs are continually monitored and improved.
• Predictable Delivery: Engineering work is tested, documented, version-controlled, and deployed through approved practices.
• Strong Partnerships and Ownership: Stakeholders understand progress, risks, and trade-offs; initiatives are owned through implementation and production support.

How You Show Up: Core Competencies

• Organizational Competencies: Agility, Learning and Innovation: Being able to handle change, learn quickly, and adjust how you work as things evolve. It also means sharing ideas that help the organization grow.
• Collaboration and Teaming: Working well with others to reach shared goals, strengthening partnerships across departments, and creating meaningful experiences for members and teammates.
• Emotional Intelligence: Understanding your own emotions and the emotions of others so interactions stay productive and relationships stay strong. It’s balancing logic and feeling to navigate challenges and support a healthy workplace.
• Listening and Communication: Communicating clearly, respectfully, and openly. Showing empathy, being present, and keeping your words and actions aligned.
• Trusting Relationships: Building genuine, respectful, and supportive connections that strengthen teamwork, create psychological safety, and lead to meaningful experiences for members and coworkers.

Compensation: $91,600 to $155,600 annually

Offers are based on experience and education.

APGFCU provides comprehensive benefits such as medical and dental (shared expense), vision, 401(k), life and disability insurance, flexible spending account, employee assistance program, referral program, educational assistance, holidays, annual leave and sick leave.

Equal Opportunity Employer

APGFCU is proud to be an Equal Opportunity and Affirmative Action employer. We are committed to creating a workplace where everyone feels welcome and supported. Employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, or any other protected status under applicable federal, state, or local law. If an accommodation is needed during the hiring process, please email [email protected].

Employment with APGFCU is at-will, meaning that either you or APGFCU may terminate the employment relationship at any time, with or without cause or notice.

APGFCU participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. You can view the details by clicking here or returning to the careers homepage.

APGFCU participa en E-Verify y proporcionará al gobierno federal la información de su Formulario I-9 para confirmar que usted está autorizado para trabajar en los EE.UU.. Puede ver los detalles haciendo clic aquí o regresando a la página de inicio de carreras profesionales.