Sr. Business Analyst - Sensitive Data Management

Esri

Redlands (CA)

On-site

USD 73,000 - 135,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Esri in Redlands, CA seeks a senior Business Analyst to drive data warehouse usage discovery, requirements engineering, and migration validation across Finance and HR domains. You will translate business needs into technical specs, define data rules, and coordinate validation with data engineers while handling restricted data with appropriate confidentiality.

You will collaborate across Finance, HR, and IT teams on data quality, governance, and reporting requirements, contributing to the design

Qualifications

  • 5+ years of direct business analysis experience supporting data, analytics, BI, or data warehouse initiatives
  • Demonstrated ability to translate business requirements into functional specs, data mappings, test plans, and backlog items
  • Intermediate to advanced querying with T-SQL, SQL Server tools, Excel, data profiling/validation
  • Knowledge of dimensional modeling, semantic models, reporting layers, KPIs, data lineage
  • Experience with data validation, reconciliation, UAT, stakeholder sign-off, and production readiness for reporting/data products
  • Excellent written and verbal communication, adapting messaging for SMEs, engineers, product owners, managers, executives
  • Strong facilitation, organization, prioritization, and ability to work with sensitive data constraints
  • Ability to handle restricted HR, compensation, payroll, financial data with confidentiality
  • Authorized to work in the United States; visa sponsorship not available
  • Bachelor’s degree or related field, or equivalent experience

Responsibilities

  • Partner with Finance, HR and technical stakeholders to gather and document requirements
  • Facilitate workshops to understand processes, reporting needs, data warehouse usage and controls
  • Translate requirements into implementation-ready specifications including data mappings and transformation rules
  • Create and maintain project docs: data dictionaries, models, requirements matrices, and logs
  • Collaborate with data engineers to define business rules and resolve gaps
  • Coordinate validation activities for migrated data products using reconciliation and testing
  • Establish data quality, parity reporting, and monitoring solutions using Power BI or similar tools
  • Document governance, security, and compliance requirements including RBAC, data masking, retention, lineage
  • Lead user acceptance testing, including planning, scripts, readiness, approvals, and post-migration support
  • Serve as liaison between business and technical teams, managing risks and changes

Skills

Business Analysis
Data Analytics
SQL / T-SQL
Power BI
Data Warehousing
Stakeholder Management
Documentation

Education

Bachelor's degree or equivalent

Tools

SharePoint
Excel
Azure DevOps
Jira
Visio
Lucidchart

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 accounting concepts, HR lifecycle processes, payroll concepts, workforce reporting, or compliance-driven reporting needs
  • Working familiarity with collaboration and analysis tools such as Microsoft 365, SharePoint, Teams, Visio, Lucidchart, Azure DevOps, Jira, or similar delivery tooling
  • Comfortable reviewing SQL logic, stored procedures, views, business rules, and report calculations to support requirement clarification and validation

#LI-TM1

#LI-Onsite

Total Rewards

Esri's competitive total rewards strategy includes industry-leading health and welfare benefits: medical, dental, vision, basic and supplemental life insurance for employees (and their families), 401(k) and profit-sharing programs, minimum accrual of 80 hours of vacation leave, twelve paid holidays throughout the calendar year, and opportunities for personal and professional growth. Base salary is one component of our total rewards strategy. Compensation decisions and the base range for this role take into account many factors including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs.

A reasonable estimate of the base salary range is

$72,800—$135,200 USD

The Company

At Esri, diversity is more than just a word on a map. When employees of different experiences, perspectives, backgrounds, and cultures come together, we are more innovative and ultimately a better place to work. We believe in having a diverse workforce that is unified under our mission of creating positive global change. We understand that diversity, equity, and inclusion is not a destination but an ongoing process. We are committed to the continuation of learning, growing, and changing our workplace so every employee can contribute to their life's best work. Our commitment to these principles extends to the global communities we serve by creating positive change with GIS technology. For more information on Esri's Racial Equity and Social Justice initiatives, please visit our website here.

Esri is an equal opportunity employer (EOE) and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. If you need reasonable accommodation for any part of the employment process, please email askcareers@esri.com and let us know the nature of your request and your contact information. Please note that only those inquiries concerning a request for reasonable accommodation will be responded to from this e-mail address.

Esri Privacy Esri takes our responsibility to protect your privacy seriously. We are committed to respecting your privacy by providing transparency in how we acquire and use your information, giving you control of your information and preferences, and holding ourselves to the highest national and international standards, including CCPA and GDPR compliance.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Analyst
Business Analyst

Esri • Redlands (CA)

On-site
USD 71,000 - 100,000
Human Resources Business Partner
Human Resources Business Partner

Esri • Redlands (CA)

On-site
USD 74,000 - 121,000
Relocation assistance
Human Resources Business Partner - Products
Human Resources Business Partner - Products

Esri • Redlands (CA)

On-site
USD 74,000 - 121,000
Medical coverage
Dental coverage
Vision coverage
+6
Internal Auditor
Internal Auditor

ESRI • Redlands (CA)

On-site
USD 71,000 - 117,000
Process Analyst
Process Analyst

Esri • Yucaipa (CA)

On-site
USD 71,000 - 100,000
Technical Consultant - Utilities
Technical Consultant - Utilities

Esri • Redlands (CA)

On-site
USD 84,000 - 142,000
Health benefits
401(k) and profit-sharing
Vacation and holidays
Software Development Engineer II – CI/CD & Platform Automation (Mission-Focused)
Software Development Engineer II – CI/CD & Platform Automation (Mission-Focused)

Esri • Redlands (CA)

On-site
USD 97,000 - 162,000
Medical insurance
Dental
Vision
+6
Technical Consultant - Enterprise Data Engineer (Geospatial Data & Platforms)
Technical Consultant - Enterprise Data Engineer (Geospatial Data & Platforms)

ESRI • Redlands (CA)

On-site
USD 84,240 - 142,480
Health and welfare benefits
401(k) and profit-sharing programs
Minimum accrual of 80 hours of vacation leave
+1
Technical Consultant - Utilities
Technical Consultant - Utilities

ESRI • Louisville (CO)

On-site
USD 84,000 - 142,000
Sr. Consultant - Natural Resources
Sr. Consultant - Natural Resources

Esri • Washington

On-site
USD 107,120 - 183,040
Health and welfare benefits
401(k) and profit-sharing programs
Vacation leave and paid holidays