IT Project Lead Analyst, Supply Chain Systems
Emerson
Quezon City, National Capital Region, Philippines
16d ago

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

Data Gathering

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

Data Manipulation

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)

Data Analysis

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

Reporting

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

Project Initiation

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

  • 3.Leads scope reviews - drives the conversation, provides overview of the team including processes, capabilities and purpose;
  • 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

  • Leads the planning of projects (static / dynamic sites), apps w / straight forward business rules, high quantity low complexity).
  • 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

  • Validates developed system / tool and output with the stakeholders based on requirements. Provide in-depth analysis on data integrity issues.
  • 18.Approves KPI report design. Provide recommendations and validate with stakeholders.

    Project Execution

    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

    Requirements

    Education : Bachelor of Science, Information Technology, Computer Science, Computer Engineering, or any related field of study / equivalent experience

    Job Related Experience :

  • At least 7 years’ relevant work experience in the IT software development field
  • Experience in web programming, support and project management
  • Specific Knowledge :

  • Microsoft Office
  • Data Interpretation & Data Correlation
  • Web Development, design and Programming
  • Product datasheets, Price Awareness, manuals & catalogs
  • Basic understanding of MRP, ERP and SRM systems and tools
  • Basic understanding of strategic procurement and how it ties up with the business outcomes.
  • In Depth understanding of Procurement systems and how it ties up with the financial exhibits
  • In Depth understanding of financial data and how to interpret it to useful information for management
  • Familiarity with commodities
  • Comparative Analysis
  • Root Cause / Gap Analysis
  • In Depth understanding of Ariba System Skills :
  • Advanced Microsoft Excel proficiency Level 3 - Advanced Formulas, Pivot Tables & VBA Macros
  • Oral and written communication skills
  • Programming Skills (SQL, Java)
  • Project Management
  • Problem Solving & Analytical Skills
  • Database Management Skills
  • Presentation Skills
  • Training Skills
  • Software design skills
  • Proficient in written and oral communication skills in a technical environment
  • Web & software development
  • About Emerson

    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.

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form