Power BI Data Analyst - ERP & Finance Dashboards

The Timberline Group; St. Louis (MO); On-site; USD 65,000 - 100,000; Full time

Job summary

The Timberline Group in St. Louis, MO is seeking a Data Analyst to design and develop dynamic dashboards by integrating data from ERP systems. You will extract, transform, and consolidate data from multiple sources, ensuring accuracy and performance in reporting.

The ideal candidate has 3-5 years of experience in financial analysis or BI, with strong Power BI skills, SQL proficiency, and ERP integration experience. Collaboration with cross-functional teams is essential for impactful dashboards.

Qualifications

• Bachelor’s degree in Finance, Information Systems, Data Analytics, or a related field.
• 3-5 years of experience in financial analysis or business intelligence.
• Strong Power BI expertise with DAX, Power Query, and data modeling.
• Experience integrating ERP data (Epicor or Dynamics 365) into dashboards.

Responsibilities

• Extract, transform, and load (ETL) data from multiple SQL tables into Power BI.
• Design and build interactive dashboards and reports for financial metrics and trends.
• Optimize SQL queries for performance in Power BI data models.
• Ensure data integrity and consistency during ERP integration.
• Collaborate with stakeholders to understand reporting requirements including KPI dashboards.
• Connect Power BI to ERP systems (Epicor and Dynamics 365) for data extraction.

Skills

Power BI

DAX

Power Query

SQL

Data modeling

ETL

Financial analysis

Variance analysis

Communication

Python/R

Education

Bachelor’s degree in Finance, Information Systems, Data Analytics, or related field

Tools

Epicor

Microsoft Dynamics 365

SQL Server

Azure

Job description

The Timberline Group in St. Louis, MO is seeking a Data Analyst to design and develop dynamic dashboards by integrating data from ERP systems. You will extract, transform, and consolidate data from multiple sources, ensuring accuracy and performance in reporting.

The ideal candidate has 3-5 years of experience in financial analysis or BI, with strong Power BI skills, SQL proficiency, and ERP integration experience. Collaboration with cross-functional teams is essential for impactful dashboards.