Data Governance & Automation Analyst

United States Bakery External • Vancouver, WA

3d

About The Position

Franz Family Bakery is seeking a Data Governance & Automation Analyst to support the quality, consistency, governance, and automation of ERP master and reference data. The role processes and validates approved data requests, maintains records and cross-system mappings, investigates data-quality issues, and supports setup, migration, testing, and deployment activities across Microsoft Dynamics NAV, Dynamics 365 Business Central, integrations, reporting platforms, and approved downstream systems.

The analyst also identifies recurring data-maintenance tasks that could be simplified or automated, then builds and maintains practical Power Automate workflows and lightweight Power Apps or other low-code tools within established standards. The role documents procedures and controls, maintains audit-ready records, communicates requirements and corrections to users, and recommends improvements to data quality and master-data processing. The position supports Franz Core Values and includes other related duties as assigned.

Requirements

• 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 and ability to work effectively with business users, data owners, and technical teams.
• Ability to manage multiple priorities while maintaining accuracy and following established procedures.

Nice To Haves

• 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.

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 master-data consistency 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.

Benefits

• Competitive wages: $36.06–$43.27 hourly
• Growth and development opportunities
• Generous holiday and vacation
• Comprehensive healthcare
• 100% employer-paid healthcare premiums for the employee and all eligible dependents
• Profit-sharing and 401(k) plans
• 50% discount on Franz products

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: No Education Listed