Logo
KORE1

Data Engineer: MS SQL, AWS, ETL (Python w/ Airflow / SSIS) & basic Power BI req;

KORE1, Irvine, California, United States, 92713

Save Job

Data Engineer: MS SQL, AWS, ETL (Python w/ Airflow / SSIS) & basic Power BI req; Snowflake DW, MySQL, Boomi a +

Data Engineer: MS SQL, AWS, ETL (Python w/ Airflow / SSIS) & basic Power BI req; Snowflake DW, MySQL, Boomi a +

Get AI-powered advice on this job and more exclusive features. This range is provided by KORE1. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range

$100,000.00/yr - $150,000.00/yr Direct message the job poster from KORE1 Career Matchmaker / Talent Curator / Solving Staffing Challenges through Workforce Planning

THIS ROLE IS FULLY ONSITE IN IRVINE, CA FOR 90 DAYS. AFTER THAT, THE ROLE WILL DROP TO 3 DAYS ONSITE, 2 DAYS REMOTE (PENDING CONTINUED PERFORMANCE). ONLY LOCAL CANDIDATES WILL BE CONSIDERED. UNFORTUNATELY, WE ARE UNABLE TO TRANSFER VISAS AT THIS TIME. KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for a

Data Engineer: MS SQL, AWS, ETL (Python w/ Airflow / SSIS) & basic Power BI req; Snowflake DW, MySQL, Boomi a + We are looking for a talented Data Engineer who loves to be hands-on and has experience with Microsoft SQL Server, Snowflake (a plus), AWS RDS, Python / Airflow (for ETL), and MySQL (a plus) to join a team of Business Intelligence Developers and Data Engineers. The ideal candidate will have a strong background and experience working with Snowflake Data Warehouses and Data Lakes, SQL Server, SSIS, and Power BI. 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 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 and business intelligence tools, ideally including Power BI (req) and other similar scripting languages like Python or R. Help ensure and maintain database security, integrity, and compliance following the industry's best practices. Qualifications Bachelor degree is required (any field acceptable) Bachelor or Master's Degree in Computer Science, Information Systems, Data Sciences, or equivalent 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 required MySQL database development skills are a plus. Data warehouse / data lakes: 2+ years of hands-on experience working with AWS 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 ETL / data pipelines with Python / Airflow DAG is required. SSIS is required, if not strongly preferred BI / reporting solutions Basic Power BI skills are required (we have a separate BI reporting team, however, we use Power BI for monitoring for our DW - so basic skills are required) Other: 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. Excellent communication and organizational skills essential Compensation depends on experience but is typically $100-150K. Seniority level

Seniority level Mid-Senior level Employment type

Employment type Full-time Job function

Job function Information Technology Industries Financial Services and Data Infrastructure and Analytics Referrals increase your chances of interviewing at KORE1 by 2x Inferred from the description for this job

Medical insurance Vision insurance 401(k) Disability insurance Get notified about new Data Engineer jobs in

Irvine, CA . Santa Ana, CA $90,000.00-$95,000.00 1 month ago San Juan Capistrano, CA $110,000.00-$130,000.00 1 month ago Long Beach, CA $132,000.00-$169,000.00 2 weeks ago Irvine, CA $90,000.00-$120,000.00 1 week ago Irvine, CA $140,000.00-$180,000.00 1 month ago Irvine, CA $110,000.00-$130,000.00 1 week ago Irvine, CA $120,000.00-$140,000.00 4 weeks ago Irvine, CA $111,000.00-$136,500.00 3 weeks ago Newport Beach, CA $100,530.00-$122,870.00 2 weeks ago Irvine, CA $154,000.00-$192,500.00 2 weeks ago San Juan Capistrano, CA $110,000.00-$130,000.00 2 weeks ago Irvine, CA $140,000.00-$180,000.00 1 week ago Senior Data Engineer, Information Technology – Data & Development

Irvine, CA $119,000.00-$180,000.00 4 days ago Newport Beach, CA $125,500.00-$150,000.00 1 week ago Fountain Valley, CA $103,170.00-$158,873.00 3 days ago Irvine, CA $110,000.00-$150,000.00 5 days ago Long Beach, CA $163,000.00-$209,000.00 5 days ago Irvine, CA $150,000.00-$180,000.00 2 weeks ago Irvine, CA $116,300.00-$145,400.00 1 week ago Irvine, CA $80,000.00-$105,000.00 3 weeks ago Newport Beach, CA $125,000.00-$135,000.00 3 weeks ago Irvine, CA $99,500.00-$200,000.00 1 week ago Santa Ana, CA $126,100.00-$168,100.00 2 days ago Irvine, CA $150,000.00-$180,000.00 1 month ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr