BI Data Engineer — ETL & Data Warehouse Expert

Golden State Foods; Irvine (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Golden State Foods is looking for a Business Intelligence Data Engineer in Irvine, California. The role involves full-cycle data warehousing development, including analyzing business requirements and designing ETL processes to present data for reporting.

Candidates must have a degree in a quantitative field and experience with data warehousing, SQL, and ETL tools. The position emphasizes collaboration with developers and business users to enhance data quality and delivery.

Qualifications

• Four‑year college degree in a quantitative field or equivalent work experience.
• Industry experience in Business Intelligence Data Engineer, Software Engineer, or similar roles.
• Strong proficiency in SQL.
• Expertise in ETL tools and data manipulation languages.
• Extensive experience in data warehousing development.

Responsibilities

• Identify and understand source data systems; resolve data issues.
• Map source system data to data warehouse tables.
• Develop and test ETL processes, validate data flows.
• Define and capture metadata, rules, and documentation.
• Collaborate with developers and business users.

Skills

SQL

ETL tools (Matillion, Informatica, SSIS, ODI)

Data manipulation languages (Python, SAS, R)

Data warehousing development

Troubleshooting and production support

Education

Four-year college degree in a quantitative field

Tools

AWS (Redshift, EC2, S3)

PowerBI

Job description

Golden State Foods is looking for a Business Intelligence Data Engineer in Irvine, California. The role involves full-cycle data warehousing development, including analyzing business requirements and designing ETL processes to present data for reporting.

Candidates must have a degree in a quantitative field and experience with data warehousing, SQL, and ETL tools. The position emphasizes collaboration with developers and business users to enhance data quality and delivery.