Data & Financial Analyst

PAE CONSULTING ENGINEERS INC•Seattle, WA

2d•Hybrid

About The Position

The Data & Financial Analyst turns business data into trusted, decision-ready insight for PAE. This role owns recurring and ad hoc reporting, BI dashboards, data validation, and KPI visibility across key business systems. The analyst combines strong financial acumen with data management and visualization expertise to make performance trends, risks, and opportunities easy to see and act on. Success in this role means building scalable, reliable reporting that supports PAE’s growth.

Requirements

Bachelor’s degree in finance, accounting, or business related field, or equivalent experience
3-5 years of relevant experience in financial analysis, business intelligence, data analytics, or a similar cross-functional reporting role
Demonstrated experience building executive reporting and dashboards in Power BI
Experience working with project, financial, and operational data across multiple systems
Experience developing interactive reports, calculators, and dashboards using data visualization tools (Tableau, Power BI, etc.) and techniques, and familiarity with the limitations and strengths between them
Proficient in Excel, including Power Query, pivot tables, complex formulas, charts, lookups, and financial modeling
Experience using languages (Python, R, Java, SQL, etc.) to manipulate data and draw insights from large data sets
Experience with data cleansing, normalization, master data management, and data quality control
Strong financial and business analysis skills, including forecasting, variance analysis, KPI development, and scenario modeling
High attention to detail, strong prioritization, and comfort working in a fast-paced, evolving environment

Nice To Haves

Deltek/DPS or Vantagepoint
SSRS
MS Access
Data Factory
APIs/ODBC
Newforma
project-based/AEC experience
Models curiosity, accountability, collaboration, and service - able to work across teams, translate messy data into clear decisions, and raise confidence in the numbers

Responsibilities

Work with PAE stakeholders to identify opportunities to utilize data and intelligence to drive business solutions
Develop interactive reports, calculators, and dashboards using data visualization tools and techniques that inform decision-making
Develop and maintain standardized datasets, master data, metric definitions, and reporting logic to improve consistency and trust in business data
Build, maintain, and publish recurring dashboards, scorecards, and reports in Power BI and Excel
Partner with Finance, EE, Marketing, IS, and other stakeholders to define reporting needs and dashboard priorities
Pull, combine and audit data from multiple systems, including Deltek VantagePoint (DVP) project and marketing databases, spreadsheets, and other business applications
Support monthly and quarterly reporting cycles through analysis, reconciliations, variance explanations, and management reporting
Perform data integrity audits and partner with system owners and subject matter experts to resolve gaps
Create ad hoc analyses and models to support forecasting, scenario planning, project performance reviews, revenue and backlog tracking, and marketing or business development decisions
Document data sources, business rules, and report definitions so the function scales beyond one person
Train end users on dashboards and reporting tools to increase adoption and self-service
Identify opportunities to automate reporting to reduce manual efforts
Perform other duties as assigned

Benefits

Employer paid health insurance (medical, dental, vision)
Annual 401k profit sharing based on company profit for the year and account contribution
Professional development reimbursements including state registration and professional association dues
Employer paid commuter/parking stipend
Cell phone stipend
Life insurance and disability benefits
Hybrid work schedule
Employee Assistance Program
9 paid holidays including an additional employee-selected day
Paid time off for sick leave, family leave, community service, holidays and vacation