Solutions Analyst

Law School Admission Council • Newtown Township, PA

4d • $85,000 - $88,000 • Hybrid

About The Position

LSAC’s mission is to advance law and justice by promoting access, equity, and fairness in law school admission and supporting the learning journey from prelaw through practice. The Solutions Analyst – Reports & Analytics is responsible for delivering enterprise reporting and analytics solutions using Microsoft Fabric and Power BI. This role partners with business and technical teams to gather requirements, develop and validate reporting solutions, perform data analysis using SQL/PLSQL, and ensure the quality and accuracy of analytical products through comprehensive testing.

Requirements

• Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or related field; or equivalent work experience.
• 3–5+ years of experience delivering enterprise reporting, business intelligence, and analytics solutions.
• Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse) and Power BI (reports, dashboards, semantic models, and administration).
• Strong proficiency in SQL/PLSQL, data modeling, data warehousing, and analytics solution development.
• Experience with test planning, data validation, regression/UAT testing, and Agile delivery methodologies.
• Holds a strong sense of accountability for both individual and team objectives.
• Embraces a forward-thinking mindset, contributing to a culture of continuous improvement and creativity.
• Excellent time management, prioritization, attention to detail and organization skills
• Advanced proficiency in Microsoft Fabric and Power BI, including semantic modeling, dashboard development, data visualization, and analytics solution design.
• Strong knowledge of SQL/PLSQL, data analysis, query optimization, and troubleshooting complex data issues.
• Experience with data warehousing concepts, dimensional modeling, Lakehouses, and Warehouses.
• Strong testing and quality assurance skills, including test planning, data validation, defect management, and user acceptance testing.
• Ability to analyze business requirements and translate them into scalable reporting and analytics solutions.
• Excellent analytical, problem-solving, and critical-thinking skills with strong attention to detail and data accuracy.
• Strong verbal and written communication skills with the ability to collaborate effectively with technical and non-technical stakeholders.
• Understanding of Agile principles, iterative delivery, and continuous improvement practices.
• Knowledge of Power BI administration, security, governance, and deployment best practices.
• Commitment to delivering high-quality, reliable, and business-focused analytics solutions.

Responsibilities

• Design, develop, and maintain enterprise analytics solutions using Microsoft Fabric and Power BI, including dashboards, reports, and reusable data products.
• Develop and manage Power BI semantic models, ensuring performance, scalability, data consistency, and alignment with business requirements.
• Build, support, and optimize Microsoft Fabric Warehouses and Lakehouses to enable trusted, enterprise-wide analytics and reporting.
• Administer and support the Power BI platform, including workspace management, security, access controls, deployment processes, and governance standards.
• Collaborate with business stakeholders to gather requirements, define reporting needs, and translate them into actionable analytics solutions.
• Design, develop, optimize, and troubleshoot SQL/PLSQL queries, stored procedures, and data validation processes to support reporting and analytics requirements.
• Create and execute test plans, test cases, and test strategies; perform functional, integration, regression, and user acceptance testing to ensure data accuracy and solution quality.
• Investigate, document, and resolve data, reporting, and analytics issues while managing defects through resolution.
• Contribute to Agile planning, continuous improvement, and delivery of high-quality solutions aligned with organizational goals.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level