Senior Data Analyst / Business Intelligence Analyst

Job Title

Senior Data Analyst / Business Intelligence Analyst

Overview

We are seeking a senior-level Data Analyst with strong Business Intelligence expertise to support and stabilize data, reporting, and analytics in an enterprise environment following a major system migration. This role requires deep experience working in active production environments, strong business-facing skills, and the ability to translate complex business logic into reliable, well-documented reporting and data solutions.

The ideal candidate is highly detail-oriented, comfortable working with ambiguity, and capable of partnering closely with business stakeholders, analysts, developers, and project managers.

Key Responsibilities

• Lead the refinement, validation, and ongoing maintenance of an enterprise data dictionary

• Partner directly with business subject matter experts (SMEs) to elicit, clarify, and confirm data definitions, calculations, and business rules

• Function as a business analyst when needed to bridge gaps between business needs and technical implementation

• Collaborate with business analysts to validate data logic and ensure consistency across requirements, reports, and applications

• Design, develop, and maintain reports and dashboards using business intelligence tools

• Support the conversion, remediation, and redevelopment of reports impacted by application or system migrations

• Provide advanced SQL Server expertise, including complex queries, functions, stored procedures, and performance optimization

• Support data warehouse development and optimization, including indexing strategies and performance tuning

• Analyze system tables, query performance, and data behavior to support reporting and application needs

• Translate business logic into clear, actionable technical specifications for reporting and analytics

• Identify data quality issues and collaborate with technical teams to define and implement resolutions

• Document data lineage, transformations, calculations, and report logic clearly and consistently

• Communicate progress, risks, and data-related issues to project and technical leadership

• Perform other related duties as assigned

Required Qualifications

• Extensive professional experience in data analysis or business intelligence (typically 10+ years)

• Proven experience working in active production environments under tight timelines

• Advanced SQL Server expertise, including performance tuning and optimization

• Strong experience with reporting and BI tools (e.g., Power BI, SSRS, or equivalent)

• Significant experience working with data warehouses

• Demonstrated ability to elicit, validate, and document requirements directly from business stakeholders

• Ability to work effectively with SMEs, business analysts, developers, and project managers

• Exceptional attention to detail and strong documentation skills

Preferred Qualifications

• Strong written and verbal communication skills

• Experience supporting financial, tax, accounting, or property-related systems

• Experience assisting with system migrations or large-scale report conversions

• Proven ability to independently validate data logic and resolve ambiguity

• Experience working in public sector, regulated, or highly visible environments