Data Engineer

About the Role

This role is for our client in the data engineering sector. The successful candidate will be responsible for ensuring the integrity and accuracy of data transferred from a shared file transfer service to an S3 bucket and subsequently into and through our Snowflake data platform. This data will be utilized by downstream applications and reporting systems. These applications and the corresponding consumed data are critical to business process execution.

Key Responsibilities

• Implement and maintain data quality to ensure the accuracy and reliability of data throughout the ETL process.
• Design, develop, and optimize ETL workflows to efficiently transfer data from file transfer services to S3 buckets and Snowflake.
• Ensure seamless data integration into data platform, enabling efficient consumption by downstream applications and reporting tools.
• Address data quality challenges, including inconsistencies in source data that do not meet ingestion requirements, which can lead to load failures or data backouts.
• Work closely with business owners, data analysts, business intelligence teams, and other stakeholders to understand data requirements and deliver high-quality data solutions.
• Monitor pipelines, identify issues, and implement solutions to preserve data flow and integrity.
• Collaborate with cross-functional teams to ensure data quality and integrity.
• Develop and maintain data pipelines to support business intelligence and reporting.
• Design and implement data quality checks to ensure data accuracy and reliability.
• Develop and maintain documentation for data pipelines and data quality processes.

Required Skills & Experience

• Demonstrated mid-level+ experience in data engineering, with a emphasis on data quality assurance and ETL processes.
• Expertise in Python, PyPI, and SQL.
• Expert analytical and problem-solving skills.
• Demonstrate a strong understanding of cybersecurity principles related to code development, DevOps, data access, and fundamental cybersecurity.
• Understanding of fundamental public-cloud capabilities.
• Proven capacity to comprehend business needs and convert them into technical requirements.
• Demonstrated excellence in communication and collaboration abilities.
• Proven capacity to define success, deliver, and operate in an agile setting.

Tools & Technologies

• Python
• PyPI
• SQL
• Snowflake
• S3 bucket
• File transfer services
• DevOps
• Public-cloud capabilities

Work Schedule & Duration

• This is a contract position with a start date of August 3, 2026, and an end date of August 2, 2027.
• The manager would like the candidate to be onsite regularly throughout the position.

Interview Process

The process typically includes an initial screening followed by a technical interview via webcam or in-person.

Position Details

• Employment Type: Contract
• Duration: Approximately 12 months (with potential for extension)
• Work Authorization: Must be authorized to work in the United States