Note: The job is a remote job and is open to candidates in USA. K&L Gates is a global law firm seeking a Senior Business Solutions Analyst to bridge business stakeholders and technical teams. The role focuses on gathering and translating requirements, analyzing and validating data, managing data mappings and governance in Microsoft Purview, validating Power BI KPIs, and supporting Agile delivery and user acceptance testing.
Responsibilities
- Work closely with business stakeholders to gather, clarify, and document business requirements
- Translate business needs into technical user stories, epics, and acceptance criteria within Agile frameworks (Scrum/Kanban)
- Maintain and refine the product backlog in collaboration with product owners and delivery teams
- Participate in Agile ceremonies such as sprint planning, backlog grooming, daily stand-ups, sprint reviews, and retrospectives
- Ensure requirements are clearly communicated to and understood by development and data engineering teams
- Use SQL to query, extract, and analyze data from multiple systems to validate requirements and ensure data integrity
- Perform data profiling and data quality assessments to identify inconsistencies or anomalies
- Define and document business rules, data transformations, and KPI calculations to support reporting and analytics initiatives
- Validate Power BI dashboards and ensure alignment between source data and business-defined KPIs
- Create and maintain data mapping documentation within Microsoft Purview, linking source systems to target destinations (e.g., Power BI datasets, data warehouses)
- Manage and update the Unified Data Catalog in Purview to ensure data assets are discoverable, properly classified, and well-documented
- Support data lineage tracking and metadata management to ensure transparency across the data lifecycle
- Collaborate with data governance and compliance teams to uphold data quality and stewardship standards
- Work with data engineers, BI developers, and data architects to translate functional requirements into technical specifications
- Support UAT (User Acceptance Testing) by preparing test cases, validating results, and obtaining stakeholder approval
- Ensure traceability between user stories, data mappings, and delivered solutions
- Develop process flow diagrams, use cases, and system interface documentation as needed
Skills
- + Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related technical discipline
- + 5+ years as a Technical Business Analyst, Data Analyst, or Business Systems Analyst in a data-focused environment
- + Proven experience working within an Agile delivery framework
- + Strong hands-on experience writing user stories, epics, and acceptance criteria in tools such as Jira or Azure DevOps
- + Advanced proficiency in SQL for querying, data validation, and complex data analysis
- + Experience with Microsoft Purview (data mapping, unified catalog, lineage tracking)
- + Familiarity with Power BI data models, datasets, and KPI validation
- + Experience collaborating with data engineers, ETL developers, and data governance teams
- • Advanced SQL (joins, aggregations, window functions, data validation)
- • Expertise in Microsoft Purview – data mapping, lineage, and unified catalog management
- • Strong understanding of data modeling, data warehousing, and ETL pipelines
- • Familiarity with Power BI, including DAX logic, datasets, and visualization validation
- • Understanding of data governance principles, metadata management, and data quality frameworks
- • Experience using Agile tools (Jira, Confluence, Azure DevOps)
- • Excellent communication and interpersonal skills; able to translate between technical and non-technical stakeholders
- • Strong analytical and problem-solving abilities with attention to detail
- • Highly organized and able to manage multiple priorities in an Agile environment
- • Self-motivated, proactive, and able to work independently and collaboratively
- • Skilled at documentation, requirement traceability, and stakeholder alignment
- • Familiarity with Azure data ecosystem (Microsoft Fabric, Fabric Data Factory)
- • Understanding of data privacy and compliance frameworks (GDPR, CCPA)
- • Experience with data quality or data lineage tools in Purview
- • Exposure to Python or other scripting languages for data validation
Benefits
- Medical/Prescription Drug Coverage (including a Health Savings Account feature)
- Back-up Child/Elder Care and access to a caregiving concierge
- Dental Insurance
- Wellness Program
- Vision Insurance
- Pre-tax Commuting Benefits
- 401(k) Retirement Plan and Profit Sharing
- Business Travel Accident Insurance
- Short- and Long-term Disability Protection
- Pet Insurance
- Life Insurance (including Basic, Supplemental, Spouse, Child, and Accidental Death and Dismemberment)
- Health Advocacy Services
- Paid Time Off (25-30 days per year)
- Identity Protection/Restoration and Fraud Insurance
- Parental Leave (18 weeks of which 6 are paid; short-term disability may provide additional paid time off)
- Student loan refinancing options and access to a student loan concierge service
- Paid Holidays (12)
- Addiction Resources
- Family Building Benefits
- Breast Milk Delivery and Lactation Support Services
- Flexible Spending Accounts
- Employees also may be eligible to receive bonuses and certain expense reimbursements
- Employee Assistance Program
- Professional Development and CLE Credit Opportunities
- 529 Deductions
- Relocation
- Accident Insurance
- Employee Referral Program
- Critical Illness Insurance
- Hybrid/Remote Work Opportunities
- Hospital Indemnity Insurance
- Perks including: Technology, Entertainment, and Travel Discount Programs
- Bereavement Leave
- All other benefits (such as leaves of absence) required by law
Company Overview
Company H1B Sponsorship