Senior Oracle Data Architect / Lead Developer

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

This is a contract position for 12 months, with a hybrid schedule requiring a minimum of 3 days onsite per week in Addison, TX. The start month is targeted for September. The interview process includes 1-2 rounds, with video and in-person interviews required.

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 and inclusive culture, and exposure to cutting-edge technologies and projects.

Pay

The pay range for this position is $68.25/hr (W2).

Schedule

This is a contract position with a duration of 12 months.