L3 BI Analyst Programmer
City Of Muntinlupa
About the role
The L3 BI Analyst Programmer will be responsible for developing, maintaining, and supporting Business Intelligence (BI) solutions, data platforms, and enterprise reporting environments. The role involves working with large datasets, developing data pipelines, maintaining BI reports and dashboards, and ensuring data accuracy, reliability, and performance.
What you’ll do
- Develop, enhance, and maintain BI reports and dashboards using SAP Business
- Objects, Qlik, or similar enterprise BI tools.
- Develop, optimize, and maintain SQL queries and database solutions to support reporting and analytics requirements.
- Work with modern data platforms such as Databricks and Python to process, transform, and analyze large datasets.
- Develop and support ETL/ELT processes and data pipelines using Azure Data Factory (ADF) or similar data integration and orchestration tools.
- Design, maintain, and support data models, including dimensional modeling and star schema structures.
- Develop and maintain semantic layers and universes using SAP Business
- Objects Information Design Tool (IDT) or similar tools.
- Support enterprise BI production environments, including report maintenance, platform administration, and troubleshooting.
- Investigate and resolve data quality issues, reporting discrepancies, pipeline failures, and performance-related concerns.
- Perform incident troubleshooting, root cause analysis, and implement sustainable solutions to recurring technical issues.
- Collaborate with data engineers, analysts, and business stakeholders to understand requirements and deliver reliable BI solutions.
- Participate in technical discussions, support technical initiatives, and provide guidance or mentorship to other engineers when needed.
- Identify opportunities for process improvements and ensure the reliability and continuous improvement of BI solutions.
Qualifications
- Ability to perform in-depth investigations, identify root causes, and implement sustainable solutions.
- Comfortable handling incident troubleshooting, issue resolution, and continuous improvement.
Must Have
- Business Intelligence Data Analytics
- Strong experience working in Business Intelligence and Data Analytics environments.
- Strong SQL development skills and experience working with SQL-based databases using SSMS or similar tools.
- Experience working with modern data platforms such as Databricks and Python.
- Experience with Azure Data Factory (ADF) or similar data integration and orchestration tools.
- Experience developing and supporting BI reports and dashboards using Qlik, SAP Business
- Objects, or similar tools.
- Experience analyzing, transforming, and validating large datasets for reporting and analytics.
- Understanding of data modeling concepts, including dimensional modeling and star schema design.
- Reporting BI Tools
- Experience developing reports using SAP Business
- Objects (Web Intelligence / Universe Design) or similar enterprise BI tools.
- Experience designing or maintaining semantic layers and universes using Information Design Tool (IDT) or similar tools.
- Familiarity with Central Management Console (CMC) or equivalent BI platform administration tools.
- Experience supporting enterprise BI production environments.
- Proficiency in Microsoft Office applications, particularly Excel.
- Data Engineering Integration
- Experience working with ETL/ELT processes and data pipelines.
- Understanding of data integration patterns between enterprise systems and analytics platforms.
- Ability to troubleshoot data issues, performance problems, and reporting discrepancies.
- Technical Leadership Production Support
- Experience mentoring engineers or supporting technical initiatives.
- Ability to participate in technical discussions, troubleshooting, and root cause analysis.
- Experience working in production support environments.
- Willingness to handle both development and production support responsibilities.
- Nice to Have
- Knowledge or experience with SAP BW / BW on HANA (BWHANA) data modeling or reporting.
- Soft Skills
- Strong analytical and problem-solving skills, with the ability to investigate complex data and system issues.
- Ability to communicate technical findings clearly and effectively to stakeholders.
- Comfortable working in fast-paced production support environments.
- Strong sense of ownership in building and maintaining reliable BI solutions.
- Ability to collaborate effectively with cross-functional teams, including data engineers, analysts, and business users.