Technology and Data Analyst

<meta><p basel="" grotesk",arial,sans-serif;font-size:12pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:left;"=""><b><strong>Key Responsibilities:</strong></b></p><ul data-pattern="discCircleSquare" data-depth="1" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin:8px="" 0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:disc;"=""><li><span>Develop a deep understanding of the firm’s operations, departments, and technology stack.</span></li><li><span>Design, build, and maintain advanced Power BI dashboards and reports tailored to various departments (e.g., legal, marketing, HR, finance).</span></li><li><span>Manage Power BI Service: publish reports, configure data gateways, manage workspace permissions, and schedule data refreshes.</span></li></ul><p basel="" grotesk",arial,sans-serif;font-size:12pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:left;"=""><br></p><ul data-pattern="discCircleSquare" data-depth="1" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin:8px="" 0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:disc;"=""><li><u><b><strong>Integrate and transform data from multiple sources, including:</strong></b></u></li><li><span>Legal and CRM platforms: Filevine, LeadDocket, HubSpot</span></li><li><span>Microsoft 365 tools: Excel, SharePoint, Teams, OneDrive</span></li><li><span>HR and productivity tools: BambooHR, ActiveTrack</span></li><li><span>Conduct in-depth data analysis to support strategic decisions by attorneys, directors, and executive leadership.</span></li><li><span>Automate reporting processes and build scalable, reusable data models.</span></li><li><span>Monitor and analyze KPIs, providing monthly/quarterly executive summaries.</span></li><li><span>Ensure data quality, consistency, and accuracy through regular audits and validation.</span></li><li><span>Collaborate with stakeholders to gather requirements and translate them into actionable insights.</span></li><li><span>Maintain comprehensive documentation of data sources, definitions, dashboards, and reporting standards.</span></li><li><span>Provide ad hoc analysis and support for special projects and operational needs.</span></li></ul><p basel="" grotesk",arial,sans-serif;font-size:12pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:left;"=""><br></p><p basel="" grotesk",arial,sans-serif;font-size:12pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:left;"=""><b><strong>Required Qualifications:</strong></b></p><ul data-pattern="discCircleSquare" data-depth="1" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin:8px="" 0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:disc;"=""><li><span>Bachelor’s degree in Data Science, Computer Science, Statistics, Business Analytics, or a related field.</span></li><li><span>3+ years of experience in data analytics with a strong focus on Power BI dashboard development.</span></li><li><span>Advanced proficiency in:</span></li><li><ul data-pattern="discCircleSquare" data-depth="2" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin-left:0px;margin-right:0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:circle;"=""><li><span>Power BI (DAX, Power Query, data modeling)</span></li><li><span>SQL (data extraction, transformation, and optimization)</span></li><li><span>Microsoft Excel (pivot tables, advanced formulas, Power Pivot)</span></li><li><span>Python: API Creation and Integration</span></li></ul></li><li><span>Experience working with Microsoft 365 ecosystem (Teams, SharePoint, OneDrive, Outlook).</span></li><li><span>Strong understanding of marketing analytics (e.g., campaign attribution, funnel analysis) and financial reporting (e.g., cash flow, burn rate, revenue forecasting).</span></li><li><span>Excellent communication skills with the ability to present complex data in a clear, actionable format.</span></li><li><span>Detail-oriented with a strong commitment to data integrity, privacy, and confidentiality.</span></li><li><span>Professional fluency in English (written and verbal); Spanish bilingual is a plus.</span></li><li><span>Experience with cloud-based databases and data warehouses (Azure)</span></li></ul><p basel="" grotesk",arial,sans-serif;font-size:12pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:left;"=""><br></p><p basel="" grotesk",arial,sans-serif;font-size:12pt;font-weight:400;line-height:1.6;letter-spacing:0.25px;margin:4px="" 0px;padding:0px;text-align:left;"=""><b><strong>Preferred Qualifications:</strong></b></p><ul data-pattern="discCircleSquare" data-depth="1" basel="" grotesk",arial,sans-serif;font-size:11pt;font-weight:400;margin:8px="" 0px;line-height:1.6;padding:0px="" 0px="" 32px;list-style-type:disc;"=""><li><span>Experience in a legal, professional services, or regulated industry environment.</span></li><li><span>Familiarity with legal case management systems and CRMs (e.g., Filevine, LeadDocket, HubSpot).</span></li><li><span>Understanding of personal injury legal processes and key performance metrics.</span></li><li><span>Knowledge of data governance, compliance, and privacy best practices.</span></li><li><span>Background in KPI development and performance tracking for legal or service-based teams.</span></li><li><span>Experience with scripting or automation tools (e.g., Power Automate, Python, R) is a plus.</span></li></ul>