Data Governance & Automation Analyst

Are you ‘bread’ for success?

Come make $ dough $ with us!

Franz Family Bakery was founded in 1906 in the Pacific Northwest and has become one of country’s most successful bakeries. We produce a variety of baked products, marketed under a wide range of premium labels, all made with quality ingredients and a superior baking process. We employ over 4,000 employees and distribute our products in Alaska, Idaho, California, Utah, Montana, Oregon, and Washington. Take your career to the next level and join our exciting team. Franz offers employees excellent benefits including:

• Competitive Wages:
  • $36.06 - 43.27 hourly rate
• Growth and Development Opportunities
• Generous Holiday and Vacation
• Comprehensive Healthcare
  • 100% Employer paid healthcare premiums for employee and all eligible dependents
• Profit Sharing and 401K plans
• 50% Discount Franz Products

Primary Duties and Responsibilities

• Process approved requests to create, update, correct, or retire customer, location, route, item/SKU, vendor, pricing, and related ERP reference data.
• Validate requests for completeness, required approvals, business-rule compliance, duplicate risk, effective dates, and downstream impact before updating ERP records.
• Apply established naming conventions, coding standards, source-of-truth rules, required fields, and data-quality controls across assigned master-data domains.
• Perform recurring data-quality reviews, reconciliations, and audits; investigate missing, duplicate, inconsistent, outdated, or incorrectly mapped records.
• Coordinate issue resolution with business data owners, requestors, ERP support, integration teams, and other technical resources.
• Maintain cross-system mappings and verify that master data remains consistent across Microsoft Dynamics NAV, Dynamics 365 Business Central, integrations, reporting platforms, and approved downstream systems.
• Support new-item, customer/location, route, vendor, pricing, and related setup processes using approved workflows and documented procedures.
• Maintain request status, validation evidence, approval history, change records, exception details, and audit-ready documentation.
• Identify repetitive data-maintenance and validation activities that can be simplified or automated.
• Build and maintain practical Power Automate workflows and lightweight Power Apps or low-code tools for intake, approvals, validations, notifications, exception routing, and status tracking within established standards.
• Test workflow changes, document dependencies and support procedures, monitor automated processes, and troubleshoot or escalate failures.
• Support data mapping, cleansing, migration validation, setup-data readiness, NAV-to-Business Central comparisons, reconciliation, testing, cutover, and post-deployment data stabilization.
• Create and maintain data dictionaries, standard operating procedures, data-entry guides, validation checklists, ownership records, and exception-handling documentation.
• Provide clear communication and user guidance on data requirements, request status, corrections, and approved procedures.
• Recommend improvements that strengthen data quality, reduce rework, improve traceability, and streamline master-data processing.
• Support and adhere to Franz Core Values.
• Perform other related duties as assigned.

Preferred Education/Experience

• Associate or bachelor's degree in Information Systems, Business, Data Management, Supply Chain, Computer Science, or a related field; or an equivalent combination of education, technical training, and relevant experience.
• Experience with Microsoft Dynamics 365 Business Central, Microsoft Dynamics NAV, or a comparable ERP platform.
• Experience supporting customer, item/SKU, vendor, route, pricing, or related reference-data processes.
• Experience with Microsoft Power Automate and Power Apps for workflow, approval, notification, validation, or intake solutions.
• Familiarity with Dataverse, APIs, SSIS/ETL processes, or ERP integrations.
• Experience supporting ERP implementations, data migrations, system cutovers, or post-deployment stabilization.
• Experience with data mapping, data cleansing, duplicate detection, cross-system reconciliation, or migration validation.
• Experience in manufacturing, food production, distribution, retail, logistics, or supply-chain environments.
• Familiarity with data governance, data stewardship, internal controls, or audit-support practices.

Critical Skills and Expertise

• One to two years of relevant experience in ERP master data, data governance, business systems, data operations, process improvement, workflow automation, or a related field.
• Experience creating, maintaining, validating, or reconciling master or reference data in an ERP or other enterprise business application.
• Understanding of data-quality concepts, including completeness, accuracy, consistency, uniqueness, timeliness, validation, and auditability.
• Experience following documented data standards, approval workflows, change controls, and security requirements.
• Strong Microsoft Excel skills for data comparison, cleansing, validation, and analysis.
• Working SQL skills for approved data investigation, record comparison, and reconciliation.
• Experience documenting procedures, data definitions, business rules, test results, exceptions, and corrective actions.
• Ability to investigate data issues, identify likely causes, coordinate resolution, and validate completed corrections.
• Ability to translate repetitive business processes into clear workflow requirements and support practical automation solutions.
• Strong analytical, organizational, problem-solving, and attention-to-detail skills.
• Strong written and verbal communication skills with the ability to work effectively with business users, data owners, and technical teams.
• Ability to manage multiple priorities while maintaining accuracy and following established procedures.