ERP Master Data Manager

About Western Building Supply

Western Building Supply is a fast-growing component manufacturer on a mission to build people and lasting relationships—exceptional products and service are the by-products. We don't sell on price; we solve real problems for builders and contractors across the Mountain West. Our aim is clear: become the #1 component manufacturer in the pole-barn industry.

We're leveling up our digital backbone—Paradigm + SmartBuild, cleaner item master data, rock-solid GL mapping, and a customer portal that's fast, accurate, and easy. We believe simple scales, complex fails—so we're standardizing, automating, and measuring what matters. If you love turning messy data into trustworthy decisions and want your work to impact sales, operations, and finance every single week, you'll thrive here.

Why this role matters right now

• Scale with clarity: 8,000+ SKUs cleaned, standardized, and governed so quotes and costs are right the first time.
• Financial truth: Revenue, COGS, and Inventory that reconcile cleanly—month-end without drama.
• Contractor experience: A portal and workflows that feel world-class because the data underneath is.

If excellence as a habit is your default and you're hungry to ship real improvements, Welcome to Western.

The Mission

Build clean, reliable, and scalable data across our ERP stack so Sales, Ops, and Finance move fast with confidence. You'll own item/GL integrity, workflow rules in Paradigm and SmartBuild, and the SQL layer that powers audits and reporting.

What You'll Own

• ERP Data Hygiene & Structure
• Design/maintain Item Classes, attributes, categories, and naming standards.
• Enforce rock-solid GL mappings (Revenue / COGS / Inventory / Prepayments / Returns).
• Financial Integrity
• Trace transaction flows; reconcile Revenue COGS Inventory by scenario (stock, special order, dropship, returns).
• Find/fix misposts and mapping gaps; document root causes and prevention.
• Workflow & System Build-Out
• Configure/QA rules in Paradigm and SmartBuild (length limits, color selects, add-ons, prompts).
• Ship clear SOPs and regression test packs for every change.
• Reporting, SQL & Automation
• Author SQL scripts to extract, transform, validate, and monitor data (exception reports, reconciliations, and ops dashboards).
• Build high-trust Excel/Google Sheets models fed by SQL extracts for A/R, pipeline, margin, inventory turns, and audit trails.
• Stand up red-flag monitors (e.g., color ≠ coil, unmapped COGS, negative inventory, orphaned SKUs).
• Quality Assurance
• Write test plans, run regressions after each release, maintain a clean change log.

Must-Have Skills

• ERP Mastery: 3+ years deep in item master, costing, GL mapping, inventory flows.
• GL & Costing Fluency: Knows how transactions hit P&L and Balance Sheet.
• SQL Scripting (hands-on):
• Comfortable writing SELECT/JOIN/GROUP BY/CASE/UNION queries; building data-quality checks and reconciliation scripts.
• Able to optimize for readability and performance; designs tables/views/extracts that downstream users can trust.
• Excel / Google Sheets Expert: INDEX/XMATCH/XLOOKUP, ARRAY formulas, QUERY, PivotTables, data validation, error trapping.
• Database Mindset: Normalization, keys, constraints, schema thinking; understands how to model business logic.
• Detail-Obsessed Communicator: Tight documentation, clear English, proactive daily updates.

Nice-to-Have

• Experience with Paradigm ERP and/or SmartBuild (big plus).
• Manufacturing/building-materials background (assemblies/BOMs/cut-lists).
• Google Apps Script or VBA for light automation.
• Familiarity with Paradigm SQL constraints (e.g., no CTEs; no alias reuse in ORDER BY/GROUP BY).

Tools You'll Use

Paradigm, SmartBuild, SQL (RDBMS varies), Excel/Google Sheets, Google Drive, Slack/Email, basic BI.

How to Apply

Email with subject "ERP Analyst", and include:

• 3–5 bullets on your ERP + GL experience
• 1–2 SQL scripts you've written (sanitized) or screenshots + explanation (If applicable)
• A spreadsheet/report sample you built
• Your internet speed test + weekly availability
• Send a short video of the following.
• 1. Who are you? Your name, years of ERP experience, primary systems you've worked in.
• 1. What makes you excited?
• 1. Why you are applying for this position.

Job Type: Full-time

Pay: Php90, Php120,000.00 per month

Work Location: Remote