Ascent CFO Solutions

Compensation

Full Description

Job Description: • Work directly with clients to assess, restructure, and improve financial data to redesign them into intuitive, usable, and effective solutions • Perform FP&A-style analysis using Excel, Google Sheets, and Power Query • Build and maintain complex financial models, including robust cash flow forecasting tools and multi-source spreadsheet systems • Clean, transform, and normalize financial data for reporting and analysis • Apply strong accounting knowledge to ensure data aligns correctly across P&L statements, balance sheets and cash flow models • Design and build internal tools and systems to support client delivery and internal workflows • Develop and maintain spreadsheet-based systems with advanced logic and automation • Write and maintain Google Apps Script • Build and support API-based integrations and data connections • Automate data flows between systems and spreadsheets • Integrate and experiment with AI tools (including Gemini) • Serve as a Power BI developer supporting client reporting needs • Help maintain and evolve our Power BI infrastructure, ensuring data models, refresh processes, and reporting standards remain reliable and scalable. Requirements: • Advanced Excel and Google Sheets skills, including the ability to create and use LAMBDA functions for custom, reusable formulas, complex spreadsheet modeling, and automation. • Strong experience with Power Query (Excel or Power BI) and working knowledge of Power BI, including building data models and preparing data for reporting. • Must have an understanding of accounting and financial data, including how P&L, balance sheets, and financial statements interrelate. • Experience cleaning, transforming, and structuring real-world (often messy) financial data • Ability to independently evaluate data structures and propose better solutions • Google Apps Script or JavaScript API integrations and data connectivity Benefits: • W2 Position with employee health, dental and vision insurance • 401K match • Quarterly stipend towards educational or professional development • Technology stipend • Paid sick time, holiday time & volunteer time • Bonus/commission eligibility • Mentoring opportunities