Data/ETL Engineer (Senior)
DecisionPoint Technologies, Inc.2 years ago
Responsibilities
- Sustain, troubleshoot, and optimize SSIS packages, configurations, schedules, and dependencies.
- Develop and maintain integrations between source systems, databases, APIs, analytical environments, and reporting platforms.
- Write SQL queries, stored procedures, transformations, reconciliation routines, and Python scripts for ingestion, processing, validation, orchestration, and automation.
- Implement raw, standardized, and curated data layers, incremental loads, checkpoints, tracking, and documented transformation rules.
- Implement API authentication, pagination, retry handling, logging, error processing, duplicate and missing-record controls, and controlled reprocessing.
- Reconcile source and target data using record counts, totals, completeness checks, and business rules.
- Manage schema changes and maintain source-to-target mappings, identifier mappings, metadata, and data lineage.
- Monitor pipeline execution, data freshness, performance, and operational errors, and investigate complex failures.
- Support automated regression testing, data-quality checks, defect resolution, and release validation.
- Maintain version-controlled code, deployment instructions, rollback procedures, operational runbooks, and technical status reporting.
- Coordinate changes with database, application, governance, AI/ML, BI, testing, and Government stakeholder teams.
Requirements
- Active Secret clearance or higher.
- Minimum of eight years of relevant professional experience.
- Bachelor’s degree in computer science, information systems, or a related field, or a permitted equivalent.
- Experience maintaining and supporting SQL Server Integration Services (SSIS).
- Strong SQL and Python skills.
- Experience building or supporting API integrations, implementing incremental data loads, reconciling data, managing schema changes, documenting data lineage, and troubleshooting complex 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.
- Preferred qualifications include relevant data engineering or cloud platform certification, federal or Department of Defense data-environment experience, enterprise data warehouse or BI experience, SSIS modernization or cloud migration experience, data-governance familiarity, automated reconciliation and regression-testing experience, and familiarity with secure service accounts, secrets management, encryption, and audit logging.
- Strong troubleshooting, documentation, communication, and cross-team coordination skills.
Benefits
- Remote position; Chicago-area candidates are preferred.
- Application authorizes DecisionPoint to include and share the applicant’s resume and personal information with subsidiaries, affiliates, and teaming partners for the active competitive government contract bid and comparable opportunities.
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.