Business Intelligence Data Engineer

Golden State Foods is seeking a hands-on Business Intelligence Data Engineer to join our Frisco, TX on-site team. The role centers on building and maintaining the data warehouse and ETL/ELT pipelines, evaluating BI and data-warehouse tools, and powering reporting and visualization for users across the organization. A four-year degree in a quantitative field and strong SQL plus ETL experience form the foundation for success in this role.

Responsibilities

• Interpret business requirements to identify source data systems, resolve data issues, and coordinate with data analysts to validate needs; conduct user and developer interviews to gather requirements.
• Map data from source systems to data warehouse tables.
• Design, test, and validate data flows; implement ETL/ELT processes aligned with business requirements and ensure design specifications reflect those requirements.
• Define and capture metadata and rules associated with ETL processes.
• Adapt ETL processes to accommodate changes in source systems and evolving business needs.
• Collaborate with developers and business users to gather data and execute ETL programs and scripts; support data warehouse activities and prepare related reports.
• Provide ongoing support and maintenance for ETL processes and related documentation.
• Foster partnerships across application, business, and infrastructure teams.
• Pursue continuous improvement of software delivery practices and processes.
• Champion company standards and best practices.

Requirements

• A four-year college degree in Computer Science, Computer Information Systems, or commensurate work experience.
• Experience as a BI Data Engineer or related roles (e.g., Software Engineer, BI Engineer, Data Scientist) with a track record in understanding, manipulating, processing, and extracting value from various systems.
• Strong proficiency in SQL.
• Expertise with ETL tools such as Matillion, Informatica, SSIS, ODI, and/or other data manipulation languages such as Python, SAS, and R.
• Creative in designing innovative methods, systems, and processes.
• Desire to create and build predictive or optimization tools for structuring datasets.
• Extensive experience in Data Warehousing development: Star Schema modeling, slowly changing dimensions, row-level security, standard DW architecture, troubleshooting, and production support.

Technologies

• Matillion
• Informatica
• SSIS
• ODI
• Python
• SAS
• R
• SQL
• AWS Redshift
• AWS EC2
• AWS S3
• PowerBI

Benefits

• Comprehensive benefits package supporting holistic wellness.

Why Join Us

• People First: Golden State Foods fosters a community where talent is celebrated and ambitions are nurtured.
• Values Driven: Core values of innovation, integrity, and excellence guide daily work and long-term impact.
• People Development: The company emphasizes ongoing development to prepare for tomorrow's needs.
• Philanthropy & Sustainability: Commitments extend beyond the workplace through global philanthropy and sustainability efforts.
• Extensive Benefits: A holistic approach to wellness with benefits designed to support the whole person.

GSF Values

• TRUST: Demonstrates fairness, leads by example, keeps commitments, and admits mistakes to maintain trust.
• INSPIRATION TO OTHERS: Supports colleagues, helps develop ideas, seeks success for the team, and addresses process failures rather than blaming people.
• DRIVES TOWARD HIGHEST QUALITY RESULTS: Creative, quality-focused, and willing to take prudent risks; embraces change and strives for annual goals.
• INTEGRITY: Acts honestly in all situations, treats customers fairly, and does the right thing even when unsupervised.
• OPEN & HONEST COMMUNICATION: Communicates timely and directly, listens with empathy, and seeks full context before conclusions.
• TEAM PLAYER/PARTNERSHIP: Supports others, shares credit, and prioritizes collective success over individual wins.

Travel

Regular travel requirements are expected to be less than 5 percent.

Management Responsibility

N/A

Core Competencies

The organization notes universal core competencies apply across roles; specifics vary by job and grade level.