Description To support the Supply Chain communities through business systems and data analysis, business intelligence and project management, by combining analytics, supply chain and information technology (database) skills (SQL, Java programming).
She, He will also be responsible for leading, training and mentoring junior analysts in performing his / her job function.
Particular focus will be on Group level projects across Business Units for which are required strong project management skillset.
Responsibilities Duty 1 : Metrics, Reporting and Analytics
1. Extracts / generates quantitative information from a single or multiple tools (Business Intelligence Tools (ie : SSIS, etc)
2.Communicates with resource person to get input / raw data needed for report generation
3.Extracts / generates quantitative information from databases using standard queries. (basic coding)
4.Communicates with resource person to get input / raw data needed for report generation
5.Conducts research to gather qualitative information (competitive product information, industry trends, and check product specifications) from internal & external sources that will be used for analysis
1.Cleans extracted data using pre-defined guidelines or instructions
2.Formats extracted data based on expected report output. (with batching capability)
3.Calculates data using available fields within the gathered information (basic math)
4.Calculates data using available fields within the gathered information. ( statistics)
5.Formats extracted data based on expected report output. (multiple data formatting requirements)
6.Categorizes and segments extracted data using tools to convert data to information relevant to the report (excel, macro, database)
7.Consolidates and standardize data structure from different data sources
8.Combines extracted data from multiple resources using automated tools (SSIS, Excel, Macro, Database)
9.Combines extracted data from different system tools in one single database using queries (SQL, MS Access)
1.Gathers and analyzes report requirements from stakeholders. Identify and provide solution to general inquiries
2.Analyzes gathered information & data using descriptive analytics (basic mathematics & comparative analysis)
3.Analyzes gathered information & data using diagnostic analytics (root cause analysis, gap analysis)
4.Analyzes stakeholder requirements from an existing report and provides improvement and recommendation based on customer request
5.Analyzes gathered information & data using predictive and prescriptive analytics (data interpretation, data correlation & statistics)
6.Analyzes gathered information & data using predictive and prescriptive analytics (data interpretation, data correlation, forecasting with the use of advanced statistical tools, models, hypothesis testing)
7.Evaluates objectives and recommends non-standard reports / workaround based on customer requirement
8.Evaluates objective / charter and recommends non-standard reports / workaround based on gathered data and analysis
1.Creates supply chain related reports based on standard templates
2.Creates and tests dynamic reports based on the designed format
3.Conceptualizes report design contents and methodologies based from gathered data and / or analysis for static or dynamic reports
4.Provide report recommendations and validate with stakeholders.
Duty 2 : Project Support / Management
1.Attends scope reviews to learn what the project request is all about.
2.Drives or assists the project manager in gathering, analyzing and clarifying customer requirements; uses technical knowledge to gauge complexity of the request
Understands or uncovers the real need for the project; uses technical and business knowledge to have an initial understanding of the value, impact and complexity of the project
Project Planning and Design
1.Creates prototypes, mock-ups using standard project templates and tools for projects without wireframes.
2.Provides own work estimates and can negotiate turnaround time within the team. Informs the project lead on changes.
3.Encodes documentation using standard project templates; stores and organizes the documents to the team’s repository.
4.Creates process maps, user journey maps or application / database design using standard project templates
5.Creates project scope and timeline for small applications. In case of differences, negotiate with clients for small applications
6.Leads project milestone and gate reviews
7.Introduces and tests new technologies to continuously improve the technical capabilities of the team
8.Reviews and assesses prototypes in terms of relevance and application to the requirements of the customers
9.Recommends and negotiates solution and development timeline to the stakeholders; gets their buy-in and commitment to any deliverable
10.Analyzes risk and mitigate project circumstances base on impact assessment
Understands the high level view of the application and can identify dependencies or conflicts during the early stages of the project.
Breaks down project objectives into modules or deliverables and cascades them to the team
11.Plans resource requirements to meet the budget provided by project sponsor - man hours and materials (hardware / software).
Leads planning sessions to create process maps, user journey maps, prototypes, mock-ups or database design; decides what functionalities are needed vs those that are nice to have.
Recommends the final process map, user journey map, prototypes, mock-ups or database design to be used by the system
12.Decides on how to handle scope creeps by analyzing importance and impact to overall project; communicates the decision to the stakeholders and negotiates if needed
13.Designs and creates solution / system architecture (high level overview of the system focusing on the back-end part).
Creates an overall plan for the project (ex : quad charts, project charter)
Data Sourcing and Integration
1.Monitors continuity of ETL (Extract, Transform, Load) processes.
2.Connects on established access to all identified sources
3.Communicates with resource person to get input / raw data needed for report generation
4. Decodes data fields / column equivalents from existing data source table to another
5.Troubleshoots basic connectivity problems both hardware and software. Execute a reliable solution.
6.Writes basic query (like CRUD statements) and views to extract data needed for ETL process.
7.Creates and designs prototypes, mock-ups based on agreed requirements
8. Performs internal quality checks on developed system and tool's output
9.Decodes data fields / column equivalents from unidentified data source table to another
10.Designs data structure to optimize data transfer
11.Writes intermediate query (like joins, stored procedure, functions) and views to extract data needed
12.Joins and combines various data sources, systems, databases, reports, to come up with a single data output
13.Negotiates with stakeholders to get access when there is conflict of priorities
14.Writes advanced queries (like joins, stored procedure, functions and use of variables) to be used on non-standard and customized reports
15.Enhances and optimizes advanced query, views and procedures to improve efficiency and reliability of data manipulation (SSIS, VBA, Excel Macro, VB .Net, SQL)
16.Writes advanced features of the integration services tool (ex. SSIS) to achieve target output used on data extract transformation and loading for various sources. For ETL Process.
17,Conceptualizes and develop business reporting tools, database and records for business unit strategies (usage of complex formula, macro, VBA and MS Access, TSQL, Tableau).
For Extract Transform Load Process
18.Approves KPI report design. Provide recommendations and validate with stakeholders.
1.Writes code based on specifications defined (i.e. UI, back-end coding); Participates in cross-functional testing and peer reviews.
2.Follows set coding standards, code sharing and design guidelines of the team.
3.Shares only working codes with teams.
4.Develops simple modules or basic functionalities.
5.Reports own progress back to the project tracking tool.
6.Troubleshoots and optimizes codes of other team members and resolves code conflicts.
7. Test coding standards and design guidelines or any development related improvement
8.Develops complex modules or advanced functionalities
9.Sets up the development environment, configures servers, create database and project solutions, necessary permissions, code repository and populates project tracking tool.
10. Approves coding standards and design guidelines and implements them to the team
Project Testing and Deployment
1.Sets up UAT (informing participants, scheduling, gathering results).
2.Creates user manuals using standard templates of the team.
3.Implements the necessary fix or improvement for advanced functionalities based on the UAT results.
4.Creates user manuals using standard templates of the team
5.Creates test cases to be used during UAT
6.Finalizes and approves the test cases to be used during UAT
7.Identifies, analyzes and mitigates UAT and Go-Live test results issues.
8.Reviews the objective in comparison to the actual output
9.Create, recommends and seek approval for UAT plan (data back-up / migration, communication, cut-offs, code freeze, production server setup)
10.Secures commitment on critical deliverables from different stakeholders such as marketing, training to align with Go-Live plans
Duty 3 : System Support and Maintenance
1.Gathers requirements and approvals needed
2.Monitors the progress of all transactions
3.Reviews and analyzes web project requirements and approvals needed. Provides recommendations on the content.
4.Monitors errors and data inconsistencies
5.Troubleshoot and fix minor problems with the tool. Such as minor UI changes, typo errors, simple coding errors
6.Troubleshoots and fixes major problems with the tool. (Logical, system, database errors and changes)
7.Performs import / export of records and / or data for validation
8.Create workbooks / dashboards, modify metadata, and finally publish a completed workbook or data source to SQL Server
9.Organize activities with the contractors for system readiness assessment and in-house testing prior to delivery of support service from the vendor.
10.Encodes new features or changes related to the system upgrade
11.Creates and Sends maintenance announcements to end-users
12.Monitors data transfer and load processes
13.Controlling permissions for system contents such as data sources, workbooks, and views for data security. Gathers approval and validates completeness of the requirements
14.Provides basic technical supporton issues such as user contact, issue triage, user follow-up and communication
15.Interprets BU report requirements and cascade to action owner
16.Maintain and upgrade existing system functionality and capacity as needed based on identified issues and improvements (involves additional scripting and modification in user interface)
17.Validates new features thru testing
Education : Bachelor of Science, Information Technology, Computer Science, Computer Engineering, or any related field of study / equivalent experience
Job Related Experience :
Specific Knowledge :
Imagine being surrounded by intelligent, driven, and passionate innovators all working toward the same goal to create groundbreaking solutions that leave our world in a better place than we found it.
Emerson is a global technology and engineering company providing innovative solutions for customers in industrial, commercial, and residential markets.
Our Emerson Automation Solutions business helps process, hybrid, and discrete manufacturers maximize production, protect personnel and the environment while optimizing their energy and operating costs.
Our Emerson Commercial and Residential Solutions business helps ensure human comfort and health, protect food quality and safety, advance energy efficiency, and create sustainable infrastructure.
A dynamic environment is what you’ll discover at Emerson, a Fortune 500 company with $14.5 billion in sales and 155 manufacturing locations worldwide.
Together, we’re changing the world, and we have all the resources to help you achieve your professional goals.
Whether you’re an established professional looking for a career change, an undergraduate student exploring options, or recently received your MBA degree, you’ll find a variety of opportunities at Emerson.
Join our team and start your journey today.