JobHabor
Menu

Business Data Analyst

The AES Group · Albuquerque, NM, United States

Mixed hiring record · median 20 days open

100100

Hiring signal

Actively hiring

Posted today · Never reposted · Checked today · How we score

First seen
16 November 2026
Reposted
Not since September 2026
Last checked
Today · still on the employer's board
All reasons
  • 33% of this employer's openings are over 60 days old

In its favour

  • Posted yesterday
  • Still listed on the employer's own board
  • Publishes a salary range

Did you apply?

Business Data Analyst at The AES Group. We’ll keep it in your applied jobs, so you can see it later and be warned before applying to the same employer twice.

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.

Skills

  • Azure
  • SQL
  • Data analysis
  • Excel
  • ETL
  • Data modeling
  • data integration
  • Data Warehousing
  • data governance
  • data quality
  • Metadata
  • Data Profiling

More jobs at The AES Group

All 45

Similar roles