ETL developer

Ampcus Inc

Orlando (FL)

On-site

USD 110,000 - 140,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ampcus Inc. seeks a Development Lead to drive end-to-end data ingestion, transformation, and distribution, and to provide onsite leadership to an offshore team, aligning pipelines with BI and analytics requirements.

You will also work hands-on developing critical data pipeline artefacts, enforcing coding standards, and collaborating with architects, product owners, and analysts to translate complex business needs into scalable solutions.

Qualifications

  • Bachelor’s degree in computer science, information technology, or a related field.
  • 6+ years of experience in data warehousing, data engineering, or ETL/ELT development, with at least 1-2 years in a technical lead or senior engineering capacity.
  • Advanced proficiency in SQL and scripting languages like Python or Java.
  • Hands-on experience with modern data integration platforms (e.g., AWS Glue, Apache Spark, or Kafka).
  • Deep understanding of data modeling (snowflake schemas), real-time streaming architectures, and performance tuning large datasets.
  • Exceptional communication, stakeholder management, and project management capabilities.

Responsibilities

  • Develop data/ETL pipelines and review artefacts generated by offshore Data Engineers.
  • Design scalable, robust, fault-tolerant batch and real-time data ingestion pipelines.
  • Oversee ETL or Streaming Data processes across heterogeneous source systems to centralized warehouses and data lakes.
  • Implement data profiling, data reconciliation, validation frameworks, and automated testing to ensure data integrity.
  • Partner with data architects, Data admins, product owners, and business analysts to translate business requirements into technical specs.
  • Troubleshoot data pipeline bottlenecks, optimize SQL queries, and manage incident resolution.

Skills

SQL
Snowflake
Python
Good communication

Education

Bachelor’s degree in computer science, information technology, or a related field

Tools

AWS Glue
Apache Spark
Kafka

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Strong Key Skills

SQL, Snowflake, Python, Good communication

Role Overview:
  • As a Development Lead, you will drive the end-to-end lifecycle of data ingestion, transformation, and distribution.
  • You will provide onsite presence and technical leadership to offshore team, enforce best practices for code quality and testing, collaborate with enterprise architects to align data pipelines with critical business intelligence and analytics requirements.
  • You will also be working hands‑on developing critical data pipeline artefacts.
Key Responsibilities:
  • Develop data/ETL pipelines and assess review the artefacts generated by a team of Data Engineers working from Offshore. Conduct code reviews, facilitate agile ceremonies, and oversee project delivery timelines.
  • Design scalable, robust, and fault-tolerant batch and real‑time data ingestion pipelines. Establish coding standards and integration design patterns.
  • Oversee the Extraction, Transformation, and Loading (ETL) or Streaming Data processes across heterogeneous source systems (e.g., APIs, relational databases, flat files, and cloud storage) to centralized data warehouses and data lakes.
  • Implement data profiling, Data reconciliation processes, validation frameworks, and automated testing procedures to ensure data integrity, consistency, and compliance.
  • Partner with data architects, Data admins, product owners, and business analysts to translate complex business requirements into technical specifications.
  • Troubleshoot critical data pipeline bottlenecks, optimize SQL queries, and manage incident resolution.
Required Qualifications:
  • Bachelor’s degree in computer science, Information Technology, or a related field.
  • 6+ years of experience in data warehousing, data engineering, or ETL/ELT development, with at least 1-2 years in a technical lead or senior engineering capacity.
  • Advanced proficiency in SQL and scripting languages like Python or Java.
  • Hands‑on experience with modern data integration platforms (e.g., AWS Glue, Apache Spark, or Kafka).
  • Deep understanding of data modeling (snowflake schemas), real‑time streaming architectures, and performance tuning large datasets.
  • Exceptional communication, stakeholder management, and project management capabilities.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL developer
ETL developer

Ampcus, Inc • Orlando (FL)

On-site
USD 110,000 - 160,000
Data Engineering Lead
Data Engineering Lead

Ampcus, Inc • Irving (TX)

On-site
USD 140,000 - 180,000
Senior Data Engineer
Senior Data Engineer

Ampcus, Inc • Cincinnati (OH)

Hybrid
USD 110,000 - 150,000
Senior Data Engineer
Senior Data Engineer

Ampcus Inc • Cincinnati (OH)

Hybrid
USD 110,000 - 140,000
ETL Developer / Data Engineer
ETL Developer / Data Engineer

Veriipro • Dallas (TX)

On-site
USD 100,000 - 150,000
AWS Data Engineering
AWS Data Engineering

Ethereum Technologies LLC • Chicago (IL)

On-site
USD 120,000 - 160,000
AWS Data Engineering
AWS Data Engineering

Quantum Technologies LLC • Chicago (IL)

On-site
USD 110,000 - 170,000
AWS Data Engineering
AWS Data Engineering

Valiant Technologies LLC • Chicago (IL)

On-site
USD 120,000 - 180,000
Senior ETL Developer | Lead Data Pipelines & Real-Time
Senior ETL Developer | Lead Data Pipelines & Real-Time

Ampcus Inc • Orlando (FL)

On-site
USD 110,000 - 140,000
ETL Engineer
ETL Engineer

UNAVAILABLE • McLean (VA)

On-site
USD 110,000 - 150,000