Senior BI Analyst: Power BI, SQL & AI-Driven Insights

Compunnel, Inc.; Northern (KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Compunnel, Inc. is seeking a Business Intelligence Analyst to collaborate with the Director of Data & Analytics to develop content and analyze financial and operational data, delivering insights trusted by firm leadership, practice groups, and partners.

You will build semantic models, dashboards, and reports within Power BI and Microsoft Fabric, applying responsible AI-assisted tools to enhance efficiency and scalability of analytics work.

Qualifications

• Bachelor’s degree in finance, accounting, economics, statistics, computer science, or information/data systems from an accredited college or university.
• 5+ years of experience in data analysis and report development.
• Strong proficiency in SQL (T-SQL) and Microsoft Excel for data analysis.
• Advanced experience developing Power BI dashboards and Paginated Reports, including semantic and dimensional data modeling, DAX, and Power Query (M).
• Experience using Python for scripting, automation, and data processing.
• Experience with Microsoft Fabric or a comparable modern analytics platform.
• Experience using source control with Git.
• Experience using AI-assisted analytics and development tools for coding, documentation, testing, and automation, with demonstrated judgment in reviewing and validating AI-generated output.
• Clear and effective communication skills with the ability to convey complex concepts to technical and non-technical users.
• Strong attention to detail in data analysis and reporting.

Responsibilities

• Provide financial reporting, analysis, and decision support to firm leadership, timekeepers, and various departments, partnering with stakeholders to understand business questions and how the analysis will be used.
• Design, build, and maintain reusable, well-governed semantic models and analytical data products, including Power BI dashboards and Paginated Reports.
• Analyze drivers of firm performance, including partner and practice-group profitability, client and matter profitability, pricing and rate realization, and timekeeper productivity.
• Own data quality by building and maintaining documented validation and reconciliation checks against source financial systems to ensure reporting is accurate, consistent, and defensible.
• Maintain metric definitions, business glossary content, semantic model documentation, data lineage, and supporting metadata, and contribute to broader data governance practices.
• Coordinate with users to answer data inquiries, provide ad hoc analysis as required, and enable governed self-service analytics to reduce repetitive reporting over time.
• Use firm-approved AI-assisted analytics and development tools to accelerate research, coding, documentation, testing, and automation while independently validating AI-generated output and complying with firm policies.
• Partner with data engineering, application, and source-system teams to define data requirements, resolve data issues, and support delivery of curated, analytics-ready data.
• Handle confidential and privileged information appropriately while respecting ethical walls and information barriers.
• Perform other duties as assigned.

Education

Bachelor’s degree in a quantitative or analytical field

Tools

SQL (T-SQL)

Microsoft Excel

Power BI

Paginated Reports

DAX

Power Query (M)

Python

Microsoft Fabric

Git

Job description

Compunnel, Inc. is seeking a Business Intelligence Analyst to collaborate with the Director of Data & Analytics to develop content and analyze financial and operational data, delivering insights trusted by firm leadership, practice groups, and partners.

You will build semantic models, dashboards, and reports within Power BI and Microsoft Fabric, applying responsible AI-assisted tools to enhance efficiency and scalability of analytics work.