Senior Business Analyst

IGEL Technology; United States; Hybrid; USD 110,000 - 140,000; Full time

Job summary

IGEL Technology in Fort Lauderdale, FL is seeking a Senior Business Analyst to own and advance BI dashboards and reporting. Power BI is the primary platform, with Tableau as a transferable skill; strong SQL and data-modeling expertise are essential to translate complex data into actionable insights for senior leadership.

The role involves designing and maintaining dashboards, validating large datasets, and leading discovery sessions with business leadership to define KPIs and priorities.

Qualifications

• Bachelor’s degree or equivalent in a relevant field.
• 5+ years of analytics/BI experience with complex reporting deliverables.
• Production dashboards using Power BI or Tableau.
• Strong SQL with complex joins, CTEs, window functions, and tuning.
• Advanced Excel for large datasets and reconciliation.

Responsibilities

• Design, develop, and maintain Power BI dashboards and management reports communicating key metrics.
• Use SQL to query, transform, and validate large datasets; resolve data-quality issues.
• Create integrated analytical datasets across finance, commercial, and operations to support reporting.
• Develop upstream data models (e.g., SQL views) to streamline Power BI workloads.
• Optimize performance of SQL queries and Power BI visuals/DAX; monitor governance and security.
• Lead stakeholder discovery sessions and translate requirements into technical solutions.
• Explain findings clearly to both technical and non-technical audiences; ensure data lineage and validation.
• Maintain metric definitions, data source lineage, and release practices; document dashboards and reduce duplication.
• Assist in BI adoption through documentation and user enablement.

Skills

Power BI

SQL

Dashboard development

Data modeling

Stakeholder management

Excel

Problem solving

Education

Bachelor’s degree or equivalent

Related field experience

Tools

Tableau

Power BI Service

MS Fabric

Job description

Position: Senior Business Analyst

Location: On-site - Fort Lauderdale, FL, Hybrid, 4 days In Office + 1 day remote

THE ROLE:

Own the development and ongoing improvement of business intelligence dashboards and reporting solutions, enabling reliable, consistent and timely information for business decisions. Develop and enhance 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 for this position. Tableau experience is welcome as transferable dashboard-development experience; the successful candidate will be expected to build and maintain solutions in Power BI. Strong SQL skills and an upstream-first data modeling approach are central to the role.

• 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 (for example, 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/DAX performance.
• Lead stakeholder discovery sessions, including 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; 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; proactively identify opportunities to simplify the reporting catalog and reduce duplicated business logic.
• Support BI adoption through concise documentation, user enablement and guidance on how to interpret 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.
• Perform data validation and reconciliation between Excel, Power BI, and underlying source systems, identifying and resolving discrepancies to maintain data accuracy, integrity, and consistency.

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

PREFERRED QUALIFICATIONS

• 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 (fact/dimension design, 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/monitoring and scalable BI governance.