Data Engineer: Oracle/SQL Automation & Data Quality

Insight Global; San Diego (CA); On-site; USD 110,000 - 160,000; Full time

Job summary

Insight Global is seeking a highly analytical Data Engineer to support a growing database team and on-board new clients, manage large-scale database operations, and automate processes to reduce technical debt.

You will work with Oracle, PostgreSQL, and SQL Server, crafting and tuning SQL, PL/SQL, and T-SQL, while focusing on data retention, compliance, auditing, and data quality in regulated environments. Strong problem-solving and stakeholder collaboration are essential.

Qualifications

• 4+ years of hands-on data engineering experience within relational database environments.
• Strong experience with Oracle, PostgreSQL, and/or SQL Server databases (Oracle preferred).
• Ability to write, troubleshoot, and optimize SQL queries.
• Hands-on experience with T-SQL and/or PL/SQL development, including stored procedures, functions, and scripting.
• Experience onboarding or integrating new data sources and mapping data into enterprise data models.
• Strong understanding of database concepts including partitions, schemas, database objects, indexing, and query performance tuning.
• Experience developing repeatable and scalable database processes to support audits, retention initiatives, and operational workflows.
• Ability to collaborate with both technical and business stakeholders to understand requirements and translate them into database solutions.
• Experience in regulated environments with HIPAA compliance.
• Background in QA, Reporting, BI, or Data Analytics.
• Familiarity with data masking, de-identification techniques, and scripting for automation.

Responsibilities

• Load and map historical client data into existing systems.
• Automate manual database processes to reduce workload and errors.
• Develop and maintain stored procedures, scripts, and automation for data retention, audits, and governance.
• Optimize database performance, including partitioning strategies and indexing.
• Collaborate with stakeholders to translate requirements into robust database solutions.

Skills

SQL

Python

Data modeling

Analytical thinking

Tools

Oracle

PostgreSQL

SQL Server

Job description

Insight Global is seeking a highly analytical Data Engineer to support a growing database team and on-board new clients, manage large-scale database operations, and automate processes to reduce technical debt.

You will work with Oracle, PostgreSQL, and SQL Server, crafting and tuning SQL, PL/SQL, and T-SQL, while focusing on data retention, compliance, auditing, and data quality in regulated environments. Strong problem-solving and stakeholder collaboration are essential.