Senior Data Engineer

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Data Engineer with a contract length of "unknown," offering a pay rate of "unknown." Key skills include ETL/ELT, SQL, AWS, and experience with Unemployment Insurance data. A Bachelor's degree in a related field is required.
🌎 - Country
United States
💱 - Currency
$ USD
💰 - Day rate
Unknown
Unknown
400
🗓️ - Date discovered
April 17, 2025
🕒 - Project duration
Unknown
🏝️ - Location type
Unknown
📄 - Contract type
Unknown
🔒 - Security clearance
Unknown
📍 - Location detailed
Irvine, CA
🧠 - Skills detailed
#Python #Data Lake #REST (Representational State Transfer) #SQL (Structured Query Language) #Database Security #REST API #Kubernetes #GIT #Consulting #HTTP & HTTPS (Hypertext Transfer Protocol & Hypertext Transfer Protocol Secure) #Visual Studio #Snowflake #AWS (Amazon Web Services) #Docker #Database Design #Security #Data Warehouse #Data Pipeline #Consul #JSON (JavaScript Object Notation) #Data Engineering #Data Conversion #Computer Science #C# #Terraform #Cloud #"ETL (Extract #Transform #Load)" #SAS #BI (Business Intelligence) #Lambda (AWS Lambda) #AWS Glue #Monitoring #Migration #Project Management #API (Application Programming Interface) #SSIS (SQL Server Integration Services)
Role description

Minimum Mandatory Qualifications

SENIOR DATA ENGINEER:

   • A minimum of four (4) years of experience, in developing and monitoring data pipelines, ETL/ELT (Extract Transform Load / Extract Load Transform).

   • A minimum of five (5) years of experience developing in SQL and one (1) year of experience translating between different versions of SQL.

   • A minimum of five (5) years of experience developing with ETL Tools including SSIS, SAS DI Studio, and AWS Glue, and Lambda.

   • A minimum of five (5) years of experience developing Rest APIs, including experience with JSON, C#, and Python.

   • A minimum of three (3) years of experience, in database design, database development, and database security.

   • A minimum of three (3) years of experience, working as a lead with data conversion and migration efforts involving legacy data formats and legacy data repositories such as IBM Mainframe.

   • A minimum of three (3) years of experience with Microsoft Visual Studio and Git Code Repositories.

   • A minimum of three (3) years of experience with Cloud Technologies in in AWS (e.g. glue and lambda) and Snowflake.

   • A minimum of five (5) years of experience working on a large-scale modernization project involving data conversion and migration projects over $50 million in budget, designing and creating raw, integration, and presentation layers.

   • A minimum of three (3) year experience working with Unemployment Insurance and Disability Insurance data.

   • A minimum of three (3) years of experience designing and optimizing data warehouses and data lakes.

   • A minimum of three (3) years of experience with Terraform, Kubernetes, Docker, and CI/CD pipelines.

   • A minimum of three (3) years of experience in automating workflows and data pipelines.

   • A minimum of three (3) years of experience in identifying bugs and bottlenecks. Identifying poor performance and optimize ELT/ETL pipeline.

   • A minimum of three (3) years of experience working with JSON, API, CSV, SQL and Parquet files.

   • 

   • Bachelor’s degree in computer science, engineering, information systems, math or a technology related field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.

Desired (Highly Desired)

   • Six (6) or more years of experience in developing and monitoring data pipelines, ETL/ELT (Extract Transform Load / Extract Load Transform).

   • Seven (7) or more years of experience developing in SQL and three (3) or more years of experience translating between different versions of SQL.

   • Seven (7) or more years of experience developing with ETL Tools including SSIS, SAS DI Studio, and AWS, Glue, and Lambda.

   • Seven (7) or more years of experience developing Rest APIs, including experience with JSON, C#, and Python.

   • Five (5) or more years of experience in database design, database development, and database security.

   • Five (5) or more years of experience working as a lead with data conversion and migration efforts involving legacy data formats and legacy data repositories such as IBM Mainframe.

   • Five (5) or more years of experience with Microsoft Visual Studio and Git Code Repositories.

   • Five (5) or more years of experience with Cloud Technologies in AWS (e.g. glue and lambda) and Snowflake

   • Seven (7) or more years of experience working on large scale modernization projects involving data conversion and migration projects over $50 million in budget, designing and creating raw, integration, and presentation layers.

   • Seven (7) or more years of experience working with Unemployment Insurance and Disability Insurance data.

   • Five (5) or more years of experience designing and optimizing data warehouses and data lakes

   • Five (5) or more years of experience with Terraform, Kubernetes, Docker, and CI/CD pipelines.

   • Five (5) or more years of experience in automating workflows and data pipelines.

   • Five (5) or more years of experience in identifying bugs and bottlenecks. Identifying poor performance and optimize ELT/ETL pipeline.

   • Five (5) of more years of experience working with JSON, API, CSV, SQL and Parquet files.

   • 

   • Master's degree in computer science, engineering, information systems, math or a technology related field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.

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 http://www.estradaci.com/ to learn about our projects, managed services, awards and certifications delivering value for a range of businesses and government agencies.