Senior Data Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Knowledge Services · 1 day ago

Senior Data Engineer

Knowledge Services is seeking a remote Senior Data Engineer for a 6-month contract. The Sr. Data Engineer will lead the design, develop, and optimize data pipelines across diverse sources, focusing on efficient data extraction, staging, and loading into a Snowflake-based data warehouse.

Cloud ManagementConsultingHuman ResourcesInformation ServicesInformation TechnologyService IndustrySoftware
badNo H1Bnote
Hiring Manager
Paul Doray
linkedin

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

Qualification

SnowflakeData integration toolsAdvanced SQLETL/ELT frameworksPythonData modelingCloud platformsAnalytical skillsCommunication skillsProblem-solving skills

Required

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
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

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

Company

Knowledge Services

twittertwittertwitter
company-logo
Knowledge Services is a certified woman-owned business enterprise (WBE) that is reshaping how public and private organizations work together to better serve our nation.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Fred Brittain
Vice President of Information Security
linkedin
Company data provided by crunchbase