DeveloperJobs.io
← Back to all jobs
PiTech Solutions

Data Engineer

PiTech Solutions
Huntsville, AL Full time Posted 5d ago
Data Data Analysis Data Analytics Data Architecture Data Engineer Data Integration Data Pipeline Data Platform Data Processing Data Warehouse Database Databases Engineer ETL Informatica Integration SQL
Apply Now

Job Description

PiTech Solutions is seeking a Data Engineer to design, build, and maintain data infrastructure with a focus on migrating from a legacy system to a modernized platform. This onsite role in Huntsville, AL includes leading ETL development, supporting data governance practices, and participating in Agile execution.

Role Responsibilities

  • Design and implement ETL pipelines using SQL Server Integration Services (SSIS) to migrate legacy data into the modernized system while maintaining 100% source-to-target traceability.
  • Define and document data mappings, transformation rules, and validation logic for all migrated data elements.
  • Partner with Subject Matter Experts (SMEs) to validate mappings before implementation, targeting at least 90% SME sign-off.
  • Build and maintain a Data Dictionary and Entity Relationship Diagrams, updating them each sprint.
  • Optimize Microsoft SQL Server database schemas, queries, and indexes to meet performance targets, including search queries (≤ 2 seconds) and record retrieval (≤ 1 second).
  • Design and adapt data interfaces, including Spartan and EODIMS integrations, aligned to the modernization lexicon and schema.
  • Ensure database and integration work follows Data Governance Manual v4.2 and relevant API standards and best practices.
  • Monitor and validate ETL execution results and document row counts, successes, and failures each sprint.
  • Support CI/CD by implementing data-layer test automation, and ensure ETL activities are linked to user stories in Digital.ai.
  • Participate in Agile SCRUM ceremonies including sprint planning, standups, reviews, and retrospectives.

Required Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or a related field; equivalent experience accepted.
  • 3+ years of experience designing and implementing ETL pipelines using SSIS or comparable tools.
  • Proficiency in Microsoft SQL Server, including schema design, query optimization, and index tuning.
  • Demonstrated experience with source-to-target data mapping and enterprise data migration.
  • Familiarity with federal data governance frameworks.
  • Strong written and verbal communication skills, including the ability to document complex data transformations clearly.

Technologies and Tools

  • SQL Server Integration Services (SSIS)
  • Microsoft SQL Server
  • Digital.ai
  • REST APIs, JSON, XML, CSV
  • NIST SP 800-53, FedRAMP
  • Agile SCRUM, CI/CD
  • GIS: .shp, ESRI
  • i2 Analyst’s Notebook

Location, Work Mode, and Clearance

Work Location: In person (onsite).
Location: Huntsville, AL.
Clearance: Public Trust Background Investigation.

Preferred Qualifications

  • Experience supporting federal law enforcement or case management systems.
  • Knowledge of NIST SP 800-53 data security controls and FedRAMP compliance.
  • Experience integrating REST APIs and working with JSON, XML, and CSV data formats.
  • Familiarity with Agile/SCRUM methodologies and tools such as Digital.ai.
  • Experience with GIS data formats (for example, .shp, ESRI) and i2 Analyst’s Notebook.

Similar Jobs