Master Data Engineer III
Job Description
Simplot is seeking a Master Data Engineer III to improve the quality, consistency, and usability of master data used across strategic projects and day-to-day operations. This onsite role blends business understanding with advanced data analysis and transformation to convert business rules into practical, standardized data solutions.
What you’ll do
- Learn and document business use cases and the rules that apply to each in-scope master data attribute.
- Partner with stakeholders to reconcile differing requirements and establish consistent enterprise definitions and rules.
- Lead stakeholder meetings to define source-to-target attribute mappings that enable data standardization and system-to-system conversions.
- Profile source data to support and validate source-to-target mappings against attribute definitions and business use cases.
- Assess adherence to data standards, including naming conventions, value formats, and allowed values.
- Evaluate data accuracy, completeness, and uniqueness to identify gaps and areas for improvement.
- Create action plans with business stakeholders and coordinate resolution for identified data quality and mapping issues.
- Design, develop, and validate automated transformations to align source-system data with target-system standards.
- Define manual data transformation procedures when automation is not feasible.
- Implement data standards, governance rules, validation rules, and matching strategies.
- Run validation sessions with business stakeholders to assess completeness and accuracy of transformed data, and document readiness for production loading.
- Collaborate with Data Governance Leads to define domain-relevant data quality metrics and reporting solutions to monitor data quality.
What you bring
- At least 8 years of relevant experience in master data management, data transformation, data quality, or related work.
- Proficiency in writing SQL queries and scripts for analysis and transformation.
- Advanced Microsoft Excel skills, including complex formulas and pivot tables.
- Experience gathering and documenting requirements, defining business use cases, and translating requirements into data solutions.
- Proven ability to plan and facilitate meetings and build consensus across stakeholder groups.
- Strong interpersonal and communication skills, including working effectively with both technical and nontechnical stakeholders, and senior leaders.
- Ability to navigate ambiguity, prioritize competing demands, manage multiple projects, and deliver results in a fast-paced environment.
- Experience coordinating initiatives to improve data quality and/or data transformation processes.
- Willingness to travel up to 5%, potentially including international travel.
Technologies
- SQL
- Microsoft Excel
- Databricks
- SAP S/4HANA
- Python
Education
Bachelor’s Degree (B.A. or B.S.) from a 4 year college or university.
Preferred qualifications
- Experience with Databricks.
- Experience with SAP S/4HANA.
- Experience with Python.
This is a full-time onsite position, Monday through Friday, at Simplot HQ in Boise, Idaho. Remote and/or hybrid options are not available. Travel requirement is listed as less than 10%. Job requisition ID: 27959. Location: Boise, ID, United States.