Data Engineer III – Data Ingestion & Platform Modernization- Remote

ConsultNet

Birmingham, AL(remote)

JOB DETAILS
SALARY
$70–$77 Per Hour
SKILLS
Amazon Simple Storage Service (S3), Application Programming Interface (API), Atlassian JIRA, Banking Services, Big Data, Business Support, Cloud Computing, Cloudera, Data Lake, Data Management, Enterprise Data Integration, Mainframe Computer, Microsoft SQL Server, Microsoft SharePoint, Oracle Applications, Oracle Database, Performance Tuning/Optimization, Process Improvement, Profit & Loss, Python Programming/Scripting Language, Reengineering, Regulations, Relational Databases (RDBMS), SQL (Structured Query Language), SQL Server Integration Services (SSIS), Scalable System Development, Scripting (Scripting Languages), Small Business, Snowflake Schema, Software Engineering, Test Data
LOCATION
Birmingham, AL
POSTED
1 day ago

Data Engineer III – Data Ingestion & Platform Modernization
Remote (working CST)
6- month contract
Pay Rate: $70.00 - $77.00per hr.

Our client needs a Data Engineer -This role supports a major enterprise data modernization initiative within a large banking environment. The organization is actively migrating from on-prem systems and a legacy Cloudera-based data lake into a Snowflake-based cloud data platform, while also supporting multiple high-priority business and regulatory initiatives. This position is part of a highly visible engineering team responsible for building and maintaining scalable data ingestion pipelines across multiple enterprise systems.

Key Business Initiatives Supported

  • Project Turbo (top profitability initiative): improving small business checking processes
  • R2 (top deposit initiative): enabling enterprise-wide data availability for testing and iteration
  • Open banking regulatory data ingestion (non-Kafka streaming required for this role)
  • Enterprise data lake modernization and migration into Snowflake

Core Responsibilities

  • Build and support end-to-end data ingestion pipelines from multiple source systems into Snowflake
  • Move and transform data from on-prem environments into cloud platforms
  • Support ingestion from diverse data sources:
    • Flat files
    • RDBMS systems (Oracle, SQL Server)
    • Mainframe extracts
    • SSIS-based pipelines
  • Work with ingestion/orchestration tools such as Precisely and Click
  • Perform data obfuscation and transformation as required
  • Move data into AWS S3 landing zones and Snowflake staging/landing layers
  • Develop and optimize SQL for complex transformations and joins
  • Support Python-based data engineering scripts and workflows
  • Contribute to ingestion pipeline re-engineering and optimization
  • Integrate data from enterprise systems including SharePoint and Jira into Snowflake

Required Skills:

  • 5+ years of relevant experience
  • Strong experience in data engineering and big data environments
  • Advanced SQL (complex joins, optimization, performance tuning)
  • Python development experience
  • Snowflake experience
  • Cloudera or similar big data platform experience
  • Experience with ingestion tools such as Precisely and Click
  • Understanding of enterprise data ingestion patterns
  • Experience with multiple data sources (RDBMS, flat files, mainframe, APIs)

Bonus Skills:

  • AWS S3 experience
  • Experience with Jira and SharePoint data extraction/integration
  • Experience working in highly regulated or banking environments

About the Company

C

ConsultNet