Sr. Data Engineer

Motion Recruitment; Charlotte (NC); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Motion Recruitment is seeking a Software Engineer on a long-term contract in Charlotte, NC (Hybrid) to design and build scalable data pipelines and modernize data platforms across on-prem and Google Cloud. The role emphasizes hands-on development with AB Initio, Python, and SQL, plus migration to BigQuery.

The ideal candidate has 4+ years in data engineering, strong SQL/PL/SQL skills, and experience with ETL, data warehousing, and governance.

Qualifications

• 4+ years of Data Engineering experience or equivalent demonstrated through one or more: work experience, training, military experience, education.
• 4+ years PL/SQL and SQL skills with proven experience in Oracle, Teradata, Python and/or BigQuery: complex query development, tuning, and debugging.
• 4+ years Ab Initio skills with proven experience to build complex graphs, Psets, performance tuning.
• 3+ years programming skills in Python; hands-on PySpark for distributed data processing
• 3+ years of ETL/ETL design, data warehousing concepts, and data modeling best practices

Responsibilities

• Build and maintain scalable batch and near real-time data pipelines using AB Initio, Python, PySpark, PL/SQL and SQL.
• Develop and optimize BigQuery transformations and data models, including partitioning, clustering, and cost/performance tuning.
• Support modernization/migration from Teradata and Ab Initio workflows to GCP/BigQuery with re-platforming and cutovers.
• Implement orchestration and scheduling for pipelines using Autosys and migrating toward Airflow (Google Cloud Composer).
• Apply data governance and discovery practices using Dataplex: metadata management, classification, and lineage.
• Build and operationalize data quality controls using Informatica Data Quality: profiling, rules, thresholds, and exception handling.
• Ensure operational excellence: monitoring, alerting, runbooks, incident triage, and continuous improvements.
• Implement secure data engineering practices: least-privilege access, PII handling, retention controls and audit-friendly docs.
• Partner with product, analytics, and engineering to translate requirements into data contracts and documentation.
• Must-have: use AI-assisted coding tools to accelerate development with strong code reviews and secure coding.
• Collaborate with Architects to design, develop, test and support reliable reusable data pipelines.
• Analyze complex business requirements and generate technical specifications for ETL processes.
• Serve as a technical resource guiding less experienced staff and solving complex middleware problems.

Skills

Data engineering

PL/SQL

SQL

Python

PySpark

BigQuery

Ab Initio

ETL design

Data warehousing

Data modeling

AI-assisted coding

GCP knowledge

Tools

Autosys

Airflow

Git

Jenkins

uDeploy

Dataplex

Informatica Data Quality

Job description

Outstanding long-term contract opportunity! A well-known Financial Services Company is looking for a Software Engineer in Charlotte, NC (Hybrid).

Work with the brightest minds at one of the largest financial institutions in the world. This is a long-term contract opportunity that includes a competitive benefit package! Our client has been around for over 150 years and is continuously innovating in today's digital age. If you want to work for a company that is not only a household name, but also truly cares about satisfying customers' financial needs and helping people succeed financially, apply today.

Contract Duration: 12 Months

Required Skills & Experience

• 4+ years of Data Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
• 4+ years PL/SQL and SQL skills with proven experience in Oracle, Teradata, Python and/or BigQuery: complex query development, tuning, and debugging.
• 4+ years Ab Initio skills with proven experience to build complex graphs, Psets, performance tuning.
• 3+ years programming skills in Python; hands-on PySpark for distributed data processing
• 3+ years of ETL/ETL design, data warehousing concepts, and data modeling best practices

Desired Skills & Experience

• Production operations experience: monitoring, SLAs, incident response, root cause analysis, and performance optimization.
• Experience working in hybrid environments (on-prem + cloud) and supporting data migration/modernization initiatives.
• Experience with scheduling/orchestration in Autosys and Airflow-based orchestration (Cloud Composer direction).
• Experience with Git-based workflows, code reviews, and automated testing practices for data pipelines.
• Experience with Harness, Jenkins and uDeploy based CICD environments.
• Practical experience using AI-assisted coding tools in daily development to improve productivity without compromising quality or security.
• Ab Initio development/maintenance experience and/or hands-on migration of Ab Initio graphs to modern Spark/SQL patterns.
• Experience with Dataplex and broader data governance concepts (metadata, classification, stewardship, lineage practices).
• Experience with Informatica Data Quality implementation patterns (profiling, rules, scorecards/metrics, exception workflows).
• Experience designing near real-time patterns (micro-batch/event-driven concepts) and handling late-arriving/out-of-order data.
• Familiarity with GCP operational practices for data workloads (service accounts/IAM basics, job monitoring, quota/cost controls).

What You Will Be Doing

• Build and maintain scalable batch and near real-time data pipelines using AB Initio, Python, ?PySpark, PL / SQL and SQL to ingest, transform, and publish curated datasets across on-prem and Google Cloud platforms.
• Develop and optimize BigQuery transformations and data models, including partitioning, clustering, query optimization, and cost/performance tuning.
• Support modernization/migration from Teradata and Ab Initio workflows to GCP/BigQuery, including logic re-platforming, reconciliation, parallel runs, and controlled cutovers.
• Implement orchestration and scheduling for pipelines using legacy Autosys while driving migration toward Google Cloud Composer (Airflow), including dependency management, retries, SLAs, and backfills.
• Apply data governance and discovery practices using Dataplex: metadata management, dataset organization, classification support, and ensuring data is consumption-ready.
• Build and operationalize data quality controls using Informatica Data Quality: profiling, rule implementation, thresholds, exception handling, and embedding quality gates into pipelines.
• Ensure operational excellence: monitoring, alerting, runbooks, incident triage/root cause analysis, and continuous improvements to reliability and performance.
• Implement secure data engineering practices: least-privilege access, PII handling/masking where required, retention controls, and audit-friendly documentation.
• Partner with product, analytics, and engineering stakeholders to translate requirements into clear data contracts, curated datasets, and maintainable documentation (data dictionaries, reconciliation notes, operational runbooks).
• Must-have: Use AI-assisted coding tools (e.g., GitHub Copilot, Devin, or similar) to accelerate development while maintaining strong code review discipline, testing, and secure coding standards.
• Closely partner with Product Owners, Architects and Engineers on definition, design, development, integration, testing and support of reliable and reusable Data pipelines.
• Analyze highly complex business requirements; generate technical specifications to design ETL processes.
• Act as an expert technical resource for analysis and provides critical direction to less experienced staff. Work with team members to provide insight into solving complex problems with middleware while leveraging enterprise and industry best practices (including scalability, availability, maintainability, and flexibility).

Posted By: Jennifer Reynolds