[Remote] Data Engineer III
Note: The job is a remote job and is open to candidates in USA. 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, playing a critical part in delivering exceptional results for this opportunity.
Responsibilities
- 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
Skills
- 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
- 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
Benefits
- 15 days of Paid Time Off + 11 Paid Federal Holidays
- 401K Program (up to 5% 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!
Company Overview