Lead Data Engineer Job at Estrada Consulting Incorporated, Sacramento, CA

Um9VRS8yRXFGQ09uUDRkcTBLQ2h2TWJMNlE9PQ==
  • Estrada Consulting Incorporated
  • Sacramento, CA

Job Description

ECI is currently seeking a Senior Lead Data Engineer / Snowflake.
Candidates are preferred to live and work in the Sacramento, CA area.
Remote work.

Duration: 12-months with optional extension.

Candidates must have a bachelor's degree in a related field and provide a PDF copy along with three (3) Client Signed Reference Forms - provided by the client.

Candidates must have all the following minimum mandatory qualifications:
  • 10+ years in IT, which will include at least 4 years of the following:
    • Relevant experience in authoring and monitoring data pipelines.
    • Skills with Snowflake, ETL/ELT (dbt, AWS file systems, SES/SNS, Lambda (Boto 3), Python.
    • Expertise with micro-batch data processing, near real-time ingestion.
    • Expertise in data modeling (Data Vault 2, Star Schema).
    • Orchestrating data enrichment specifically geocoding of addresses to latitude and longitude as part of the ELT process.
    • Expertise with modern data pipeline architecture using DBT, Snowflake on a cloud platform, preferably in AWS.
    • Expertise with DBT / Snowflake Incremental Refreshes and materializations, and snowflake cost optimizations on large volumes of data received hourly.
    • Expertise in handling PII and other types of privileged data.
    • In-depth experience and knowledge of data quality management.

About Estrada Consulting Incorporated:

Estrada Consulting, Inc. (ECI) delivers technology-enabled services and solutions to clients all over the USA and British Columbia. We provide system integration, custom application development, data warehouse and business intelligence, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters is in Sacramento, California, and was established in year 2000. Visit to learn about our projects, managed services, awards and certifications delivering value for a range of businesses and government agencies.

Job Tags

Hourly pay, Full time, Remote work,

Similar Jobs

Field Force Merchandising

Tops Grocery Merchandiser Job at Field Force Merchandising

 ...Job Description: Field Force Merchandising is currently seeking part time retail service merchandisers for ongoing program in Albertsons grocery store(s) to begin work immediately. This is a permanent part-time independent contractor position requiring one service... 

PrimeFlight Aviation Services

Part Time Ramp Agent - Bill and Hillary Clinton National Airport (LIT) Job at PrimeFlight Aviation Services

 ...support services globally on behalf of commercial airlines. Join us for a rewarding career in the aviation industry!**BECOME A RAMP AGENT!**Our Ramp Agents are responsible for the loading and unloading of baggage, cargo, and mail as applicable onto the aircraft, along... 

RUIAN YUEMEI (CH PPCN DANCE STUDIO)

Kids Jazz or Hip-hop Dance Teacher Needed (Wenzhou, Zhejiang Province) Job at RUIAN YUEMEI (CH PPCN DANCE STUDIO)

Kids Jazz or Hip-hop Dance Teacher Needed (Wenzhou, Zhejiang Province)RUIAN YUEMEI (CH PPCN DANCE STUDIO).As the world of dance continues to evolve, RUIAN YUEMEI (CH PPCN DANCE STUDIO) focuses on international dance education, creating opportunities for students to learn... 

Franklin County Common Pleas Court, General Division

Court Reporter Job at Franklin County Common Pleas Court, General Division

FRANKLIN COUNTY COURT OF COMMON PLEAS-GENERAL DIVISION AN EQUAL OPPORTUNITY EMPLOYER COURT REPORTER ANNUAL SALARY: $66,111 Excellent Benefits Package POSTED DATE:December 16, 2021 SUBMISSION DATE:Continuous Purpose of Position: The purpose of this position... 

Walmart

(USA) Manager, Initiatives, Health And Wellness - Nutrition Solutions Job at Walmart

 ...science to improve our product over timeAbout the team:This is a unique opportunity to join the Everyday Health Signals project under Walmart Health ; Wellness. Our solution delivers retail insights that will power the future of healthcare for our customers through the...