IT Analyst, Business Intelligence

Financial: (normally on annual consideration)

• Related to monetary value that a function has the authority to budget, distribute, disburse, track, etc. for the whole team/group;

• Necessary to indicate for someone who has the authority to approve with finality and has the accountability to decide on the actual usage of budget/ fund.

Duty 1: Insights & Analytics

Data Gathering

• Extracts/generates quantitative information from a single or multiple source (Business Intelligence Tools – i.e.: Tableau/Power BI, SQL, Oracle, One BI, Noetix, CRM etc.) and/or from databases using standard queries
• Communicates with resource person to get input data needed for report generation
• Conducts research to gather qualitative information (market need, market size, ethnography, competitive product information, industry trends, and check product specifications) from internal & external sources that will be used for analyses

Data Processing

• Cleans extracted data using pre-defined guidelines or instructions
• Formats extracted data based on expected report output (with batching capability and multiple data formatting requirements)
• Calculates data using available fields within the gathered information
• Categorizes and segments extracted data using tools to convert data to information relevant to the report (excel, macro, database)
• Combines extracted data from multiple resources using automated tools (excel, macro, database), and/or from different system tools in one single database using queries (SQL, Tableau/Power BI, Oracle, One BI, Noetix, CRM) standardize data structure from different data sources

Data Analysis

• Analyzes report requirements from stakeholders. Identify and provide solution to general inquiries
• Analyzes gathered data using descriptive analytics (basic mathematics & comparative analysis), diagnostic analytics (root cause analysis, gap analysis), predictive and prescriptive analytics (data interpretation, data correlation & statistics)
• Analyzes stakeholder requirements from an existing report and provides improvement and recommendation based on customer request
• Evaluates and customizes reports aligned with customer requirements

Reporting

• Creates standard and customized report aligned with customers requests
• Conceptualizes report design contents and methodologies based on gathered data and/or analysis for static or dynamic reports
• Develop reports and dashboards using different business intelligence and data visualization tools (Tableau, PowerBI)

Provides insights and validates with stakeholders if recommended solutions address business questions and are aligned with the objectives

Strategic Pricing

• Escalates model configuration issues to product configuration solutions team
• Validates price performance metrics (Sales, AUP, Realized Price)
• Performs price data warehouse activities related to price increase and factors update.

Duty 2: Project Support

Project Initiation

• Attends scope reviews to learn what the project request is all about
• Assists project manager in gathering, analyzing, and clarifying customer requirements; uses technical knowledge to gauge complexity of the request
• 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

• Performs research and analysis to validate if the detailed solution is the best fit to meet the requirements
• Creates prototypes, mock-ups using standard project templates and tools for projects without wireframes
• Provides own work estimates and can negotiate turnaround time within the team
• Informs the project lead on changes
• Creates process maps, user journey maps or database design using standard project templates
• Creates project scope and timeline for dashboards. In case of differences, negotiates with clients for dashboards.
• Leads project milestone and gate reviews
• Introduces and tests new technologies to continuously improve the technical capabilities of the team
• Reviews and assesses prototypes in terms of relevance and application to the requirements of the customers
• Analyzes risk and mitigate project circumstances based on impact assessment
• Understands the high-level view of the project and can identify interdependencies in the early stages of the project
• Breaks down project objectives into modules or deliverables and cascades them to the team
• Recommends the final process map, user journey map, prototypes, mockups, or database design to be used by the system
• Assesses scope creeps by analyzing importance and impact to overall project; communicates the assessment to the team and negotiates if needed

Project Execution

• Writes code based on specifications defined (i.e. frontend and backend); Participates in cross-functional testing and peer reviews
• Follows set coding standards, code sharing and design guidelines of the team
• Shares working codes with the teams.

• Develops simple modules or basic functionalities
• Reports own progress back to the project tracking tool
• Troubleshoots and optimizes codes of other team members and resolves code conflicts.
• Creates coding standards and design guidelines or any development related improvement
• Develops complex modules or advanced functionalities
• Recommends and negotiates solution and development timeline to the stakeholders; gets their buy-in and commitment to any deliverable

Project Testing and Deployment

• Sets up UAT (informing participants, scheduling, gathering results)
• Implements the necessary fix or improvement for basic functionalities based on the UAT results
• Creates user manuals using standard templates of the team
• Creates test cases to be used during UAT
• Finalizes and approves the test cases to be used during UAT
• Reviews the objective in comparison to the actual output
• Create, recommends, and seek approval for UAT plan (data back-up/migration, communication, cut-offs, code freeze, production server setup)
• Secures commitment on critical deliverables from different stakeholders and training to align with Go-Live plans
• Performs import/export of records and/or data for validation
• Create workbooks/ dashboards, modify metadata, and finally publish a completed workbook or data source to server

Project Maintenance

• Troubleshoots minor and/or major bugs/defects and assists in making sure issues/requests are resolved appropriately and on time (minor: UI fixes, raw data requests; advanced bug/defects: loss of data, server errors, logical errors)
• Evaluates and decides which request goes to the project backlog for next phase of the project

Continuous Process & Innovation

• Records and reviews the improvements raised by the business unit.
• Escalates project concerns and recommends solutions to address them.
• Works closely with counterparts/POCs to identify loopholes and process gaps.
• Validates and tracks if the business units action plan adequately addresses the project concerns to drive successful results.

Vendor Support

• Monitors the progress of the issues based on the timeline
• Monitors the progress of 3rd party suppliers, coordinates with stakeholders if there are issues and concerns
• Assesses/Rates contractors’ performance based on specified criteria

• Analyzes issues and concerns and recommends solution on how to manage the 3rd party vendor

Duty 3: System Support and Maintenance

System Maintenance

• Implements the basic change request (dashboard enhancements, data source modifications)
• Performs testing of published dashboards
• Monitors errors and data inconsistencies.
• Recommends improvement on change request and processes
• Setup user access and active directories

Database Maintenance

• Develops and manages the teams Datawarehouse, connecting various data sources into one repository
• Troubleshoots minor problems thru minor UI changes, correcting typo errors, and identifying coding errors
• Troubleshoots major problems thru Logical system checks, identifying database errors, etc.

Maintenance & Upgrades

• Encodes new features or changes related to the system upgrade
• Creates and Sends maintenance announcements to end-users
• Monitors data transfer and load processes
• Monitors errors and data inconsistencies
• Controlling permissions for system contents such as data sources, workbooks, and views for data security.
• Gathers approval and validates completeness of the requirements
• Provides basic technical support on issues such as user contact, issue triage, user follow-up and communication
• Interprets BU/Platform/WA report requirements and cascade to action owner
• Maintain existing system functionality and capacity as needed based on identified issues and improvements
• Validates new features thru testing
• Troubleshoots business system issues and relays them to other world areas and IT
• Propose and Implement Preventive action to avoid issue recurrence
• Troubleshoots business systems/data issues with the 3rd party vendor and gives feedback to end-users

Duty 4: Operations Support

Documented Information Management

• Creates technical documentation/user manual (database architecture which involves table formats, ETL structure, dependencies of table (back end), data dictionary, database schema, etc.)
• Updates and maintains the following information and processes (e.g. procedures, forms, templates, manuals, articles, etc.)
• Identifies and controls the storage, retention, and disposal of documentation.

Create a new Documented Information related documents and processes (e.g. procedures, forms, templates, manuals, articles, external documented

• information, etc.) based on documentation guidelines (e.g. identification, description, format)

Training and Development

• Conducts basic and/or intermediate and comprehensive overview and awareness training on products, processes and/or business tools
• Coaches and Mentors other analysts in a functional/technical capacity

Duty 5: Continuous Improvement and Innovation

Identifies continuous improvement project ideas

Records and reviews/assess the improvement/innovation raised by the business unit

Escalates specific issues and provides recommendation to customers to address them.

Support projects related to quality improvement (such as Think Customer, QMS, etc.) and handles tasks to support the objectives of the management.

Education:

• Bachelors degree or equivalent (Computer Science, Computer Engineering, Information Technology, Information Systems or similar) is preferred

Job Related Experience:

• At least 5 Fresh graduate3-5 years of relevant work experience in IT software development field, data mining, manipulation, analysis and reporting.years of relevant experience in Oracle Business Intelligence Tools (Noetix), Project Management and Support & maintenance

Required Specific Knowledge:

• Microsoft Office 365 tools (MS Word, Excel, Access, PowerPoint, Project)
• Strong kKnowledge in writing complex SQL and PLSQL programs
• SQL Developer, PVCS, Kintana, HP Service Manager, Service Now
• Knowledge in Oracle e-Business Suite
• Oracle Production Business Systems

Skills:

• Advanced Microsoft Excel proficiency Level 3 – Advanced Formulas, Pivot Tables & VBA Macro
• Oral and written communication Skills
• Problem Solving & Analytical Skills
• Presentation Skills
• Training Skills
• Project Management Skills
• Marketing and/or sales aptitude