Reports Analyst | Blended WFH & Onsite

Industry Category	Sciences	Position	Actuarial / Statistics
Recruitment Department		Number Of Recruits	several
Work Location	Metro Manila (NCR) Quezon City	Nature Of Work	Full Time
Gender Requirements	Male	Marriage Requirement	No marital status restrictions
Education Level	College Diploma	Work Experience	No work experience restrictions
Age Requirement	Above 18 years old	Salary Package	Negotiable
Updated Date	2022-09-26	Valid Until	Long-term validity

Duty 1: Metrics, Reporting and Analytics

Report Scoping and Planning

Monitors and assigns incoming emails in common mailbox and respond to customer inquiriesUpdates internal trackers and databases to ensure that all transactions/requests are recordedCoordinates and validates with stakeholders on reporting requirements (product quality metrics, new vs. legacy).

Data Gathering

Extracts/generates quantitative and qualitative information from multiple tools (Business Intelligence Tools (i.e.: Power BI, Tableau, etc.)Gathers and collates data from different sources based on approved requirements (Established Simple Reporting)Communicates with resource person to get input/raw data needed for report generationExtracts/generates quantitative information from databases using non-standard queries. (basic and intermediate coding)Performs data validation to achieve data consistency

Data Manipulation

Cleans extracted data using pre-defined guidelines or instructions.Formats extracted data based on expected report output (with batching capability)Formats extracted data based on expected report output. (multiple data formatting requirements)Consolidates and standardize data structure from different data sourcesCombines extracted data from multiple resources using automated tools (excel, macro, database)Combines extracted data from different system tools in database using queries (SQL, MS Access)Categorizes and segments extracted data using tools to convert data to information relevant to the report (excel, macro, database)Calculates data using available fields within the gathered information. (basic math and statistics)Creates histograms, charts, summaries as necessary to aid in easy interpretation and better provide decision support to the Marketing and Sales Community

Data Analysis

Gathers and analyzes report requirements from stakeholders. Identify and provide solution to general inquiriesAnalyzes gathered information & data using descriptive analytics (basic mathematics & comparative analysis)Analyzes stakeholder requirements from an existing report and provides improvement and recommendation based on customer request

Reporting

Provides status updates on report development, raise issues encountered and adjust timeline as appropriate.Creates reports based on standard templatesGenerate, analyze, create report/dashboard from different sources and submit to requestorEnhances tools/scripts that can automate the reporting process (Excel Macro, VBA, SQL, Access)Builds new reports, templates and/or dashboards on top of existing business systems (Oracle, CRM, etc.) and makesthem available to all users

Duty 2: Project Support

Continuous Process & Innovation

Identifies continuous improvement project ideas Project InitiationAttends scope reviews to learn what the project request is about.Assists in gathering, analyzing and clarifying customer requirements; uses technical knowledge to gauge complexity of the request

Project Planning

Encodes documentation using standard project templates; stores and organizes the documents to the team repositoryProvides own work estimates and can negotiate turnaround time within the teamLeads project milestone and gate reviewsReduces complexity by breaking down large modules to smaller deliverables ready to be assigned to team membersPerforms research and analysis to validate if the detailed solution is the best fit to meet the requirements

Project Execution

Follows set standards and guidelines of the team.Reports own progress back to project trackerParticipates in cross-functional testing and peer reviewsTroubleshoots and optimizes processes.Creates process standards and guidelines or any development related improvement.

Duty 3: Customer Data Administration

Customer Common Name Database AdministrationReceives assigned customer record/s from Marketing AnalystSearches, validates, adds and/or updates the customer common name and 8-digit SIC Code in a temporary databaseInforms the Marketing Analyst with own progress

Requirements:

Education: Bachelor’s Degree in MIS, Statistics, Mathematics, Analytics, Economics, Finance, Information Technology, Computer Science or other business or analytics related courses.

Job Related Experience: Minimum of 2 years of experience in reporting and data analysis.

Specific Knowledge:

Expert proficiency in MS ExcelAdvanced knowledge in other MS Office Applications (PowerPoint)Intermediate knowledge in MS Access and SQLIntermediate knowledge in StatisticsExperience in Business Intelligence Tools (Power BI, Tableau, etc)Strong oral and written communication skillsDatabase ManagementData Manipulation & InterpretationComparative AnalysisProject Management

Skills:

Communication skills (oral & written)Strong analytical skillsTime/work managementProblem solving skillsDetail orientedAbility to work in a collaborative team environmentGood comprehension of technology and data management tools used in the process of collecting, storing, retrieving and analyzing

Are you ready to join a purpose-driven, global technology, software and engineering company?A career — and future — at Emerson is grounded in and centered around our Purpose: We drive innovation that makes the world healthier, safer, smarter and more sustainable. Headquartered in St. Louis, MO with 170 locations and 86,700+ employees worldwide, Emerson is a universal brand that serves local communities across the globe. With a 130+ year history, we take pride in our past, but remain focused on our future.In the Philippines, Emerson plays a strategic role in supporting global and regional functions for the company and its customers in the fields of accounting, analytics, customer support, engineering, finance, information technology, human resources, marketing and business development, and supply chain management.Our Automation Solutions business helps process, hybrid, and discrete manufacturers maximize production, protect personnel and the environment while optimizing their energy and operating costs.Our Commercial & Residential Solutions business helps ensure human comfort and health, protect food quality and safety, advance energy efficiency and create sustainable infrastructure.Living Our Purpose as One EmersonEvery day, our global workforce fulfills our unified Purpose and lives out the Values we hold close as an organization: Integrity, Safety & Quality, Support Our People, Customer Focus, Continuous Improvement, Collaboration, and Innovation.Our Causes – Planet, Humanity, Champion, Inclusion and Future – shape, define and fuel Emerson’s culture while inspiring our innovative spirit and driving our focus.Learn more: https://www.emerson.com/en-us/about-us/living-our-purposeAwards & RecognitionEmerson is ranked among the leading companies in the United States and across the globe – but don’t just take our word for it.2022 Linkedin Top Companies in the PhilippinesDec 2021 to Dec 2022 Great Place to Work Certified™ 2021 GradPhilippines Top 100 Graduate Employers2022 Human Rights Campaign Foundation Best Places to Work for LGBTQ+ Equality2021 Women Engineer Magazine Top 50 Employers2020 Forbes Best Employers for DiversityLearn more: https://www.emerson.com/en-us/about-us/awards-recognitionBenefits at EmersonThrough our benefits, development opportunities, and an inclusive work environment, we aim to create an organization our people are proud to represent.• Competitive Wages and Benefits – We provide employees with market-competitive pay and benefits package.Allowance: food, transportation, clothingNight DifferentialLife InsurancePersonal Accident InsuranceRetirement BenefitPerfect Attendance IncentiveGuaranteed Midyear Pay• Career Development Opportunities – We help team members reach their highest potential with learning programs.• Healthcare – We offer quality healthcare coverage (medical and dental) for our team members.• Paid Leaves – Vacation, Sick, Parental, Bereavement• Tuition Reimbursement for Approved Programs – We support opportunities for employees to advance their education.• Safe Working Environment – Safety is a top priority across our global network and workplace.• Well-Being Programs – Well-Being Days, Counseling Service for team members and their family, Fund Assistance• Blended Work Benefits – Work from Home Allowance, Internet Subsidy, Workstation Set-up ReimbursementWhether you’re an established professional looking for a career change, an undergraduate student exploring possibilities, or recently received your master’s degree, you’ll find opportunities with us.Join our team and start your journey today!Visit our career site: emerson.com/en-ph/careers