Senior Oracle Data Architect / Lead Developer

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

Job Title: Senior Oracle Data Architect / Lead Developer

Location: Addison, TX

Duration: Contract - 12 months

Pay Range: $68.25/hr (W2)

Job ID: 407943

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 Oracle Developer / Data Architect to join our dynamic team in Claims Technology. 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 E2E ETL processes and real-time operational services, establish metadata catalogs, and deliver scalable data solutions.

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.

Required Skills & Qualifications

• Primary: Oracle SQL/PLSQL with proven performance tuning expertise.
• Secondary: Data modeling and architecture for warehouse environments.
• 15+ years of experience in data engineering, data governance, and data warehousing with large-scale datasets, preferably in financial services.
• 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.

Preferred Skills

• Experience with data visualization tools such as Tableau or Power BI.
• Exposure to Python, Hadoop, and Gen AI/ML.
• Financial services or banking industry experience.

Work Arrangement and Interview Process

• Hybrid schedule with a minimum of 3 days onsite per week in Addison, TX.
• Start month targeted for September.
• Interview process includes 1-2 rounds. Video is required. In-person interview required. Glider ID verification will be conducted.

Resume Guidance

• Please list current location, relocation plan, availability or start date, and cooling-off requirements if applicable.

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.