Senior Business Intelligence Analyst

Senior Business Intelligence Analyst

We are seeking a highly skilled and experienced Senior Business Intelligence Analyst to join our dynamic Business Intelligence and Technology Services Team. As a Senior BI Analyst, you will play a key role in driving data-driven decision-making across the organization. This role will partner with business stakeholders to gather requirements, analyze data, optimize business processes, and support enterprise reporting and system integration. The ideal candidate has a strong understanding of relational databases and hands-on experience writing complex SQL queries involving joins, subqueries, aggregations, stored procedures, and performance optimization techniques.

Key Responsibilities:

• Collaborate with business stakeholders to gather, document, and analyze business and system requirements.

• Translate business needs into functional and technical specifications.

• Analyze large datasets to identify trends, anomalies, and business insights.

• Design, write, test, and optimize advanced SQL queries for reporting, auditing, and operational analysis.

• Develop complex SQL logic using:

o INNER, LEFT, RIGHT, and FULL OUTER JOINS

o UNION / UNION ALL

o Common Table Expressions (CTEs)

o Subqueries and correlated queries

o Window functions

o Aggregate functions and GROUP BY logic

o Stored procedures, views, and temporary tables

• Work within Azure Synapse Analytics and Power BI to support data modeling, reporting, and analytics initiatives.

• Validate and reconcile data across multiple source systems in the data warehouse.

• Support ETL/data integration processes and assist with data mapping activities.

• Partner with Finance, Operations and Commercial teams to troubleshoot data quality and performance issues.

• Create dashboards, KPIs, and operational reports using BI tools.

• Participate in system testing, UAT coordination, and defect resolution.

• Document workflows, system processes, and technical specifications.

• Recommend process improvements and automation opportunities.

• Gain a clear understanding of all data, fields and objects being reported on. Own the data.

• Flexibility is required to accommodate evolving business objectives.

Qualifications:

• Bachelor’s degree in computer science, Information Systems, Business Analytics, Computer Science or a related field; advanced degree preferred.

• 5 years of experience in business intelligence, data analysis, or related roles.

• Advanced SQL experience with demonstrated ability to write and optimize complex queries.

• Hands-on experience with Azure Synapse Analytics, SQL data warehouses, or cloud-based analytics platforms.

• Strong understanding of relational database concepts and data modeling.

• Solid understanding of basic accounting principles for financial report and dashboard building to include metrics such as Revenue Growth Rate, Profit Margin, EBITDA, Cash Flow from Operations, Working Capital Ratio, Debt-to-Equity Ratio, ROI, DSO, Inventory Turnover Ratio, Operating Expense Ratio, CAC, Churn Rate, ROA, Gross Profit Margin, and Capex to Revenue Ratio.

• Experience supporting rolling forecast models and financial planning cycles, including common forecasting formats such as 3+9 (Q1), 6+6 (Q2), and 9+3 (Q3), where actual financial results are combined with forecasted projections to maintain accurate year-end outlooks.

• Ability to analyze variances between actuals and projections, providing leadership with actionable insights to adjust spending, optimize resource allocation, and support informed business decision-making.

• Excellent analytical and problem-solving skills with the ability to work with large datasets.

• Strong communication and interpersonal skills with the ability to collaborate effectively with cross-functional teams.

• Proven track record of delivering high-quality BI solutions that meet business requirements.

• [Certifications or additional skills relevant to the role]

Technical Skills

• Advanced SQL Query Development

• Azure Synapse Analytics

• SQL Server / Azure SQL

• Data Warehousing Concepts

• ETL & Data Integration

• Query Optimization & Performance Tuning

• Business Requirements Analysis

• Data Validation & Reconciliation

• Power BI / Tableau / SSRS

• Azure Data Factory (ADF)

• Jira / Confluence

• Microsoft Excel

Sample SQL & Data Warehouse Competencies Expected

Candidates should be comfortable:

• Writing advanced SQL queries involving multiple-table joins and nested logic

• Creating optimized queries against large-scale data warehouse environments

• Developing CTEs, window functions, and analytical SQL calculations

• Troubleshooting slow-running queries and tuning performance

• Working with Azure Synapse Analytics serverless pools and dedicated SQL pools

• Supporting ETL validation and data reconciliation processes

• Building reusable views, stored procedures, and reporting datasets

• Validating enterprise data across operational and analytical systems