Financial Reporting & Dashboard Automation Specialist (12-16 Week Contract)
SCOPE OF ROLE
Reporting to the Vice President of Finance and Operations, the Financial Reporting & Dashboard Automation Specialist will be an experienced, hands-on contractor who will take our vision for automated financial reporting and turn it into reality. You'll connect and clean data from multiple systems including QuickBooks, Salesforce, project management systems, and internal worksheets and build dynamic dashboards and reports that give our team clear, real-time financial visibility. We're looking to leverage Google Gemini's AI capabilities to surface smarter insights and reduce manual work.
EXPERIENCE
This engagement requires a seasoned contractor who can take full ownership of the project lifecycle, leading planning, driving execution, and delivering a polished handoff that sets our team up for long-term success.
LOCATION
Remote
SALARY RANGE
$100hr- $120hr
The skills and experience of qualified candidates will determine the exact compensation for which this job is filled.
QUALIFICATIONS
Experience building dynamic financial dashboards and reports in Power BI
Hands-on expertise with Google Gemini and experience integrating Gemini APIs into data and reporting workflows
Experience in system integrations specifically QuickBooks, Salesforce, and Asana
Strong understanding of financial reporting concepts (P&L, cash flow, budget vs. actuals)
Comfortable working directly with senior leadership and operations stakeholders to gather requirements and present solutions
Experience creating end-user documentation and delivering training to non-technical staff
Proven ability to work autonomously and deliver high-quality work with minimal oversight
Polished communicator who can engage confidently with business and finance stakeholders
PREFERRED QUALIFICATIONS
Experience with ETL tools or data pipeline automation (e.g., Fivetran, Zapier, Power Automate)
Strong SQL skills for custom data transformations and data cleaning
Familiarity with the broader Google Cloud AI ecosystem (Vertex AI, BigQuery
RESPONSIBILITIES
Partner closely with the Finance and Operations team to understand reporting needs, and align on priorities
Lead discovery sessions with stakeholders to map workflows and translate business requirements into technical solutions
Audit, clean, and organize data from QuickBooks, Salesforce, and Excel/Google Sheets budget files — resolving inconsistencies, duplicates, and structural issues before they reach reports
Design and implement a clean, reliable data structure that serves as the foundation for all reporting
Architect and build automated, dynamic financial reports and dashboards in Power BI or other agreed upon data visualization tool
Integrate Google Gemini to enhance reporting with capabilities such as natural language querying, anomaly detection, forecasting, and AI-generated financial summaries
Ensure data accuracy, consistency, and refresh scheduling
Document all workflows, data connections, data structures, and report logic in clear, maintainable reference materials
Collaborate with Operations Manager to develop training materials and deliver hands-on training sessions for internal staff covering how to run, modify, and enhance reports and dashboards
Coordinate with Operations Manager to complete a structured handoff to ensure the team is confident and self-sufficient after the engagement ends
ABOUT FINANCIAL HEALTH NETWORK
Make an impact in the financial lives of millions with our growing organization. The Financial Health Network is the leading authority on financial health. We envision a future where all people, especially those who are most vulnerable, have the day-to-day financial systems they need to be resilient and thrive. We are a trusted resource for business leaders, policymakers and innovators united in a mission to improve the financial health of their customers, employees and communities. Through groundbreaking research, advisory services, measurement tools, and opportunities for cross-sector collaboration, we advance awareness, understanding and proven best practices in support of improved financial health for all. With offices in Chicago and Washington, DC, Financial Health Network is a highly collaborative environment, seeking people who share our values.
At Financial Health Network our mission to improve financial health for all, especially the most vulnerable, can only be accomplished through a diverse population of employees at all levels who are representative of the many communities we seek to impact. We strive to recruit, hire, develop, empower, and retain talented individuals at all levels across various dimensions of diversity and intersectionality including, but not limited to, race, ethnicity, sexual orientation, gender identity, gender expression, religion, age, neurodiversity, disability status, veteran status, and citizenship. We welcome and need your unique voice and look forward to having you join our team!
We will provide equal employment opportunities to all applicants without regard to an applicant’s race, color, religion, sex, sexual orientation, gender identity or expression, gender, genetic information, uniformed service, national origin, age, veteran status, disability, pregnancy, or any other status protected by federal or state law. We will provide reasonable accommodations to allow an applicant to participate in the hiring process (e.g., accommodations for a job interview) if so requested.
TO APPLY
Our mission is very important to us, and we would like to know why you would like to be a part of the Financial Health Network. Please submit a compelling cover letter and resume with your application