Data Process Transformation Lead

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. #J-18808-Ljbffr Bravura Inc.