Senior Data Engineer

Knowledge Services; United States; Remote; USD 120,000 - 150,000; Full time

Job summary

A remote technology services company is seeking a Senior Data Engineer for a contract role focused on developing and optimizing data pipelines. The ideal candidate will have over 5 years of experience in data engineering, proficiency with Snowflake, and strong SQL skills. Responsibilities include creating efficient data extraction methodologies and collaborating with diverse teams. A Bachelor’s degree in a related field along with specific certifications is preferred. This position is fully remote with competitive compensation.

Qualifications

• Minimum of 5 years’ experience in data engineering with a focus on data extraction and cloud-based warehousing.
• Solid understanding of data modeling and relational database design.
• Familiarity with cloud platforms such as AWS and Azure.

Responsibilities

• Develop efficient and scalable data extraction methodologies from diverse sources.
• Design and implement robust data loading processes for data warehousing.
• Implement data quality checks and validation processes.
• Mentor and support junior data engineers.
• Collaborate with cross-functional teams for data requirements.

Skills

Proficiency with Snowflake and Fivetran

Advanced SQL skills

Experience with Python scripting

Strong analytical and problem-solving skills

Strong communication skills

Education

Bachelor's or Master’s degree in Computer Science or related field

Snowflake Architect or Data Engineering certification

Tools

ETL/ELT frameworks

dbt for data transformations

Job description

Knowledge Services is seeking a remote Senior Data Engineer for a 6-month contract (potential for extension). This role may work 100% remotely.

• Please note that we CANNOT CONSIDER ANYONE REQUIRING C2C or Sponsorship for a work visa

The Sr. Data Engineer will lead the design, develop, and optimize data pipelines across diverse sources. This role focuses on efficient data extraction, staging, and loading into our Snowflake-based data warehouse, ensuring high availability, accuracy, and performance. The ideal candidate will bring a technical foundation in modern data engineering practices, hands‑on experience with Snowflake and tools like Fivetran, and a collaborative mindset.

Duties and Responsibilities:

• Develop efficient and scalable data extraction methodologies to retrieve data from diverse sources, such as databases, APIs, web scraping, flat files, and streaming platforms.
• Design and implement robust data loading processes to efficiently ingest and integrate data into the latest data warehousing technology, ensuring data quality and consistency.
• Develop and maintain staging processes to facilitate the organization and transformation of raw data into structured formats, preparing it for downstream analysis and reporting.
• Implement data quality checks and validation processes to identify and address data anomalies, inconsistencies, and integrity issues.
• Identify and resolve performance bottlenecks in data extraction and loading processes, optimizing overall system performance and data availability.
• Ensure adherence to data security and privacy standards throughout the data extraction and warehousing processes, implementing appropriate access controls and encryption mechanisms.
• Create and maintain comprehensive documentation of data extraction and warehousing processes, including data flow diagrams, data dictionaries, and process workflows.
• Mentor and support junior data engineers, providing guidance on best practices, technical design, and professional development to elevate overall team capability and performance.
• Collaborate with cross‑functional teams, including data scientists, data analysts, software engineers, and business stakeholders, to understand their data requirements and provide efficient data engineering solutions.
• Stay updated with the latest advancements in data engineering, data warehousing, and cloud technologies, and proactively propose innovative solutions to enhance data extraction and warehousing capabilities.
• Minimum of 5 years’ experience in data engineering, with a strong focus on data extraction and cloud-based warehousing; a combination of years of experience and relevant advanced technology proficiency will also be considered.

Qualifications:

• Proficiency with Snowflake and data integration tools like Fivetran.
• Advanced SQL skills and experience with ETL/ELT frameworks.
• Experience with scripting languages such as Python for data processing and automation.
• Solid understanding of data modeling and relational database design.
• Strong communication skills and the ability to collaborate with technical and non‑technical stakeholders.
• Strong analytical and problem‑solving skills, with the ability to identify and resolve complex data engineering challenges.

Preferred Credentials and Experience:

• Bachelor's or Master’s degree in Computer Science, Information Systems, or a related field.
• Snowflake Architect, Administrator, or Data Engineering certification required.
• Experience with dbt (data build tool) for managing data transformations, modeling, and maintaining version‑controlled, modular SQL pipelines.
• Familiarity with cloud platforms such as AWS and Azure, including services like S3, Lambda, Redshift, Glue, Azure Data Lake, and Synapse.