Financial Data Analyst

Ironsmith Fire, LLC; Collierville (TN); On-site; USD 65,000 - 100,000; Full time

Job summary

Ironsmith Fire, LLC is seeking a data analyst who connects financial and operational systems to deliver accurate, decision-ready data for leadership. You will design data pipelines, maintain relational models, and develop automated reporting across ERP, payroll, CRM, and more.

Partner with Finance and IT to translate accounts, budgets, and job-cost data into KPIs, dashboards, and self-service analytics; support ad hoc requests and drive process improvements with AI tools.

Qualifications

• Five+ years in data analytics, database administration/design, or related field.
• Advanced SQL skills and experience with relational databases.
• Experience developing and maintaining API integrations and ETL/data transformations.
• Practical use of AI/LLM tools for automation or analysis.
• Proficiency with BI/visualization tools like Power BI or Tableau.
• Working knowledge of financial reporting, job costing, or budgeting.
• Ability to explain technical findings to Finance and Ops stakeholders.

Responsibilities

• Design, build, and troubleshoot data pipelines and API integrations across ERP, job-cost, payroll/HRIS, CRM, and related systems.
• Develop relational databases and data models to support reliable financial and operational reporting.
• Transform and reconcile data from multiple sources into accurate reporting datasets.
• Implement data validation and quality controls and coordinate corrections with stakeholders.
• Build dashboards and reports for FP&A, Finance, leadership, and executives.
• Translate COA, budget, and job-cost information into KPIs and actionable insights.
• Support ad hoc analyses, variance analyses, and cross-branch comparisons.
• Collaborate with stakeholders to prioritize reporting requirements and define metrics.

Skills

SQL & data modeling

Data integration & API development

Financial literacy & job-cost analysis

BI, analytics, automation

Cross-functional collaboration & Stake

Documentation & data governance

Education

Bachelor’s degree in Computer Science / Information Systems / Data Analytics / Finance

Tools

Power BI

Tableau

Deltek ComputerEase

UKG

HubSpot

Job description

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

Location

Experienced (Non-Manager)

Category

Information Technology

Job Type

Travel

This position generally requires minimal to no travel

Job Description

POSITION SUMMARY

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 leadership.

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

Job Requirements

MINIMUM QUALIFICATIONS

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

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.

WORK ENVIRONMENT & TRAVEL

Work is primarily performed in a professional office environment at corporate headquarters, with frequent use of computers, databases, reporting applications, and virtual collaboration tools. The position requires coordination with IT, Finance, and operational teams and may occasionally involve travel to company branches or business sites. Work outside standard business hours may be necessary during system deployments, integration changes, or time-sensitive reporting cycles.

PHYSICAL REQUIREMENTS

The position generally requires extended periods of sitting and computer use; frequent verbal and written communication; and the ability to move within an office environment and attend meetings. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential job functions.

ADDITIONAL EXPECTATIONS

Perform other related duties as assigned. Responsibilities may evolve with the company’s systems, reporting needs, and organizational growth. This description summarizes the role and does not constitute a contract of employment.

COMMITMENT TO DIVERSITY

At Ironsmith Fire, we're dedicated to fostering an inclusive workplace where everyone feels valued and respected. We actively encourage applications from diverse backgrounds and believe that embracing differences enhances our team's creativity and effectiveness. Regardless of race, gender, age, religion, or other characteristics, we welcome all to join us in creating a culture where everyone can thrive.