Senior Data Architect / Lead Oracle Developer

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

Job Title: Senior Data Architect / Lead Oracle Developer - Claims TechnologyLocation: Addison, TXDuration: Contract - 12 monthsPay Range: $68.25/hr (W2)Job ID: 411082

About BCforward

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.

Job Description

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.

Responsibilities

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

Required Skills & 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.

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.

Why BCforward?

• 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

About Our Commitment

BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.