Senior Reporting Lead

The Senior Reporting Lead manages a team of Reporting Analysts responsible for designing, building, enhancing, and sustaining business and management reports. The role combines hands-on expertise in Power BI, Power Query, and Power Apps with people leadership, delivery governance, and strong stakeholder partnership. The Senior Reporting Lead translates evolving business needs into scalable reporting solutions, ensures data accuracy and clear data lineage, and maintains delivery momentum when priorities or requirements change. The role is expected to be flexible, decisive, and quick to pivot while protecting report quality, controls, usability, and agreed timelines. Position Responsibilities The Senior Reporting Lead owns the quality, timeliness, and effectiveness of reporting deliverables within the assigned portfolio. The role sets priorities, allocates work, reviews solutions, resolves delivery issues, and serves as the first line of review for data integrity, report logic, user experience, and supporting documentation. Key responsibilities include, but are not limited to, the following: 1) Reporting Solution Design and Delivery Report Development and Enhancement · Lead the end-to-end delivery of dashboards, recurring reports, scorecards, and ad-hoc analytical solutions using Power BI and related Microsoft tools. · Translate business requirements into practical report designs, data models, measures, visualizations, and user experiences. · Review and approve report logic, calculations, filters, drill-through paths, refresh behavior, and presentation before release. · Balance speed, scalability, control, and user needs when determining whether to build, enhance, consolidate, automate, or retire a report. Data Modeling and Analytics · Guide the development of reliable semantic models, relationships, calculated columns, measures, and business definitions. · Ensure metrics are consistently defined and traceable to approved data sources, with clear documentation of assumptions and limitations. · Challenge unusual movements, trends, and exceptions through reasonability checks before reports are distributed. · Promote reusable datasets and common definitions to reduce duplication and conflicting versions of information. Power BI Delivery · Provide advanced oversight and hands-on support for Power BI Desktop and Power BI Service solutions, including DAX, data modeling, visualization design, row-level security, workspace organization, publishing, refresh monitoring, and access coordination. · Establish practical development and review standards that improve performance, maintainability, usability, and consistency across the reporting portfolio. Power Query and Data Preparation · Use and guide the team in Power Query for data extraction, cleansing, transformation, consolidation, and repeatable preparation workflows. · Review query steps, joins, parameters, error handling, and dependencies to improve reliability and reduce manual intervention. Power Apps and Workflow Enablement · Lead or support the design of Power Apps solutions that capture, validate, maintain, or supplement reporting data. · Partner with process owners and technology teams to connect user inputs, approval steps, and reporting outputs in a controlled and user-friendly manner. · Identify appropriate opportunities to integrate Power Apps with Power BI, SharePoint, Excel, Microsoft Lists, and Power Automate where this improves the reporting process. 2) Delivery Management, Agility and Governance Requirements Management · Lead discovery sessions with stakeholders to clarify business questions, success measures, data sources, users, frequency, security needs, and acceptance criteria. · Convert incomplete or changing requests into prioritized requirements, decision logs, prototypes, and manageable delivery increments. · Manage scope changes transparently, communicate impacts, and quickly pivot the team when business priorities shift. Planning and Execution · Maintain a visible portfolio of reporting demand, work in progress, risks, dependencies, and delivery dates. · Allocate resources across BAU reporting, enhancements, defects, and project work based on business value, urgency, complexity, and team capacity. · Use iterative development, early prototypes, and structured user acceptance testing to reduce rework and accelerate stakeholder feedback. · Escalate material risks, data constraints, and conflicting priorities with clear options and recommendations. Quality, Controls and Documentation · Establish quality checks covering source-to-report reconciliation, calculation accuracy, completeness, refresh status, access, presentation, and release readiness. · Ensure solutions have current documentation, including requirements, source mapping, business rules, data lineage, report ownership, refresh procedures, access controls, testing evidence, and change history. · Maintain appropriate segregation of duties and partner with data owners, risk, compliance, and technology teams on control requirements. Reporting Portfolio Management · Regularly assess reports for duplication, usage, relevance, performance, and maintenance effort. · Recommend whether reports should be retained, improved, consolidated, automated, expanded, or retired. · Drive standardization of templates, naming conventions, KPI definitions, and report development practices. 3) People Leadership and Capability Development Team Leadership · Lead, coach, and develop a team of Reporting Analysts, establishing clear accountabilities, delivery expectations, and development objectives. · Create an inclusive, collaborative environment where team members raise risks early, share knowledge, and take ownership of outcomes. · Provide timely feedback, support performance improvement, and build succession and cross-training plans for critical reports and skills. Technical Coaching and Review · Serve as the team’s escalation point for comple