Senior Data Architect / Lead Oracle Developer

Job Title: Senior Data Architect / Lead Oracle Developer - Claims Technology

Location: Addison, TX

Duration: Contract - 12 months

Pay 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?

At BCforward, we believe in advancing lives and careers. When you join our team, you gain access to:

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

Interested? Apply Now!

If this sounds like the right opportunity for you, please apply with your most recent resume.