FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Data/ETL Engineer – Journeyman
DecisionPoint Corporation. Develop, maintain, and troubleshoot ETL workflows using SSIS and approved integration tools .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in developing and maintaining ETL workflows, SQL transformations, and data mappings while ensuring data quality and integrity through reconciliation checks and documentation. Proficient in Python for automating data processes and familiar with data governance and metadata management in federal or Department of Defense environments.
Highest-signal resume keywords
ETL Workflow DevelopmentSQL Server Integration Services (SSIS)SQL TransformationsPython AutomationData Lineage Maintenance
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
ETL Workflow DevelopmentSQL TransformationsData MappingsReconciliation ChecksSchema ManagementIncremental LoadsData Quality ChecksAPI IntegrationsData GovernanceMetadata Management
Soft Skills
TroubleshootingDocumentationCommunicationCross-Team Coordination
Tools & Technologies
SSISSQL ServerPythonCI/CDVersion Control
Certifications & Qualifications
Active Secret ClearanceCompTIA Security+ CEData Engineering Certification
Industry Keywords
Federal Data EnvironmentsDepartment of DefenseData WarehousesAnalytical DatasetsBI Platforms
Tech Stack
Tools & technologiesETLPythonSQLSSIS
About the role
Key responsibilities & impact- Develop, maintain, and troubleshoot ETL workflows using SSIS and approved integration tools
- Implement approved integrations between source systems, APIs, databases, and analytical or reporting environments
- Write and maintain SQL transformations, queries, and supporting database routines
- Use Python to automate data processing, validation, integration, and routine pipeline activities
- Implement raw, standardized, and curated data layers using approved designs and transformation rules
- Develop and maintain source-to-target mappings, field mappings, and identifier mappings
- Build reconciliation checks to verify record counts, totals, completeness, and transformation accuracy
- Support incremental loading, processing checkpoints, retries, and controlled reprocessing
- Implement approved schema changes and identify effects on dependent workflows and datasets
- Maintain data lineage, pipeline documentation, configuration records, and operating instructions
- Monitor scheduled processing, execution results, data freshness, and pipeline errors
- Investigate failures involving source data, SQL logic, SSIS packages, APIs, and downstream dependencies
- Document troubleshooting findings and escalate complex issues to senior engineers
- Correct assigned defects and support regression testing, reconciliation, and release validation
- Maintain version-controlled code and support approved deployment and rollback procedures
- Coordinate with governance, database, BI, AI/ML, and testing teams on data definitions, dependencies, and quality issues
- Update runbooks and technical documentation following pipeline changes and operational findings
Requirements
What you’ll need- Active Secret clearance or higher
- Minimum of six years of relevant professional experience
- Bachelor’s degree in computer science, information systems, or a related field, or a permitted equivalent
- Experience developing and maintaining ETL workflows
- Experience supporting SQL Server Integration Services (SSIS)
- Strong SQL skills, including experience developing SQL transformations
- Experience with Python and API integrations
- Experience developing and maintaining data mappings
- Experience building and executing reconciliation checks
- Experience maintaining pipeline documentation and data lineage
- Ability to support schema management and troubleshoot data pipelines
- Ability to implement raw, standardized, and curated data layers
- CompTIA Security+ CE or another approved IAT Level II certification when applicable to assigned duties
- Relevant data engineering certification is preferred
- Experience supporting federal or Department of Defense data environments is preferred
- Experience with data warehouses, analytical datasets, BI platforms, or AI-ready data is preferred
- Experience implementing incremental loads, checkpoints, retries, and failed-record handling is preferred
- Familiarity with metadata management, data governance, common identifiers, and authoritative sources is preferred
- Experience developing automated data-quality and regression checks is preferred
- Familiarity with version control, CI/CD, deployment automation, and rollback processes is preferred
- Familiarity with secure API authentication, service accounts, secrets management, and audit logging is preferred
- Strong troubleshooting, documentation, communication, and cross-team coordination skills are preferred
Benefits
Comp & perks- Regular full-time employment
- Opportunity to work remotely
- Chicago-area candidates preferred
- Opportunity to support a USMEPCOM ENLIST government contract program
- Equal Employment Opportunity and Affirmative Action protections