Role: Business Data Analyst
Location: Albuquerque, NM
Let’s create our future together at The AES Group!
Position Overview
As a Business Data Analyst, you will lead business discovery, source-system assessment, data profiling, and requirements definition for an enterprise data integration initiative.
You will collaborate closely with government stakeholders, program teams, partner agencies, and technical engineering teams to understand existing data environments and translate business needs into actionable data requirements, conceptual and logical data models, and source-to-target mappings.
The ideal candidate combines strong SQL and data analysis capabilities with excellent stakeholder management, requirements gathering, and documentation skills.
Key Responsibilities
1. Data Discovery and Stakeholder Engagement
- Identify and inventory data sources, including permitting systems, legacy applications, SharePoint, file repositories, scanned documents, GIS layers, and spreadsheets.
- Assess data ownership, volume, formats, refresh frequency, quality, accessibility, and integration constraints.
- Conduct requirements workshops with business units covering air, water, waste, land, enforcement, IT, records management, and partner agencies.
- Identify business users, search requirements, user personas, and operational use cases.
2. Data Analysis, Modeling, and Quality
- Define enterprise data entities and metadata schemas covering document types, permit numbers, facilities, applicants, locations, programs, statuses, dates, and related records.
- Develop entity resolution and matching rules to identify duplicate facilities, permittees, and regulatory records across multiple systems.
- Perform hands-on SQL-based data profiling to identify duplicates, missing identifiers, inconsistent reference codes, and orphaned records.
- Develop conceptual and logical data models, entity relationship diagrams, data dictionaries, and business glossaries.
- Establish source-to-target mappings across Bronze, Silver, and Gold layers of the medallion architecture.
- Define data cleansing, standardization, validation, and conformance requirements.
- Identify sensitive information, including personally identifiable information (PII) and enforcement-sensitive records.
3. Business Requirements and Documentation
- Gather and document functional and non-functional requirements for enterprise search capabilities, including metadata search, full-text search, filters, map-based search, and record relationships.
- Develop current-state assessments, gap analyses, target-state recommendations, and phased implementation roadmaps.
- Translate business requirements into actionable Agile user stories, acceptance criteria, and backlogs using Azure DevOps.
- Define data governance, ownership, stewardship, reference data, and quality management requirements.
- Present findings, recommendations, and proposed solutions to business stakeholders and leadership.
Required Qualifications
- 8+ years of experience as a Business Analyst, Data Analyst, or in a related data-focused role.
- At least 3 years of experience leading data integration, data warehouse, data lake, or enterprise data modernization assessments and requirements initiatives.
- Advanced to expert-level SQL skills with hands-on experience in data profiling, validation, and analysis.
- Strong proficiency in Excel and experience analyzing large, complex datasets.
- Solid understanding of conceptual and logical data modeling, entity relationships, master data, and reference data.
- Experience developing source-to-target mappings, data dictionaries, business glossaries, and functional requirements documentation.
- Proven ability to facilitate cross-functional requirements workshops and engage effectively with non-technical stakeholders.
- Strong Microsoft technology experience, including Azure, with familiarity with modern data platforms, data lakes, lakehouse concepts, and medallion architecture.
- Excellent analytical, problem-solving, communication, presentation, and documentation skills.
Preferred Qualifications
- Experience with Master Data Management (MDM), including golden records, survivorship rules, matching, and merge logic.
- Familiarity with data quality frameworks, quality dimensions, validation metrics, and scorecards.
- Experience analyzing unstructured data and defining document classification and metadata requirements.
- Hands-on experience creating Agile user stories and managing backlogs in Azure DevOps.
- Working knowledge of Python for data analysis and automation.
- Experience supporting government, environmental, natural resources, public health, or regulatory agency programs.
- Familiarity with environmental regulatory data, including Air Permits, NPDES, Stormwater, and RCRA.
- GIS data literacy and familiarity with EPA Facility Registry Service (FRS) or similar facility master data solutions.