> Markdown version of [/jobs/ext/1349163-shared-data-warehouse-sdw-process-transformation-subject-matter-expert-sme](https://www.wearedevelopers.com/jobs/ext/1349163-shared-data-warehouse-sdw-process-transformation-subject-matter-expert-sme). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Shared Data Warehouse (SDW) Process Transformation Subject Matter Expert (SME) - **Company:** Bravura Information Technology Systems, Inc. - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Audit Trail, Big Data, Databases, Data Architecture, Data Validation, Data Governance, Extract Transform Load (ETL), Data Transformation, Data Sharing, Metadata, Performance Tuning, Data Streaming, Unstructured Data, Automated Data Processing (ADP), Data Management, 3-tier Architectures, Oracledb - **Published:** July 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=e0dabc32872c70e2 ## About the Role 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), * 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. ## 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. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Events like RSAC Get You CISOs. Developers Decide What Actually Gets Deployed.](https://www.wearedevelopers.com/magazine/693-events-like-rsac-get-you-cisos-developers-decide-what-actually-gets-deployed) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Why Attend a Developer Event in 2026?](https://www.wearedevelopers.com/magazine/688-why-attend-a-developer-event-in-2026)