The role involves financial data analysis, automating data processes, developing internal tools, and supporting client reporting through Power BI.
Position: Financial Data Analyst & Development Operations Programmer
Overview
At Ascent CFO Solutions, we are a leading Fractional CFO services firm dedicated to providing strategic financial leadership and insights for scaling companies. Our mission is to empower businesses to achieve financial clarity and sustainable growth.
We’re looking for a top-notch Financial Data Analyst + Development Operations Programmer who understands finance and can design, structure, and automate data in ways that are genuinely useful for clients and internal teams. This role blends financial analysis with data architecture and the design and development of scalable systems.
This role is split between direct client work with Ascent CFO Solutions clients and internal development for the organization. You’ll partner with smaller, growing clients—many of whom are encountering formal data architecture for the first time—to clean, structure, and model financial data, helping them build practical, scalable foundations. The remainder of your time will be spent developing and improving internal systems, tools, and automations. This is a hands-on role for someone who is curious, systems-oriented, and comfortable teaching themselves new tools as needed.
Core Responsibilities
Client Financial Data & Analytics (≈45%)
Overview
At Ascent CFO Solutions, we are a leading Fractional CFO services firm dedicated to providing strategic financial leadership and insights for scaling companies. Our mission is to empower businesses to achieve financial clarity and sustainable growth.
We’re looking for a top-notch Financial Data Analyst + Development Operations Programmer who understands finance and can design, structure, and automate data in ways that are genuinely useful for clients and internal teams. This role blends financial analysis with data architecture and the design and development of scalable systems.
This role is split between direct client work with Ascent CFO Solutions clients and internal development for the organization. You’ll partner with smaller, growing clients—many of whom are encountering formal data architecture for the first time—to clean, structure, and model financial data, helping them build practical, scalable foundations. The remainder of your time will be spent developing and improving internal systems, tools, and automations. This is a hands-on role for someone who is curious, systems-oriented, and comfortable teaching themselves new tools as needed.
Core Responsibilities
Client Financial Data & Analytics (≈45%)
- 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
- 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
- 2-Time Winner of Inc. 5000 Fastest-Growing Companies nationwide
- 4-Time Winner of Built In's Best Places to Work
- Set your own schedule, choose the number of hours you want to work, generally between 25-35+ hours/week, and work remotely (with in-person opportunities)
- Engage with a wide range of business matters across a variety of industries
- Connect with highly talented Ascent team members (CFOs, VPs Finance, Controllers, Accounting Managers, and Senior Accountants) who are ready and willing to collaborate and support you on projects
- Benefit from our strong 12+ year reputation in delivering custom engagements with a high level of accuracy, responsiveness, and expertise
- Work directly with smart entrepreneurs and business leaders who view you as a trusted partner in their companies
- 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
Top Skills
Api Integrations
Excel
Google Apps Script
Google Sheets
JavaScript
Power BI
Power Query
Ascent CFO Solutions Boulder, Colorado, USA Office
Our office is in one of Boulder's trendiest areas with plenty of restaurants and shops outside our door.
Ascent CFO Solutions Denver, Colorado, USA Office
2806 Speer Blvd, Denver, CO, United States, 80211
Similar Jobs
Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
The role involves managing the product lifecycle of Salesforce functionalities, coordinating with teams, integrating AI, and ensuring product innovation based on stakeholder feedback.
Top Skills:
AICertiniaIroncladMachine LearningSaaSSalesforce
Cloud • Greentech • Social Impact • Software • Consulting
The Senior Global Enterprise Account Executive is responsible for acquiring new enterprise customers, managing full-cycle sales, and building relationships with stakeholders at all levels. This role requires expertise in complex sales cycles and a strong track record in exceeding sales targets.
Top Skills:
6SenseG2GongLinkedin Sales NavigatorOutreachSalesforceZoominfo
Artificial Intelligence • Cloud • Fintech • Professional Services • Software • Analytics • Financial Services
Lead and manage AI/ML projects, integrating Generative AI into products. Mentor teams, collaborate across functions, and ensure timely delivery of SaaS solutions.
Top Skills:
AWSAzureGCPGenerative AiLlmMl
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
