Analyst II Reports
Greenlee Textron Inc
Quezon City, National Capital Region,  Philippines
4d ago

Description :

To provide support to the different aspects of Fluid and Motion Control Sales and Marketing, focusing on Business Intelligence and Data Analysis in the creation of business-related reports, analyses and database management as needed by the business unit.

Responsibilities :

Report Scoping and Planning

Clarifies, evaluates and recommends scope, timeline and report structure.

Manages and monitors report request

Data Gathering

Performs data validation to achieve data consistency

Communicates with resource person to get input / raw data needed for report generation

Extracts quantitative information from databases

Data Manipulation

Cleans extracted data using pre-defined guidelines or instructions.

Formats extracted data based on expected report output. (multiple data formatting requirements)

Consolidates and standardize data structure from different data sources

Combines extracted data from different system tools in one single database using queries

Creates histograms, charts, summaries as necessary to aid in easy interpretation and better provide decision support to the Marketing and Sales Community

Calculates data using available fields within the gathered information. (statistics)

Data Analysis

Analyzes gathered information & data using predictive and prescriptive analytics (data interpretation, data correlation, forecasting with the use of advanced statistical tools, hypothesis testing)

Reporting

Provides status updates on report development, raise issues encountered and adjust timeline as appropriate.

Conceptualizes and develops tools / scripts that can automate the reporting process (usage of complex formula, Excel Macro, VBA, SQL).

Builds new reports and templates on top of existing business systems and makes them available to all users"

Creates and tests dynamic reports based on the designed format

Designs, tests and proposes improvement to reporting process optimization

Project Support

Assists the Sr Developer in gathering, analyzing and clarifying customer requirements; uses technical knowledge to gauge complexity of the request

Introduces and tests new technologies to continuously improve the technical capabilities of the team

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

Project Execution

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

Project Testing and Deployment

Implements the necessary fix or improvement for advanced functionalities based on the UAT results

Creates user manuals using standard templates of the team

Data sourcing and Integration (Extract, Transform, Load)

Joins and combines various data sources, systems, databases, reports, to come up with a single data output

Designs data structure to optimize data transfer.

Enhances and optimizes advanced query, views and procedures to improve efficiency and reliability of data manipulation

Conceptualizes and develop business reporting tools, database and records for business unit strategies

Communicates with resource person to get input / raw data needed for report generation

Troubleshoots major bugs / defects and assists associate developers in making sure issues / requests are resolved appropriately and on time (advanced bug / defects : loss of data, server errors, logical errors, unexpected app behavior)

Requirements : Education :

Education :

Bachelor’s Degree in MIS, Statistics, Economics, Industrial Engineering, Marketing, Information Technology, and other data analytics related course.

Job Related Experience :

Minimum 2 years of experience in reports and business intelligence, analytics and dashboard creation using data visualization tools such as Power BI and Tableau.

Specific Knowledge :

Intermediate proficiency in Business Intelligence Tools (Power BI or Tableau).

Experience with Power BI Data Analysis Expressions (DAX) .

Experience with data analysis, data modeling and data presentation (reports, charts, tables, dependencies, interfaces, etc.)

Proficiency in MS Excel, Pivot Table, VB Macro.

Working knowledge in other MS Office Applications (MS Team, SharePoint, Office 360 )

Familiarity with data warehouses and multidimensional database solutions

Intermediate knowledge in Statistics

Strong oral and written communication skills

Database Management

Data Manipulation & Interpretation

Skills :

Communication skills (oral & written)

Strong analytical skills

Time / work management

Problem solving skills

Detail oriented

Ability to work in a collaborative team environment

Good comprehension of technology and data management tools used in the process of collecting, storing, retrieving and analyzing data

Report this job
checkmark

Thank you for reporting this job!

Your feedback will help us improve the quality of our services.

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