Sr Data and Business Intelligence Analyst

Job Description

We are looking for a highly skilled Sr Data and Business Intelligence Analyst to join our team in San Francisco, California. This role is pivotal in driving data-driven decision-making by benchmarking organizational performance, supporting cross-departmental reporting needs, and implementing advanced business intelligence tools. The ideal candidate will possess a strong analytical mindset and a proven ability to manage and optimize data systems, ensuring the seamless flow of information across the organization.

Responsibilities:

• Develop and maintain comprehensive financial analyses, including profitability, time and billing, accounts payable, accounts receivable, collections, and general ledger, using advanced reporting and querying tools.

• Collaborate with firm leadership and technical teams to define and implement a business intelligence strategy that aligns with organizational goals.

• Design, create, and optimize data models, analytics layers, and dashboards using tools like Power BI, Tableau, and Aderant.

• Provide technical support and guidance to departments such as Finance, Human Resources, and Legal Recruiting to enhance their use of business intelligence applications.

• Investigate and resolve discrepancies and issues in business systems, ensuring data consistency and integrity across all platforms.

• Manage and enhance practice management tools related to budgeting, reporting, and data functionalities, while ensuring smooth implementation of new applications.

• Partner with departments to develop and maintain internal evaluations and surveys, ensuring alignment with organizational objectives.

• Oversee data flows between various firm systems, including Aderant, IntApp, and payroll systems, to ensure seamless integration and functionality.

• A minimum of 5 years of experience in business intelligence, data analysis, or a related field.

• Intermediate proficiency in Aderant Expert,

• In-depth knowledge of SQL Server, SSIS, and SSRS.

• Strong understanding of financial systems and processes, including budgeting, reporting, and operational analysis.

• Proven ability to create and maintain advanced dashboards, data models, and visualizations.

• Excellent problem-solving skills and the ability to troubleshoot complex system issues.

Full-time