Business Intelligence Analyst (Bulacan)

JOB SUMMARY

The Business Intelligence Analyst is responsible for designing, developing, and maintaining data pipelines, models, and reporting solutions that transform operational and enterprise data into actionable insights. By building dashboards, optimizing data flows, and enforcing governance standards, the BI Analyst enables cross-functional teams to drive efficiency, performance, and data-driven decision-making across the enterprise.

PRINCIPAL DUTIES

1. Extract, transform, and load (ETL) data from ERP, MES, production systems, and cloud platforms into centralized data models, ensuring accuracy, completeness, and timeliness.

2. Design, develop, and optimize data models, queries, and database structures (SQL, time-series, relational) to support analytics and self-service reporting.

3. Write and tune complex SQL queries, stored procedures, and ETL workflows for high-volume data extraction, transformation, and load operations.

4. Design, deploy, and manage enterprise BI dashboards and reports using Power BI, Tableau, and Excel with DAX, Power Query, or equivalent scripting.

5. Implement data governance frameworks, including role-based access, audit controls, data lineage, and quality assurance processes.

6. Collaborate with IT and data engineering teams to integrate BI solutions with cloud data lakes, data warehouses, and streaming data sources.

7. Automate recurring reporting and analytics processes using BI scripting, Python/R, or workflow automation tools to reduce manual interventions.

8. Monitor and troubleshoot BI infrastructure, optimizing query performance, report refresh cycles, and pipeline runtimes.

9. Provide technical documentation of BI architectures, data dictionaries, ETL mappings, and integration workflows for operational continuity.

10. Research, evaluate, and deploy emerging BI and cloud analytics technologies to enhance scalability and analytical capabilities.

11. Perform other tasks as needed to support data-driven initiatives and business objectives.

JOB SPECIFICATIONS

1. Formal Education:

- Graduate of science/engineering courses related to data analytics, e.g. Statistics, Applied Mathematics, Engineering, Data Science or other Engineering or related courses

2. Experience:

- No prior experience required; internships, academic projects, or certifications in business intelligence, data analytics, or process optimization are an advantage.

3. Training/Skills:

- Proficiency in SQL for querying, data transformation, and performance optimization.

- Skilled in building dashboards and reports using Power BI, Tableau, or similar BI tools.

- Experience with data modeling and ETL/integration workflows.

- Familiarity with cloud BI and data services (Azure Synapse, Databricks, AWS Redshift, Google BigQuery, or equivalent).

- Understanding of data governance, security, and compliance requirements in BI systems.

- Strong analytical and problem-solving skills, with the ability to validate data accuracy and interpret results.

- Strong skills in documentation, stakeholder engagement, and presentations.