Finance Data Analyst

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.

Skills and experience

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

Work environment

• 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