Strategic Business Analyst

Zeus Fire and Security; Willistown Township (PA); On-site; USD 120,000 - 180,000; Full time

Job summary

Zeus Fire and Security seeks a Strategic Business Analyst, Office of the CEO, to translate executive questions into actionable analysis, reconcile data from ERP/CRM sources, and present defensible insights for decision-making.

You will own cross-functional initiatives, support board and investor materials, and help define analytics architecture as the ERP program matures, with exposure to leadership and potential career paths in finance or corporate development.

Qualifications

• Bachelor's degree in a finance, analytics, or business field.
• 2–5 years in consulting, investment banking, corporate strategy, or FP&A.
• Advanced Excel modeling and large dataset handling.
• SQL proficiency for data extraction and reconciliation.
• Ability to build executive-level PowerPoint materials that stand on their own.
• Experience with BI tools like Power BI or Tableau.
• Proven cross-functional project delivery without direct authority.
• Strong written and verbal communication with senior executives.
• Discretion handling confidential information and competing priorities.

Responsibilities

• Translate executive questions into defined analytic scope and execute independently.
• Gather and reconcile data from ERP, CRM, and legacy hubs; document sources.
• Build models for revenue, margin, headcount, backlog, and profitability.
• Deliver recommendations with explicit assumptions and conditions.
• Produce board-quality decks and recurring executive reporting packages.
• Support post-acquisition integration and diligence efforts as needed.
• Coordinate cross-functional initiatives sponsored by the CEO from start to finish.

Skills

Advanced Excel modeling

SQL for data extraction

Power BI

Tableau

Executive-level PowerPoint

Cross-functional project management

Strong communication

Data reconciliation

Analytical storytelling

Education

Bachelor's degree in Finance, Accounting, Economics, Business, Engineering, Data Analytics

Tools

Power BI

Tableau

Job description

Role Overview

The Strategic Business Analyst, Office of the CEO is the analytical engine of the executive office. You will take questions from the CEO and the executive leadership team, find the data required to answer them, reconcile it across inconsistent sources, form a defensible point of view on what it means, and deliver that answer in a form leadership can act on immediately.

This is not a reporting role. Producing the number is the entry price. The value is in telling us what the number means, where it disagrees with another number, and what you would do about it. You will be expected to take positions, defend them, and be clear about where your confidence is low.

Beyond analysis, you will manage discrete initiatives that matter to the CEO but do not warrant a dedicated program manager, and you will share responsibility for the operational continuity of the executive office.

This is a high-visibility, high-trust seat with unusual exposure for the level. You will work directly with the CEO, CFO, COO, and CIO, and with the board, and you will see financial, acquisition, and strategic material before most of the organization does. For the right person, this is a launching pad into finance, corporate development, operations leadership, or a chief of staff track.

Key Responsibilities

Analysis and Insight

• Translate open-ended executive questions into a defined analytical scope, then execute against it independently
• Gather, structure, and reconcile financial, operational, sales, and customer data from multiple ERP, CRM, and legacy hub systems
• Identify and resolve discrepancies between sources, and document which source is authoritative and why
• Build and maintain analytical models covering revenue, recurring monitoring revenue, margin, headcount productivity, backlog, pipeline, and customer profitability
• Perform variance analysis against budget, forecast, and prior period, and explain the drivers rather than restating the delta
• Deliver a clear recommendation with every analysis, including the assumptions it rests on and the conditions that would change it
• Conduct ad hoc research on markets, competitors, acquisition targets, and industry benchmarks

Executive Reporting and Presentation

• Produce board-quality decks, memos, and reporting packages that are complete, accurate, and require no rework
• Own recurring executive reporting products end to end, including monthly and quarterly business review materials
• Build data visualizations that make the point without narration, and choose the chart that tells the truth rather than the chart that looks best
• Maintain version control, source documentation, and an audit trail for every number that reaches the board
• Support preparation for board meetings, lender reporting, and investor communications

Project Management

• Own cross-functional initiatives sponsored by the CEO that are too small to staff formally, driving them from definition to completion
• Build and manage project plans, timelines, milestones, and status reporting
• Coordinate work across corporate functions and operating brands without direct authority over the participants
• Escalate blockers early and with a recommended path forward
• Support post-acquisition integration workstreams, including data consolidation, reporting alignment, and synergy tracking
• Support diligence efforts on active acquisition targets

Executive Office Continuity

• Serve as continuity coverage for the CEO's calendar, scheduling, and travel when the Executive Assistant is out of office or otherwise unavailable, ensuring the executive office does not go dark
• Coordinate logistics for executive and board meetings, including materials distribution and follow-up tracking
• Track executive action items and commitments to closure
• Handle confidential financial, acquisition, personnel, and strategic information with absolute discretion
• Build durable working relationships with finance, operations, IT, and hub leadership
• Contribute to the definition of Zeus's future analytics and reporting architecture as the ERP program matures

Qualifications

• Bachelor's degree in Finance, Accounting, Economics, Business, Engineering, Data Analytics, or a related field
• 2-5 years of experience in management consulting, investment banking, private equity, corporate development, corporate strategy, FP&A, or a comparable analytical role
• Advanced Microsoft Excel skills, including complex modeling, large dataset manipulation, and structured model design
• Working proficiency in SQL for data extraction and reconciliation
• Demonstrated ability to build executive-level PowerPoint materials that stand on their own
• Experience with business intelligence tools such as Power BI, Tableau, or equivalent
• Track record of managing projects to completion in a cross-functional environment without formal authority
• Strong written and verbal communication, including the ability to brief a senior executive concisely
• Demonstrated sound judgment in handling confidential information
• Ability to manage several competing priorities under real deadlines

EEOC Statement

Zeus provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.