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

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

Valenti Real Estate

Assistant Property Manager Job at Valenti Real Estate

 ...We are looking for an assistant property manager/office manager in the Sparta/Cedar Springs area who has LIHTC experience. Must be able to self-direct and stay on task to ensure the communities are a success. Rent collection, recertifications, attention to curb appeal... 

Cloud think technologies LLC

Salesforce Devops architect Job at Cloud think technologies LLC

 ...teams to integrate ML models into applications Communication & Interpersonal Skills: - Communicate effectively with internal and customer stakeholders via verbal, email, and instant messaging - Strong interpersonal skills for building relationships and... 

United Rentals

Sales Intern (Paid) Job at United Rentals

 ...United Rentals!**We have an excellent opportunity for a branch Sales Intern who is ready to grow their career with the leading company...  ...In addition to our health and financial plans, we also offer:+ Paid Parental Leave+ United Compassion Fund (+ Employee Discount... 

Entp

Frontend Developer Job at Entp

Work at entp!Frontend DeveloperENTP is looking to add a Frontend DeveloperThe JobLighthouse is getting a major facelift and we're...  ...cookies, or whatever your vices are :)ApplySend an email to ****@*****.*** with a links to your code and a blurb about yourself... 

University of California San Francisco

Assistant Clinical Research Coordinator Job at University of California San Francisco

 ...The Helen Diller Family Comprehensive Cancer Center (HDFCCC) Clinical Research Support Office (CRSO) has experienced unprecedented growth...  .../or Principal Investigator (PI), the incumbent will perform entry-level duties related to the support and coordination of clinical studies...