Senior Business Solutions Analyst

Job DescriptionAt K&L Gates, we are looking for smart, imaginative and hard-working people with diverse backgrounds, experiences and ideas to join us. Perhaps our search for talented visionaries and your search for important and impactful work lead to the same place.We are seeking a highly skilled Senior Business Solutions Analyst with strong data analysis, data governance, and Agile delivery experience to act as the bridge between business stakeholders and technical teams.The ideal candidate will have hands-on expertise with SQL, Microsoft Purview (data mapping and unified catalog), and Power BI, along with proven experience working in an Agile environment. This role involves gathering and translating business requirements into technical specifications, defining business rules, mapping data from source to target systems, validating KPIs, and ensuring alignment between business objectives and data-driven solutions.Key Responsibilities:Business Analysis & Agile DeliveryWork 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.Data Analysis & ValidationUse 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.Data Mapping & Governance (Microsoft Purview)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.Technical Coordination & DocumentationWork 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.Required Qualifications:Education:Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related technical discipline.Experience: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.Technical Skills: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).Soft Skills: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.Preferred (Nice-to-Have):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.Compensation Salary $97,392 - $182,594 / year The compensation salary for this position will be determined during the interview process and will vary based on multiple factors, including but not limited to prior experience, relevant expertise, current business needs, and market factors.ABOUT THE FIRMK&L Gates is a fully integrated global law firm with lawyers located in more than 40 offices. We have experienced dramatic growth in the past decade and now rank among the largest U.S. based law firms in the world. We take pride in constantly striving for innovation, imagination and an entrepreneurial spirit. We come up with big ideas and then roll up our sleeves to get the job done, guiding our clients through their most complex issues in a variety of industry sectors and across multiple regions of the world. The industry recognition the firm has garnered emanates from the foundation of a global community aligned on behalf of our clients. The people at K&L Gates are committed to working together to create a legacy for each other, the firm, our clients, and the communities in which we serve. We thrive in an inclusive and socially conscious environment that embraces diversity and takes a holistic approach to the career evolution of all our professionals.For more information or to view other job opportunities, please click here to go back to our careers page.Notice: We participate in E-Verify in certain Firm locations for purposes of verifying employment eligibility.Please be advised that this position requires successful completion of a background check. In accordance with the Washington State Fair Chance Act, Los Angeles Fair Chance Ordinance, San Francisco Fair Chance Ordinance, the California Fair Chance Act, and applicable law qualified California and Washington State applicants with criminal history records will be considered. A criminal history will not categorically exclude a candidate from employment, and the Firm will consider relevant factors before making employment decisions based on criminal history information.It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.BENEFITSK&L Gates offers our personnel a comprehensive suite of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time personnel include:Medical/Prescription Drug Coverage (including a Health Savings Account feature)Back-up Child/Elder Care and access to a caregiving conciergeDental InsuranceWellness ProgramVision InsurancePre-tax Commuting Benefits401(k) Retirement Plan and Profit SharingBusiness Travel Accident InsuranceShort- and Long-term Disability ProtectionPet InsuranceLife Insurance (including Basic, Supplemental, Spouse, Child, and Accidental Death and Dismemberment)Health Advocacy ServicesPaid Time Off (25-30 days per year)Identity Protection/Restoration and Fraud InsuranceParental Leave (18 weeks of which 12 are paid; short-term disability may provide additional paid time off)Student loan refinancing options and access to a student loan concierge servicePaid Holidays (12)Addiction ResourcesFamily Building BenefitsBreast Milk Delivery and Lactation Support ServicesFlexible Spending AccountsEmployees also may be eligible to receive bonuses and certain expense reimbursementsEmployee Assistance ProgramProfessional Development and CLE Credit Opportunities529 DeductionsRelocationAccident InsuranceEmployee Referral ProgramCritical Illness InsuranceHybrid/Remote Work OpportunitiesHospital Indemnity InsurancePerks including: Technology, Entertainment, and Travel Discount ProgramsBereavement LeaveAll other benefits (such as leaves of absence) required by lawEQUAL EMPLOYMENT OPPORTUNITYThe Firm is an equal opportunity employer. It is the policy of the Firm that employment decisions shall be based on merit, qualifications and competence. Employment practices will not be influenced or affected by virtue of a person’s race (including traits associated with race, including hair texture and protective hairstyles such as afros, braids, locks, and twists), religion, creed, color, national origin, ancestry, citizenship, physical disability, mental disability, medical condition, genetic information, marital status, sex, pregnancy, childbirth, breastfeeding, gender, parental status, gender identity, gender expression, sexual orientation, age, familial status, domestic violence victim status, military and veteran status, or any other characteristic protected by applicable federal, state, or local law. This policy governs all aspects of employment including, without limitation, recruiting, hiring, compensation, benefits, promotion, assignment, and dismissal. In addition, it is the Firm’s policy to provide an environment that is free of prohibited harassment of any kind including, without limitation, that which is based on sex, race, age, disability, ethnic background, or any other category protected by law (including the categories listed above). The Firm complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If you require reasonable accommodation in completing this application, interviewing, or otherwise participating in the employee selection process, please contact View email address on click.appcast.io.