Data Engineer III

Andrew Morgan

United States

Remote

USD 145,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

PTO 15 days + 11 holidays
401K with employer matching (up to 4%)
Three healthcare options (employer-pro

Job summary

Andrew Morgan LLC seeks an experienced Data Engineer III to support a potential DoD contract award. You will lead data pipeline development, SSIS package maintenance, and secure data integration with the VA IT budget/finance initiative.

The role involves collaboration with the VA CDW and DCBI teams to extend data sources and ensure reliable data delivery. You will maintain ETL workflows, tune databases, and support Power BI reports with dashboards, data models, and scheduled refreshes.

Qualifications

  • 10+ years in data engineering or related roles.
  • Expertise building and managing data pipelines with SSIS.
  • Strong SQL skills for data engineering and automation.
  • Experience developing, supporting, and troubleshooting Power BI reports and datasets (DAX/M).
  • Background in DoD, federal healthcare, or compliance-driven settings; Tier 1 background check eligibility.

Responsibilities

  • Lead pipeline development, data transformation, and secure data integration.
  • Oversee planning, monitoring, and maintenance of data assets from the DC BI team.
  • Support ETL packages, validation scripts, and migration workflows into Apptio via SSIS.
  • Develop SSIS packages for additional data sources as identified by the customer.
  • Maintain SSIS Job Maintenance Log and update packages as upstream systems change.
  • Coordinate ticket resolution for data assets and data integration environment.
  • Perform tuning and indexing of operational databases; sustain and troubleshoot Power BI reports.
  • Maintain comprehensive Technical Documentation (ICD, DFD, ERD, SOPs, CoE docs).

Skills

SSIS pipelines
SQL
Power BI
Data lineage
Documentation

Tools

SSIS
Power BI service
SQL Server

Job description

Andrew Morgan, LLC is a rapidly growing Service-Disabled Veteran-Owned Small Business (SDVOSB) organization. We are seeking a qualified Data Engineer III to support a potential contract award with DoD Federal Client This role is contingent upon contract award and will play a critical part in our efforts to deliver exceptional results for this opportunity.

RESPONSIBILITIES

The Data Engineer III leads pipeline development, data transformation, and secure data integration activities supporting the VA Office of Information & Technology (OIT) IT Budget and Finance (ITBF). Oversee planning, monitoring, and maintenance of data assets provided by the Data Centralization and Business Intelligence (DCBI) team. Support existing ETL packages, validation scripts, and migration workflows for ingestion into Apptio using Microsoft SQL Server Integration Services (SSIS). Work with data owners and the VA Corporate Data Warehouse (CDW) support team to develop new SSIS packages for additional data sources when identified by the customer. Maintain a SSIS Job Maintenance Log to identify updates and changes to SSIS-based data interfaces and related data staging processes. Update existing SSIS packages based on upstream system changes identified by the SSIS Job Maintenance Log. Manage data staging and data loading into production environments. Coordinate resolution of help desk tickets (Levels 1–3) related to all data assets and aspects of the data integration environment. Perform tuning and indexing of operational databases. Provide sustainment and troubleshooting for Microsoft Power BI reports and scheduled refreshes. Maintain Technical Documentation including Interface Control Document (ICD)s, Data Flow Diagram (DFD)s, Entity Relationship Diagram (ERD)s, Standard Operating Procedure (SOP)s, Center of Excellency (CoE) documentation and training materials.

REQUIREMENTS

10 or more years of experience in data engineering, data integration, or related technical roles. Proven expertise in building and managing data pipelines using SSIS. Skilled in SQL for data engineering and automation. Hands on experience developing, supporting and troubleshooting Power BI reports, semantic models, and scheduled dataset refreshes in the Power BI service including knowledge of DAX and M. Proficient in implementing data lineage tracking and documentation. Experience with legacy, heterogeneous, and distributed data environments. Background in DoD, federal healthcare, or compliance-driven settings. Must be eligible for Tier 1 background investigation.

PREFERED QUALIFICATIONS

Prior experience working with the VA Corporate Data Warehouse (CDW) support team on VA programs that leverage CDW data services and assets. Prior experience working with the VA Power BI Support team to resolve issues in VA’s Power BI Service hosting environment. Prior experience working with the VHA Services Support Service Center to resolve issues with CDW data exposed in SAAS cubes.

SALARY

Base Salary: $145,000 - $180,000 Salary is commensurate with both location and experience.

THE AM EMPLOYEE WILL DISPLAY…

Attention to Detail: Produce high-quality deliverables and outputs that align with contract outcomes. Self-Sufficiency: Execute tasks independently, seeking client assistance only after internal resources are exhausted, ensuring requests align with contract goals. Teamwork: Collaborate effectively with team members, including AMC resources, subcontractors, and government stakeholders. Communication/Engagement: Maintain professional conduct in meetings and written communication, participating actively with cameras on. Responsiveness: Stay engaged, communicate promptly, and ensure deadlines are consistently met.

ABOUT ANDREW MORGAN

Andrew Morgan, LLC, founded in 2017 and headquartered in Alexandria, VA, is a Service-Disabled Veteran Owned Small Business (SDVOSB). We specialize in delivering high-quality consulting services to both federal and commercial clients, offering expertise in Strategy and Management Consulting, Technology & Architecture Services, and Industry & Mission Analytics Solutions. Our distinguished clientele includes the Department of Veterans Affairs (VA), National Aeronautics and Space Administration (NASA), the Department of Defense (DoD), and the United Stated Army Corps of Engineers (USACE). We are committed to providing innovative solutions and exceptional service to support our clients' missions and objectives.

BENEFITS
  • 15 days of Paid Time Off + 11 Paid Federal Holidays
  • 401K Program (up to 4% employer matching)
  • Three Gold Healthcare Options (with 75%-90% employer-paid premiums)
  • Flexible Spending Account / Dependent Care Assistance Program
  • Employer-Paid Short Term Disability Insurance
  • Employer-Paid Long Term Disability Insurance
  • Employer-Paid Life Insurance
  • Professional Training and Development
  • Corporate Team Building Events And MORE!
EQUAL OPPORTUNITY EMPLOYER:

Andrew Morgan Consulting does not discriminate in employment opportunities, terms and conditions of employment, or practices. All qualified applicants will receive consideration for employment without regard to race, age, gender, religious or political beliefs, national origin or heritage, disability, sexual orientation, protected veteran status, or any characteristic protected by law.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

TBM Developer
TBM Developer

Andrew Morgan • United States

Remote
USD 125,000 - 140,000
401K Matching
Health benefits
Paid time off + holidays
+1
AI/Data Scientist
AI/Data Scientist

AIToolboard • Falls Church (VA)

Hybrid
USD 120,000 - 150,000
Paid Time Off
401K Program
Healthcare Options
+3
Senior Data Engineer | SSIS Pipelines & Power BI
Senior Data Engineer | SSIS Pipelines & Power BI

Andrew Morgan • United States

Remote
USD 145,000 - 180,000
PTO 15 days + 11 holidays
401K with employer matching (up to 4%)
Three healthcare options (employer-pro
Senior OneStream Project Manager
Senior OneStream Project Manager

Andrew Morgan • United States

Remote
USD 110,000 - 160,000
Paid time off
Holiday pay
401K matching
+6
Data Migration ETL Engineer
Data Migration ETL Engineer

Intégral • Tysons (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
Flexible Spending Accounts
Disability Insurance (short/long)
+5
Data Migration ETL Engineer
Data Migration ETL Engineer

Integral • Tysons (VA)

Hybrid
USD 130,000 - 140,000
Medical Insurance
Dental Insurance
Vision Insurance
+8
Data Migration ETL Engineer
Data Migration ETL Engineer

Integral Federal, Inc. • Tysons (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
Flexible Spending Accounts
Disability Insurance
+5
Data Migration ETL Engineer
Data Migration ETL Engineer

Integral Federal, Inc. • Tysons (VA)

On-site
USD 130,000 - 140,000
Medical, Dental & Vision Insurance
401(k) Matching
Paid Time Off & Holidays
+3
Senior Data Engineer
Senior Data Engineer

Leidos • United States

Remote
USD 108,000 - 195,000
Competitive compensation
Health and Wellness programs
Income Protection
+1
Data Analyst
Data Analyst

ADP, Inc. • Washington

On-site
USD 80,000 - 95,000
Health benefits
Life Insurance
Disability coverage
+3