Senior Software & Data Engineer
Summary
Hybrid contract role in Harrisburg, PA: a senior engineer providing production support and troubleshooting for applications, databases, and ETL pipelines — debugging Python and C#/.NET code, T-SQL/SQL Server and PL/SQL/Oracle databases, and data-lake integrations to resolve data sync issues between independent systems.
e&e is seeking a Senior Software & Data Engineer for a hybrid contract opportunity in Harrisburg, PA!
We are seeking a highly skilled Senior Software & Data Engineer to provide advanced production support, troubleshoot complex technical issues, and ensure the reliability and integrity of critical applications and data systems. This role requires a strong combination of software development, database engineering, ETL/data integration, and production troubleshooting expertise.
The ideal candidate will have extensive hands-on experience with Python, C#/.NET, T-SQL/SQL Server, PL/SQL/Oracle, and ETL/data lake technologies, with a particular emphasis on Python development and troubleshooting data synchronization between independent systems.
Key Responsibilities
- Diagnose, troubleshoot, and resolve complex production issues involving applications, databases, ETL processes, and data integrations.
- Investigate data synchronization issues between independent systems, identifying discrepancies, failed processes, and underlying causes.
- Analyze, debug, and optimize Python and C#/.NET applications, scripts, and services.
- Troubleshoot and maintain T-SQL (SQL Server) and PL/SQL (Oracle) queries, stored procedures, and database operations.
- Support, maintain, and troubleshoot ETL pipelines, data lake architectures, and data integration workflows.
- Investigate data processing failures, application errors, and performance issues to identify and implement long-term solutions.
- Utilize Apache Airflow or comparable ETL/orchestration technologies to troubleshoot and improve data workflows.
- Perform data validation, auditing, and quality checks to ensure accuracy and consistency across systems.
- Implement production fixes using established best practices, including backups, testing, change validation, and rollback procedures.
- Apply strong analytical and problem-solving skills to resolve critical technical issues while minimizing operational disruptions.
- Maintain disciplined version control practices using Git, including clear documentation, controlled changes, and code reviews.
- Document root causes, corrective actions, and recommendations to prevent recurring production issues.
- Collaborate with technical teams and business stakeholders to understand issues, communicate risks, and deliver effective solutions.
- Provide responsive, independent technical support for urgent and escalated production incidents.
Required Qualifications
- Advanced hands-on experience with Python development, including debugging, scripting, troubleshooting, and production support.
- Strong proficiency in C#/.NET, with experience maintaining and troubleshooting existing applications.
- Expert-level experience with T-SQL and Microsoft SQL Server, including complex queries, stored procedures, and database troubleshooting.
- Expert-level experience with PL/SQL and Oracle databases, including query optimization, troubleshooting, and data validation.
- Extensive hands-on experience with ETL processes, data integration, and data lake architectures.
- Proven ability to troubleshoot complex data synchronization issues between independent systems.
- Strong background in production support, root cause analysis, and resolution of critical application and database issues.
- Experience validating data accuracy, investigating discrepancies, and troubleshooting data quality issues.
- Proficiency with Git and established software development and change management practices.
- Strong understanding of production data protection, backup procedures, testing methodologies, and rollback strategies.
- Excellent analytical, troubleshooting, and problem-solving abilities.
- Ability to work independently, quickly understand unfamiliar systems, and resolve issues with minimal supervision.
- Strong written and verbal communication skills, including the ability to document technical findings and explain complex issues.
- Availability to provide technical support on short notice as production needs arise.
Preferred Qualifications
- Hands-on experience with Apache Airflow for ETL orchestration, workflow management, and troubleshooting.
- Experience with alternative ETL technologies such as SSIS, Informatica, or Azure Data Factory.
- Background in data engineering, data analytics, or data science, particularly involving data validation, auditing, and troubleshooting.
- Experience supporting complex enterprise environments with multiple interconnected applications and databases.
- Demonstrated success resolving high-priority production incidents and implementing preventative improvements.
- Experience optimizing data pipelines, improving system performance, and ensuring data consistency across platforms.
Skills
Sign in to read and join the discussion.