Senior Data Architect & Oracle Lead for Claims Tech

BCforward; Addison (TX); Hybrid; USD 78,000 - 110,000; Full time

Benefits offered by this job

Competitive compensation

Growth opportunities

Inclusive culture

Exposure to cutting-edge technologies

Job summary

BCforward is hiring a Senior Data Architect / Lead Oracle Developer for its Claims Technology division in Addison, TX. This contract role focuses on Oracle SQL/PLSQL, data modeling, and high-performance ETL across data warehouses.

The ideal candidate brings 15+ years in data engineering/data warehousing, strong ETL and governance experience, and a proven track record in Agile environments. Hybrid onsite schedule with three days in the office weekly is expected.

Qualifications

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

Responsibilities

• Review and optimize end-to-end 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.

Skills

Oracle SQL/PLSQL

Data modeling

ETL architecture

Unix scripting

Python scripting

Agile/Scrum

Data quality & governance

Communication skills

Tools

Tableau/Power BI

Python

Hadoop

Gen AI/ML concepts

Job description

BCforward is hiring a Senior Data Architect / Lead Oracle Developer for its Claims Technology division in Addison, TX. This contract role focuses on Oracle SQL/PLSQL, data modeling, and high-performance ETL across data warehouses.

The ideal candidate brings 15+ years in data engineering/data warehousing, strong ETL and governance experience, and a proven track record in Agile environments. Hybrid onsite schedule with three days in the office weekly is expected.