> Markdown version of [/jobs/ext/3776670-senior-data-architect-lead-oracle-developer](https://www.wearedevelopers.com/jobs/ext/3776670-senior-data-architect-lead-oracle-developer). 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). --- # Senior Data Architect / Lead Oracle Developer - **Company:** BCforward - **Location:** Addison, TX, United States - **Experience:** Expert - **Salary:** $141,960.0 - **Contract:** Contract - **Skills:** Big Data, Unix, Data Architecture, Information Engineering, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Virtualization, Data Visualization, Data Warehousing, Apache Hadoop, Python (Programming Language), Machine Learning, Oracle SQL Developer, Performance Tuning, Scrum Methodology, Power BI, Reverse Engineering, PL-SQL, Data Streaming, Tableau (Software), Scripting, Generative AI, Physical Data Models, Data Pipelines - **Published:** October 16, 2026 - **Apply:** https://www.dice.com/job-detail/5d4d524e-04fa-4b6f-b8e8-d4c47ab61bf1 ## About the Role We are seeking a Senior Data Architect / Lead Oracle Developer - Claims Technology to join our dynamic team. The ideal candidate will have strong experience in Oracle SQL/PLSQL, data modeling and architecture, and high-performance ETL frameworks and a proven ability to optimize end-to-end ETL processes, improve data quality, and deliver scalable data solutions across claims technology., * Expertise in Oracle SQL/PLSQL, including performance tuning, partitions, indexes, CDC, purging, and data virtualization. * Proven experience building high-performance, scalable ETL frameworks with robust error handling. * Strong data modeling and architecture skills for warehouse environments. * Experience in reverse engineering and producing data flow and asset diagrams; establishing metadata catalogs. * Unix and Python scripting experience. * Strong analytical skills and the ability to connect data across systems and diverse claims products. * Effective verbal and written communication skills with the ability to drive consensus. * 3+ years of experience working in Agile/Scrum delivery models. * 15+ years of experience in data engineering, data governance, and data warehousing with large data volumes, preferably in financial services. Preferred Skills: * Experience with Tableau or Power BI for data visualization. * Exposure to Python, Hadoop, and Gen AI/ML concepts. * Financial services or banking industry experience. Role Logistics & Schedule: * Approved location: Addison, TX. Hybrid with a minimum of 3 days onsite per week. * Target start: November. In-person interview required after video round(s). Glider ID verification required. * On resume: include current location, relocation plan, availability/start date, and any cooling-off requirement. ## Description * Review and optimize E2E ETL processes and real-time operational services with advanced performance tuning. * Design conceptual, logical, and physical data models for data warehouse environments. * Establish and maintain a metadata catalog across multiple products. * Create documentation and collaborate with solution teams on application and code design. * Improve and streamline data flow and data quality processes; challenge data integrity issues. * Engage and influence business analysts and development teams across Claims Technology and business units. * Balance delivery of multiple concurrent projects while adhering to architectural standards.