MDM Data Quality Analyst

Job Description

Job Description

MDM Data Quality Analyst (Informatica MDM, SQL & Power BI):

Total Required Experience in Years: 12+ Years

Mode of Work: 100% Onsite Austin, TX Locals Only

The MDM Data Quality Analyst will ensure the accuracy, completeness, consistency, and reliability of enterprise master data. The role requires strong hands-on experience in data quality analysis, SQL, data profiling, relational and dimensional data models, data validation, and development of metrics and KPIs.

The analyst will work closely with business and technical teams to identify and resolve data discrepancies, establish data quality rules, monitor trends, and develop management-level dashboards and scorecards.

Important: Candidates must currently reside in Austin, TX and be willing to work 100% in-office .

Key Responsibilities:

• Define, document, and enforce enterprise data quality rules.

• Profile and analyze master data to identify anomalies, patterns, trends, and quality issues.

• Perform regular data quality testing and validation.

• Identify and investigate data discrepancies.

• Perform root-cause analysis of data-quality issues.

• Work with business and technical teams to resolve data issues.

• Develop data quality dashboards and scorecards.

• Create and track measures, metrics, and KPIs.

• Monitor and report data quality trends.

• Develop management-level data quality reporting.

• Validate data accuracy, completeness, consistency, and integrity.

• Query and analyze enterprise data using SQL.

• Work with both relational and dimensional data models.

• Support MDM and data governance initiatives.

Additional Responsibilities:

• Profile enterprise data using Informatica MDM.

• Develop advanced visualizations using Power BI, Tableau, or similar tools.

• Provide data-quality findings and recommendations to management.

• Support data remediation and reconciliation activities.

• Maintain data-quality documentation and reporting.

• Collaborate with data owners, stewards, business users, and technical teams.

• Support continuous improvement of enterprise data-quality processes.

Required Skills:

• Minimum 7+ years of Data Quality Analysis experience , preferably within an MDM environment.

• Strong hands-on SQL and database querying skills.

• Experience with relational data models .

• Experience with dimensional data models .

• Proven experience creating and tracking:

  • Measures

  • Metrics

  • KPIs

  • Data Quality Trends

• Experience defining and enforcing data-quality rules.

• Experience with data profiling and analysis.

• Experience performing data-quality testing and validation.

• Experience identifying and resolving data discrepancies.

• Strong analytical and problem-solving skills.

• Strong business and technical stakeholder collaboration skills.

Preferred Skills:

• Hands-on experience profiling data using Informatica MDM .

• Advanced Power BI experience.

• Advanced Tableau or similar data-visualization experience.

• Management-level dashboard and reporting experience.

• State of Texas experience.

• Other state government experience.

• State retirement system experience.

• Experience working with:

  • Pension Data

  • Benefits Data

  • Member Master Data

  • Employer Master Data

  • Financial Master Data

• Data governance and data stewardship experience.

Qualifications:

• Must currently reside in Austin, TX .

• Must be willing to work 100% in-office .

• Resume must clearly demonstrate required experience within the candidate\'s actual project/work history.

• Strong attention to data accuracy and detail.

• Ability to independently investigate complex data-quality issues.

• Strong written and verbal communication skills.

• Ability to communicate technical data-quality findings to management and business stakeholders.

Education:

• Bachelor\'s degree in Information Systems, Computer Science, or a related field Required

• Master\'s degree in Information Systems, Computer Science, or a related field Strongly Preferred

Certifications:

• Informatica MDM Certification Preferred

• Microsoft Certified: Power BI Data Analyst Associate Preferred

• DAMA Certified Data Management Professional (CDMP) Preferred

• Tableau Certification Preferred