Senior Data Architect, Lead Oracle Developer
- BCforward
1 Hours Ago
68-69 per Hourly
W2
Addison-TX
15-20 Years
Required Skills: Senior Data Architect , Lead Oracle Developer
Job Description
Skills
Senior Data Architect
Lead Oracle Developer
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.
