Senior Oracle Data Architect & ETL Lead

BCforward; Addison (TX); Hybrid; USD 80,000 - 107,000; Full time

Job summary

BCforward in Addison, TX is seeking a Senior Oracle Data Architect / Lead Developer to join our Claims Technology team. The ideal candidate will bring strong Oracle SQL/PLSQL, data modeling and architecture, and high‑performance ETL frameworks.

You will optimize end-to-end ETL processes and real-time services, establish metadata catalogs, and design scalable data warehouse models across multiple claims products, while driving data quality and governance in a collaborative, Agile environment.

Qualifications

• Oracle SQL/PLSQL with proven performance tuning expertise.
• Data modeling and architecture for warehouse environments.
• 15+ years of experience in data engineering, data governance, and data warehousing with large-scale datasets.
• Experience in reverse engineering and documenting data flow and asset diagrams.
• Hands-on in building high-performance ETL data frameworks with error handling and scalability.
• Strong experience with partitions, indexes, CDC, purging, and data virtualization.
• Unix and Python scripting experience.
• 3+ years of experience in Agile/Scrum delivery models.
• Strong analytical and communication skills with the ability to drive groups toward common goals.

Responsibilities

• Review and optimize end-to-end ETL processes and real-time operational services with advanced performance tuning.
• Analyze complex data across systems and multiple claims products to connect data relationships and resolve issues.
• Design conceptual, logical, and physical data models for data warehouse environments.
• Establish and maintain a metadata catalog for data management across products.
• Create documentation, partner with solution teams, and contribute to application and code design.
• Improve data flow and data quality processes to enhance accuracy, viability, and value.
• Engage business analysts and development teams to drive alignment and influence outcomes.
• Balance concurrent complex projects while maintaining architectural standards.

Skills

Oracle SQL/PLSQL

Data modeling

Data warehousing

ETL frameworks

High-performance ETL

Unix scripting

Python scripting

Agile/Scrum

Analytical communication

Tools

Tableau

Power BI

Python

Hadoop

Gen AI/ML

Job description

BCforward in Addison, TX is seeking a Senior Oracle Data Architect / Lead Developer to join our Claims Technology team. The ideal candidate will bring strong Oracle SQL/PLSQL, data modeling and architecture, and high‑performance ETL frameworks.

You will optimize end-to-end ETL processes and real-time services, establish metadata catalogs, and design scalable data warehouse models across multiple claims products, while driving data quality and governance in a collaborative, Agile environment.