Reports Analyst

Job Title: Reports Analyst

Department: Operations

Reports To: Head of Operations

Location: Alabang (On-site)

Pinnacle Intelligence is at the forefront of transforming the automotive retail industry. We provide AI-powered, sustainable, and scalable digital solutions designed to engage customers, accelerate sales growth, and elevate the entire auto retail value chain. Our mission is to revolutionize the automotive retail industry through intelligent technology, unlocking dealerships' full potential and setting new standards of efficiency, profitability, and market leadership. We are dedicated to powering the future of auto retail with AI, Data, and Automation, driven by intelligence at every turn. 

The Reports Analyst at Pinnacle Intelligence is a crucial role responsible for transforming raw operational data into actionable insights that drive efficiency, improve performance, and support strategic decision-making across our BPO operations. This role will heavily leverage the Microsoft Power Platform to develop, maintain, and enhance dynamic reports, dashboards, and automated solutions. The ideal candidate is highly analytical, detail-oriented, and proficient in data visualization and automation tools, enabling our teams to make informed decisions and achieve operational excellence.

1. Report & Dashboard Development:

• Design, develop, and maintain comprehensive reports and interactive dashboards using Microsoft Power BI to visualize key performance indicators (KPIs), trends, and operational metrics.
• Create custom data models and calculations within Power BI to support advanced analytics requirements.
• Ensure reports are intuitive, accurate, and provide actionable insights for various stakeholders, from frontline staff to senior management.

2. Data Analysis & Interpretation:

• Extract, transform, and load (ETL) data from various sources (e.g., CRM systems, client platforms, databases) to prepare it for analysis and reporting.
• Conduct in-depth analysis of operational data to identify root causes, performance gaps, and opportunities for process improvement.
• Interpret complex data sets and present findings clearly and concisely to non-technical audiences.

3. Microsoft Power Platform Solutions:

• Develop and optimize automated workflows and processes using Microsoft Power Automate to streamline data collection, report generation, and operational tasks.
• Design and implement simple custom applications or forms using Microsoft Power Apps to enhance data capture or improve operational efficiency as needed.
• Explore and implement other components of the Microsoft Power Platform to drive innovation in reporting and data management.

4. Stakeholder Collaboration & Requirements Gathering:

• Collaborate closely with Operations Managers, Team Leaders, and other department heads to understand their reporting needs and translate them into effective data solutions.
• Gather detailed requirements for new reports, dashboards, and automated tools, ensuring alignment with business objectives.
• Provide training and support to end-users on how to effectively utilize reports and dashboards.

5. Data Quality & Governance:

• Ensure the accuracy, consistency, and integrity of all data used for reporting and analysis.
• Implement data validation processes and best practices to maintain high data quality standards.
• Document data sources, methodologies, and report specifications to ensure transparency and maintainability.

Required:

• Experience: Minimum of 2-3 years of experience in a Data Analyst, Business Intelligence Analyst, or Reports Analyst role, preferably within a BPO or high-volume operational environment.
• Microsoft Power Platform Expertise:
  • Strong proficiency in Microsoft Power BI for data modeling, visualization, and dashboard creation.
  • Experience with Microsoft Power Automate for building automated workflows.
  • Familiarity with Microsoft Power Apps for creating basic custom applications.
• Data Analysis & Manipulation: Proven ability to extract, clean, transform, and analyze large datasets from various sources.
• SQL Proficiency: Solid understanding and practical experience with SQL for data querying and manipulation.
• Analytical & Problem-Solving: Exceptional analytical skills with the ability to identify trends, draw insights, and recommend actionable solutions.
• Communication & Presentation: Excellent verbal and written communication skills, with the ability to present complex data findings clearly to both technical and non-technical audiences.
• Attention to Detail: Meticulous in ensuring data accuracy, report precision, and adherence to requirements.
• Tool Proficiency: Experience with other reporting tools (e.g., Excel advanced functions) is a plus.

Preferred:

• Bachelor's degree in Computer Science, Information Technology, Statistics, Business Analytics, or a related quantitative field.
• Experience with other programming languages for data analysis (e.g., Python, R) is a plus.
• Prior experience supporting clients or operations within the automotive retail industry.

Pinnacle Intelligence offers a unique opportunity to be part of a growing and innovative company that is redefining intelligent business solutions for the automotive retail industry. We provide a collaborative work environment, opportunities for professional growth, and the chance to make a significant impact on our clients' success by providing critical data insights. If you are a driven Reports Analyst with a passion for data, the Microsoft Power Platform, and contributing to strategic decision-making, we encourage you to apply