Data Analyst (urgent)

PCWORX IT Solutions; Quezon City; On-site; PHP 320,000 - 520,000; Full time

Job summary

PCWORX IT Solutions is seeking a Data Analyst to collect, transform, analyze, and visualize data to support business decisions. You will develop Power BI dashboards, write SQL queries, and provide actionable insights across Finance, Accounting, Procurement, and Operations.

You will work with MS SQL Server, MySQL, and Excel, perform EDA, prepare data for reporting, and collaborate with stakeholders to translate requirements into dashboards and reports.

Qualifications

• Bachelor's Degree in Computer Science, Information Systems, Statistics, Business, Mathematics, or a related field.
• Fresh Graduates are welcome to apply.
• Preferably 1–2 years of experience as a Data Analyst or in a similar role.
• Familiarity with Power BI and basic SQL.
• Strong understanding of data analysis techniques and reporting best practices.

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Create and manage data models, visualizations, and reporting solutions.
• Develop custom KPIs and metrics using DAX (Data Analysis Expressions).
• Write and optimize SQL queries to extract, manipulate, and validate data from relational databases.
• Collect, clean, and analyze large datasets from multiple sources.

Skills

Power BI Dashboard Development

DAX

Power Query

SQL

MySQL

MS SQL Server

Data Modeling

Data Visualization

EDA

Stakeholder Communication

Team Collaboration

Education

Bachelor's degree in a related field

Tools

MS SQL Server

MySQL

Excel

Job description

Job Summary

The Data Analyst is responsible for collecting, transforming, analyzing, and visualizing data to support business decision-making. This role will develop Power BI dashboards and reports, write SQL queries, perform data analysis, and provide actionable insights to stakeholders across various business units, including Finance, Accounting, Procurement, and Operations.

Key Responsibilities

Power BI Development

• Design, develop, and maintain interactive Power BI dashboards and reports.

• Create and manage data models, visualizations, and reporting solutions.

• Develop custom KPIs and metrics using DAX (Data Analysis Expressions).

• Optimize report performance and manage automated data refresh processes.

• Perform data transformation and modeling using Power Query.

SQL and Data Management

• Write and optimize SQL queries to extract, manipulate, and validate data from relational databases.

• Support reporting requirements through efficient data extraction and analysis.

• Ensure data accuracy, integrity, and consistency across reporting platforms.

• Work with databases such as MS SQL Server, MySQL, and similar database systems.

Data Analysis and Reporting

• Collect, clean, and analyze large datasets from multiple sources.

• Conduct exploratory data analysis (EDA) to identify trends, patterns, anomalies, and opportunities.

• Prepare and validate data for operational and management reporting.

• Develop meaningful insights and recommendations to support business decisions.

• Conduct pre- and post-production system and data testing and elevate issues when necessary.

Stakeholder Collaboration

• Partner with Accounting, Finance, Procurement, Operations, and other departments to gather reporting requirements.

• Present findings and reports to both technical and non-technical audiences.

• Translate business requirements into meaningful dashboard and reporting solutions.

Documentation and Governance

• Maintain documentation for data models, reports, processes, and reporting standards.

• Ensure data definitions, calculations, and KPIs are properly documented.

• Support data governance and reporting best practices.

Qualifications

• Bachelor's Degree in Computer Science, Information Systems, Statistics, Business, Mathematics, or a related field.

• Fresh Graduates are welcome to apply.

• Preferably with 1–2 years of experience as a Data Analyst or in a similar role.

• Familiarity with Power BI and basic SQL.

• Strong understanding of data analysis techniques and reporting best practices.

Required Skills

Technical Skills

• Power BI Dashboard Development

• DAX (Data Analysis Expressions)

• Power Query (ETL Processes)

• MS SQL / SQL Server / MySQL

• Microsoft Excel (Advanced Formulas, Pivot Tables, Dashboards)

• Data Modeling and Data Visualization

• Data Validation and Testing

• Basic Data Warehousing Concepts

Analytical Skills

• Data Analysis and Interpretation

• Problem Solving

• Trend and Pattern Identification

• Attention to Detail and Accuracy

• Data Quality Management

Soft Skills

• Strong Communication Skills

• Stakeholder Management

• Collaboration and Teamwork

• Time Management and Organization

• Ability to Manage Multiple Priorities in a Fast-Paced Environment

Preferred Qualifications

• Experience building Power BI dashboards from scratch.

• Experience working with large datasets and multiple data sources.

• Knowledge of reporting best practices and KPI development.

• Exposure to business intelligence and analytics tools.

Employment Level: Entry-Level to Junior Level
Experience: Fresh Graduate / 1–2 Years Relevant Experience