Financial Data Analyst: ERP, BI & Automation

Ironsmith Fire, LLC; Memphis (TN); On-site; USD 85,000 - 110,000; Full time

Job summary

Ironsmith Fire, LLC in Memphis, TN is seeking a Data Analyst to connect financial and operational systems and deliver accurate, decision-ready data. You will develop data integrations, maintain data models, and produce automated reports across ERP, payroll, CRM, and more.

You will partner with Finance and IT to improve reporting reliability, visibility, and efficiency, translating complex data into actionable insights for leadership and branch managers.

Qualifications

• Five+ years of experience in data analytics or related field.
• Advanced SQL skills and experience designing and working with relational databases.
• 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 BI tools such as Power BI or Tableau.

Responsibilities

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

Skills

SQL

Relational data modeling

Data integration

API development

ETL

BI tooling

Data governance

Analytical thinking

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Finance, or related field

Tools

Power BI

Tableau

dbt

Snowflake

Deltek ComputerEase

UKG

HubSpot

Job description

Ironsmith Fire, LLC in Memphis, TN is seeking a Data Analyst to connect financial and operational systems and deliver accurate, decision-ready data. You will develop data integrations, maintain data models, and produce automated reports across ERP, payroll, CRM, and more.

You will partner with Finance and IT to improve reporting reliability, visibility, and efficiency, translating complex data into actionable insights for leadership and branch managers.