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

VnUrTHZXUnpsUytrekwxenBMNmhxMm9YK3c9PQ==
  • 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

Royal Oak Health Group

North Carolina Cardiology - Non-Invasive Cardiologist Needed, Generous $ Job at Royal Oak Health Group

 ...Healthcare employer located in the Blue Ridge Mountains of North Carolina seeks to hire BC/BE Non-Invasive cardiologist to join group. This is a hospital-employed opportunity. Candidate should have Nuclear and Echo skills. TEE skills a plus. Will work out of one main... 

Charlotte's Best Nanny Agency

Full-Time Nanny in South Park for Three Children, 9, 6 and 3.5 Years Old Job at Charlotte's Best Nanny Agency

 ...after themselves, and learning to play independently. In the summer, the children are enrolled in various half-day camps. During the...  ...experience Have a professional resume Fill out a complete online application Pass a pre-screening interview with Charlottes Best... 

Hyatt

Housekeeping Aide Job at Hyatt

 ...Summary Hourly Rate: $21.85 Are you looking for a place where meaningful moments are made together? At Hyatt Vacation Club (HVC), we make vacation dreams come true for travelers around the world in a supportive, friendly, and beautiful work environment. As a Housekeeping... 

GE Vernova

Lead Data Engineer Job at GE Vernova

 ...excited at the opportunity to electrify and decarbonize the world?We are seeking a dynamic, forward-thinking, and results-driven Data Engineer to join our Grid Innovation team. This role focuses on designing, building, and maintaining the infrastructure and data... 

Interim HealthCare of Raleigh, NC

Healthcare Recruiter Job at Interim HealthCare of Raleigh, NC

Were looking for a motivated and relationship-driven Healthcare Recruiter to join our growing Talent Acquisition team. In this role, youll lead full-cycle recruitment efforts to identify, attract, and hire top-tier healthcare professionals who align with our mission...