Workforce Reporting Analyst (With PowerBI dashboard creation experience)

TransPerfect Business Solutions Inc; Eastern Manila District; On-site; PHP 600,000 - 900,000; Full time

Job summary

TransPerfect Business Solutions Inc is seeking a Reporting Analyst to design and maintain automated reporting using SQL and Power BI, turning raw data into actionable insights.

You will manage intraday and EOD reporting cycles, troubleshoot gateway issues, and deliver timely dashboards for executives.

Strong knowledge of DAX, Power Query, ETL concepts, and data warehousing will help you succeed.

Qualifications

• Advanced SQL knowledge with joins, subqueries and window functions.
• End-to-end Power BI development experience (data connectivity, modeling, visualization).
• Experience managing intraday and EOD reporting cycles.
• Proficiency in DAX and Power Query (M).
• Familiarity with ETL processes and data warehousing concepts.
• Attention to detail and problem-solving aptitude.
• Strong analytical, organizational, and multi-tasking skills.

Responsibilities

• Ensure automated reports and data refreshes succeed; troubleshoot SQL or Power BI Gateway issues.
• Execute and distribute intraday snapshots (hourly or mid-day) to support tactical decision-making.
• Respond to ad-hoc data requests and provide context for current-day performance trends.
• Finalize and distribute EOD performance packages with reconciled data entries.
• Perform other duties and assignments as directed.

Skills

SQL proficiency

Power BI

Reporting cycles

DAX / Power Query

ETL & Data warehousing

Attention to detail

Analytical ability

Education

BSc in CS/Statistics/Data Mgmt

Tools

Power BI Gateway

Job description

OVERVIEW

The Reporting Analyst focuses on the design, development, and maintenance of automated reporting solutions. They will bridge the gap between raw data and actionable business insights, utilizing SQL to extract complex datasets and Power BI to transform them into clear, executive-level visualizations along with

DESCRIPTION

• Ensure all automated reports and data refreshes have completed successfully; troubleshoot any SQL or Power BI Gateway failures.
• Execute and distribute scheduled intraday snapshots (e.g. hourly or mid-day updates) to support tactical decision-making.
• Respond to urgent ad-hoc data requests and provide context for current-day performance trends.
• Finalize and distribute EOD performance packages, ensuring all manu7al data entries or adjustments are reconciled.
• Perform other duties and assignments as directed.

REQUIRED SKILLS

• Advanced knowledge of SQL (including joins, subqueries, and window functions) for efficient data preparation and real-time querying.
• Proven experience developing end-to-end Power BI solutions, including data connectivity, modeling, and visualization.
• Previous experience managing time-sensitive intraday and EOD reporting cycles.
• Strong proficiency in DAX and Power Query (M formula language)
• Familiarity with ETL (Extract, Transform, Load) processes and data warehousing concepts.
• Attention to detail and problem-solving aptitude.
• Strong analytical, organizational, and multi-tasking skills

DESIRED SKILLS AND EXPERIENCE

• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Experience with Python or R for advanced data manipulation within Power BI
• BSc/BA in Computer Science, Statistics, Data Management, or a related field a plus