Financial Data Analyst

Share this job as a link in your status update to Linked In.

Location

Experienced (Non-Manager)

Category

Information Technology

Job Type

Travel

This position generally requires minimal to no travel

Job Description

The Data Analyst connects financial and operational systems to provide accurate, consistent, decision-ready data for Ironsmith Fire leadership. This role develops and maintains data integrations, relational data structures, automated reporting, and analytics solutions spanning accounting, job costing, payroll/HRIS, CRM, and other business platforms. Working within IT and in close partnership with Finance, the analyst combines strong technical execution with financial and operational understanding to improve reporting reliability, visibility, and efficiency.

• Design, build, maintain, and troubleshoot data pipelines and API integrations connecting ERP/accounting, job-cost, payroll/HRIS, CRM, and related business systems.
• Develop and maintain relational database schemas, data models, and structures that support reliable financial and operational reporting.
• Transform, standardize, join, and reconcile data from multiple source systems into accurate reporting datasets.
• Implement data validation, reconciliation, and quality controls; investigate root causes of discrepancies and coordinate corrections with system stakeholders.

• Build, maintain, and enhance dashboards, recurring reports, and self-service analytics for FP&A, Finance, branch/division leadership, and executives.
• Partner with Finance to translate chart-of-accounts, budget, and job-cost information into understandable KPIs, management reports, and actionable insights.
• Respond to ad hoc analytical requests, including variance analysis, reconciliations, and comparisons across branches or business units.
• Collaborate with business stakeholders to prioritize reporting requirements, clarify metric definitions, and deliver solutions aligned with operational needs.

• Use approved AI/LLM tools, scripting, and automation to improve data transformation, analysis, coding, and recurring reporting workflows.
• Evaluate and implement practical process improvements that reduce manual work, improve data availability, and maintain appropriate review and validation of automated outputs.
• Support testing and ongoing enhancement of data integrations, reporting tools, and relevant system implementations.

• Document data flows, transformation logic, business definitions, system dependencies, and reporting procedures so outputs are repeatable and auditable.
• Coordinate with IT, Finance, and source-system owners on integration design, data access, technical requirements, and resolution of data quality issues.
• Apply company information-security, confidentiality, access-control, and change-management requirements when handling financial, employee, and operational data.
• Communicate technical findings and limitations clearly to nontechnical audiences, and identify issues requiring escalation to IT management or Finance leadership.

• SQL, relational data modeling, and technical problem-solving
• Data integration, API development, ETL, and analytical accuracy
• Financial literacy, job-cost analysis, and business acumen
• Business intelligence, automation, and responsible AI tool use
• Cross-functional collaboration and clear stakeholder communication
• Documentation, information stewardship, attention to detail, and accountability for results

Job Requirements

• Five or more years of experience in data analytics, database administration/design, or a closely related field.
• Advanced SQL skills and hands-on experience designing and working with relational databases.
• Demonstrated experience developing and maintaining software-system API integrations and ETL/data transformation processes.
• Practical experience using AI/LLM tools for coding, automation, or analysis.
• Proficiency with at least one business intelligence or visualization tool, such as Power BI or Tableau.
• Working knowledge of financial reporting, profit-and-loss statements, job costing, or budgeting.
• Ability to explain technical findings effectively to Finance and Operations stakeholders.

• Experience in construction, specialty contracting, field services, or job-cost accounting environments.
• Familiarity with Deltek Computer Ease, UKG, Hub Spot, or…