Skip to main content
Insight Global logo

Senior ERP Data and Analytics Analyst

Insight Global

Denver, COJobSeen todayIn the employer's feed · checked in the last 2 days

See where you stand before you apply. No sign-up to start.

You apply on the posting's application page, with no Olive account needed.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
No compensation found
Location
Denver, CO
Work Authorization
Not specified

Olive focuses on jobs in the United States, including remote roles you can work from there.

Job overview

The Senior ERP Data and Analytics Analyst turns financial and ERP data into reporting, dashboards, and insights for business decision-making. The role focuses on Oracle JD Edwards EnterpriseOne, Perceptive A/P, and Microsoft Fabric, partnering with Finance, Accounting, and IT to understand needs, analyze data, build reporting, and maintain accuracy across systems. The analyst reports to the Director of Enterprise Applications and may occasionally support work outside normal hours.

Skills & qualifications

RequiredNice to have

Skills

JDE E1, requiredJDE Financial Modules, requiredSQL, requiredT-SQL, requiredPower BI, requiredAnalytical Skills, requiredProblem Solving, requiredData Reconciliation, requiredData Communication, requiredMicrosoft 365, requiredExcel, requiredWritten Communication, requiredVerbal Communication, requiredOrganization, requiredTime Management, requiredPriority Management, requiredTeamwork, requiredIndependent Work, requiredCuriosity, requiredMicrosoft Fabric, nice to haveData Warehousing, nice to haveBI Publisher, nice to haveOne View Reporting, nice to haveOrchestrator, nice to haveOneStream, nice to havePerceptive a/P, nice to havePower Automate, nice to haveCopilot Studio, nice to haveAI Tools, nice to haveAutomation, nice to haveSharePoint, nice to haveMicrosoft Azure, nice to haveEntra, nice to haveUser Access Management, nice to haveSystems Integration, nice to haveAPIs, nice to haveData Feeds, nice to haveITSM, nice to haveITIL, nice to haveSoftware Development Lifecycle, nice to have

Qualifications

Bachelor's in Related Field or Equivalent Experience, required7+ Years IT or Analytics Experience, required5+ Years JDE E1 Experience, required5+ Years SQL Experience, required3+ Years Power BI Experience, requiredCustomized JDE E1 Experience, required

Full job description

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.

Skills and Requirements

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. 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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].

How this job compares

Set against the 4,647 open Data Analyst jobs on Olive Jobs, counted November 20, 2026.

Pay
  • This postingNot listed
  • Colorado median$85–120K/yr63 salary ranges
  • US median$40–50/hr372 hourly ranges
Openings
Olive Jobs lists 74 open Data Analyst jobs in Colorado and 4,647 across the US. 8% of them nationwide are listed as remote or flexible.
Hiring the most in Colorado
Experience
This posting asks for at least 7 years of experience — more than three in four Data Analyst postings that state a minimum ask for (median 3 years, across 3,676 postings).
Education
1,748 of the 4,647 open Data Analyst jobs (38%) ask for a bachelor's degree or higher.

Counted across the open, public US postings on Olive Jobs on November 20, 2026. Figures based on too few postings are left out.

Prepare for this role

You've read the whole posting — now see how you match it.