Ascent CFO Solutions

Financial Data Analyst, Development Operations Programmer

Ascent CFO Solutions

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Salary

💰 $125,000 - $150,000 per year

About the role

  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
ExcelGoogle SheetsPower Queryfinancial modelingcash flow forecastingdata transformationGoogle Apps ScriptAPI integrationsautomationPower BI
Soft Skills
client assessmentproblem-solvingindependent evaluationcommunication