MDM Data Analyst I-IV (Depends on Experience)
Ephrata, PA - USA
Job Summary
Closing Date to Apply: This position is openuntilfilled. Applications will be reviewed as theyare received. The position may close at any time once a sufficient pool of qualified candidates has beenestablished.
Salary:
Level I: $97786 - $163405
Midpoint: $130596
Level II: $104822 - $177107
Midpoint: $140964
Level III: $112585 - $192317
Midpoint: $152452
Level IV: $121165 - $209233
Midpoint: $165199
Grant PUD posts the full salary range for each position. The midpoint is provided as a reference point and is not a guaranteed starting pay. Starting pay is based on job-related factors such as qualifications experience skills internal alignment and organizational needs. Most new hires are typically placed between the minimum and midpoint of the range.
Benefits: This link below will provide you with Grant PUDs benefit that may be available if hired different employee types are eligible for different benefits.
Grant PUD Unified Insurance Program ()
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.
Position Summary
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 organizations 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 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 IIII.
Essential Functions
Essential functions as defined under the Americans with Disabilities Act may include the following representative duties knowledge and skills. This is not a comprehensive listing; employees may be assigned duties not listed below and reasonable accommodations will be made as required. The job description does not constitute an employment agreement and is subject to change at any time by the employer.
- This position requires NERC CIP access and incumbents must meet and maintain eligibility with the established criteria in the Grant PUD Personnel Risk Assessment Procedure. Pursuant to NERC standards Grant PUD conducts background screening of personnel who have access to the Districts critical physical and/or cyber assets.
- Executes assigned work plans safely compliantly on time and in accordance with established standards procedures and standard work practices. (Executing)
- Maintains required technical knowledge and skills serves as a reliable resource within their area of expertise and seeks training when needed. (Learning)
- Communicates effectively with supervisors peers and customers demonstrating respect and alignment with the organizations values and Code of Excellence. (Communicating)
- Identifies obstacles risks equipment issues or resource gaps and communicates them through appropriate reporting channels to maintain safety reliability and performance. (Owning)
- Conducts work consistent with Grant PUDs 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.
Specific Functions:
MDM Data Analyst I
- 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.
MDM Data Analyst II
- 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.
MDM Data Analyst III
- 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 III team members.
MDM Data Analyst IV
- 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 IIIII.
- Deliver training and mentorship for Analysts IIII 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.
Required Qualifications: (Education and Experience License and/or Certification)
MDM Data Analyst I
- Bachelors 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.
MDM Data Analyst II
- Bachelors 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.
MDM Data Analyst III
- Bachelors 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.
MDM Data Analyst IV
- Bachelors 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.
Preferred Qualifications: (Education and Experience License and/or Certification)
MDM Data Analyst I
- 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).
MDM Data Analyst II
- 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).
MDM Data Analyst III
- 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.
MDM Data Analyst IV
- Masters 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.
Other Knowledge Skills and Abilities
MDM Data Analyst I
- 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.
MDM Data Analyst II
- 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.
MDM Data Analyst III
- 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.
MDM Data Analyst IV
- 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.
Physical Requirements
- Position may be eligible for hybrid work arrangement: âYes âNo
- Majority of work is performed in a standard office setting.
- Will perform work onsite at the locations of the assigned Business Units
- Typical shift of employees in this position: â8 hours â9 hours â10 hours â12 hours
*applicant/incumbent should refer to the Physical Capacity Evaluation (PCE)
The statements contained herein reflect general details as necessary to describe the principal functions for this job the level of knowledge and skill typically required and the scope of responsibility but should not be considered an all-inclusive listing of work requirements. Individuals may perform other duties as assigned including work in other functional areas.
Required Experience:
IC