Data Analyst

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

Not eligible for C2C

Candidates must be legally authorized to work in the US without sponsorship.

Must reside in the US

Ever dream of doing work that makes a difference? Want to join a growing company? Here it is! We seek the talent of a dynamic Data Analyst who seeks to bring their A game to a collaborative team of talented professionals. You are not afraid to make impact where your opinion matters in a company that has a masterful, mature history that operates as best-in-class.

We are seeking a skilled Data Analyst to design and develop dynamic, actionable dashboards by integrating data from diverse ERP systems. The role involves extracting, transforming, and consolidating data from multiple sources, ensuring accuracy and consistency in reporting. The ideal candidate will excel in creating insightful visualizations that drive business decisions while maintaining a strong focus on data integrity and performance optimization. Collaboration with cross-functional teams to understand and translate business requirements into impactful dashboards is essential.

The Data Analyst will work to support our St. Louis region.

As a Data Analyst, you will:

• Extract, transform, and load (ETL) data from multiple SQL tables into Power BI.
• Design and build interactive dashboards and reports tailored to financial performance metrics and trends.
• Optimize SQL queries for performance in Power BI data models.
• Ensure data integrity and consistency during integration.
• Collaborate with stakeholders to understand reporting requirements including, but not limited to dynamic KPI dashboards and variance analysis reports.
• Connect Power BI to Epicor and Microsoft Dynamics 365 for seamless data extraction and visualization.
• Collaborate with IT to ensure proper data flows between systems and Power BI.
• Troubleshoot and optimize ERP data connections for efficiency and reliability.
• Build robust data models in Power BI to analyze financial datasets, including budgeting, forecasting, pricing and profitability analysis.
• Use advanced DAX formulas and Power Query to derive insights from complex ERP datasets.
• Ensure data integrity by reconciling Power BI outputs with Epicor and Microsoft Dynamics 365 records.
• Partner with finance teams to understand business requirements and deliver custom reporting solutions.
• Work with ERP administrators to enhance the usability and functionality of Epicor and Dynamics 365 data for reporting purposes.
• Automate routine financial reporting by leveraging Power BI and ERP integration capabilities.
• Identify and implement process improvements to streamline financial operations and reporting cycles.
• Train finance and operational teams on utilizing Power BI dashboards and ERP-integrated reports.
• Act as a subject matter expert for Power BI and ERP reporting capabilities within the organization.

About You:

• 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 expertise in Power BI, including DAX, Power Query, SQL skills (query optimization, joins, stored procedures) and data modeling.
• Ability to translate business requirements into actionable dashboards.
• Advanced knowledge of SQL for data extraction and manipulation.
• Familiarity with financial processes, including P&L analysis, budgeting, and forecasting.
• Excellent communication skills to explain complex data insights to non-technical stakeholders.
• Strong problem-solving and critical-thinking abilities.
• Knowledge of Python/R for data manipulation (optional but beneficial).
• Experience with Power Query or other ETL tools.
• Familiarity with Azure or cloud-based data services (if applicable).
• Familiarity with Epicor and/or Dynamics 365.