Data/ETL Engineer (Journeyman)
DecisionPoint Technologies, Inc.2 years ago
Responsibilities
- Develop, maintain, and troubleshoot ETL workflows using SSIS and approved integration tools.
- Implement integrations among source systems, APIs, databases, and analytical or reporting environments.
- Write and maintain SQL transformations, queries, and database routines.
- Use Python to automate data processing, validation, integration, and pipeline activities.
- Implement raw, standardized, and curated data layers and maintain source-to-target, field, and identifier mappings.
- Build reconciliation checks for record counts, totals, completeness, and transformation accuracy.
- Support incremental loading, checkpoints, retries, controlled reprocessing, and failed-record handling.
- Implement schema changes, assess downstream impacts, and maintain data lineage, documentation, configuration records, and runbooks.
- Monitor scheduled processing, data freshness, execution results, and pipeline errors; investigate and document failures.
- Maintain version-controlled code and support regression testing, release validation, deployment, and rollback procedures.
- Coordinate with governance, database, BI, AI/ML, and testing teams on data definitions, dependencies, and quality issues.
Requirements
- Active Secret clearance or higher.
- At least 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 and supporting SQL Server Integration Services (SSIS).
- Strong SQL skills, including experience developing SQL transformations.
- Experience with Python, API integrations, data mappings, reconciliation checks, pipeline documentation, and data lineage.
- Ability to support schema management, troubleshoot data pipelines, and implement raw, standardized, and curated data layers.
- CompTIA Security+ CE or another approved IAT Level II certification when applicable to assigned duties.
- Preferred qualifications include a relevant data engineering certification, federal or Department of Defense data-environment experience, and experience with data warehouses, analytical datasets, BI platforms, or AI-ready data.
- Preferred experience includes incremental loads, checkpoints, retries, failed-record handling, metadata management, data governance, automated data-quality and regression checks, version control, deployment automation, secure API authentication, service accounts, secrets management, and audit logging.
Benefits
- Remote position; Chicago-area candidates are preferred.
- The position supports an active competitive government contract bid, and applicants consent to having their resumes included in the bid.
- Applicants authorize DecisionPoint to share submitted resumes and associated personal information with subsidiaries, affiliates, and teaming partners for consideration.
About DecisionPoint Technologies, Inc.
DecisionPoint Technologies, Inc. provides enterprise mobility and edge technology integration for large organizations, combining its IntelliTrack asset and inventory platform with managed services such as device lifecycle management, RFID, and help desk support. The company sells hardware, software, and implementation/support services to enterprises in supply chain, retail, and government. Headquartered in Baltimore, Maryland, it operates across the U.S. and Canada and is privately held.