Data Engineer III

Andrew Morgan, LLC  is a rapidly growing Service-Disabled Veteran-Owned Small Business (SDVOSB) and HUBZone-certified 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 

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) and a certified HUBZone Small Business. 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!

Join AM Today!

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.