Data & Financial Analyst

Job DetailsLevel: ExperiencedJob Location: NYNY New York - New York, NY 10001Position Type: Full TimeJob Category: FinanceThe 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: $66,000-$85,900 annual  This position is eligible for time and a half overtime pay Open to candidates in New York, NY and Boston, MA 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 (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 To 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 Please include the words "blue crayon" in the first sentence of your cover letter to be considered for this role.