Senior Data Architect / Lead Oracle Developer

• 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.

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.

• Competitive compensation and benefits
• Opportunities for growth with global clients
• A supportive, inclusive culture that values innovation and people
• Exposure to cutting-edge technologies and projects

BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.