Role: Shared Data Warehouse (SDW) Process Transformation Subject Matter Expert (SME)
Location: Aberdeen, MD / Remote
Education/Certifications: N/A
Years of Experience: 10+ years’ professional experience in IT or related field
Clearance Level & Investigation: Tier 3 or equivalent (ADP/IT-II)
IT Level (AR 25-2): IT-II or NACLC
IA Cert Level (DoD 8570.01): IAT Level II
Computing Environment Certifications: Relevant certification from nationally recognized authority (preferred)
Job Description:
- Implement and support ETL workflows to extract data from SDW mid-tier, transform it into usable formats, and load it into SDW Oracle DB.
- Create efficient and scalable ETL pipelines to handle large volumes of data.
- Ensure ETL processes align with business requirements and data architecture standards.
- Perform complex data transformations to standardize, cleanse, and enrich SDW data from MOCAS for analytical or operational purposes.
- Integrate SDW data from MOCAS, including structured, semi-structured, and unstructured data formats.
- Ensure seamless data flow between SDW, MOCAS and systems, applications, and databases.
- Implement data quality checks and validation rules within ETL processes to ensure accuracy, consistency, and completeness of data.
- Identify and resolve data anomalies, inconsistencies, and errors during transformation.
- Collaborate with stakeholders to define data quality standards and metrics.
- Monitor ETL process performance and identify bottlenecks or inefficiencies.
- Optimize ETL workflows, queries, and transformations to improve processing speed and resource utilization.
- Implement best practices for ETL performance tuning and scalability.
- Manage ETL tools and platforms (ex. Informatica).
- Configure and maintain ETL environments, ensuring they are secure, reliable, and up to date.
- Evaluate and recommend new ETL tools or technologies to enhance data transformation capabilities.
- Ensure ETL processes comply with DoW organizational policies, industry standards, and regulatory requirements (Ex. Managing PII data).
- Implement data governance practices to maintain data lineage, metadata, and audit trails.
- Collaborate with data stewards and governance teams to enforce data security and privacy measures.
- Create and maintain detailed documentation for ETL workflows, data mappings, and transformation logic.
- Provide regular reports on ETL process performance, data quality metrics, and operational status.
- Document lessons learned and best practices to improve future ETL implementations.
Required Minimum Experience:
- 10+ years of overall professional experience in IT or related field.
- Must have knowledge and expertise in the following: ETL Process Design and Development; Data Transformation and Integration; Data Quality and Validation; Performance Optimization; ETL Tool Management; Data Governance and Compliance; Documentation and Reporting; Incident Management and Troubleshooting.
Required Clearance:
- Must possess IT-II security clearance or have a current National Agency Check with Local Agency Check and Credit Check (NACLC).
Certifications:
- Relevant certification from a nationally recognized technical authority preferred.
- DoW Approved 8570 Baseline Certification: Category IAT Level II.