Financial Data Analyst at Ironsmith Fire, LLC
Collierville, TN — full-time
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. KEY RESPONSIBILITIES Data Integration & Architecture • 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. Financial Analytics & Reporting • 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. Automation, AI & Process Improvement • 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. Data Governance & Cross-Functional Support • 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