This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Lamb Weston is pursuing a modernization of its data assets and analytics environment. With executive support, Lamb Weston is building out its data assets to enable next generation analytics by strengthening its historical and diagnostic activities while enabling forward looking predictive, predictive, management science and optimization activities across it business functions. This role plays an exciting and central role in the success of this mission. The successful candidate will be supporting and migrating our legacy to our modern data environment. We be working with business partners and be empowered to build enterprise business focused data models to drive tangible and material business value.
Job Responsibility
Design, build and maintain data warehouses (existing and from scratch) using Kimball and modern data methodologies
Debug support issues with the legacy environment and support our business users
Design and implement efficient data pipelines (ETLs) to integrate data from a variety of sources into Data Warehouse as well as data model changes that align with warehouse standards and backfill or other warehouse data management processes
Evaluates data design, database architecture, metadata and repositories for performance and effective design
Develop scalable ETL data pipelines with python, SQL, and AWS cloud tools
Optimization of existing SQL queries to improve reliability and performance
Develop and execute testing strategies to ensure high quality warehouse data
Provide documentation, training, and consulting for data warehouse users
Work with cross functional stakeholders to design and architect data warehouse and analytics solutions
Perform requirement and data analysis in order to support warehouse project definition
Provide input and feedback to support continuous improvement in team processes
Analyze data to ensure information is accurate and reconcilable to its source of origin. Perform quality assurance testing as appropriate prior to releasing data/information/reports into production / end users
Requirements
Minimum BS in Computer Science or related field or combination of education and experience sufficient to perform duties at an experienced level
Minimum of 3 years experience in a technical environment with data warehouse design and implementation
3 years of programming experience in SQL, Java or Python
In depth knowledge of Snowflake
Knowledge of Informatica
1 year+ working as a DBA
Demonstrated ability to work in a team and collaborative environment
Strong communication and interpersonal skills
Love of learning new technologies and having fun
Ability to travel 10% of the time
Preferred experience with assisting with SQL environments and migrating to modern platforms like Snowflake
Preferred experience with AWS Tooling, Snowflake, Domo, and Visual Importer
Experience modeling in Kimball methodology
What we offer
Health Insurance Benefits - Medical, Dental, Vision
Flexible Spending Accounts for Health and Dependent Care, and Health Reimbursement Accounts
Well-being programs including companywide events and a wellness incentive program
Paid Time Off
Financial Wellness – Industry leading 401(k) plan with generous company contributions, Financial Planning Services, Employee Stock purchase program, and Health Savings Accounts, Life and Accident insurance
Family-Friendly Employee events
Employee Assistance Program services – mental health and other concierge type services