Sr. Business Analyst - Sensitive Data Management

esri; Redlands (CA); On-site; USD 120,000 - 170,000; Full time

Job summary

Esri in Redlands, CA is seeking a senior Business Analyst who can drive discovery, requirements engineering, data analysis, and migration validation across Finance and HR data domains.

You will translate business needs into implementation-ready technical specifications, coordinate with data engineers, and support governance, security, reconciliation, UAT, and audit-ready documentation throughout Fabric migrations.

Qualifications

• 5+ years of direct business analysis experience supporting data, analytics, BI, or data warehouse initiatives.
• Demonstrated ability to translate business requirements into functional specifications, data mappings, acceptance criteria, and test plans.
• Intermediate to advanced querying and analysis skills using SQL Server tools and Excel.
• Knowledge of dimensional modeling concepts, semantic models, reporting layers, measures, KPIs, and data lineage.
• Experience supporting data validation, reconciliation, defect triage, UAT, and production readiness for critical reporting.
• Strong written and verbal communication skills adaptable to SMEs, engineers, and executives.

Responsibilities

• Partner with Finance, HR, and technical stakeholders to gather, analyze, and document requirements.
• Facilitate workshops to understand current-state processes, reporting needs, data warehouse usage, pain points, controls, and objectives.
• Translate requirements into implementation-ready specifications, including mappings, transformation rules, and acceptance criteria.
• Create and maintain project documentation: data dictionaries, data models, and traceability matrices.
• Collaborate with data engineers to define business rules, resolve gaps, and support development planning.
• Design and coordinate validation activities for migrated data products using reconciliation, testing, and defect tracking.
• Establish data quality, validation, parity reporting, and monitoring solutions using BI tools.
• Document governance, security, and compliance requirements including RBAC, PII, retention, lineage, and audit needs.
• Lead UAT planning, script development, readiness assessments, and post-migration validation support.

Skills

Data analysis

Requirements gathering

Stakeholder management

SQL

Power BI

T-SQL

Documentation

Education

Bachelor's degree in a related field

BA/BS in Information Systems, Analytics, or similar

Tools

Microsoft Fabric

Azure Data Factory

Azure Synapse

Power BI

SQL Server

Data dictionaries

Job description

Overview

This role is intended for a senior Business Analyst who can operate across business process discovery, requirements engineering, data analysis, and migration validation. The analyst will work directly with Finance and HR subject matter experts to understand current-state data warehouse usage, document the future-state needs for Fabric, and help engineering teams convert business requirements into actionable technical specifications. The role involves sensitive Human Resources and Finance data, the BA should be comfortable documenting restricted data elements, role-based access needs, data quality expectations, and validation evidence while maintaining appropriate confidentiality and auditability.

Be part of a dynamic collaborative environment and join the team at our stunning campus in Redlands, CA, where your analytical skills will help drive strategic business decisions.

Responsibilities

• Partner with Finance, HR, and technical stakeholders to gather, analyze, and document business, functional, non-functional, reporting, and security requirements
• Facilitate workshops to understand current-state processes, reporting needs, data warehouse usage, pain points, controls, and business objectives
• Translate business requirements into implementation-ready specifications, including source-to-target mappings, transformation rules, business logic, exception handling, and acceptance criteria
• Create and maintain project documentation, including process flows, data dictionaries, data models, requirements traceability matrices, report mockups, and decision logs
• Collaborate with data engineers and subject matter experts to define business rules, resolve requirements gaps, validate assumptions, and support development planning
• Design and coordinate validation activities for migrated data products, including tables, dimensions, facts, semantic models, and reports using reconciliation, testing, and defect tracking methodologies
• Establish and maintain data quality, validation, parity reporting, and operational monitoring solutions using Power BI or similar analytics tools
• Document and support governance, security, and compliance requirements, including data classifications, PII, compensation-related data, role-based access controls, row-level security, data masking, retention, lineage, and audit requirements
• Lead user acceptance testing (UAT) activities, including test planning, script development, readiness assessments, sign-off processes, and post-migration validation support
• Serve as the primary liaison between business and technical teams, communicating risks, managing requirement changes, and ensuring solutions align with Finance and HR business goals

Requirements

• 5+ years of direct business analysis experience supporting data, analytics, business intelligence, or data warehouse initiatives for Human Resources, Finance, Accounting, Payroll, or similarly controlled business domains
• Demonstrated ability to translate business requirements into functional specifications, data mappings, acceptance criteria, test plans, and development-ready backlog items
• Intermediate to advanced querying and analysis skills using T-SQL, SQL Server tools, Excel, and similar data profiling or validation approaches
• Working knowledge of dimensional modeling concepts, semantic models, reporting layers, measures, KPIs, hierarchies, and data lineage
• Experience supporting data validation, reconciliation, defect triage, UAT, stakeholder sign-off, and production readiness for business-critical reporting or data products
• Exceptional written and verbal communication skills, including the ability to adapt messaging for SMEs, engineers, product owners, managers, and executive stakeholders
• Strong facilitation, organization, prioritization, and follow-through skills in an environment with multiple stakeholders, evolving requirements, and sensitive data constraints
• Ability to maintain confidentiality and exercise sound judgment when working with restricted HR, compensation, payroll, financial, or accounting data
• Applicants must be authorized to work for any employer in the United States; visa sponsorship is not available for this posting
• Bachelor's degree in business, information systems, mathematics, finance, accounting, human resources, data analytics, or a related field, or equivalent experience

Recommended Qualifications

• Hands-on experience with Microsoft Fabric, Azure Data Factory, Synapse, Lakehouse/Warehouse patterns, Power BI, or cloud data platform migration projects
• Prior experience migrating or modernizing HR, Finance, Payroll, Accounting, or enterprise reporting data warehouses
• Experience with medallion architecture concepts, source-system ingestion, bronze/silver/gold layering, dimensional models, and report modernization
• Experience documenting security models, row-level security, role-based access controls, data masking requirements, and sensitive data handling expectations
• Knowledge of financial and account