Financial Data & Analytics Engineer

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

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.