Sourcing Engineer

Sun Recruiting; Charlotte (NC); Hybrid; USD 69,000 - 76,000; Full time

Job summary

Innova Solutions is seeking a Data Engineer in Charlotte, NC for a 24+ month contract with hybrid work (3 days onsite, 2 days remote). The role focuses on designing and maintaining scalable ETL pipelines and migrating to Google Cloud Platform.

The ideal candidate will have extensive experience in SQL/PLSQL, Python, PySpark, and ETL design, plus familiarity with GCP, Dataplex, BigQuery, and CI/CD tools. Equal opportunity employer.

Qualifications

• 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 business stakeholders across U.S. and India-based Scrum teams.
• Support monitoring, incident response, root cause analysis, and production reliability.

Responsibilities

• Data Engineering experience.
• Experience in PL/SQL and SQL with Oracle, Teradata, Python, and/or BigQuery (complex query development, tuning, debugging).
• Experience in Ab Initio (complex graphs, Psets, performance tuning).
• Experience in Unix Shell scripting.
• Experience in Python and PySpark for distributed data processing.
• Experience in ETL design, data warehousing concepts, and data modeling best practices.
• Experience in Financial Services or Mortgage industry experience.
• Experience in hybrid environments (on-prem + cloud) and modernization initiatives.
• Scheduling/orchestration with Autosys and Airflow/Cloud Composer.
• Git-based workflows, code reviews, automated testing practices.
• CI/CD with Harness, Jenkins, uDeploy.
• Ab Initio migration to modern Spark/SQL patterns.
• Data governance with Dataplex and Informatica Data Quality.
• Experience designing near real-time patterns (micro-batch/event-driven).
• Familiarity with GCP operational practices (IAM, monitoring, quota/cost controls).

Skills

Data engineering

SQL & PL/SQL

Python

PySpark

BigQuery

Ab Initio

Unix shell scripting

ETL design

Data warehousing

Data modeling

GCP

Dataplex

CI/CD pipelines

Jenkins

Airflow

Cloud Composer

Git workflows

uDeploy

Autosys

Informatica Data Quality

Data governance

Near real-time patterns

Tools

Jenkins

Harness

uDeploy

Autosys

Airflow

Cloud Composer

Dataplex

BigQuery

Oracle

Teradata

Git

Informatica Data Quality

Job description

Data Engineer

Title: Data Engineer
Position type: Full Time – Contract
Duration: 24+ Months
Location: Charlotte, NC (Hybrid-3 days onsite and 2 days Remote)

Data Engineer, You will:

• 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 business stakeholders across U.S. and India?based Scrum teams.
• Support monitoring, incident response, root cause analysis, and production reliability.

The ideal candidate will have:

• Data Engineering experience.
• Experience in PL/SQL and SQL with Oracle, Teradata, Python, and/or BigQuery (complex query development, tuning, debugging).
• Experience in Ab Initio (complex graphs, Psets, performance tuning).
• Experience in Unix Shell scripting.
• Experience in Python and PySpark for distributed data processing.
• Experience in ETL design, data warehousing concepts, and data modeling best practices.
• Experience in Financial Services or Mortgage industry experience.
• Experience in hybrid environments (on?prem + cloud) and modernization initiatives.
• Scheduling/orchestration with Autosys and Airflow/Cloud Composer.
• Git?based workflows, code reviews, automated testing practices.
• CI/CD with Harness, Jenkins, uDeploy.
• Ab Initio migration to modern Spark/SQL patterns.
• Data governance with Dataplex and Informatica Data Quality.
• Experience designing near real?time patterns (micro?batch/event?driven).
• Familiarity with GCP operational practices (IAM, monitoring, quota/cost controls).

This position is only open to applicants who can be engaged on a W-2 basis.

Pay Range: $50/hr to $55/hr

Benefits: Innova Solutions offers benefits (based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).

Innova Solutions is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates.

If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at [e-mail] or [phone]. Please indicate the specifics of the assistance needed. Innova Solutions encourages all interested and qualified candidates to apply for employment opportunities.

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Innova Solutions and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help.

Website: https://www.innovasolutions.com/

Innova Solutions offers a referral bonus for qualified Ambassadors who refer eligible referrals. Submit referrals at https://innovasolutions.workllama.com/atsuser/anonreferafriend and earn $250-$1,000 per referral.

Recent Recognitions:

• Named One of America’s Best Employers for New Grads by Forbes (2024
• Named One of the Best Companies to Work for by U.S. News & World Report (Private Companies List, 2024-2025)
• One of the Largest IT Staffing Firms in the US – Ranked #3 by Staffing Industry Analysts (SIA, 2024)
• One of the Largest Staffing Firms in the US – Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics)
• Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023)
• One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024)
• AWS Advanced Tier Services Partner with 100+ certifications