IT Data Analytics Specialist

Cardinal Santos Medical Center - Colinas Verdes Hospital Managers Inc.; Metro Manila; On-site; PHP 600,000 - 1,200,000; Full time

Job summary

Cardinal Santos Medical Center - Colinas Verdes Hospital Managers Inc. seeks a Data Analytics Specialist to design, develop, and maintain enterprise BI dashboards, data pipelines, and analytical models across the organization.

You will design dashboards with Power BI/Tableau/Metabase, optimize ETL workflows, build robust data models, and apply statistics with Python or R to forecast resource needs while ensuring data privacy and quality.

Qualifications

• Bachelor's degree in Data Analytics, CS, IT, Statistics, or related field.
• 3–5 years of progressive experience as Data Analyst/BI Developer/Data Engineer.
• Advanced SQL skills (Window Functions, Stored Procedures) with MSSQL/MySQL/PostgreSQL.
• Experience with BI tools such as Power BI, Tableau, Metabase, or Looker.

Responsibilities

• Design, build, and maintain BI dashboards and reports.
• Architect and optimize ETL/ELT workflows into data warehouses.
• Design star-schema or snowflake data models for performant querying.
• Implement automated data validation and anomaly detection for accuracy.
• Run complex SQL queries and analytics scripts to analyze trends.
• Apply Python or R for forecasting and exploratory analysis.
• Ensure data privacy and security per policies and Data Privacy Act.
• Embed data validation gates and peer reviews before deployment.
• Collaborate with leaders and developers to translate requirements into data specs.

Skills

SQL proficiency

Education

Bachelor's Degree in Data Analytics / related fields

Tools

Power BI

Tableau

Metabase

Looker

MSSQL

MySQL

PostgreSQL

Python

R

Job description

Serves as a Data Analytics Specialist responsible for designing, developing, optimizing, and maintaining enterprise business intelligence (BI) dashboards, data pipelines, and analytical models across the organization.

MAJOR RESPONSIBILITIES:

• Design, build, and maintain interactive business intelligence dashboards, operational reports, and executive scorecards using tools such as Power BI, Tableau, or Metabase
• Architect, update, and optimize automated Extraction, Transformation, and Loading (ETL/ELT) workflows to ingest structured and unstructured data from transactional databases, cloud data lakes, and third-party APIs into central data warehouses
• Design and optimize star-schema and snowflake relational data models to maintain performant querying, indexed analytics tables, historical snapshots, and aggregated metrics across enterprise data repositories
• Implement rigorous automated data validation, anomaly detection, and reconciliation routines to maintain high data accuracy and consistency
• Execute complex SQL queries, analytical scripts, and statistical profiling to evaluate operational trends and investigate data discrepancies
• Apply statistical methods, regression models, trend forecasting, and exploratory data analysis using Python or R to identify patterns and forecast resource requirements
• Enforce strict data privacy and security protocols across reporting and storage layers, adhering to enterprise access control policies and regulatory standards such as the Data Privacy Act
• Embed automated data validation gates, reconciliation scripts, and peer review processes to eliminate reporting inaccuracies prior to production deployment
• Collaborate with departmental leaders, business analysts, and systems developers to translate complex business requirements into technical data specifications and actionable reporting models

QUALIFICATIONS:

• Bachelor's Degree in Data Analytics, Computer Science, Information Technology, Statistics, Applied Mathematics, or related quantitative fields
• Preferably with at least 3–5 years of progressive experience as a Data Analyst, BI Developer, or Data Engineer in enterprise environments
• Advanced proficiency in SQL (MSSQL, MySQL, PostgreSQL), including Window Functions and Stored Procedures
• Experience with Business Intelligence tools such as Power BI, Tableau, Metabase, or Looker