Data Engineer : MS SQL, AWS or Snowflake DW, ELT modern data pipelines, & Python req; Airflow DAG, SSIS ETL, MySQL a +

ONLY LOCAL CANDIDATES WILL BE CONSIDERED. IF YOU ARE OUTSIDE THE AREA, YOU WILL NOT RECEIVE A CALLBACK.  THIS ROLE IS FULLY ONSITE IN IRVINE, CA, FOR 60 TO 90 DAYS. AFTER THAT, THE ROLE WILL DROP TO 3 DAYS ONSITE, 2 DAYS REMOTE (PENDING CONTINUED PERFORMANCE). UNFORTUNATELY, WE ARE UNABLE TO TRANSFER / SPONSOR VISAS AT THIS TIME. KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for a Data Engineer : MS SQL, AWS or Snowflake DW, ELT modern data pipelines, & Python req; Airflow DAG, SSIS ETL, MySQL a +

We are looking for a talented Data Engineer who loves to be hands-on to join a team of Business Intelligence Developers and Data Engineers. This is a key position within the company and aligns with our data strategy, driving optimization, reliability, and robust business intelligence capabilities across the organization. This position is ideal for data professionals seeking to have influence and who wish to apply their technical expertise in a collaborative, data-driven organization focused on innovation and growth. Essential Duties and Responsibilities

• Develop and maintain SQL Server and Snowflake Data Warehouses and Data Lakes with a focus on data governance, security, and performance optimization.
• Manage and optimize database solutions within Snowflake, SQL Server, MySQL, and AWS RDS environments.
• Build and optimize ETL / ELT pipeline processes using Python, Airflow DAG, SSIS, etc.
• Proficiency in Data Tools such as SSMS, VS, Profiler, Query Store, Redgate, etc.
• Perform light operational tasks, including database backup & restore.
• Collaborate and support organizational data development projects, working closely with the Business Intelligence and Business Analysts Teams.
• Configure and manage data integration platforms
• Leverage business intelligence tools, ideally including Power BI, to generate DW monitoring reports (including failed SQL jobs) for remediation
• Help ensure and maintain database security, integrity, and compliance following the industry's best practices.

Qualifications

Compensation depends on experience but is typically $100-145K.