Sr. Data Analyst

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

Job summary

Zeus-Fire-and-Security-1 seeks a Senior Analyst in the Office of the CEO to transform questions into actionable analysis. You will reconcile data across systems, form defensible positions, and present insights leadership can act on immediately.

This high-visibility role involves managing select initiatives, supporting continuity of the executive office, and coordinating with the CEO, CFO, COO, CIO, and board on strategic matters.

Qualifications

• Bachelor's degree or equivalent in a related field.
• 4–7 years in analytical roles such as management consulting, investment banking, or corporate strategy.
• Advanced Excel with complex modeling and large datasets.
• Working proficiency in SQL for data extraction and reconciliation.
• Ability to build executive-level PowerPoint materials.

Responsibilities

• Translate executive questions into analytical scope and execute independently.
• Gather and reconcile data from multiple systems; document source of truth.
• Build models for revenue, margin, headcount, backlog, pipeline, and profitability.
• Deliver recommendations with clear assumptions and decision thresholds.
• Produce board-quality decks and recurring executive reporting packages.
• Coordinate cross-functional initiatives sponsored by the CEO end-to-end.

Skills

Excel modeling

SQL

Power BI

Tableau

Cross-functional collaboration

Executive storytelling

Data reconciliation

Education

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

Tools

Excel

SQL

Power BI

Tableau

Job description

Role Overview

The Senior 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
• 4 to 7 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.