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

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

RSC Landscaping

Landscape Administrative Assistant Job at RSC Landscaping

 ...customers Lead intake for design and irrigation leads Intake and work ticket creation for installation of plants purchased at garden center Point of contact for customers during the design/construction process Works directly with design team on proposal follow... 

Closet Factory - Los Angeles

In Home Sales Consultant Job at Closet Factory - Los Angeles

Job descriptionJoin the Closet Factory team. Design Closets, Home offices, entertainment centers, wall beds, garages, mud rooms, laundries...  ..., sell and install custom closets, home offices, garages, home theaters, pantries, bookshelves and more. Our products are of the highest... 

Saint Luke's

Nursing Intern - Inpatient - PRN Job at Saint Luke's

 ...are paid opportunities.**The Nurse Internship position is for students currently enrolled in an accredited RN program who have completed...  ...restricted from performing any licensed tasks.It is the expectation to work full time hours over the course of the summer and breaks. During... 

Hirekeyz Inc

Cognos Report Developer (Deltek Integration) Job at Hirekeyz Inc

 ...data from Deltek systems into Cognos. Key Responsibilities: Design, develop, and maintain reports and dashboards using IBM Cognos Analytics . Extract and analyze data from Deltek ERP systems for reporting needs. Map, transform, and integrate... 

Central Kentucky Community Action Council, Inc.

Head Start Teacher Job at Central Kentucky Community Action Council, Inc.

JOB PURPOSE: The Head Start Teacher is responsible for providing instructional experiences for the preschool child for adequate development in the social, emotional, physical, and educational processes. RESPONSIBILITIES AND DUTIES: Possesses knowledge and understanding...