Business Analyst - Legal Analytics / Data Science

Scott & Associates, PC; Plano (TX); On-site; USD 60,000 - 90,000; Full time

Job summary

Scott & Associates, PC, a multi-state legal recoveries firm based in Plano, TX, is seeking a Business Analyst to join the Data Science team. The role focuses on developing Power BI dashboards, building reliable data pipelines, and improving reporting data quality to support decisions.

You will collaborate with Operations, HR, Compliance, and other business units, translating reporting needs into practical solutions and ensuring data availability for dashboards and analytics initiatives.

Qualifications

• 0–3 years of experience in business analysis, reporting, analytics, or data-related roles.

Responsibilities

• Build and maintain Power BI dashboards, reports, and data models.
• Develop and support data pipelines used for dashboarding and reporting.
• Clean, validate, and transform data from multiple systems.
• Work with business teams to gather requirements and improve reporting.
• Create Excel tools and templates when needed to support business processes.
• Document data sources, report logic, business rules, and user instructions.
• Support testing, deployment, troubleshooting, and user training.

Skills

Communication skills

Documentation

Education

Bachelor's degree in Business Analytics/IS/Operations/Data Analytics/CS

Tools

Power BI

SQL

Excel

Power Query

VBA

ETL processes

SQL Server

FileMaker

Job description

Scott & Associates, PC is a well-established, multi-state legal recoveries firm.

Since our founding in 2000, we’ve grown into a leading force in debt recovery, providing trusted and comprehensive legal solutions for financial institutions nationwide.

Our teams are driven, collaborative, and committed to delivering results.

Position Details

We are seeking a motivated Business Analyst to join our Plano, Texas-based Data Science team.

The Business Analyst will support company-wide dashboarding, reporting, and data development across Operations, HR, Compliance, and other business areas.

Reporting to the Senior Manager of Automation and Analytics, this is a hands-on role focused on developing Power BI dashboards, building reliable data pipelines, and improving the quality and availability of reporting data.

The Analyst will work with business teams to understand reporting needs and create practical solutions that support better decision-making.

Minimum Qualifications

• 0–3 years of experience in business analysis, reporting, analytics, or data-related roles.

Working knowledge of:

• Power BI, including dashboard development, data modeling, and DAX
• SQL, ETL processes, and data transformation
• Excel, Power Query, pivot tables, and VBA
• Experience using reporting and data tools to solve operational problems.
• Bachelor’s degree in Business Analytics, Information Systems, Operations, Data Analytics, Computer Science, or a related field.

Preferred Qualifications

• Experience building and maintaining Power BI dashboards.
• Experience preparing and integrating data from multiple systems.
• Experience building ETL pipelines and automated reporting processes.
• Experience with SQL Server, FileMaker, or similar data systems.
• Strong documentation and communication skills.

Responsibilities

• Build and maintain Power BI dashboards, reports, and data models.
• Develop and support data pipelines used for dashboarding and reporting.
• Clean, validate, and transform data from multiple systems.
• Work with business teams to gather requirements and improve reporting.
• Create Excel tools and templates when needed to support business processes.
• Document data sources, report logic, business rules, and user instructions.
• Support testing, deployment, troubleshooting, and user training.