Senior Data Engineer
Location: Memphis, TN
Job Type: Contract
Company: Nextech
Category: Job 5146: Senior Data Engineer (SQL Server / SSIS / AWS)
Job Description Apply Now
Senior Data Engineer - SummaryThe Senior Data Engineer role is a critical position focused on designing, building, and maintaining robust data integration solutions that support enterprise analytics and business intelligence goals. As a Senior Data Engineer, you will be responsible for the full lifecycle of data engineering processes, from developing scalable data ingestion pipelines to optimizing database performance. This opportunity is ideal for candidates with a strong background in SQL Server, SSIS, AWS cloud services, and modern ETL/ELT methodologies. By joining the team as a Senior Data Engineer, you will collaborate with cross-functional technical teams and contribute to the ongoing evolution of enterprise data platforms. This position offers the chance to tackle complex data challenges and make a significant impact on how the organization leverages data for strategic decision-making.
Working in this role provides exposure to innovative data engineering projects, access to the latest cloud technologies, and the ability to influence data architecture at an enterprise level. As a valued member of the team, your technical expertise and problem-solving abilities will help ensure the delivery of high-quality, reliable data solutions that drive business success.
Duties & Responsibilities- Design, develop, and maintain enterprise data ingestion pipelines, including support for full data loads, incremental data processing, and change data capture methodologies.
- Build and support data integration solutions leveraging SQL Server and API-driven approaches to streamline data flow across the organization.
- Develop, implement, and maintain ETL/ELT workflows to transfer and transform data into centralized data platforms, supporting both data warehouse and data lake environments.
- Optimize SQL queries, index structures, and overall database performance to ensure scalable and efficient data processing.
- Troubleshoot and resolve production issues related to data quality, pipeline failures, or performance bottlenecks, maintaining high levels of data integrity and system reliability.
- Design and implement robust monitoring, alerting, and validation processes to enhance the stability and reliability of all data pipelines.
- Participate in architecture discussions, focusing on scalability, performance, and operational excellence within the data engineering ecosystem.
- Collaborate closely with architects, application developers, and other data engineering professionals to support seamless end-to-end data movement and integration.
- Conduct code reviews and participate in technical design discussions, championing engineering best practices throughout the team.
- Create and maintain comprehensive technical documentation, including process flows and implementation diagrams for data solutions.
- Competitive compensation aligned with industry standards for Senior Data Engineer positions.
- Comprehensive benefits package (details provided upon interview).
- Opportunities for professional development and growth within the data engineering space.
- Supportive, collaborative team environment that values innovation and continuous improvement.
- Extensive experience in designing and supporting enterprise data ingestion and synchronization pipelines.
- Advanced expertise in SQL Server, with a proven track record in query optimization, performance tuning, index design, and troubleshooting complex database issues.
- Hands-on experience developing SSIS packages and managing data movement workflows.
- Solid background in building and maintaining ETL/ELT pipelines within data warehouse or data lake environments.
- Demonstrated experience with AWS cloud-based data engineering solutions, including services such as S3, Lambda, Glue, Athena, CloudWatch, and CloudTrail.
- Proficiency in designing and implementing cloud-native data pipelines.
- Experience with .NET-based data processing solutions and working knowledge of Python for data engineering tasks.
- Expertise in implementing data validation, reconciliation, and data quality processes to maintain data integrity.
- Skilled in designing monitoring, observability, and alerting solutions for production data pipelines.
- Experience using Git, Bitbucket, or similar source control and release management tools.
- Strong analytical, troubleshooting, and problem-solving abilities.
- Excellent communication and collaboration skills, with a demonstrated ability to work effectively across technical teams.
- Experienced in using DBT (Data Build Tool) or similar platforms for modern data transformation.
- Familiar with connector-based data integration technologies such as CData.
- Knowledgeable about AWS architectural best practices and cloud design principles.
- Understanding of data governance, data lineage, and data ownership standards.
- Proven ability to contribute to technical architecture decisions and mentor fellow engineers.
- Background working in enterprise-scale data engineering environments.
- This Senior Data Engineer position is a remote opportunity, offering flexibility and the ability to work with diverse teams across locations.
- The organization is committed to providing equal employment opportunities and fostering an inclusive workplace environment for all employees.
- Qualified candidates will be contacted regarding next steps in the hiring process following a review of submitted resumes.
- Working in this role offers exposure to advanced data engineering technologies and the opportunity to contribute to high-impact enterprise data solutions.
- To apply, please use the application button provided on this page and submit your resume for confidential consideration.
If you are ready to take your career in data engineering to the next level, apply now for the Senior Data Engineer position and become part of a forward-thinking team that values expertise, innovation, and collaboration.