Sign upLog in
Data Analysis Jobs in Saint Louis, MO

Data Analyst

The Timberline Group
  • Saint Louis, Missouri
    30+ days ago

    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.

     

    Numbers & Facts

    LocationSaint Louis, Missouri
    Websitehttp://www.timberlinegrp.com

    Skills

    • Budgetingunmatched
    • Business Intelligenceunmatched
    • Business Skillsunmatched
    • Cloud Computingunmatched
    • Communication Skillsunmatched
    • Cross-Functionalunmatched
    • Data Analysisunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Setsunmatched
    • Data Visualizationunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • ERP (Enterprise Resource Planning)unmatched
    • Financeunmatched
    • Financial Analysisunmatched
    • Financial Metricsunmatched
    • Financial Operationsunmatched
    • Financial Reportingunmatched
    • Financial Systemsunmatched
    • Financial Trend Analysisunmatched
    • Forecastingunmatched
    • Identify Issuesunmatched
    • Information Technology & Information Systemsunmatched
    • Microsoft Dynamicsunmatched
    • Microsoft Windows Azureunmatched
    • Performance Metricsunmatched
    • Performance Tuning/Optimizationunmatched
    • Power BIunmatched
    • Pricingunmatched
    • Problem Solving Skillsunmatched
    • Process Improvementunmatched
    • Profit & Loss Analysisunmatched
    • Python Programming/Scripting Languageunmatched
    • Query Optimizationunmatched
    • R Programming Languageunmatched
    • Reconciliationunmatched
    • Reporting Dashboardsunmatched
    • Reporting Skillsunmatched
    • Requirements Managementunmatched
    • SQL (Structured Query Language)unmatched
    • Stored Proceduresunmatched
    • Team Playerunmatched
    • Training Data Setsunmatched
    • Usability Engineeringunmatched
    • Variance Analysisunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder