Senior Oracle Data Engineer - Medical Claims

Job Description We are seeking a Senior Oracle Data Engineer to lead foundational data model and ETL enhancements for a large-scale enterprise data platform. This role owns Oracle-side design and delivery of new data attributes, including complex historical backfills, to support downstream data processing and file-based integrations. Responsibilities: · Design and implement Oracle ETL enhancements to support new and evolving data attributes across both daily processing and multi-year historical datasets. · Extend and maintain Oracle data models and curated tables to reliably support downstream analytics and extract-driven consumers. · Analyze and implement identifier normalization and cross-reference strategies, assessing downstream impacts and data lineage. · Build and automate historical extraction and backfill processes, ensuring alignment with go-forward incremental loads. · Produce data extracts and placeholder artifacts required for parallel development across multiple downstream teams. · Partner closely with QA and downstream engineering to support integration testing, defect resolution, and production readiness. Pay rate: 45-60/hr. We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/. Skills and Requirements · 6+ years of experience in Oracle-based data engineering, including advanced SQL and PL/SQL. · Medical Claims experience · Proven experience delivering large historical backfills alongside ongoing incremental loads. · Strong data modeling skills and experience supporting extract-heavy data platforms. Experience working with high-volume, regulated, or compliance-sensitive data domains. · Experience with Talend or similar ETL orchestration frameworks. ? Talend is used for orchestration of report generation § Or similar tools such as Airflow · Familiarity with unique identifier generation and reconciliation strategies for historical datasets. Strong documentation and cross-team collaboration skills in complex delivery environments.