Senior BI Analyst

Hammerjack Pty Ltd; Taguig; On-site; PHP 900,000 - 1,500,000; Full time

Job summary

Hammerjack Pty Ltd in Manila (Taguig area) seeks a Senior BI Analyst to own end-to-end BI reporting for the CX organization. You will translate stakeholder requirements into technical specs, design data models, build ETL pipelines, and deliver Power BI reports and dashboards while managing data quality and releases.

You will also govern semantic models, manage ticket-based work, and mentor team members in a fast-paced environment. Strong Power BI and data skills are essential.

Qualifications

• 5+ years of BI development, reporting, or data analytics with end-to-end ownership.
• Advanced Power BI including Power Query, M language, and DAX.
• Dimensional and medallion data modeling and semantic governance.
• Advanced Excel for data maintenance and analysis.
• Familiarity with Salesforce data structures (Cases, Users, Opportunities, CRM objects).
• Experience with ticket-based work tracking (Jira or similar).

Responsibilities

• Gather requirements and translate them into technical specs and report designs in Power BI.
• Develop reports and dashboards, ensuring consistent formatting and standards.
• Architect source-to-target data models and semantic structures; design measures.
• Build and maintain Power BI dataflows; implement ETL and data maintenance processes.
• Scope requests into tickets, manage releases, and maintain data lineage and QA documentation.
• Communicate data logic and definitions to stakeholders; guide teammates when needed.

Skills

Power BI

DAX

Data modeling

Power Query

End-to-end reporting

Excel

Salesforce data

Jira

Tools

Jira

Salesforce

Job description

Summary

The Senior BI Analyst owns and delivers reporting solutions that support the CX organization (Customer Success, Support, Forms Design, Onboarding, and Knowledge and Enablement). This role works independently, end to end, from business requirement through finished, released report, with minimal oversight required from the Senior Manager. Responsibilities include gathering and translating stakeholder requirements into technical specifications, designing data models, building ETL pipelines, developing semantic models, and delivering reports within the Power BI platform. The role also owns the operational side of the reporting function: scoping work, tracking tickets, and coordinating releases.

Key Responsibilities

Report & Dashboard Development

• Gather and analyze business requirements from stakeholders, translating them into technical specifications and report designs within the Power BI platform.
• Build the resulting reports and dashboards
• Apply consistent formatting, naming, and design standards across deliverables
• Deliver ad hoc requests via Excel or an application's native reporting module (e.g., Salesforce Reports) when the request doesn't warrant a Power BI build.

Data Architecture & Modeling

• Architect source-to-target data models for new reporting domains using dimensional/medallion design principles
• Design semantic model structure: tables, relationships, and DAX measures

ETL & Pipeline Development

• Build and maintain Power BI dataflows across Bronze/Silver/Gold layers
• Write and troubleshoot Power Query transformations
• Develop and maintain manual/spreadsheet-based data maintenance processes for sources without a direct system feed

Release & Process Management

• Scope incoming requests into tickets with clear requirements and acceptance criteria
• Manage release scheduling and coordinate deployment of dataflow, model, and report changes
• Maintain documentation for data lineage, business logic, and known data quality issues

Stakeholder Communication

• Gather requirements directly from business stakeholders across the CX organization
• Explain data logic, metric definitions, and limitations in non-technical terms
• Flag data quality or architectural issues that affect metric defensibility before they reach a report
• Operate independently against ambiguous or incomplete requirements, making sound architectural and tooling decisions without requiring direction from the Senior Manager
• Provide occasional technical guidance and mentoring to other team members

Required Skills

• 5+ years of experience in BI development, reporting, or data analytics, with demonstrated ownership of end-to-end reporting solutions
• Advanced Power BI (Power Query/M, DAX, data modeling)
• Dimensional and medallion data modeling
• Semantic model governance, including row-level security and workspace access management
• Advanced Excel (formulas, structured data maintenance, pivot-based analysis)
• Familiarity with Salesforce data structures (Cases, Users, Opportunities, or similar CRM objects)
• Experience with ticket-based work tracking (Jira or similar)

Nice to Have

• SQL or other query language fluency
• Exposure to APIs or ing for data pull automation (Apps , Power Automate)