[Remote] Financial Data Analyst & Development Operations Programmer

Note: The job is a remote job and is open to candidates in USA. Ascent CFO Solutions is a leading Fractional CFO services firm dedicated to providing strategic financial leadership and insights for scaling companies. They are seeking a Financial Data Analyst & Development Operations Programmer who will blend financial analysis with data architecture to support clients and internal systems.

Responsibilities
• 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 (often syncing 10–15+ interconnected spreadsheets)
• 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) to improve efficiency and tooling
• Utilize AI tools (including Gemini) where helpful to accelerate development, but understand the underlying logic well enough to troubleshoot and extend it
• 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
• Use Power Query to clean, normalize, and prepare client data from various sources
• Design and maintain clear, logical Power BI data models that reflect underlying financial realities

Skills
• 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

Company Overview
• Ascent CFO Solutions is a Fractional CFO firm providing finance and accounting services to high-growth start-ups and scale-ups. It was founded in 2011, and is headquartered in Boulder, Colorado, USA, with a workforce of 11-50 employees. Its website is http://www.ascentcfo.com/.

Apply Now

Apply Now