Sr. Business Intelligence Analyst - Sensitive Data Management
Senior Business Analyst partnering with Finance and HR stakeholders to gather requirements, document data models, and validate data migration to Microsoft Fabric, using SQL, Power BI, and Azure data platform tools.
- Compensation
- $72.8K–$135.2K / yr
- Location
- Redlands, CA
- Work setup
- Not specified
- Seniority
- Senior
- Employment
- Not specified
- Experience
- 5+ years
- Category
- Data analytics
- Posted
Skills
Must have
- 5+ years of business analysis experience in data, analytics, BI, or data warehouse initiatives for HR, Finance, Accounting, or Payroll
- Translate business requirements into functional specs, data mappings, acceptance criteria, test plans, and backlog items
- Intermediate to advanced T-SQL, SQL Server, Excel, and data profiling/validation skills
- Working knowledge of dimensional modeling, semantic models, reporting layers, measures, KPIs, hierarchies, and data lineage
- Experience with data validation, reconciliation, defect triage, UAT, stakeholder sign-off, and production readiness
- Exceptional written and verbal communication skills across diverse stakeholder audiences
- Strong facilitation, organization, prioritization, and follow-through skills with sensitive data
- Ability to maintain confidentiality with restricted HR, compensation, payroll, and financial data
- Authorized to work for any employer in the US; no visa sponsorship available
- Bachelor's degree in business, IS, math, finance, accounting, HR, data analytics, or related field (or equivalent experience)
Nice to have
- Hands-on experience with Microsoft Fabric, Azure Data Factory, Synapse, Lakehouse/Warehouse patterns, or Power BI
- Prior experience migrating or modernizing HR, Finance, Payroll, or enterprise reporting data warehouses
- Experience with medallion architecture, bronze/silver/gold layering, and report modernization
- Experience documenting security models, RLS, RBAC, data masking, and sensitive data handling
- Knowledge of financial/accounting concepts, HR lifecycle, payroll, workforce reporting, or compliance reporting
- Familiarity with Microsoft 365, SharePoint, Teams, Visio, Lucidchart, Azure DevOps, or Jira
- Comfortable reviewing SQL logic, stored procedures, views, and report calculations for validation
Full description
Overview
This role is intended for a senior Business Intelligence 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