Data & Financial Analyst

Job Overview Position: Data & Financial Analyst, Full Time, Finance, Experienced Level. Location: New York, NY 10001. 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 Qualifications 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 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 Benefits Hiring Base Salary Range: $66,000‑$85,900 annual Position eligible for time and a half overtime pay Open to candidates in New York, NY, and Boston, MA Employer paid health insurance (medical, dental, vision) Annual 401(k) 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 Equal Employment Opportunity PAE is committed to pay equity – paying employees equitably for substantially similar work. PAE does not discriminate in employment opportunities or practices based on race, color, religion, gender, 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. #J-18808-Ljbffr