Business Intelligence Senior Analyst

Trends Group, Inc.; Makati; On-site; PHP 900,000 - 1,800,000; Full time

Job summary

Trends Group, Inc. in Makati is seeking a Business Intelligence Senior Analyst to bridge BI, analytics, and data engineering. You will partner with business teams to define reporting needs and build analytical datasets and dashboards.

You will own analytical logic, work with Data Engineers on productionization, security, and scalability, and apply SQL, Python, Spark, and BI tools to deliver trusted insights.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Data Science, Statistics, Business Analytics, Engineering, or a related field.
• At least 4 years of relevant experience in Data Analysis, BI, Reporting, or Analytics.
• At least 1 year of hands-on experience building automated data transformations or pipelines using SQL and Python.
• Advanced SQL skills, including joins, window functions, CTEs, query troubleshooting, and data reconciliation.
• Strong Python capability for data manipulation, automation, testing, and reusable analytics code.
• Hands-on experience with Apache Spark, PySpark, Spark SQL, or comparable distributed data-processing technologies.
• Proven skills in Power BI, Tableau, or equivalent BI tools, including data modeling, measures, dashboard design, and visualization.
• Understanding of dimensional modeling, semantic layers, ETL/ELT, data lineage, metadata, data quality, and data governance.

Responsibilities

• Partner with business units to define KPIs, reporting requirements, and data-driven decision needs.
• Analyze data to uncover trends, patterns, risks, and opportunities.
• Develop and maintain dashboards, scorecards, and reports using Power BI, Tableau, or equivalent BI platforms.
• Translate analytical findings into clear, actionable recommendations for technical and non-technical stakeholders.
• Design analytical and semantic data models, measures, and reusable datasets for reporting and self-service analytics.
• Write advanced SQL for data profiling, reconciliation, transformation, and validation across multiple data sources.
• Maintain business glossaries, data dictionaries, lineage records, data definitions, and reporting documentation.
• Monitor and address data quality issues involving accuracy, completeness, consistency, timeliness, and uniqueness.
• Build and maintain automated data transformations and small-to-medium batch pipelines using SQL and Python.
• Use Apache Spark, PySpark, Spark SQL, or comparable distributed data-processing technologies to transform, join, aggregate, and validate large datasets.
• Contribute to scheduled analytical workflows using Apache Airflow or comparable orchestration platforms.
• Work with governed analytical datasets and formats such as Parquet and CSV.
• Apply version control, peer review, reusable code, testing, and technical documentation practices.
• Monitor pipeline health, job outcomes, latency, and data freshness using metrics and dashboards.
• Perform first-level investigation of failed or delayed analytical workflows.
• Document runbooks, dependencies, known issues, and recovery procedures.
• Support data governance, metadata management, privacy, access control, and change-management requirements.
• Mentor junior analysts and share BI and analytics best practices with business users.

Skills

SQL proficiency

Python scripting

Power BI/Tableau

Spark/PySpark

Data modeling

ETL/ELT

Education

Bachelor's in IT/CS/Data Science/Statistics/Analytics

Tools

Power BI

Tableau

Apache Spark

Airflow

Python

Job description

Business Intelligence Senior Analyst

Trends Group, Inc. | Corporate IT Operations

Turn complex data into trusted insights that drive better business decisions.

We are looking for a Business Intelligence Senior Analyst who can bridge business intelligence, analytics, and data engineering. You will partner with business teams to understand their reporting and decision-making needs, build analytical datasets and dashboards, and transform large volumes of data using SQL, Python, Apache Spark, PySpark, or Spark SQL.

You will own analytical logic and data products while partnering with Data Engineers on productionization, complex integrations, security, scalability, and platform operations.

What You'll Do

Business Intelligence & Analytics

• Partner with business units to define KPIs, reporting requirements, and data-driven decision needs.
• Analyze data to uncover trends, patterns, root causes, risks, and opportunities.
• Develop and maintain dashboards, scorecards, and reports using Power BI, Tableau, or equivalent BI platforms.
• Translate analytical findings into clear, actionable recommendations for both technical and non-technical stakeholders.

Data Modeling & Quality

• Design analytical and semantic data models, measures, and reusable datasets for reporting and self-service analytics.
• Write advanced SQL for data profiling, reconciliation, transformation, and validation across multiple data sources.
• Maintain business glossaries, data dictionaries, lineage records, data definitions, and reporting documentation.
• Monitor and address data quality issues involving accuracy, completeness, consistency, timeliness, and uniqueness.

Data Transformation & Pipelines

• Build and maintain automated data transformations and small-to-medium batch pipelines using SQL and Python.
• Use Apache Spark, PySpark, Spark SQL, or comparable distributed data-processing technologies to transform, join, aggregate, and validate large datasets.
• Contribute to scheduled analytical workflows using Apache Airflow or comparable orchestration platforms.
• Work with governed analytical datasets and formats such as Parquet and CSV.
• Apply version control, peer review, reusable code, testing, and technical documentation practices.

Monitoring, Governance & Continuous Improvement

• Monitor pipeline health, job outcomes, latency, and data freshness using available metrics and monitoring dashboards.
• Perform first-level investigation of failed or delayed analytical workflows.
• Document runbooks, dependencies, known issues, and recovery procedures.
• Support data governance, metadata management, privacy, access control, and change-management requirements.
• Mentor junior analysts and share BI and analytics best practices with business users.

What We're Looking For

• Bachelor's degree in Information Technology, Computer Science, Data Science, Statistics, Business Analytics, Engineering, or a related field.
• At least 4 years of relevant experience in Data Analysis, Business Intelligence, Reporting, or Analytics.
• At least 1 year of hands-on experience building automated data transformations or pipelines using SQL and Python, or equivalent demonstrated experience.
• Advanced SQL skills, including joins, window functions, CTEs, query troubleshooting, and data reconciliation.
• Strong Python capability for data manipulation, automation, testing, and reusable analytics code.
• Hands-on experience with Apache Spark, PySpark, Spark SQL, or comparable distributed data-processing technologies.
• Proven skills in Power BI, Tableau, or equivalent BI tools, including data modeling, measures, dashboard design, and visualization.
• Understanding of dimensional modeling, semantic layers, ETL/ELT, data lineage, metadata, data quality, and data governance.

Added Advantage

Experience or familiarity with the following is beneficial:

• Apache Airflow or similar orchestration tools
• MinIO, S3-compatible platforms, or object storage
• Prometheus and Grafana or comparable monitoring technologies
• Git-based version control
• CI/CD concepts for analytics assets

Prior experience with every platform-specific tool is not required, as familiarity with comparable technologies may be considered.