← Back to jobsJob ID col-cmwp9589d08lyd8has3kriubd

Ampcus IncPosted 1 day ago

Senior Data EngineerNew

Full-time
On-site
7+ years
Competitive
Posted 1 day ago

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are seeking a Senior Data Engineer to join our Data Services team, responsible for developing ETL workflows, API integrations, and ensuring data quality and governance. The ideal candidate will collaborate with cross-functional teams to support smooth data integration and operational processes.

Posted
1 day ago
Source
www1.jobdiva.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Design, develop, and optimize ETL pipelines using Azure Databricks, ADF, and Pentaho to support enterprise data workflows
  • Implement and maintain data movement, transformation, and integration across multiple systems
  • Ensure seamless data exchange between cloud, on-prem, and hybrid environments
  • Work with Globalscape FTP for secure file transfers and automation
  • Develop, consume, and integrate RESTful and SOAP APIs to facilitate data
  • Work with API gateways and authentication methods such Oauth, JWT, certificate, and API keys
  • Implement and optimize API-based data extractions and real-time data integrations
  • Implement data validation, cleansing, and enrichment techniques
  • Develop and execute data reconciliation processes to ensure accuracy and completeness
  • Adhere to data governance policies and security compliance standards
  • Troubleshoot and resolve ETL failures, data load issues, and performance bottlenecks
  • Optimize SQL stored procedures and complex queries for better performance
  • Support ongoing enhancements and provide operational support for existing data pipelines
  • Work closely with Data Analysts, Business Analysts, and stakeholders to understand data needs
  • Document ETL processes, data mappings, and workflows for maintainability and knowledge sharing
  • Provide guidance and best practices to ensure scalability and efficiency of data solutions

Qualifications

  • 7+ years of experience in ETL development, data integration, and SQL scripting
  • Strong expertise in Azure Databricks, ADF (Azure Data Factory), and Pentaho
  • Experience handling secure file transfers using Globalscape FTP
  • Hands-on experience in developing and consuming APIs (REST/SOAP)
  • Experience working with API security protocols (Oauth, JWT, API Keys, etc.)
  • Proficiency in SQL, stored procedures, performance tuning, and query optimization
  • Understanding of data modeling, data warehousing, and data governance best practices
  • Strong problem-solving skills, troubleshooting abilities, and ability to work independently
  • Excellent communication skills and ability to work in a fast-paced environment

Preferred

  • Hands-on experience with cloud-based data platforms (Azure/AWS) is a plus

Required skills

API security protocols JWTAPI security protocols OauthAzure Data Factory (ADF)Azure DatabricksData governanceData integrationData modelingData warehousingETL developmentGlobalscape FTPPentahoQuery optimizationREST API developmentSOAP API development

Full job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are seeking a Senior Data Engineer to join our Data Services team, responsible for developing ETL workflows, API integrations, and ensuring data quality and governance. The ideal candidate will collaborate with cross-functional teams to support smooth data integration and operational processes.

Responsibilities

  • Design, develop, and optimize ETL pipelines using Azure Databricks, ADF, and Pentaho to support enterprise data workflows
  • Implement and maintain data movement, transformation, and integration across multiple systems
  • Ensure seamless data exchange between cloud, on-prem, and hybrid environments
  • Work with Globalscape FTP for secure file transfers and automation
  • Develop, consume, and integrate RESTful and SOAP APIs to facilitate data
  • Work with API gateways and authentication methods such Oauth, JWT, certificate, and API keys
  • Implement and optimize API-based data extractions and real-time data integrations
  • Implement data validation, cleansing, and enrichment techniques
  • Develop and execute data reconciliation processes to ensure accuracy and completeness
  • Adhere to data governance policies and security compliance standards
  • Troubleshoot and resolve ETL failures, data load issues, and performance bottlenecks
  • Optimize SQL stored procedures and complex queries for better performance
  • Support ongoing enhancements and provide operational support for existing data pipelines
  • Work closely with Data Analysts, Business Analysts, and stakeholders to understand data needs
  • Document ETL processes, data mappings, and workflows for maintainability and knowledge sharing
  • Provide guidance and best practices to ensure scalability and efficiency of data solutions

Preferred

  • Hands-on experience with cloud-based data platforms (Azure/AWS) is a plus
  • Cloud-based data platforms
  • Azure
  • AWS

Company

  • Business and technology consulting and staff augmentation firm
  • Chantilly, Virginia, USA
  • http://www.ampcus.com/
  • Founded in 2004
  • 1001-5000 employees

Qualifications

  • 7+ years of experience in ETL development, data integration, and SQL scripting
  • Strong expertise in Azure Databricks, ADF (Azure Data Factory), and Pentaho
  • Experience handling secure file transfers using Globalscape FTP
  • Hands-on experience in developing and consuming APIs (REST/SOAP)
  • Experience working with API security protocols (Oauth, JWT, API Keys, etc.)
  • Proficiency in SQL, stored procedures, performance tuning, and query optimization
  • Understanding of data modeling, data warehousing, and data governance best practices
  • Strong problem-solving skills, troubleshooting abilities, and ability to work independently
  • Excellent communication skills and ability to work in a fast-paced environment
  • Hands-on experience with cloud-based data platforms (Azure/AWS) is a plus
  • 7+ years of experience in ETL development, data integration, and SQL scripting.

Required skills

  • API security protocols API Keys, API security protocols JWT, API security protocols Oauth, Azure Data Factory (ADF), Azure Databricks, Data governance, Data integration, Data modeling, Data warehousing, ETL development, Globalscape FTP, Pentaho, Query optimization, REST API development, SOAP API development, SQL performance tuning, SQL scripting, SQL stored procedures

Experience

  • 7+ years

Job details

Employment type

Full-time

Seniority level

7+ years

Date posted

Nov 20, 2026

Work mode

On-site

Job source

www1.jobdiva.com

Company

Ampcus Inc

Information Technology & AI

Business and technology consulting and staff augmentation firm

See all 12 jobs from Ampcus Inc →
  • Chantilly, Virginia, USA
  • Information Technology & AI
  • 1001-5000 employees
  • Founded 2004
  • ampcus.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in White Plains

Randstad Digital Americas

1d ago

New

Data Engineer

Full-timeOn-siteDurham, NCCompetitive

Randstad Digital is seeking a Data Engineer to build and maintain data pipelines, data platforms, and database solutions for enterprise analytics and operational needs.

Why similarSame roleData GovernanceData Integration

Capgemini Engineering

1d ago

New

Data Engineer AWS

Full-timeHybridWinter Haven, FLCompetitive

Capgemini Engineering is hiring a Data Engineer (AWS) for an innovative project in the automotive sector.

Why similarSame roleData GovernanceData Modeling

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleData WarehousingRemote

Get new Data Engineer jobs in White Plains by email

Create job alert

Senior Data Engineer

Ampcus Inc · Competitive

Apply on company site