Lead Data Business Analyst – Data Lake & Master Data Management

Centraprise, Corp.; Albuquerque (NM); On-site; USD 110,000 - 160,000; Full time

Job summary

Centraprise, Corp. seeks a Lead Data Business Analyst to guide assessment of enterprise data sources and define requirements for a unified data platform. You will shape metadata schemas, data dictionaries, and governance across Bronze–Gold layers, coordinating with stakeholders and IT teams.

You will lead workshops, translate requirements into Agile user stories, and ensure data quality, lineage, and search capabilities align with business needs for a modern data lakehouse.

Qualifications

• 8+ years of experience in business analysis, data analysis, data management, or related roles.
• At least 3 years leading data integration, data warehouse, data lake, or enterprise data assessment initiatives.
• Strong understanding of conceptual and logical data modeling, entity relationships, master data, and reference data.
• Hands-on SQL for data profiling, validation, reconciliation, and quality assessment.
• Experience with Master Data Management (MDM), golden records, entity resolution, survivorship, and match/merge logic.
• Proven experience developing source-to-target mappings, data dictionaries, business glossaries, and metadata specifications.
• Strong understanding of data quality dimensions, metrics, scorecards, and remediation requirements.
• Knowledge of data lakehouse concepts and medallion architecture (Bronze, Silver, Gold).
• Experience evaluating structured and unstructured data, including document metadata requirements.

Responsibilities

• Conduct discovery and assess data sources including databases, legacy apps, SharePoint, file shares, and GIS data.
• Lead stakeholder workshops to gather business requirements and define data search and discovery needs.
• Develop conceptual and logical data models, ERs, master records, and metadata schemas.
• Define MDM rules including golden record creation, entity matching, survivorship, and merge logic.
• Perform SQL-based data profiling and assess data quality issues.
• Create source-to-target mappings, data dictionaries, glossaries, and metadata specs.
• Define data transformation and quality requirements across Bronze, Silver, Gold layers.
• Identify governance, ownership, stewardship, privacy, security, and retention requirements.
• Define search requirements covering metadata filters, full-text search, and document relationships.
• Develop current-state assessments, gap analyses, target-state roadmaps, and backlogs.
• Translate business requirements into Agile user stories and acceptance criteria in Azure DevOps.
• Collaborate with technical teams to validate solutions against business needs.

Skills

SQL

Data Modeling

Data Governance

MDM / Golden Records

Stakeholder Management

Agile / Azure DevOps

Tools

Microsoft Purview

Azure AI Search

Azure AI Document Intelligence

Power BI

SharePoint / Microsoft 365

Job description

Lead Data Business Analyst – Data Lake & Master Data Management

Job Summary

We are seeking an experienced Lead Data Business Analyst to lead the assessment of enterprise data sources and define business requirements for a unified, searchable data platform. The ideal candidate will have strong expertise in data modeling, data quality, master data management, SQL-based data profiling, and data integration assessments.

This role will work closely with business stakeholders, records management teams, IT teams, and external agencies to understand existing data sources, define standardized document metadata, establish data governance requirements, and develop a roadmap for a modern data lakehouse platform.

Key Responsibilities

• Conduct discovery and assessment of data sources, including databases, legacy applications, SharePoint, file shares, spreadsheets, scanned documents, and GIS data.
• Lead stakeholder workshops to gather business requirements, document use cases, and define data search and discovery needs.
• Develop conceptual and logical data models, entity relationships, master record definitions, and metadata schemas.
• Define master data management rules, including golden record creation, entity matching, survivorship, and match/merge logic.
• Perform SQL-based data profiling and assess data quality issues, including duplicates, missing values, inconsistent codes, and orphaned records.
• Create source-to-target mappings, data dictionaries, business glossaries, reference data definitions, and data lineage requirements.
• Define data transformation and quality requirements across Bronze, Silver, and Gold layers of a medallion architecture.
• Identify data governance, ownership, stewardship, privacy, security, retention, and records management requirements.
• Define search requirements covering metadata filters, full-text search, document relationships, and location-based discovery.
• Develop current-state assessments, gap analyses, target-state recommendations, phased implementation roadmaps, and delivery backlogs.
• Translate business requirements into Agile user stories and acceptance criteria using Azure DevOps.
• Collaborate with technical teams to evaluate data platform capabilities and validate proposed solutions against business requirements.

Required Qualifications

• 8+ years of experience in business analysis, data analysis, data management, or related roles.
• At least 3 years of experience leading data integration, data warehouse, data lake, or enterprise data assessment initiatives.
• Strong understanding of conceptual and logical data modeling, entity relationships, master data, and reference data.
• Hands-on experience with SQL for data profiling, validation, reconciliation, and quality assessment.
• Experience with Master Data Management (MDM), golden records, entity resolution, survivorship rules, and match/merge logic.
• Proven experience developing source-to-target mappings, data dictionaries, business glossaries, and metadata specifications.
• Strong understanding of data quality dimensions, metrics, scorecards, and remediation requirements.
• Working knowledge of data lakehouse concepts and medallion architecture (Bronze, Silver, and Gold).
• Experience analyzing structured and unstructured data, including defining document metadata requirements.
• Experience gathering requirements through cross-functional workshops and communicating findings to technical and non-technical stakeholders.
• Experience creating Agile user stories and acceptance criteria in Azure DevOps.
• Excellent analytical, documentation, presentation, and stakeholder management skills.

Preferred Qualifications

• Experience in government, environmental, regulatory, public health, or other compliance-driven organizations.
• Familiarity with environmental permits, inspections, compliance records, enforcement documents, and regulatory reporting.
• Experience working with GIS data, facility identifiers, or cross-agency entity matching.
• Familiarity with EPA Facility Registry Service (FRS) or similar facility master data systems.
• Familiarity with Microsoft Purview, Azure AI Search, Azure AI Document Intelligence, Power BI, and SharePoint/Microsoft 365.
• Proficiency in Excel; Python experience is a plus.