Senior Business Analyst

IGEL Technology•Fort Lauderdale, FL

10d•Hybrid

About The Position

The Senior Business Analyst owns the development and ongoing improvement of business intelligence dashboards and reporting solutions, enabling reliable, consistent, and timely information for business decisions. The role develops and enhances Power BI dashboards and integrated reporting solutions that bring together commercial, operational, and financial data and translate complex information into actionable insights for senior leadership. Power BI is the primary delivery platform; Tableau experience is transferable, but the successful candidate will build and maintain solutions in Power BI. Strong SQL skills and an upstream-first data modeling approach are central to the role. The position also develops and maintains Excel-based reports, financial and operational analyses, and data reconciliations. It partners with business stakeholders to define questions, KPI definitions, and requirements; maintains reporting governance and documentation; and supports BI adoption through user guidance. The role is on-site in Fort Lauderdale, Florida, with a hybrid schedule of four days in the office and one remote day.

Requirements

Bachelor’s degree in Data Science, Business Informatics, Computer Science, Business Administration, Finance, or a related field; equivalent relevant experience is considered.
Minimum 5 years of relevant analytics or BI experience, or an equivalent combination of advanced education and experience, with demonstrated ownership of complex reporting deliverables.
Hands-on development of production dashboards using Power BI or Tableau, including consideration of usability, filtering, drill-down, and performance.
Strong SQL proficiency, including complex joins, CTEs, window functions, aggregation, troubleshooting, and query tuning; ability to independently build reusable reporting datasets.
Strong analytical judgment and problem-solving skills, including the ability to validate results and clearly present conclusions to senior business stakeholders.
Advanced Microsoft Excel proficiency, including building and maintaining complex reports, performing data reconciliations, and working with large datasets; strong knowledge of formulas, PivotTables, lookup functions, and data analysis techniques.
Proactive, solution-oriented working style and ability to collaborate across teams while independently driving deliverables.

Nice To Haves

Direct experience with Power BI, including DAX, semantic models, performance diagnostics, Power BI Service, refresh management, and deployment practices.
Experience with upstream SQL-based dimensional modeling, including fact/dimension design and star schemas, data warehouses or lakehouses, and ETL pipelines; familiarity with Microsoft Fabric or comparable cloud data platforms.
Experience with SaaS business models and metrics such as ARR, MRR, bookings, billings, renewals, churn, and pipeline; familiarity with Microsoft Dynamics is a plus.
Experience improving data refresh reliability, dataset efficiency, testing and monitoring, and scalable BI governance.

Responsibilities

Design, develop, maintain, and continuously improve Power BI dashboards and management reports that clearly communicate business performance and key metrics.
Use SQL to query, transform, integrate, and validate large datasets; investigate discrepancies and resolve data-quality issues affecting reporting accuracy.
Develop integrated analytical datasets combining financial, commercial, and operational information to support consistent, scalable reporting.
Design and maintain reusable, analytics-ready models upstream of Power BI, such as SQL views, with well-defined relationships and business logic; minimize unnecessary Power Query transformations and complex report-level modeling where upstream processing is more maintainable or efficient.
Optimize end-to-end performance by reviewing SQL query patterns and Power BI visual and DAX performance.
Lead stakeholder discovery sessions, including with business leadership, to frame business questions, clarify KPI definitions, prioritize requirements, and translate needs into technical reporting solutions.
Serve as a trusted analytical partner to senior stakeholders and explain findings and trade-offs clearly to technical and nontechnical audiences.
Apply reporting governance practices, including deployment controls, appropriate security such as row-level security, documentation, and validation before release.
Ensure data consistency, transparency, and dependable ongoing support of reports and analytical processes.
Maintain documented metric definitions, source-to-report lineage, testing, and release practices; identify opportunities to simplify the reporting catalog and reduce duplicated business logic.
Support BI adoption through concise documentation, user enablement, and guidance on interpreting dashboards and metrics.
Independently manage competing requests, communicate milestones, risks, and dependencies, and propose pragmatic solutions to complex reporting problems.
Develop, maintain, and enhance Excel-based reports, financial and operational analyses, and data reconciliations to support business reporting needs.
Validate and reconcile data between Excel, Power BI, and underlying source systems, identifying and resolving discrepancies to maintain accuracy, integrity, and consistency.

Benefits

Health, dental, vision, and prescription benefits, with employee premiums covered by IGEL.
11 company-paid holidays per year.
18–22 days of PTO per year, depending on tenure.
10 days of sick time per year, with rollover of unused days up to a maximum limit.
401(k) plan with 100% company match, up to $15,000 per year.
Paid maternity and paternity leave.
Monthly home office allowance.
Remote working opportunities and flexible working times.
Employee Assistance Program (EAP) and financial wellness tool.
Company-paid life insurance, long-term disability, and short-term disability coverage.
Wellbeing apps, including Rightway, Headspace, and Wellhub.
Training and development opportunities.
President’s Club for the highest-performing salespeople and overachievers.