ERP Data Business Analyst

Vortex Consulting is seeking an experienced ERP Data Business Analyst to bridge operational ERP data and business intelligence. The role supports extracting, transforming, mapping, and analyzing data to enable business decisions, reporting, and insights.

Responsibilities:

• Write Functional Design Specs - Draft functional design documents that identify data sources from ERP systems, 3rd party systems, files, or scanned images and how best to map data into data warehouses
• Data Transformation & Cleansing: Format, and standardize data records to ensure consistency and accuracy before analytical reporting
• Data Mapping & Modeling: Create and maintain source-to-target mapping documents, data dictionaries, and transformation business rules
• Query Optimization: Write and optimize SQL queries to extract data
• Data Quality & Validation: Monitor datasets for completeness and integrity, performing reconciliation and troubleshooting data discrepancies
• Reporting & Insights: Build dashboards, generate analytical reports, and present data trends to business stakeholders

Requirements:

• Seeking an experienced functional ERP Data Business Analyst with excellent communication skills
• Proficient SQL skills to write, debug, and optimize SQL queries
• Experience with Data Mapping and ETL concepts
• Strong aptitude for data analysis and root-cause investigation
• Ability to maintain clear data flow and data mapping specifications
• Strong stakeholder-facing skills to capture business requirements and write functional design specification documents
• Experience supporting ERP Procurement (Purchasing), Spending, or Invoice Data
• Past roles as a Business Systems Analyst supporting large ERP projects or implementations
• Writing Functional Design Documents
• Oracle ERP experience