Senior BI Developer

Jobtailor; Taguig; On-site; PHP 1,000,000 - 1,800,000; Full time

Job summary

Jobtailor in the Philippines seeks a seasoned Power BI specialist to design and maintain semantic layers, models, and certified data views in Snowflake for enterprise reporting.

You will translate business needs into scalable analytics solutions, optimize DAX measures, manage PowerBI workspaces, and partner with data engineering to ensure data quality and governance.

Qualifications

• Bachelor’s degree in a technical field.
• 5+ years of PowerBI report development and data analysis.
• Strong PowerBI, DAX, Power Query and data modeling skills.
• Experience with SQL and data querying languages.
• Expertise in architecting PowerBI workspaces and enterprise environments.
• Knowledge of data governance and data quality principles.

Responsibilities

• Collaborate with stakeholders to gather reporting requirements.
• Translate business requirements into technical specifications for data and reporting solutions.
• Design and maintain Snowflake views for reporting-ready data sources for PowerBI.
• Develop and optimize SQL transformations for analytics-ready structures.
• Establish and enforce naming standards and version control for reporting assets.
• Tune Snowflake views and queries for performance and cost efficiency.
• Partner with data engineering to align models and ensure data quality and lineage.
• Design, build, and maintain the semantic layer between Snowflake and PowerBI.
• Develop semantic models, relationships, and KPIs for enterprise metrics.
• Publish certified/shared semantic models for governed self-service analytics.
• Implement row-level security and publish datasets for governance.
• Choose storage modes for Snowflake to balance performance and freshness.
• Document the semantic layer and data dictionaries for transparency.
• Design and maintain dashboards and reports with best-practice visuals.
• Ensure reports are reliable, accurate, and trusted by end-users.
• Conduct UAT with end-users and iterate based on feedback.

Skills

PowerBI

DAX

Power Query

Data modeling

SQL

Snowflake

Azure

Data governance

Agile

Education

Bachelor’s degree in Computer Science

Data Science

Tools

PowerBI

Snowflake

Azure

SQL

Job description

Responsibilities

• Collaborate with business stakeholders to gather and document reporting requirements.
• Translate business requirements into technical specifications for data and reporting solutions.
• Design, build, and maintain curated SQL views and other consumption-layer objects in Snowflake to serve as the certified, reporting-ready data source for PowerBI.
• Develop and optimize SQL transformations that shape raw and modeled data into analytics-ready structures, such as star-schema views, aggregate views, and reusable business logic.
• Establish and enforce view naming standards, layering conventions, and version control so the reporting estate remains consistent, maintainable, and well documented.
• Tune Snowflake views and queries for performance and cost efficiency, applying techniques such as clustering, materialized views, and query optimization.
• Partner with data engineering to align reporting views with upstream data models and to safeguard data quality, integrity, and lineage.
• Design, build, and maintain the semantic layer that sits between Snowflake and PowerBI, providing a consistent, business-friendly representation of enterprise data.
• Develop robust PowerBI semantic models (datasets), including star-schema data models, relationships, hierarchies, and well-defined dimensions and facts.
• Author reusable DAX measures, calculation groups, and KPIs that encapsulate business logic and establish a single source of truth for enterprise metrics.
• Publish certified and shared semantic models to promote reuse, governance, and trusted self-service analytics across the enterprise.
• Implement row-level security (RLS) and object-level security within the semantic layer to enforce appropriate and compliant data access.
• Select and optimize storage modes (Import, DirectQuery, and Composite models) against Snowflake to balance performance, data freshness, and cost.
• Document the semantic layer — including data dictionaries, measure definitions, and lineage — to support transparency, governance, and onboarding.
• Design, develop, and maintain PowerBI reports and dashboards.
• Ensure reports are highly reliable, accurate, and trusted by end-users.
• Conduct user acceptance testing (UAT) with end-users and iterate based on feedback.
• Build reports and dashboards on top of certified semantic models and Snowflake-backed views to ensure consistency, reduce duplication, and reinforce a single source of truth.
• Apply data visualization and PowerBI report design best practices to deliver clear, intuitive, and accessible reports that support confident decision-making.
• Optimize report performance through efficient DAX, query reduction, and appropriate use of aggregations and the semantic layer.
• Provide technical support for PowerBI and other reporting solutions.
• Optimize reporting solutions for performance and scalability.
• Administer and manage PowerBI environments, including user access and security.
• Design and implement PowerBI workspaces to support various business units and projects.
• Ensure workspaces are structured to facilitate efficient data management and collaboration.
• Develop best practices for workspace organization and maintenance.
• Oversee the entire PowerBI environment for the enterprise, ensuring it meets business needs and compliance requirements.
• Manage PowerBI service settings, including capacity management, data refresh schedules, and gateway configurations.
• Monitor and troubleshoot PowerBI service performance and availability issues.
• Develop and maintain documentation for reporting solutions and processes.
• Provide training and support to end-users for self-service PowerBI report creation.
• Troubleshoot and resolve issues related to PowerBI reports and dashboards.
• Work closely with IT, data, and business teams to ensure alignment of reporting solutions with business goals.
• Communicate effectively with stakeholders to manage expectations and deliver high-quality reporting solutions.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• Minimum of 5 years of experience in PowerBI report development and data analysis.
• Strong technical skills in PowerBI, including DAX, Power Query, and data modeling.
• Experience with SQL and other data querying languages.
• Expertise in architecting PowerBI workspaces and managing enterprise-level PowerBI environments.
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Experience with cloud-based data platforms (e.g., Azure).
• Experience with Snowflake.
• Knowledge of data governance and data quality principles.
• Hands‑on experience designing and building semantic layers and PowerBI semantic models (datasets), including star‑schema data modelling and reusable DAX.
• Proven experience creating, optimizing, and maintaining SQL views and transformations in Snowflake (or a comparable cloud data warehouse).
• Experience implementing row-level security and publishing certified or shared datasets to enable governed self‑service analytics.
• Solid understanding of dimensional modelling (e.g., Kimball) and data warehousing concepts.
• Familiarity with Agile development methodologies.

Core Competencies

Demonstrates expertise in PowerBI report development, including DAX, Power Query, and data modeling, while ensuring data governance and quality. Proficient in designing and optimizing SQL views and semantic layers within Snowflake to support enterprise‑level analytics.