Business Intelligence Analyst - US Shift

PSG Global Solutions Inc.; Makati; Vor Ort; PHP 600.000 - 1.000.000; Vollzeit

Zusammenfassung

PSG Global Solutions Inc. is hiring a Business Intelligence Analyst to build data pipelines in Snowflake using dbt and to create scalable BI dashboards for a US healthcare staffing client.

You will extract, clean, and model data from CRM and ERP systems like Salesforce and NetSuite, partnering with US Sales, Finance, and Operations to define KPIs and self-service analytics. Strong English communication is required.

Qualifikationen

• Bachelor’s degree in a quantitative field.
• 3+ years with Snowflake or comparable cloud data warehouses, including SQL and performance tuning.
• Proficiency with dbt for data modeling, testing, and documentation.
• Advanced SQL mastery for complex queries.
• Experience building semantic layers and dashboards in modern BI tools.
• Experience modeling data from CRM/ERP platforms (Salesforce, NetSuite).
• Strong written and verbal English communication for US stakeholders.

Aufgaben

• Design and optimize data transformation pipelines using dbt in Snowflake.
• Develop scalable dashboards and semantic data models in BI platforms.
• Extract, clean, and model data from CRM and ERP sources.
• Collaborate with US stakeholders to define KPIs and reports.
• Implement data quality checks and maintain dbt documentation.
• Document data architecture and audit findings for scalable reporting.

Kenntnisse

Advanced SQL

Data modeling

English communication

Ausbildung

Bachelor's degree in Data Analytics, CS, IS, Finance, or related field

Tools

Snowflake

dbt

BI tools (Looker/Tableau/Power BI)

Salesforce

NetSuite

Jobbeschreibung

About the role

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.

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.

About you

• 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.