> Markdown version of [/jobs/ext/1367342-data-engineer-sql-server-ssis-aws](https://www.wearedevelopers.com/jobs/ext/1367342-data-engineer-sql-server-ssis-aws). 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). --- # Data Engineer (SQL Server / SSIS / AWS - **Company:** Ares Holdings, LLC - **Location:** Memphis, TN, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** .NET Framework, Amazon Web Services, Amazon S3, Cloud Database, Code Review, Databases, Data Validation, Information Engineering, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Systems, Data Warehousing, Python (Programming Language), Microsoft SQL Server, Operational Databases, Performance Tuning, Query Optimization, Release Management, Cloud Services, SQL Databases, SQL Server Integration Services, Software Technical Review, Enterprise Data Management, Data Processing, Cloud Platform System, Data Ingestion, Data Build Tool (dbt), Database Performance, Change Data Capture, Git, Data Lakes, Data Lineage, Bitbucket, Data Management, Api Design, Cloudwatch, Software Version Control, Data Pipelines - **Published:** July 21, 2026 - **Apply:** https://www.nextech-solutions.com/job/2002 ## About the Role * Strong experience designing and supporting enterprise data ingestion and synchronization pipelines. * Advanced SQL Server expertise, including: + Query optimization + Performance tuning + Index design + Blocking and locking analysis + Troubleshooting complex database issues * Hands-on experience developing SSIS packages and data movement workflows. * Experience building and supporting ETL/ELT pipelines within data warehouse or data lake environments. * Experience with cloud-based data engineering solutions using AWS services such as: + S3 + Lambda + Glue + Athena + CloudWatch + CloudTrail * Experience designing cloud-native data pipelines. * Experience with .NET-based data processing solutions. * Working knowledge of Python for data engineering tasks. * Experience implementing data validation, reconciliation, and data quality processes. * Experience designing monitoring, observability, and alerting for production data pipelines. * Experience using Git, Bitbucket, or similar source control and release management tools. * Strong analytical, troubleshooting, and problem-solving skills. * Excellent communication skills with the ability to collaborate across technical teams. Preferred Qualifications * Experience using DBT (Data Build Tool) for modern data transformation. * Experience with connector-based data integration platforms such as CData or similar technologies. * Familiarity with AWS architectural best practices and cloud design principles. * Knowledge of data governance, data lineage, and data ownership practices. * Experience contributing to technical architecture decisions and mentoring other engineers. * Experience working within enterprise-scale data engineering environments. ## Description We are seeking an experienced Senior Data Engineer to design, build, and support scalable data integration solutions that power enterprise analytics and business intelligence initiatives. This role is ideal for someone who enjoys solving complex data engineering challenges, optimizing large-scale data pipelines, and collaborating across technical teams to deliver reliable, high-quality data solutions. The ideal candidate has deep expertise in SQL Server, SSIS, modern ETL/ELT development, cloud-based data platforms, and performance optimization, along with experience building resilient data ingestion pipelines in enterprise environments., * Design, develop, and maintain enterprise data ingestion pipelines supporting full data loads, incremental processing, and change data capture. * Build and support SQL Server-based and API-driven data integration solutions. * Develop and maintain ETL/ELT workflows that move data into centralized data platforms. * Optimize SQL queries, indexes, and database performance to ensure scalable, efficient processing. * Troubleshoot production issues involving data quality, pipeline failures, and performance bottlenecks. * Design monitoring, alerting, and validation processes to improve pipeline reliability and data integrity. * Participate in architectural discussions focused on scalability, performance, reliability, and operational efficiency. * Collaborate with architects, application teams, and data engineering partners to support end-to-end data movement. * Participate in code reviews and technical design reviews while promoting engineering best practices. * Create and maintain technical documentation, process flows, and implementation diagrams. ## Related Videos - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [WeAreDevelopers LIVE - CSS is DOOMed](https://www.wearedevelopers.com/videos/1838-wearedevelopers-live-css-is-doomed) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [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) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)