FP&A Analyst
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.1
Reclaim your time by letting our AI handle the grunt work of job searching.
We continuously scan millions of openings to find your top matches.

Overview
Job Description
- Develop, maintain, and enhance standardized financial and operational metrics reports supporting month-end close, forecasting, budgeting, cash flow, and management reporting.
- Support project-based financial reporting, including revenue recognition, project profitability, labor utilization, and cost tracking.
- Produce recurring and ad hoc reports for Finance leadership, Project Managers, and Executive stakeholders.
- Write and optimize SQL queries to extract, transform, and validate financial and operational data from SQL Server data sources.
- Partner with Finance and IT to ensure alignment between source system data, reporting logic, and accounting rules.
- Automate recurring reports and data refresh processes to improve efficiency, consistency, and data governance.
- Ensure reporting solutions align with Finance-controlled definitions, metrics, and hierarchies.
- Develop and maintain Power BI reports and dashboards that present financial data clearly and accurately for Finance and business stakeholders.
- Ensure data accuracy, completeness, and integrity across all financial reporting outputs.
- Document reporting logic, calculations, and assumptions to support transparency, auditability, and knowledge transfer.
- Assist in identifying and resolving data issues related to chart of accounts, financial dimensions, project structures, and source system configuration.
- Leverage Microsoft Copilot, Power BI AI features, or other analytics tools to streamline reporting workflows and enhance financial analysis.
- Identify opportunities for automation, predictive insights, and improved self-service reporting within Finance.
- Partner with Finance, Accounting, and Project Management teams to translate financial requirements into scalable reporting solutions.
- Communicate financial insights clearly to both technical and non-technical audiences.
- Support continuous improvement of financial reporting processes and tools.
- Bachelor’s degree in Finance, Accounting, Data Analytics, Information Systems, or a related field.
- Approximately 3–5 years of experience in financial analysis, financial reporting, or business intelligence within a Finance or Accounting function.
- Strong understanding of GAAP, cost accounting, project accounting, and financial close processes.
- Demonstrated ability to write and maintain SQL queries for financial reporting and analysis.
- Proficiency with:
- Microsoft Dynamics 365 (Finance & Operations preferred)
- SQL-based querying and data preparation
- Power BI
- Excel (advanced formulas, modeling, Power Query)
- Experience in the AEC or environmental consulting industry.
- Familiarity with project-based accounting concepts such as WBS structures, labor utilization, and revenue recognition.
- Experience using Copilot, Power BI AI features, or other GenAI tools to support analytics and reporting efficiency is a plus.
- Strong financial and analytical thinking with attention to detail
- Ability to translate complex financial data into clear, actionable insights
- Strong SQL and data problem-solving skills
- Effective communicator with Finance and non-Finance stakeholders
- Highly organized, detail-oriented, and committed to data quality
- Comfortable working cross-functionally in a fast-paced environment
- Willingness to learn and adapt to evolving analytics and automation tools
Rincon Consultants, Inc does not accept unsolicited applicant/candidate resumes from search firm recruiters and/or temporary agencies that do not have a signed contract and specified work order with Rincon Consultants. Further, such resumes received will be deemed the sole property of Rincon Consultants and no fees will be paid in the event Rincon Consultants subsequently hires such individual. Rincon Consultants is an equal opportunity employer. All aspects of employment will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.
Powered by JazzHR
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.
