Overview
Skills
Job Details
Functional expertise in Manufacturing consultant with hands on Mfg Work Orders and Service Work orders using either one of the ERP (Oracle Cloud /Oracle EBS)
o Strong knowledge of SQL
o It's beneficial to have a resource with a good understanding of various BI reporting tools.
o Support in requirement gathering, data validation, and ongoing support to other teams like Data Modeler, ETL and BI Reporting
o 7+ years of experience as a highly technical Business Analyst, or Business Systems Analyst supporting data and analytic software development projects.
o Basic understanding of table-level architecture for data mapping from the ERP perspective is advantageous.
o Support in requirement gathering, data validation, and ongoing support to other teams like Modeling, ETL and Reporting.
o Provide guidance in analytics reporting involving scorecards, dashboards, KPIs, and adhoc reports.
o Leverage a solid understanding of domain specific knowledge, and the end-user experience to impact the final data visualization product, which includes dashboards, reports, insights, or analyses.
o Performs data analysis on different data sources (multiple ERP), consolidating multiple data sets and analyzing the data accurately and efficiently.
o Collaborate with reporting and end users to document the As-Is and To-Be state of existing data warehouses, focusing on:
KPIs and metrics
Data models and relationships
Business and technical logic
Transformation rules and technical specifications
o Documents current and emerging business needs and works with internal and external service providers to define and deliver data and analytics solutions.
o Assists with the development of test designs and develops test cases
o Participates in sessions to gather business context from Product Owners, analyze, document findings.
o Collaborates with internal customers to ensure user requirements are complete and concise, confirming that changes and enhancements meet technical specifications and user requirements.
o Performs business process analysis to define how data and analytic solutions should be configured to meet those needs.