Business Intelligence Analyst

What success looks like in this role:

Key Responsibilities

Reporting Solutions Development

• Design, develop, and maintain operational, management, and executive dashboards using Power BI.
• Create and support SQL Server Reporting Services (SSRS) reports and reporting frameworks.
• Develop complex data models, KPIs, scorecards, and performance metrics.
• Gather and document business requirements and translate them into reporting solutions.
• Build custom and standard reports aligned with business and contractual reporting requirements.
• Deliver reporting solutions that support data-driven decision making.

Reporting Operations & Support

• Manage the end-to-end lifecycle of reporting solutions, including design, deployment, enhancement, and retirement.
• Provide production support for reporting platforms and dashboards.
• Troubleshoot data discrepancies, dashboard issues, and reporting failures.
• Monitor report refresh schedules and ensure successful report delivery.
• Maintain reporting documentation, data dictionaries, and process documentation.

Data Management & Analysis

• Develop and optimize SQL queries, stored procedures, views, and datasets.
• Perform data validation, reconciliation, and quality assurance activities.
• Analyze large datasets to identify trends, risks, and business opportunities.
• Work with multiple data sources and databases to ensure accurate reporting.
• Support ongoing data governance and reporting best practices.

Automation & Platform Support

• Configure, administer, and support reporting and workflow automation platforms.
• Develop automated reporting processes that reduce manual effort and improve consistency.
• Support integrations between reporting systems, databases, and business applications.
• Assist in automation initiatives focused on improving reporting efficiency, data quality, and delivery timelines.
• Collaborate with infrastructure and application teams to maintain reporting platform stability.

Stakeholder Engagement

• Partner with business leaders and operational teams to understand reporting needs.
• Present findings, recommendations, and performance insights to stakeholders.
• Provide training and support to end users on reporting tools and dashboards.
• Act as a trusted advisor for reporting strategy and analytics improvements.

Required Technical Skills

Reporting & Analytics

• Microsoft Power BI (Desktop, Service, Dataflows, Semantic Models)
• SQL Server Reporting Services (SSRS)
• Advanced Microsoft Excel (Pivot Tables, Power Query, Power Pivot, VBA preferred)
• KPI and SLA reporting
• Dashboard and visualization design
• Data storytelling and executive reporting

Database & Data Management

• Advanced SQL development
• Microsoft SQL Server
• Database performance optimization
• Data modeling and relational database concepts
• ETL and data transformation processes
• Data quality management

Automation & Development

• Workflow and reporting automation platforms
• HTML
• Basic web technologies (CSS, JavaScript preferred)
• Scripting and process automation
• API and data integration concepts

Business Intelligence

• Data warehousing concepts
• Business analysis
• Requirements gathering
• Root cause analysis
• Statistical and trend analysis
• Data governance principles