Temporary Independent Contractor Data Engineer

Overview

The American College of Chest Physicians (CHEST) is a nonprofit organization whose mission is to champion the prevention, diagnosis, and treatment of chest diseases through education, communication and research.

CHEST is seeking a Temporary Independent Contractor Data Engineer. The expected work hours for this position are approximately 30-35 hours per week. There will be opportunities for in person collaboration with the team at CHEST HQ in Glenview, IL. As a result we are targeting Chicagoland applicants. This contract is expected to last approximately 10 months.

The Temporary Independent Contractor Data Engineer (DE) is primarily responsible for maintaining, monitoring, troubleshooting, and enhancing production data pipelines and database systems. This role requires hands-on experience supporting live SSIS packages, SQL Server processes, and Snowflake workloads in production environments. The Temporary Independent Contractor Data Engineer will work closely with the Data Architect and Data Analytics team, acting as a data SME with a strong focus on CRM Support, cross-functional project work, and routine job monitoring.

• Maintain data ingestion processes to Snowflake and MS SQL Server from a wide variety of data sources using Python, ELT tools, SSIS, and automation scripts.
• Design and develop Snowflake and MS SQL Server database objects and procedural code to support various custom and third-party applications, including stored procedures, functions, and triggers.
• Maintain and develop test and production environments that support CHEST’s CRM platform.
• Optimize and tune SQL queries in both Snowflake and MS SQL databases by normalizing and denormalizing data as needed, while monitoring performance.
• Monitor the day-to-day reliability of data ingestion and backup processes on production systems.
• Collaborate with application developers and data analysts to provide data services and support for existing and new applications while maintaining data integrity.
• Engineer large, complex data sets that meet business requirements while maintaining an optimal data pipeline.
• Work with stakeholders including the Product, Data and Web Development and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Support and troubleshoot application issues and document solutions.
• Identify, design, and implement process improvements.
• Perform deployment activities to pre-production and production systems.
• Ensure quality and stability of the databases, while implementing efficiencies to reduce application and database support costs.
• Work with the data analysts to build the production frameworks to orchestrate data pipelines, and automate workflow management in Snowflake, MS SQL, and other platforms as required.
• Perform problem-solving of application issues and production errors, including high level critical production issues that require immediate attention.

• 3 + years working with Snowflake, MS SQL Server
• 3+ years of practical experience with SQL and database maintenance, including stored procedures and SSIS packages.
• Understanding of data modeling concepts (e.g., star schema, normalization) and ETL/ELT design practices
• Git fundamentals, Agile development, and CI/CD practices.
• Demonstrated experience working with CRM systems and data integrations.
• Demonstrated experience working with scripting languages (Python preferred).
• Degree in Computer Science, Software Engineering, Information Technology, Mathematics, or a related field required.

The pay range for this position is $60-$65 per hour. CHEST considers factors such as, but not limited to, the scope and responsibilities of the position, key skills, and market and organizational considerations when setting the hourly pay for our temporary independent contractor positions.