Overview
On Site
$100,000 - $145,000
Full Time
No Travel Required
Skills
data engineer
aws
snowflake
python
airflow
airflow dag
ssis
ms sql
aws rds
power bi
data pipelines
ETL
ELT
date warehousing
data lakes
mysql
Job Details
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
- A bachelor's degree is required (any field acceptable)
- A bachelor's or master's degree in Computer Science, Information Systems, Data Science, or an equivalent field is a plus.
- 5+ years of hands-on experience as a Data Engineer that includes:
- Databases:
- Proven mastery of Microsoft SQL Server, including T-SQL is required
- AWS RDS strongly preferred
- MySQL skills are a plus.
- Data warehouse/data lakes:
- 2+ years of hands-on experience working with AWS OR Snowflake data warehouses and data lake environments
- Hands-on experience working with Snowflake data warehouses and data lake environments is a plus.
- ETL:
- Hands-on experience developing ELT / ETL / data pipelines with Python is required.
- Airflow DAG is a big plus
- SSIS is a plpreferred.
- Other:
- Basic Power BI skills would be a plus (we have a separate BI reporting team; however, we use Power BI for monitoring for our DW, so basic skills are required)
- Proficiency with scripting and automation, including Python, PowerShell, or R.
- Experience with and knowledge of data integration and analytic tools such as Boomi, Redshift, or Databricks is desirable.
- Databases:
- Excellent communication and organizational skills are essential
Compensation depends on experience but is typically $100-145K.
ABOUT KORE1
Specializing in professional and technical recruiting, KORE1 is committed to supporting top IT, Engineering, Creative, Scientific, Accounting and Finance professionals in their career paths. We build deep relationships with leading companies, connecting them to exceptional talent every day. With extensive industry expertise and unmatched opportunities, our goal is to provide a unique experience for our contractors and consultants as they prepare for their next role. We are passionate about matching the right people with the right companies.
Specializing in professional and technical recruiting, KORE1 is committed to supporting top IT, Engineering, Creative, Scientific, Accounting and Finance professionals in their career paths. We build deep relationships with leading companies, connecting them to exceptional talent every day. With extensive industry expertise and unmatched opportunities, our goal is to provide a unique experience for our contractors and consultants as they prepare for their next role. We are passionate about matching the right people with the right companies.
Kore1 provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Kore1 complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Kore1 expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Kore1's employees to perform their job duties may result in discipline up to and including discharge.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.