Data & Financial Analyst

The OpportunityThe 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 DoWork with PAE stakeholders to identify opportunities to utilize data and intelligence to drive business solutionsDevelop interactive reports, calculators, and dashboards using data visualization tools and techniques that inform decision-makingDevelop 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 ExcelPartner with Finance, EE, Marketing, IS, and other stakeholders to define reporting needs and dashboard prioritiesPull, combine and audit data from multiple systems, including Deltek VantagePoint (DVP) project and marketing databases, spreadsheets, and other business applicationsSupport monthly and quarterly reporting cycles through analysis, reconciliations, variance explanations, and management reportingPerform data integrity audits and partner with system owners and subject matter experts to resolve gapsCreate ad hoc analyses and models to support forecasting, scenario planning, project performance reviews, revenue and backlog tracking, and marketing or business development decisionsDocument data sources, business rules, and report definitions so the function scales beyond one personTrain end users on dashboards and reporting tools to increase adoption and self-serviceIdentify opportunities to automate reporting to reduce manual effortsPerform other duties as assigned What You BringBachelor's degree in finance, accounting, or business related field, or equivalent experience3-5 years of relevant experience in financial analysis, business intelligence, data analytics, or a similar cross-functional reporting roleDemonstrated experience building executive reporting and dashboards in Power BIExperience working with project, financial, and operational data across multiple systemsExperience developing interactive reports, calculators, and dashboards using data visualization tools (Tableau, Power BI, etc.) and techniques, and familiarity with the limitations and strengths between themProficient in Excel, including Power Query, pivot tables, complex formulas, charts, lookups, and financial modelingExperience using languages (Python, R, Java, SQL, etc.) to manipulate data and draw insights from large data setsExperience with data cleansing, normalization, master data management, and data quality controlStrong financial and business analysis skills, including forecasting, variance analysis, KPI development, and scenario modelingHigh attention to detail, strong prioritization, and comfort working in a fast-paced, evolving environmentPreferred: 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 payThe 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 (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 stipendCell phone stipend Life insurance and disability benefits Hybrid work schedule Employee Assistance Program 9 paid holidays including an additional employee-selected dayPaid time off for sick leave, family leave, community service, holidays and vacationTo learn more about our comprehensive benefits package, visit https://www.pae-engineers.com/careers/benefits. This information is provided per the Equal Pay Act Our commitment to pay equity PAE is a JUST label certified company; we demonstrate JUST label requirements within pay equity. Pay scales should meet or exceed applicable legislated wage requirements and industry standards and compensate, on the same basis, all individuals performing the same or similar work and work of equal value. We are committed to the principle of pay equity - paying employees equitably for substantially similar work. To learn more about pay equity and our commitments to equitable business practices, you may view our JUST label certification here: Living Future: Just Label Certification. To find out more visit our website. What We're Made Of Founded in 1967, PAE is a leading sustainable engineering and consulting firm on a mission to deliver clean air, energy, and water for all. We specialize in mechanical, electrical, and plumbing engineering, building performance analysis, technology design, and lighting design (LUMA). PAE designs some of the nation's highest-performing and most regenerative built environments across the U.S., from Living Buildings to all-electric buildings and beyond. Learn more at pae-engineers.com. Our portfolio includes over 100 LEED Platinum projects as well as dozens of projects that have either achieved or are pursuing the Living Building Challenge, Passive House, Architecture 2030, Carbon Neutral, Net Zero Energy, and Net Zero Water. Fine Print Please note that resumes received from third party recruiters or agencies will not be accepted unless requested directly by PAE Talent Acquisition and with a prior signed fee agreement. If candidates without a previously signed recruiter fee agreement are submitted, PAE reserves the right to engage with and hire those candidate(s) without any obligation financial or otherwise to the recruiter or agency. In order to provide equal employment and advancement opportunities to all individuals, employment decisions at PAE will be based on merit, qualifications and abilities. PAE does not discriminate in employment opportunities or practices on the basis of race, color, religion, gender (sex), national origin, age, veteran status, sexual orientation, gender identity, physical characteristics historically associated with race, disability, genetic information or any other characteristic protected by applicable law. PAE will make reasonable accommodations for qualified individuals with known disabilities unless doing so would result in an undue hardship. This policy governs all aspects of employment including: selection, job assignment, compensation, discipline, termination and access to benefits and training. LI-hybrid