Business Intelligence Analyst - US Shift

PSG Global Solutions, LLC; Makati; On-site; PHP 3,781,000 - 5,671,000; Full time

Job summary

PSG Global Solutions, LLC is seeking a Business Intelligence Analyst to design and optimize data pipelines using dbt within a Snowflake environment. You will build interactive dashboards and semantic data models across BI tools and work with Salesforce and NetSuite data.

You will partner with US Sales, Finance, Operations, and leadership to define KPIs, implement data quality checks, and document architecture for scalable reporting.

Qualifications

• Bachelor’s degree in a quantitative field (Data Analytics, CS, IS, Finance, etc.).
• 3+ years with Snowflake or similar cloud data warehouses and SQL optimization.
• Proficiency with dbt for data modeling, testing, and documentation.
• Experience building semantic layers and visualizations in modern BI tools (Looker, Tableau, Power BI).
• Experience modeling schemas from CRM/ERP platforms (Salesforce, NetSuite).
• Excellent written and verbal English communication for presenting to US stakeholders.

Responsibilities

• Design, build, and optimize dbt pipelines in a Snowflake data warehouse.
• Develop scalable, interactive dashboards and semantic data models in BI tools.
• Extract, clean, model, and analyze data from CRM (Salesforce) and ERP (NetSuite).
• Collaborate with US Sales, Finance, Operations, and leadership to define KPIs and requirements.
• Implement automated data quality checks and maintain dbt documentation.
• Document data architecture, model logic, and audit findings for scalable reporting.

Skills

dbt

Snowflake

SQL

Data modeling

Dashboards

Education

Bachelor's degree

Tools

Looker

Tableau

Power BI

Salesforce

NetSuite

BigQuery

Redshift

Databricks

Job description

The Business Intelligence Analyst supports a US healthcare staffing and workforce solutions client by building data transformation pipelines, modeling complex enterprise data, and delivering executive-level business intelligence solutions. We welcome specialists from Business Intelligence, Data Analytics, Data Engineering, and Reporting backgrounds who have strong dbt, Snowflake, and advanced SQL skills and experience modeling enterprise data, building semantic layers, and creating interactive dashboards. Key Responsibilities:

Design, build, and optimize robust data transformation pipelines using dbt within a Snowflake data warehouse environment. Design, develop, and deploy scalable, interactive dashboards and semantic data models in modern BI platforms (e.g., Domo, Omni, Looker, Tableau, Power BI). Extract, clean, model, and analyze complex datasets originating from cloud applications, primarily CRM (Salesforce) and ERP (NetSuite) platforms.

Partner directly with US Sales, Finance, Operations, and Executive leadership to gather reporting requirements, define KPIs, and deliver self-service analytics. Implement automated data quality checks, maintain comprehensive dbt documentation, and ensure a single source of truth across all core business metrics. Document data architecture, model logic, and audit findings to support scalable reporting systems.

Qualifications: Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Finance, or a related quantitative field. 3+ years of experience working with Snowflake or comparable cloud data warehouses (such as Google BigQuery, Amazon Redshift, or Databricks), including writing optimized SQL, performance tuning, and understanding data warehouse architecture.

Proven proficiency with dbt (data build tool) for version-controlled data modeling, testing, and documentation. Advanced SQL mastery for writing complex, performant queries. Proven experience constructing semantic layers and visualizations in modern BI tools (Domo, Omni, Looker, Tableau, or Power BI).

Prior experience modeling and analyzing schema structures from major CRM or ERP platforms (Salesforce, NetSuite, or comparable enterprise systems). Exceptional written and verbal English communication skills to present insights directly to US stakeholders. Preferred Qualifications:

Familiarity with Git workflows and command-line interfaces (CLI). Exposure to predictive analytics, artificial intelligence (AI), or machine learning (ML) frameworks. Experience working with healthcare staffing, recruitment, or workforce solutions data models.

#BusinessIntelligence #Snowflake #dbt #SQL #psghiring