Financial Data Analyst

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

Our mission is to empower elite teams to deliver solutions, uphold high standards, and achieve outstanding results. We work with general contractors, business owners, property developers, engineers, and many other types of clients to provide life-saving fire protection systems. Our core values are the backbone of our business and guide everything we do, including the hiring process. These core values are Workmanship, Accountability, and Results. Ironsmith Fire, LLC is privately owned and growing by the day.

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

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

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

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.