Data/ETL Engineer (Journeyman)

Qualifications

Required Qualifications

The following must-have qualifications are drawn from the supplied position requirements

• 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.

• 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.

• Relevant data engineering certification.
• Experience supporting federal or Department of Defense data environments.
• Experience with data warehouses, analytical datasets, BI platforms, or AI-ready data.
• Experience implementing incremental loads, checkpoints, retries, and failed-record handling.
• Familiarity with metadata management, data governance, common identifiers, and authoritative sources.
• Experience developing automated data-quality and regression checks.
• Familiarity with version control, CI/CD, deployment automation, and rollback processes.
• Familiarity with secure API authentication, service accounts, secrets management, and audit logging.
• Strong troubleshooting, documentation, communication, and cross-team coordination skills.

• EEO and Affirmative Action Policy: DecisionPoint Corporation is an Equal Employment Opportunity and Affirmative Action employer. It is the policy of DecisionPoint Corporation to provide equal employment opportunity in accordance with all applicable Equal Employment Opportunity/Affirmative Action laws, directives and regulations to all employees and qualified applicants without regard to race, ethnicity, color, religion, national origin, sex, age, disability status, pregnancy, sexual orientation, gender identity, genetic information, protected veteran status, or any other protected status under Federal, State or Local laws.
• Pay Transparency Policy: In accordance with Presidential Executive Order 13665, DecisionPoint Corporation will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
• Authorization to Share Resume and Personal Information: By expressing your interest and submitting your resume for this position, you authorize DecisionPoint Corporation to share your resume, as well as personal information included on the resume, with its subsidiaries, affiliates and teaming partners for the purpose of considering you for this position and other available positions requiring comparable skills, education and experience. Should DecisionPoint Corporation. or its affiliates and teaming partners wish to initiate pre-employment discussions, you will be asked to complete an employment application and related employment documents.