Senior Data Architect / Lead Oracle Developer

Requirements:

• 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 data warehouse environments.
• Experience reverse engineering systems, creating data flow and asset diagrams, and establishing metadata catalogs.
• Unix and Python scripting experience.
• Strong analytical skills and ability to connect data across systems and diverse claims products.
• Effective verbal and written communication skills, including the ability to build consensus.
• At least 3 years of experience working in Agile/Scrum delivery models.
• At least 15 years of experience in data engineering, data governance, and data warehousing with large data volumes; financial services experience is preferred.
• Preferred experience with Tableau or Power BI, and exposure to Python, Hadoop, and Gen AI/ML concepts.
• Financial services or banking industry experience is preferred.
• Candidates should include their current location, relocation plan, availability or start date, and any cooling-off requirement on their resume.
• Glider ID verification is required.
• An in-person interview is required following video interview rounds.

Responsibilities:

• Review and optimize end-to-end ETL processes and real-time operational services using advanced performance-tuning techniques.
• Design conceptual, logical, and physical data models for data warehouse environments.
• Establish and maintain a metadata catalog across multiple products.
• Prepare documentation and collaborate with solution teams on application and code design.
• Improve data flows and data quality processes, and address data integrity issues.
• Engage with and influence business analysts and development teams across Claims Technology and business units.
• Coordinate delivery across multiple concurrent projects while following architectural standards.

Technologies:

• AI
• Architect
• Data Warehouse
• ETL
• Flow
• Hadoop
• Oracle
• Power BI
• Python
• SQL
• Tableau
• Unix
• E2E
• Support

More

We are seeking a Senior Data Architect / Lead Oracle Developer for Claims Technology to join our team in Addison, Texas. This is a 12-month contract paying $68.25 per hour on W2, with a target start in November and a hybrid schedule requiring at least three onsite days per week. We are BCforward, a global IT consulting and workforce solutions firm serving Fortune 500 and government clients. Founded in 1998, we have offices and delivery centers across North America and India, and focus on long-term relationships, innovation, collaboration, and integrity. We offer competitive compensation and benefits, growth opportunities with global clients, a supportive and inclusive culture, and exposure to advanced technologies and projects. We are an equal opportunity employer committed to diversity and inclusion.

last updated 43 week of 2026