IT Analyst, Business Intelligence

• 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.

• 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

• 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

• 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

• 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)

• 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.

• 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

• 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

• 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

• 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

• 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

• 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.

• 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

• 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

• 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.

• 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

• 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.

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

• 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

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

• 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

• 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

• 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

Atticus Advisory Solutions Inc