CEO Lawyer

The CEO Lawyer Personal Injury Law Firm is dedicated to educating, empowering, and fighting for victims. With offices across the country, no matter where you are injured, our team of experienced lawyers are here to help you. We are seeking a highly

skilled and proactive Bilingual Spanish and English Power BI Data Analyst to take ownership of our firm’s dashboard ecosystem. This role is critical in ensuring timely updates, performance optimization, and alignment with evolving business needs. The ideal candidate will be a data-driven problem solver with a strong understanding of business operations, particularly in legal or professional services environments.

Key Responsibilities:

• Develop a deep understanding of the firm’s operations, departments, and technology stack.
• Design, build, and maintain advanced Power BI dashboards and reports tailored to various departments (e.g., legal, marketing, HR, finance).
• Manage Power BI Service: publish reports, configure data gateways, manage workspace permissions, and schedule data refreshes.

• Integrate and transform data from multiple sources, including:
• Legal and CRM platforms: Filevine, LeadDocket, HubSpot
• Microsoft 365 tools: Excel, SharePoint, Teams, OneDrive
• HR and productivity tools: BambooHR, ActiveTrack
• Conduct in-depth data analysis to support strategic decisions by attorneys, directors, and executive leadership.
• Automate reporting processes and build scalable, reusable data models.
• Monitor and analyze KPIs, providing monthly/quarterly executive summaries.
• Ensure data quality, consistency, and accuracy through regular audits and validation.
• Collaborate with stakeholders to gather requirements and translate them into actionable insights.
• Maintain comprehensive documentation of data sources, definitions, dashboards, and reporting standards.
• Provide ad hoc analysis and support for special projects and operational needs.

Required Qualifications:

• Bachelor’s degree in Data Science, Computer Science, Statistics, Business Analytics, or a related field.
• 3+ years of experience in data analytics with a strong focus on Power BI dashboard development.
• Advanced proficiency in:
• • Power BI (DAX, Power Query, data modeling)
  • SQL (data extraction, transformation, and optimization)
  • Microsoft Excel (pivot tables, advanced formulas, Power Pivot)
  • Python: API Creation and Integration
• Experience working with Microsoft 365 ecosystem (Teams, SharePoint, OneDrive, Outlook).
• Strong understanding of marketing analytics (e.g., campaign attribution, funnel analysis) and financial reporting (e.g., cash flow, burn rate, revenue forecasting).
• Excellent communication skills with the ability to present complex data in a clear, actionable format.
• Detail-oriented with a strong commitment to data integrity, privacy, and confidentiality.
• Professional fluency in English (written and verbal); Spanish bilingual is a plus.
• Experience with cloud-based databases and data warehouses (Azure)

Preferred Qualifications:

• Experience in a legal, professional services, or regulated industry environment.
• Familiarity with legal case management systems and CRMs (e.g., Filevine, LeadDocket, HubSpot).
• Understanding of personal injury legal processes and key performance metrics.
• Knowledge of data governance, compliance, and privacy best practices.
• Background in KPI development and performance tracking for legal or service-based teams.
• Experience with scripting or automation tools (e.g., Power Automate, Python, R) is a plus.