Data Engineer

Lensa; Irvine (CA); Hybrid; USD 120,000 - 140,000; Full time

Job summary

A leading company in the foodservice industry is seeking a Business Intelligence Data Engineer to develop ETL processes and support data warehousing solutions. The role requires expertise in SQL, AWS, and data visualization tools, alongside strong analytical abilities. This hybrid position allows for 3 days in the office per week in Irvine, CA, promoting a collaborative environment focused on innovation and data-driven decision-making.

Benefits

Paid time off

Comprehensive benefits package

Flexible work schedules

Qualifications

• 5+ years of experience with AWS, SQL, and ETL processes.
• Strong communication skills for translating complex analyses.
• Experience with predictive modeling and working with unstructured datasets.

Responsibilities

• Design ETL processes and manage data flows for business intelligence solutions.
• Collect and document business requirements to inform project direction.
• Analyze data patterns and trends to provide actionable insights.

Skills

SQL

Communication

Analytical Skills

Data Visualization

Problem Solving

Education

Four year college degree in Science or Technology

Advanced degree preferred

Tools

AWS

Tableau

Power BI

Dell Boomi

Job description

13 hours ago Be among the first 25 applicants

Lensa partners with DirectEmployers to promote this job for Golden State Foods.

Overview

If you are considering a career with one of the largest diversified suppliers in the foodservice industry. Golden State Foods sets the Gold Standard by focusing on it’s Creed and Values, putting customers first and continually innovating. GSF associates are also deeply committed to the communities where they live and work, as much as an 80% participate in the GSF Foundation, where 100% of the associate proceeds go to helping children and families in need.

TheBusiness Intelligence Data Engineerwill be responsible for the scripts and processes required to extract, transform, clean and move data and metadata so they can be loaded into a data warehouse, data mart or operational data store. Reads, analyzes and digests what the company wants to accomplish with its data, and designs the best possible ETL process around those goals. Capable of managing remote workers.Must have hands on client experience.This is a hybrid remote position for Southern California - requires 3 days in office each week.

Responsibilities

ESSENTIAL FUNCTIONS

(% of time may vary depending on assignments/projects)

• Business Requirements
• Collect and document business requirements using: interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, user stories, use cases, scenarios, business-process and workflow analysis.
• Critically evaluate information gathered from multiple sources and reconcile conflicts.
• Proactively communicate and collaborate with external and internal customers to understand processes, analyze information needs and define functional requirements.
• Serve as the conduit between the business unit and the BI development team.
• Successfully engage in multiple initiatives simultaneously and able to meet project deliverable deadlines.
• Work independently with users to define concepts.
• Review and edit requirements, specifications, business processes and recommendations related to proposed solution.
• Lead and perform complex analysis in an evolving data environment.
• Extract and analyze data, patterns, and related trends as needed, with the subsequent ability to synthesize the data into information consumable by organization.
• Provide data extraction, reports, dashboards, analysis and consultation services across organization.
• Design and roll out Business Intelligence solutions to end users.
• Ensure high levels of Business Intelligence availability through support functions and in-depth testing.
• Participate in strategic design, implementation, and maintenance of Business Intelligence software and systems, including integration with databases and data warehouses.
  
  

Business Intelligence Data Engineer Analyst Tasks

• Provide application analysis and data modeling design to collect data for centralized data warehouse.
• Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
• Proficient in the use of query and reporting analysis tools.
• Standardize data collection by developing methods for database design and validation reports.
• Work with business requirements to identify and understand source data systems; provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
• Map source system data to data warehouse tables
• Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
• Define and capture metadata and rules associated with ETL processes
• Adapt ETL processes to accommodate changes in source systems and new business user requirements
• Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
• Provide support and maintenance on ETL processes and documentation
• Build partnerships across the application, business, and infrastructure teams
• Strive to continuously improve the software delivery processes and practices
• Champion company standards and best practices
  
  

75%

• Additional Responsibilities
• Accountable for properly following all IT standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA),
• Other responsibilities and accountabilities may be assigned based on business and organization needs.
• Sets priorities for other team members on a particular initiative or project.
• Manages user expectations regarding appropriate milestones and deadlines.
• Will assist in orientation, training, work assignment and checking of less experienced developers and analysts.
• Serves as technical consultation to leaders in the IT organization and functional user groups.
• Provides documentation and status updates on behalf of a larger IT group or work stream.
• Collaborates with customers and stakeholders as well as other members of IT.
• Provide continuous improvement and implementation of ideas
• Accountable for properly following all IT standards, processes and methodologies as applicable including but not limited to Quality Assurance (QA),
• Other responsibilities and accountabilities may be assigned based on business and organization needs.
  
  

25%

Qualifications

MINIMUM QUALIFICATIONS

Education/Certification

• Four year college or commensurate work experience. Advanced degree in Science and Technology related field preferred
• 5+ years - Knowledge of AWS Infrastructure including S3, Redshift and RDS. Must have hands on client experience.
• Expertise in MS Excel.
• Expertise in SQL and relational databases
• Strong communication (verbal and written) and interpersonal skills to translate key insights from complex analyses into actionable business insights
• Proven ability of looking at solutions in unconventional ways- seeing opportunities to innovate and leading the way
• Strong proficiency in SQL
• Creative in finding new solutions and designing innovative methods, systems and processes
• Experience with building multi-dimensional data models to serve as a foundation for future analyses
• Experience with predictive modeling
• Experience with IoT, Machine Learning, and AI - Strong analytic skills for working with unstructured datasets
• Experience with connecting data sets to data visualization tools and creating reports using Tableau and Power BI
• Strong project management and organizational skills, experience working on complex initiatives with cross-functional teams in a dynamic environment
• Experience with Dell Boomi
• Experience with data visualization tools like Tableau and Microsoft Power BI
  
  

Preferred Qualifications

• Expert in ETL and/or other data manipulation languages such as Python, SAS and R
• Experienced knowledge of AWS Infrastructure including S3, Redshift and RDS
• Industry experience as a Data Engineer or related specialty (e.g. Software Engineer, Business Intelligence Engineer, and Data Scientist) with extensive professional experience and a proven track record in a role focused on understanding, manipulating, processing and extracting value from large disconnected datasets.
• 3+ years of analysis experience
• Desire to create and build new predictive/optimization tools for structuring datasets
  
  

About

At GSF, we believe that investing in our associates strengthens our culture and fuels our growth. We care about your well-being,and will support you with the following:

• Paid time off subject to eligibility, including paid leave (in compliance with state and local regulations), vacation, sick, holiday, jury duty, and bereavement.
• Comprehensive benefits package to support our associates and their families, subject to elections and eligibility: Medical, Dental, Vision, 401(k), Disability, Health and Dependent Care Reimbursement Accounts, Employee Assistance Program (EAP), Voluntary Insurance (Accident, Critical Illness, Hospital Indemnity, Legal, Life, and AD&D), Retirement Plan.
• Associate Development via Education Reimbursement and/or Scholarships, virtual courses, or classroom development experiences.
• Flexible work schedules (subject to your location and role).
• Please note that the compensation details listed in postings reflect the base pay only.
• Additional compensation including bonuses and car allowances are subject to eligibility.
  
  

The expected range for this position is $120,000–$140,000/year (For Salaried, Exempt Roles & Salaried, Non-Exempt Roles) Location, confirmed job-related skills, education, experience, and relevant training will be considered in setting the actual starting salary.

LocationUS-CA-Irvine

Job ID 2024-20436

Category Information Technology

If you have questions about this posting, please contact [e-mail]

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Lensa by 2x

Sign in to set job alerts for “Data Engineer” roles.

Santa Ana, CA $90,000.00-$95,000.00 2 weeks ago

Long Beach, CA $132,000.00-$169,000.00 1 week ago

Santa Ana, CA $112,597.33-$152,810.66 1 month ago

Irvine, CA $110,000.00-$130,000.00 1 hour ago

Irvine, CA $130,000.00-$150,000.00 1 week ago

Irvine, CA $121,500.00-$151,900.00 6 days ago

Newport Beach, CA $130,000.00-$150,000.00 3 weeks ago

Fountain Valley, CA $98,060.00-$151,008.00 1 week ago

Irvine, CA $154,000.00-$192,500.00 5 days ago

Santa Ana, CA $144,768.00-$209,109.33 1 month ago

Irvine, CA $136,858.00-$218,973.00 1 week ago

Senior Data Engineer, Information Technology – Data & Development

Business Intelligence Engineer, Amazon Ads

Irvine, CA $89,600.00-$185,000.00 6 days ago

Santa Ana, CA $126,100.00-$193,325.00 1 week ago

Irvine, CA $119,000.00-$180,000.00 1 week ago

Orange, CA $90,000.00-$100,000.00 1 day ago

Newport Beach, CA $99,000.00-$135,000.00 3 weeks ago

Software Engineer/Senior Software Engineer (Strong Python)

Santa Ana, CA $100,000.00-$150,000.00 6 days ago

Irvine, CA $110,000.00-$150,000.00 2 weeks ago

Irvine, CA $150,000.00-$180,000.00 4 days ago

Irvine, CA $150,000.00-$190,000.00 1 week ago

Irvine, CA $120,000.00-$150,000.00 1 day ago

Experienced Data Engineer- Fully Remote (US)

Irvine, CA $77,000.00-$142,600.00 12 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.