Data Engineer I - Finance

Total Quality Logistics; Cincinnati (OH); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Competitive compensation

Health, dental, vision

401(k) with company match

Employee discounts

Great Place to Work

Job summary

Total Quality Logistics is seeking a Data Engineer for FP&A to maintain and improve financial reporting across SQL, Power BI, Microsoft Fabric, Excel, and related data sources. You will work across Finance, Data Engineering, BI, and IT to translate reporting needs into practical, documented solutions.

You’ll help modernize reporting, migrate datasets to cloud, develop datasets and dashboards, apply governance, and support ad hoc reporting with rigorous QC and validation.

Qualifications

• Bachelor's degree in a relevant field is required.
• 1+ years of experience in BI, data engineering, or analytics engineering with hands-on SQL and Power BI.
• Proficiency in SQL with joins, aggregations, filtering, transformations, and troubleshooting.
• Power BI knowledge: reports, semantic models, relationships, DAX, Power Query, dashboard troubleshooting.
• Strong Excel skills and workbook review.

Responsibilities

• Build, maintain, and optimize SQL views, transformations, and pipelines for financial reporting.
• Assist in migrating FP&A datasets to Microsoft Fabric/Lakehouse cloud environment.
• Develop and optimize Power BI datasets, semantic models, and reports/dashboards.
• Apply best practices in DAX, modeling, and governance.
• Support recurring and ad hoc financial reporting and perform QC checks.

Skills

SQL

Power BI

Excel

Data validation

Education

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

Tools

Microsoft Fabric

Lakehouse

Databricks

Azure

Git

Power Automate

Job description

As a Data Engineer you’ll play a critical role within Financial Planning & Analysis (FP&A) responsible for maintaining and improving financial reporting solutions across SQL, Power BI, Microsoft Fabric, Excel, and related data sources. This role helps FP&A produce accurate, reliable, and repeatable reporting by understanding where data originates, how reporting logic is built, and how results should be validated. Working across Finance, Data Engineering, BI, and IT, the role translates defined reporting needs into practical, documented, and maintainable technical solutions. This position contributes directly to an ongoing effort to modernize and centralize financial reporting, reduce reliance on manual processes, and build a scalable, governed data foundation.

What’s in it for you:

• Competitive base salary plus performance-based bonus
• Work alongside an industry-leading Finance and FP&A team
• Health, dental, and vision coverage
• 401(k) with company match
• Employee discounts and additional perks
• Certified Great Place to Work with 900+ lifetime workplace awards
• Stability, growth, and long-term career development at a rapidly growing company

What you’ll be doing:

• Build, maintain, and optimize SQL views, transformations, and pipelines that support financial reporting.
• Assist in migrating FP&A datasets from on‑premises systems to the Microsoft Fabric/Lakehouse cloud environment.
• Power BI
• Develop, maintain, and optimize Power BI datasets, semantic models, and reports/dashboards.
• Apply best practices in DAX, modeling, and governance.
• Excel Modernization
• Help modernize and optimize complex Excel workbooks that rely on SQL, Power Query, and linked files.
• Support recurring and ad hoc financial reporting for FP&A.
• Perform quality control (QC) checks with strong attention to detail and accuracy.
• Perform data validation and reconciliation across systems and reports to ensure consistency.
• Communicate, troubleshoot, and resolve technical issues impacting reporting accuracy or performance.
• Support Finance automation and reporting‑process improvement initiatives.
• Assist with dashboard cleanup, report consolidation, and legacy process documentation.
• Participate in testing and validation of new data sources, semantic models, and enterprise datasets.
• Provide technical support and guidance to Finance report users.
• Continue developing skills in SQL, Power BI, and the Microsoft Fabric platform.
• Perform other duties and responsibilities as assigned.

What we’re looking for:

• Bachelor’s degree in computer science, Information Systems, Data Engineering, or related field.
• 1+ years of experience in BI, data engineering, or analytics engineering, including hands‑on work with SQL and Power BI.
• Proficiency in SQL, including joins, aggregations, filtering logic, data transformations, and query troubleshooting.
• Working knowledge of Power BI, including reports, semantic models, relationships, DAX, Power Query, and dashboard troubleshooting.
• Strong Excel skills, including formulas, pivots, linked files, structured tables, Power Query, and workbook review.
• Ability to investigate reporting discrepancies and trace issues across source data, SQL, Excel, Power BI, and report outputs.
• Ability to understand and document financial and operational business rules.
• Strong analytical, reconciliation, and problem‑solving skills with attention to accuracy and completeness.
• Ability to communicate technical findings clearly to both technical and nontechnical audiences.
• Ability to work in a deadline‑driven Finance environment with multiple priorities.
• Exposure to Microsoft Fabric, Lakehouse, Databricks, Azure, or similar cloud data platforms preferred.
• Familiarity with Tabular Editor, DAX Studio, Python, Git, or Power Automate is a plus.

Where you’ll be:

4289 Ivy Pointe Blvd, Cincinnati, OH 45245

Employment visa sponsorship is unavailable for this position. Applicants requiring employment visa sponsorship now or in the future (e.g., F-1 STEM OPT, H-1B, TN, J1 etc.) will not be considered.