Lead Data/ETL Engineer
DecisionPoint Technologies, Inc.2 years ago
Responsibilities
- Lead the design, implementation, maintenance, and optimization of enterprise data integration and ETL pipelines.
- Maintain and optimize SSIS packages, configurations, schedules, dependencies, and execution processes.
- Develop SQL queries, stored procedures, transformations, reconciliation logic, and Python-based ingestion, orchestration, validation, monitoring, and recovery automation.
- Implement API integrations, incremental loading strategies, and approved change-data-capture approaches.
- Build raw, standardized, and curated data layers with documented transformation rules, source-to-target mappings, identifier mappings, and lineage.
- Implement reconciliation, restartable processing, retries, checkpoints, failed-record quarantine, error logging, and controlled reprocessing.
- Monitor and troubleshoot pipeline execution, data quality, APIs, SSIS packages, downstream integrations, performance, freshness, and operational failures.
- Manage schema changes and their effects on pipelines, datasets, analytical models, and reports.
- Maintain technical documentation, version-controlled code, deployment instructions, rollback procedures, and operational runbooks.
- Coordinate with governance, database, application, AI/ML, warehouse, BI, testing, and Government stakeholders.
- Review technical designs and code, guide engineering practices, provide knowledge transfer, and communicate risks, dependencies, corrective actions, and recommendations.
Requirements
- Active Secret clearance or higher is required.
- At least 12 years of relevant professional experience is required.
- Bachelor’s degree in computer science, information systems, or a related field, or a permitted equivalent, is required.
- Experience maintaining and optimizing SQL Server Integration Services (SSIS) and strong SQL skills are required.
- Experience with Python, data engineering automation, API integrations, incremental data loads, data lineage, and complex data-pipeline troubleshooting is required.
- Ability to build raw, standardized, and curated data layers and manage reconciliation, retries, schema changes, identifier mappings, failed-record handling, and change-data capture is required.
- CompTIA Security+ CE or another approved IAT Level II certification is required when applicable to assigned duties.
- Preferred qualifications include data engineering or cloud platform certification and experience with federal or Department of Defense data environments.
- Preferred experience includes modernizing legacy SSIS integrations, transitioning pipelines to approved cloud platforms, enterprise data warehouses, analytical datasets, BI platforms, AI-ready data, data catalogs, metadata management, data governance, automated lineage, data-quality checks, regression testing, deployment automation, secure service accounts, secrets management, encryption, and pipeline audit logging.
- Strong technical mentoring, documentation, troubleshooting, and stakeholder communication skills are preferred.
Benefits
- Remote position; Chicago-area candidates are preferred.
- Applicants acknowledge and consent to having their resumes included in an active competitive government contract bid.
- Applicants authorize DecisionPoint to share submitted resumes and personal information with subsidiaries, affiliates, and teaming partners for consideration for this and comparable positions.
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.