Data Engineer - Cloud ETL & BigQuery for Mortgage

Innova Solutions Inc; Charlotte (NC); Hybrid; USD 69,000 - 76,000; Full time

Benefits offered by this job

Medical & pharmacy coverage

Dental/vision insurance

401(k)

HSA and FSA

Life Insurance

Pet Insurance

Disability insurance

Accident & Critical illness coverage

Pre-paid legal & ID theft protection

Sick time

Paid leaves as required by law

Employee Assistance Program

Job summary

Innova Solutions is seeking a Data Engineer to design and maintain scalable ETL pipelines and support data migration to cloud platforms. The role blends on-site collaboration with remote work in a hybrid setup.

The ideal candidate will have hands-on experience with Python, PySpark, SQL/PLSQL, and Ab Initio, along with knowledge of data governance and CI/CD practices. The position is based in Charlotte, NC, with a mix of on-site and remote days.

Qualifications

• Experience in ETL design and data warehousing concepts.
• Experience in financial services or mortgage domain is a plus.
• Strong query tuning and debugging skills in SQL/PLSQL.

Responsibilities

• Design, build, and maintain scalable batch and near real-time ETL pipelines using Ab Initio, Python, PySpark, SQL, and PL/SQL.
• Consolidate, cleanse, normalize, and transform data from mortgage-related systems into enterprise data products.
• Support migration from legacy platforms to GCP, leveraging BigQuery, Dataplex, and cloud-native orchestration.
• Build, schedule, and deploy solutions through enterprise CI/CD pipelines (Jenkins, Harness, uDeploy).
• Partner with Product Owners, Architects, Engineers, and stakeholders across U.S. and India-based Scrum teams.
• Support monitoring, incident response, root cause analysis, and production reliability.

Skills

Data engineering

Python

PySpark

SQL

PL/SQL

Unix shell scripting

Git-based workflows

CI/CD

BigQuery

Ab Initio

Tools

Ab Initio

BigQuery

Dataplex

Autosys

Airflow / Cloud Composer

Jenkins

Harness

uDeploy

Informatica Data Quality

Job description

Innova Solutions is seeking a Data Engineer to design and maintain scalable ETL pipelines and support data migration to cloud platforms. The role blends on-site collaboration with remote work in a hybrid setup.

The ideal candidate will have hands-on experience with Python, PySpark, SQL/PLSQL, and Ab Initio, along with knowledge of data governance and CI/CD practices. The position is based in Charlotte, NC, with a mix of on-site and remote days.