> Markdown version of [/jobs/ext/2625740-senior-data-engineer](https://www.wearedevelopers.com/jobs/ext/2625740-senior-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Engineer - **Company:** Ampcus Inc - **Location:** White Plains, NY, United States - **Experience:** Expert - **Salary:** $127,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Amazon Web Services, User Authentication, Microsoft Azure, Data as a Services, Data Validation, Data Governance, Data Integration, Extract Transform Load (ETL), Data Systems, Data Warehousing, Database Queries, Electronic Data Interchange (EDI), File Transfer, OAuth, Pentaho Data Integration, Performance Tuning, Query Optimization, JSON Web Token, Simple Object Access Protocol (SOAP), SQL Stored Procedures, SQL Databases, File Transfer Protocol (FTP), Cloud Platform System, Azure Data Factory, Software Security, SOAPAPI, Real Time Data, Api Design, Api Gateway, Restful APIs, Data Pipelines, Api Management, Databricks - **Published:** August 31, 2026 - **Apply:** https://www.careerjet.com/job/uscbee72ddf15cee6d1d01579f118934eb/eaa ## About the Role * 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. * Hands-on experience with cloud-based data platforms (Azure/AWS) is a plus. * Strong problem-solving skills, troubleshooting abilities, and ability to work independently. * Excellent communication skills and ability to work in a fast-paced environment. ## Description We are seeking a Senior Data Engineer to join our Data Services team. The ideal candidate will be an individual contributor responsible for developing ETL workflows, API integrations, supporting business-as-usual (BAU) processes, and collaborating with cross-functional teams to ensure smooth data integration, quality, and governance. This role requires expertise in Azure Databricks, ADF, Pentaho, Globalscape FTP, API Development, SQL stored procedures, and complex queries. ETL & Data Integration: * 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. API Development and Integration: * 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. Data Quality & Governance: * 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. BAU Support & Performance Optimization: * 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. Collaboration & Documentation: * 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., Responsibilities: As a Senior Data Engineer on DAPI's Tetris team, you will own the design and delivery of complex data engineering solutions that power NYBCe's enterprise analyt… + 2 months ago ## Related Videos - [Keeping applications secure by evolving OAuth 2.0 and OpenID Connect](https://www.wearedevelopers.com/videos/100152-keeping-applications-secure-by-evolving-oauth-2-0-and-openid-connect) - [Cutting LLM Costs Without Cutting Quality: How to Beat Proprietary LLMs with Fine-Tuned Open Source](https://www.wearedevelopers.com/videos/100151-cutting-llm-costs-without-cutting-quality-how-to-beat-proprietary-llms-with-fine-tuned-open-source) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [OLTP in the Lakehouse: Redefining Data for AI Workloads](https://www.wearedevelopers.com/videos/2038-oltp-in-the-lakehouse-redefining-data-for-ai-workloads) - [Delay the AI Overlords: How OAuth and OpenFGA Can Keep Your AI Agents from Going Rogue](https://www.wearedevelopers.com/videos/1637-delay-the-ai-overlords-how-oauth-and-openfga-can-keep-your-ai-agents-from-going-rogue) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)