MDM Data Analyst I-IV (Depends on Experience)

Grant County Public Utility District•Ephrata, WA

4d•$97,786 - $209,233•Hybrid

About The Position

This position is open until filled and applications will be reviewed as they are received. The position may close at any time once a sufficient pool of qualified candidates has been established. Grant County PUD will administer a background check as part of the hiring process, if selected for this position. Applicants meeting minimum qualifications may be further evaluated based on preferred qualifications and job-related criteria. Only the most qualified candidates will be referred for further consideration. The District may use the applicant pool and results from this recruitment to fill additional vacancies in the same classification for up to six (6) months following the recruitment closing date, consistent with District policy and applicable law. MDM Data Analyst I: The MDM Analyst I is an entry-level professional role responsible for executing assigned master data stewardship, validation, and rule-based data quality activities within the organization’s Master Data Management (MDM) program. Working under general guidance and established governance standards, this role applies business rules, analyzes data exceptions, maintains domain structures and metadata, and supports reliable master data across enterprise systems. In partnership with business subject-matter experts (SMEs), this role contributes to a trustworthy enterprise data foundation through record-level stewardship, data quality validation, issue resolution, and maintenance of domain data standards while developing proficiency in MDM principles, business domains, and governance processes. MDM Data Analyst II: The MDM Analyst II is a professional analyst role responsible for independently executing and improving data quality, domain integrity, and governance processes across assigned master data domains. The Analyst II collaborates with business partners to translate domain requirements into MDM rules and structures within Profisee (SaaS), performs profiling, matching and survivorship review, and maintains versioned metadata. This role exercises judgment in resolving data quality issues, refining rule logic, and recommending improvements that support accuracy, consistency, and traceability of master data across applications. MDM Data Analyst III: The MDM Analyst III serves as a senior-level data stewardship and rule-design expert responsible for governing multiple master data domains and ensuring enterprise-wide data quality, consistency, and trust. This role independently designs and configures complex MDM logic, including match rules, survivorship patterns, DQ rules, domain hierarchies, and cross-domain validation requirements within Profisee SaaS. The Analyst III partners with business SMEs, data engineers, and analytics teams to define domain structures, steward rule changes, resolve cross-system data quality issues, mentor junior analysts, and help shape stewardship processes, domain playbooks, and best practices. MDM Data Analyst IV: The MDM Analyst IV is the senior-most enterprise data stewardship and governance expert responsible for shaping master data consistency, rule standards, domain integration patterns, and cross-system data quality strategy. This role leads multi-domain stewardship activities, serves as the primary authority on business rules, domain hierarchies, and survivorship logic, and ensures MDM outputs are trusted across analytics, finance, operations, and compliance functions. The Analyst IV partners with the MDM Architect, Data Engineering, and business leadership to drive strategic data quality initiatives, guide enterprise rule catalogs, lead cross-functional governance forums, and mentor analyst levels I–III.

Requirements

Bachelor’s degree in data analytics, information systems, computer science, business analytics, data management, or related field; or 2 additional years of relevant experience in lieu of degree.
Two years of experience in master data, data stewardship, data quality, data operations, data governance, business data support, or related data work.
Requires foundational MDM concepts, data quality validation, business rule application, metadata/domain maintenance, issue triage, structured workflows, basic SQL or data profiling, and ability to support assigned master data domains or stewardship tasks.
Bachelor’s degree in a related field; or 2 additional years of relevant experience in lieu of degree.
Four years of progressively responsible experience in master data, data stewardship, MDM, data quality, data governance, data operations, or related data work.
Requires MDM platform or master data tool experience, preferably Profisee; domain-level stewardship; data profiling; validation rules; match/merge review; survivorship concepts; metadata and lineage; issue resolution; business rule documentation; and independent ownership of assigned master data domains.
Bachelor’s degree in a related field; or 2 additional years of relevant experience in lieu of degree.
Six years of progressively responsible experience in MDM, data stewardship, data quality, data governance, data operations, or related technical data management work.
Requires advanced MDM/data stewardship experience, Profisee or comparable MDM platform experience, complex business rule design, advanced profiling, cross-domain validation, match/merge logic, survivorship frameworks, metadata/lineage standards, mentoring, and ability to lead cross-domain MDM issue resolution.
Bachelor’s degree in a related field; or 2 additional years of relevant experience in lieu of degree.
Eight years of progressively responsible experience in MDM, data stewardship, data quality, data governance, enterprise data management, or related technical data management work.
Requires expert MDM/data governance expertise, Profisee or comparable MDM platform experience, enterprise rule standards, data quality KPIs, master data domain standards, metadata and lineage governance, cross-domain stewardship frameworks, governance forum support, advisory experience, and ability to guide enterprise master data quality practices.
Detail-oriented, with the ability to apply established consistency across assigned domain configurations and work effectively with Data Stewards, Data Governance, and technical teams under guidance.
Strong communication and documentation skills appropriate for technical and non-technical collaborators.
Ability to clarify requirements, verify assumptions, and apply sound judgment within established governance standards while developing proficiency in MDM principles, domain structures, and governance processes.
Able to translate domain rules into MDM platform logic with strong analytical and problem-solving abilities.
Capable communicator who explains data issues to non-technical partners; collaborative, organized, and able to work independently on assigned domains.
Demonstrates growing judgment in identifying rule conflicts, match/anomaly patterns, and upstream data quality problems.
Able to lead requirements gathering with SMEs and translate requirements into MDM rule logic.
Effective communicator who facilitates discussions with business users, IT teams, and leadership and represents the MDM program in impact assessments, quality reviews, and governance sessions.
Demonstrates strong judgment in rule design, conflict resolution, and cross-domain alignment; organized and able to manage multiple domain initiatives concurrently.
Demonstrates leadership through mentoring, training, and stewardship adoption advocacy.
Exceptional communication skills, with the ability to explain complex rule logic and data issues to executives and technical staff and drive consensus across stakeholders.
Expert in translating business policies into system-enforceable rules with deep understanding of data relationships, classification models, and cross-domain dependencies.
Highly organized and capable of managing enterprise-wide scope and multiple domains concurrently; demonstrates maturity in governance, diplomacy, leadership, and partnership-building.

Nice To Haves

Understanding of business processes in at least one relevant domain (Finance, Supply Chain, Customer, Product).
Progress toward CDS – Certified Data Steward, DGSP – Data Governance and Stewardship Professional, or CDMP – Certified Data Management Professional (Associate level).
Domain experience in at least one business area (Finance, Supply Chain, Customer, Product).
Progress toward CDS – Certified Data Steward, DGSP – Data Governance & Stewardship Professional, or CDMP (Practitioner Level).
Deep domain experience in two or more business areas (Finance, Customer, Product, Supplier).
Understanding of conceptual/logical data modeling techniques and experience with enterprise data governance or DG councils.
CDS – Certified Data Steward, DGSP – Data Governance & Stewardship Professional, or CDMP (Mastery Level) strongly preferred.
Master’s degree in Business, Finance, Analytics, Information Systems, or related field.
Expertise in MDM methodologies, including match/merge strategies, survivorship design, and hierarchy management.
Experience partnering with architects and engineers to influence data models and ingestion patterns and enterprise-level experience in financial, operational, or regulatory data use cases.
DGSP – Data Governance & Stewardship Professional, CDMP (Mastery Level), Certified Data Steward (CDS), or DAMA/DCAM coursework or certification strongly preferred.

Responsibilities

Executes assigned work plans safely, compliantly, on time, and in accordance with established standards, procedures, and standard work practices.
Maintains required technical knowledge and skills, serves as a reliable resource within their area of expertise, and seeks training when needed.
Communicates effectively with supervisors, peers, and customers, demonstrating respect and alignment with the organization’s values and Code of Excellence.
Identifies obstacles, risks, equipment issues, or resource gaps and communicates them through appropriate reporting channels to maintain safety, reliability, and performance.
Conducts work consistent with Grant PUD's mission, vision, values, strategic plan, and the Grant PUD/IBEW Local 77 Code of Excellence.
Maintains knowledge of and adheres to applicable laws, regulations, security requirements, and Grant PUD policies and procedures required for the position.
If operating a GPUD vehicle for business purposes, follows the Vehicle/Asset Usage Policy, IS-TA-POL-001.
Actively participates in the safety program by following safety policies and procedures; alerting supervisors and coworkers to unsafe or hazardous conditions; reporting safety incidents or close calls within 24 hours; and accepting feedback regarding safety performance.
Perform assigned stewardship tasks within Profisee (SaaS), including record validation, attribute updates, enrichment, corrections, standardization, simple derivations, and data quality exception handling.
Execute data quality checks and profiling; analyze discrepancies, patterns, anomalies, and potential quality issues; apply approved resolution steps and escalate non-routine issues as appropriate.
Maintain domain dictionaries, hierarchies, segments, lists, attribute mappings, and metadata in accordance with established governance standards and naming conventions.
Execute MDM workflows, de-duplication and candidate-match reviews, validate match/merge and survivorship outcomes, and perform assigned import/export tasks following established controls.
Maintain clear documentation of corrections, decisions, exceptions, and working-session outcomes in Confluence/SharePoint.
Participate in UAT for assigned rule configurations, domain enhancements, and data quality test cases; document outcomes.
Collaborate with business partners to understand data meaning, basic domain rules, approval workflows, and assigned stewardship requirements.
Run Profisee validation jobs and monitor basic data quality metrics for assigned domains.
Independently execute stewardship and data quality processes for assigned domains in Profisee and serve as primary steward for at least one master data domain.
Design and configure simple to moderately complex validation, standardization, enrichment, and attribute-derivation rules; conduct profiling to identify trends, anomalies, and rule improvements.
Manage match/merge tasks, evaluate candidate groups, identify false positives/negatives, and design or maintain survivorship and attribute-precedence logic.
Maintain domain hierarchies, relationships, data dictionaries, attribute definitions, metadata, lineage, traceability, stewardship decisions, and change history.
Collaborate with SMEs to refine domain logic, validation conditions, workflow steps, and business rules; track and resolve data quality exceptions.
Analyze upstream data issues, perform complex corrections, merges, unmerges, and updates within domain guidelines, and recommend rule or process improvements.
Coordinate and execute UAT for assigned MDM releases or rule changes; validate outcomes and document defects or refinements.
Participate in governance meetings and partner with senior analysts on cross-domain rule alignment, impact analysis, domain readiness, and data health.
Own stewardship, domain modeling, and rule design for multiple master data domains and partner with SMEs and MDM Architects to define models, hierarchies, attribute standards, reference data mappings, and shared canonical structures.
Design, configure, test, and tune complex data quality rules, conditional and cross-domain validations, standardization, enrichment, thresholds, and issue-handling workflows.
Lead advanced profiling and health checks across systems to identify root causes, evaluate rule changes, and recommend logic fixes or upstream corrections.
Design and optimize multi-pass matching, including fuzzy, exact, phonetic, composite-key, identity-resolution, trust-score, and precedence logic; lead duplicate remediation, survivorship conflicts, and complex unmerge/lineage correction.
Lead UAT and approval cycles for new rules, domains, and MDM features; facilitate rule walkthroughs and impact assessments with governance groups.
Maintain data dictionaries, design specifications, lineage, rule catalogs, versioned rule history, revision notes, and governance playbooks.
Partner with Data Engineering on ingestion requirements and MDM integration patterns, including batch sync, APIs, event-driven integration, and reference-data lookups.
Represent MDM in cross-functional meetings; contribute to roadmap planning, domain sequencing, readiness, and interdependency analysis.
Serve as a functional Profisee subject-matter expert and provide coaching, mentoring, and oversight to Analyst I–II team members.
Own enterprise stewardship processes, rule catalogs, multi-domain governance standards, and complex data quality frameworks, including matching, survivorship, exception processes, and domain reference integrations.
Facilitate governance councils and drive cross-domain alignment on definitions, hierarchies, business rules, domain modeling standards, ownership, and stewardship responsibilities.
Serve as liaison between business leadership and technical teams for data quality transparency, issue reporting, and enterprise initiatives involving finance transformation, analytics modernization, ERP upgrades, or application onboarding.
Conduct advanced profiling, cross-system lineage analysis, fit-gap assessments, enterprise impact assessments, and root-cause analysis; lead cross-functional remediation efforts.
Lead enterprise UAT and rule-optimization cycles for major releases, domain expansions, or Profisee updates.
Own enterprise rule documentation, business glossaries, data dictionaries, relationship maps, metadata lineage, versioning processes, data quality KPIs, issue classification standards, and remediation workflows.
Serve as escalation point for complex match/survivorship conflicts, data exceptions, and domain ambiguity; review and approve rule designs submitted by Analysts II–III.
Deliver training and mentorship for Analysts I–III and business domain partners.
Support audits, compliance requests, and regulatory reporting requiring high-quality master data and serve as a key advisor for enterprise data strategy and quality roadmap planning.