Required Skills & Experience
Required
- Bachelor's degree in Information Systems, Finance, Accounting, Computer Science, Data Analytics or a related field, or equivalent work experience.
- 7+ years of experience in IT, business systems or data analytics.
- 5+ years of experience working with JDE E1 (version 9.0 or higher), including a strong understanding of its data structure, tables and how financial data moves through the system.
- Strong knowledge of the core JDE E1 financial modules: Address Book, G/L, A/P, A/R, Job Cost and Fixed Assets.
- 5+ years of experience with SQL for querying, reporting and data analysis. Moderate T-SQL knowledge.
- 3+ years of hands-on experience building dashboards and reports in Power BI.
- Experience supporting reporting in a customized (non-standard) JDE E1 environment.
- Strong analytical, problem-solving and data reconciliation skills.
- Ability to explain data and findings clearly to non-technical audiences, including executives.
- Advanced Microsoft 365 skills, especially Excel.
- Excellent written and verbal communication skills, and the ability to work with executives, managers and subject matter experts.
- Strong organization and time management skills.
- Able to manage changing priorities and meet deadlines in a fast-paced environment.
- Comfortable working on a team or independently with minimal supervision. Curiosity and a desire to learn new technologies.
Nice to Have Skills & Experience
Preferred
- Experience with Microsoft Fabric or other data warehousing platforms.
- Experience with JDE reporting tools such as BI Publisher, One View Reporting or Orchestrator.
- Familiarity with OneStream Financial Management platform.
- Familiarity with the Perceptive A/P document management product.
- Experience with Power Automate, Copilot Studio or other AI and automation tools.
- Experience with SharePoint, Microsoft Azure/Entra or user access management.
- General understanding of how systems integrate (APIs, data feeds). No development required. Basic understanding of ITSM/ITIL and the software development life cycle.
Job Description
SUMMARY The Senior ERP Data & Analytics Analyst turns the company's financial and ERP data into reporting, dashboards and insights that help leaders make decisions. The role focuses on data from the Oracle JD Edwards EnterpriseOne (JDE E1) ERP platform, the Perceptive A/P document management system and the Microsoft Fabric data warehouse. This person works closely with Finance, Accounting and IT to understand business needs, analyze data, build reporting and keep data accurate across systems.
This position reports to the Director of Enterprise Applications and may periodically be assigned to other project teams. The analyst may occasionally be needed outside normal working hours for maintenance activities, special projects and urgent issues.
ESSENTIAL JOB FUNCTIONS
- Partner with Finance, Accounting and business leaders to gather reporting and analytics requirements and turn them into clear, useful solutions.
- Design, build and maintain Power BI dashboards and reports on JDE E1 financial data (G/L, A/P, A/R, Job Cost, Fixed Assets, Address Book).
- Use SQL to query, analyze and validate data for ad hoc reporting and analysis.
- Support the Microsoft Fabric data warehouse, including data models, datasets and reporting layers that feed business reporting.
- Analyze and reconcile financial data across JDE E1, Perceptive, OneStream and other connected systems to ensure accuracy and consistency.
- Investigate, resolve and document user issues involving financial data and reporting.
- Work with technical teams and vendors on data integration projects by defining data requirements, mapping data and testing results.
- Use Microsoft Power Platform tools (Power BI, Power Automate) and Copilot Studio to automate reporting and routine business processes.
- Support the design and rollout of AI-related analytics and reporting solutions.
- Create and maintain documentation for reports, data definitions and business processes.
- Take part in quality assurance and user acceptance testing for system changes, upgrades and new reports.
- Work with the Service Desk to provide Tier 2 support for reporting and data questions.
- Make sure reporting changes and data access follow IT Change Management and Corporate/IT security policies.
- Perform other duties as assigned.