Business Analytics Research Analyst  

Job Description:

We are seeking a motivated Business Analytics - Reports Analyst to join our team. The ideal candidate should have experience in ETL Tools, Data Governance, Data Management, and Microsoft 365 tools (Power BI, Power Automate, SharePoint). This role involves creating and maintaining reports and Dashboards, focusing on Data Cleaning, Validation and Maintenance. The position requires flexibility for shifting schedules and/or night shifts, with the option to work Onsite at Ten West McKinley, Taguig.

Key Responsibilities:

1. ETL Tools & Data Transformation

• Manage ETL processes for extracting, transforming, and loading data.
• Automate data pipelines and ensure data integrity through cleaning and validation.
• Collaborate with business teams to ensure data is structured and accessible.

2. Data Governance & Management

• Ensure compliance with data governance policies to maintain data quality.
• Implement best practices in data management, ensuring data is organized, integrated, and secure.
• Monitor data quality and resolve any inconsistencies or errors.

3. Integration of Microsoft 365 Tools (SharePoint, Power BI, Power Automate)

• Integrate data from Microsoft 365 tools to streamline reporting and workflow automation.
• Create interactive dashboards and reports using Power BI.
• Automate processes using Power Automate to reduce manual tasks.
• Troubleshoot integration issues and optimize data flow across platforms.

4. Reports and Dashboard Development

• Develop reports and dashboards using Power BI.
• Ensure data accuracy by focusing on data cleaning and validation.
• Create performance tracking dashboards and provide ad-hoc reporting.
• Work closely with teams to understand reporting requirements and deliver insights.

5. Communication & Collaboration

• Present data insights to non-technical stakeholders in an understandable format.
• Collaborate with cross-functional teams, including IT Department, Automation Group, and Production Influential Stakeholders, to ensure efficient integration and process flow.

Qualifications:

Experience & Exposure

• Experience with ETL tools (e.g., Sharepoint, Salesforce).
• Hands-on experience with Microsoft 365 tools like Power BI, Power Automate, and SharePoint.
• Proficiency in Data governance and Master Data Management (MDM).
• Intermediate to Advanced English communication skills (written and spoken).

Skills & Knowledge

• Intermediate to Advanced Excel Navigations.
• Expertise in data cleaning and validation techniques to ensure reporting accuracy.
• Strong experience with Syntax Formulae, Macro and/or M365 Dynamics for data transformation and management.
• Familiarity with Power Automate for Automating Workflows.
• Ability to Design, Develop, and Maintain Power BI Dashboards and Reports.
• Good-to-have skills with Azure Data Services, REST API, PowerApps Design, Javascript and/or Agile/Waterfall Methodologies.

Preferred Aptitude

• Attention to Detail – Focus on ensuring data is precise and reliable across Reports and Dashboards.
• Strong Problem-Solving skills for data issues and reporting optimization.
• Natural Researcher – Who can independently find a reasonable answers from a complex problem with less supervision.
• Find-a-way Attitude: Resourcefulness and always looking for solutions rather than roadblocks.
• Team Player – Ability to work independently and collaboratively within a Team.
• Advantage: Previous experience in a client-facing or with consulting role.

Work Conditions:

• Shift Schedule: Must be flexible in shifting schedules and night shifts.
• Onsite Work: Willingness to work onsite at Ten West McKinley, Taguig.
• Team Environment: Ability to work independently and as part of a team.