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

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

ProStaff Solutions Inc

Packer/Warehouse Associate Job at ProStaff Solutions Inc

We are looking for detail-oriented and task-driven Packer/Warehouse Associate to join our clients team in Carrollton, Texas . This role involves order filling, processing shipments, and basic warehouse duties, with an emphasis on safety and precision. If you're interested... 

Talnt

Inside Sales Representative Job at Talnt

 ...About the Role The Inside Sales Representative is responsible for driving revenue growth by managing customer accounts, generating...  ...Desired Qualifications: Experience in distributor, technical, or construction-related sales Familiarity with manufacturing... 

Egon Zehnder

Researcher, Machinery & Industrial Technology Practice, Executive Search Job at Egon Zehnder

 ...highly motivated and proactive Senior Business Analyst to join our Research team. In this fast-paced role, the Senior Business Analyst will...  ...of a similar nature (e.g., market research, qualitative or legal research, professional services/consulting, project planning)... 

Larson Design Group

Traffic Engineer Job at Larson Design Group

 ...Group (LDG) is an award-winning, employee-owned Architecture, Engineering, and Consulting Firm. Guided by our core values, were expanding...  ...and personal growth. Your Opportunity + Impact As a Traffic Engineer, you will serve as a technical leader and play a key... 

MRINetwork Jobs

Dental Site Reviewer - Miami FL Job at MRINetwork Jobs

 ...contracted with a major dental insurance provider to perform site reviews at participating dental practices The job consists of...  ...Size of office (# of patients served, # of team members, etc.) Physical appearance and other amenities HIPAA privacy adherence Etc...