Scott & Associates, PC

Business Analyst - Legal Analytics / Data Science

Scott & Associates, PC · Plano, Texas, United States · $50K–$70K/yr

Law Practice · 51-200 employees

6 h ago
Junior (0-2 yrs) Full-time United States
Log in to apply, save this posting, or score it against your profile with AI.

About the role

The role focuses on building and maintaining Power BI dashboards and data pipelines to support company-wide reporting. The analyst will collaborate with business teams to gather requirements and document data logic and business rules.

What they look for

Power BI SQL ETL Processes Data Modeling DAX Excel Power Query VBA Data Transformation Business Analysis Reporting Data Pipelines Requirement Gathering Documentation Data Validation User Training

Requirements

Candidates need 0-3 years of experience in analytics and a bachelor's degree in a technical or business field. Proficiency in Power BI, SQL, and Excel is required.

Full 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.