Design and maintain ETL flows, dashboards, and SharePoint forms; collect, validate, and analyze financial data; create reports and visualizations; ensure data integrity; automate processes; present insights to stakeholders and collaborate with cross-functional teams.
The Finance Data Analyst will be responsible for collecting, analyzing, and presenting data to support business decision-making. This role involves designing ETL data flows, developing business intelligence dashboards, creating user-friendly forms in SharePoint, and visualizing data through reports and charts. The ideal candidate will ensure data integrity, develop efficient data solutions, and collaborate with various teams to meet business needs.
Data Collection & Management
- Collect and compile data from various sources, ensuring accuracy and completeness.
- Maintain and update organizational dashboards.
Data Analysis & Reporting
- Analyze data to identify trends, patterns, and anomalies.
- Develop and maintain regular reports, dashboards, and visualizations to support decision-making.
- Create ad hoc reports as needed for special projects or inquiries.
Data Quality & Integrity
- Perform data validation and cleaning to ensure data quality.
- Monitor data quality metrics and implement improvements as necessary.
Collaboration & Communication
- Work closely with cross-functional teams to understand data needs and provide analytical support.
- Present findings and insights to stakeholders in a clear and understandable format.
Process Improvement
- Identify opportunities to streamline data collection and reporting processes.
- Implement automation where possible to improve efficiency and reduce errors.
Compliance & Security
- Ensure all data handling practices comply with company policies and relevant regulations.
- Maintain the confidentiality and security of sensitive data.
- Bachelor’s degree in Mathematics, Computer Science, Business or related field or equivalent years of relevant experience in lieu of degree
- Seven (7)+ years of progressive data reporting and analytics experience
- Ability to work independently and manage multiple tasks simultaneously
- Strong attention to detail and commitment to data integrity
- Ability to communicate complex data insights in a clear and concise manner to non-technical stakeholders
- Strong proficiency in Excel (Pivot Tables, Macros, Financial Modeling)
- Knowledge of data warehousing
- Experience with data visualization tools (Tableau, etc.)
- Strong analytical and problem-solving skills
- Proficiency in the following applications:
- Deltek Vantagepoint
- JavaScript
- Microsoft Power Automate
- Microsoft SharePoint
- Microsoft SQL Server
- Microsoft Visual Studio
- SQL Server Management Studio (SSMS)
- SQL Server Reporting Services (SSRS)
- Collaborative team environment
- Can be fully remote or in office if available
- Fast paced financial environment with complex business unit growth organically or via mergers and acquisitions
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
Similar Jobs
Professional Services
The Senior Finance Data Analyst leads financial analytics, reporting, and modeling, partnering with Finance leaders to drive insights and performance. Responsibilities include developing dashboards, managing data quality, and mentoring others in analytics best practices.
Top Skills:
AzureDaxMicrosoft Dynamics 365Power AutomatePower BISnowflakeSQL
.jpg)
Fintech • Insurance • Payments • Social Impact • Financial Services
Underwrite residential mortgage loans by reviewing credit, loan-to-value, debt ratios, property valuation and risk factors for compliance with bank and investor guidelines. Analyze exceptions, deficiencies, and special conditions; recommend alternative loan structures; coach field staff and brokers on technical underwriting issues; exercise independent judgment on matters with significant financial impact.
Fintech • Insurance • Payments • Social Impact • Financial Services
Manage final stages of residential mortgage closings: prepare and review Closing Disclosures, coordinate with settlement agents and attorneys, finalize funding and wiring, update LOS, ensure regulatory compliance (TRID/RESPA), and support post-closing and audit requests.
Top Skills:
Encompass Loan Origination SystemLoan Origination SystemMS Office
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
