Financial Data Analyst

Ironsmith Fire, LLC is seeking a Financial Data Analyst to connect financial and operational systems into accurate, consistent, decision-ready information for leadership. This role focuses on building integrations, structuring relational data for reporting, and delivering automated dashboards and analytics across finance and operational platforms.

What you’ll do

• 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, then 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 KPIs, management reporting, and actionable insights.
• Complete ad hoc analytical requests such as variance analysis, reconciliations, and cross-branch or cross–business unit comparisons.
• Collaborate with business stakeholders to prioritize reporting needs, clarify metric definitions, and deliver solutions aligned with operational requirements.
• Use approved AI/LLM tools, scripting, and automation to improve data transformation, analysis, coding, and recurring reporting workflows.
• Evaluate practical process improvements to reduce manual work, improve data availability, and ensure 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 remain repeatable and auditable.
• Coordinate with IT, Finance, and source-system owners on integration design, data access, technical requirements, and resolution of data quality issues.
• Follow company requirements for information security, confidentiality, access control, and change management when handling financial, employee, and operational data.
• Communicate technical findings and limitations clearly to nontechnical audiences and identify items that require escalation to IT management or Finance leadership.

Required qualifications

• Five or more years of experience in data analytics, database administration/design, or a closely related field.
• Advanced SQL skills, including 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 BI/visualization tool such as Power BI or Tableau.
• Working knowledge of financial reporting, including profit-and-loss statements, job costing, or budgeting.
• Ability to explain technical findings effectively to Finance and Operations stakeholders.

Technologies you may use

• SQL, Power BI, Tableau
• API integrations, ETL
• AI/LLM
• Deltek ComputerEase, UKG, HubSpot
• Python, dbt, Snowflake

Preferred qualifications

• Experience in construction, specialty contracting, field services, or job-cost accounting environments.
• Familiarity with Deltek ComputerEase, UKG, HubSpot, or comparable ERP, HRIS, and CRM platforms.
• Experience supporting ERP implementations or systems migrations.
• Python or other scripting experience for automation.
• Experience with dbt, Snowflake, or modern data warehousing platforms.
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Finance, or a related field, or equivalent practical experience.

Location and work environment

• Onsite role in Collierville, TN (corporate headquarters office environment).
• Frequent use of computers, databases, reporting applications, and virtual collaboration tools.
• Coordination required with IT, Finance, and operational teams; occasional travel to company branches or business sites may be needed.
• Work outside standard business hours may be necessary during system deployments, integration changes, or time-sensitive reporting cycles.

Core competencies

• 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

Minimum experience: Five or more years. Travel: Occasional travel may be required. Note: This job description summarizes the role and does not constitute a contract of employment.