The Opportunity
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.
Who We Are
PAE is an engineering and design firm that turns complex challenges into reality. By leveraging the latest technologies, we solve problems in unique ways, and our designs enable buildings and communities to be more resilient and efficient. PAE is trusted by our clients in every aspect of a project's lifespan, from idea to occupancy. We set ambitious goals backed by analysis to significantly conserve water and energy while balancing costs and long-term operational needs. As a B Corp, we measure success by the benefits our projects provide to our clients, our communities, and our planet. We embrace innovation, transparency, sustainability, and lifelong curiosity.
What You'll Do
- 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
What You Bring
- 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
- Preferred: Deltek/DPS or Vantagepoint, SSRS, MS Access, Data Factory, APIs/ODBC, Newforma, and 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
What We Offer
- Hiring Base Salary Range: $63,000-$81,900annual • This position is eligible for time and a half overtime pay
The base salary is one component of PAE's competitive compensation package for employees. We take into consideration a variety of factors including but not limited to skills, abilities, experience, education, credentials, internal equity and geographic location in determining exact salary offered. At PAE, employees are eligible for annual compensation reviews based on performance and business needs. The above range represents PAE's good faith and reasonable estimate of the range of possible compensation at the time of posting.
In addition, PAE offers a comprehensive benefits package which includes the following:
- Employer paid health insurance (me