Sr. Business Analyst - Sensitive Data Management
Core
Senior Business Analyst managing sensitive HR and Finance data, translating business needs into technical specs for data warehouse migration and validation.
Role type
Senior Business Analyst (Data Warehouse & Migration)
Builds
Data warehouse migrations, validation reports, and governance solutions for Finance and HR domains
Domain
Enterprise Data Management, HR, Finance, Accounting
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Requirements engineering, data mapping, UAT planning, data quality validation, stakeholder facilitation, process documentation, security compliance, SQL querying, dimensional modeling
Preferred skills
Microsoft Fabric, Azure Data Factory, Synapse, medallion architecture, row-level security, financial/payroll domain knowledge, report modernization
Technologies
T-SQL, SQL Server, Excel, Power BI, Microsoft Fabric, Azure Data Factory, Synapse, Visio, Lucidchart, Azure DevOps, Jira
Responsibilities
Partner with Finance/HR SMEs to gather and document business, functional, and security requirements; Facilitate workshops to analyze current-state processes and data warehouse usage; Translate requirements into implementation specs including source-to-target mappings and transformation rules; Design and coordinate validation activities for migrated data products using reconciliation and testing; Establish data quality monitoring solutions using Power BI; Document governance, security, and compliance requirements including PII handling and access controls; Lead UAT activities including test planning, script development, and sign-off processes.
Seniority
Senior, hands-on IC