BI Analyst: Data Pipelines & Dashboards

Motolite; Santa Maria; On-site; PHP 350,000 - 550,000; Full time

Job summary

Motolite is seeking a Business Intelligence Analyst to design and maintain data pipelines, models, and reporting that turn operational data into insights. You will build dashboards, optimize data flows, and enforce governance to empower cross-functional teams.

The role involves ETL from ERP and production systems, SQL querying, and deploying dashboards in Power BI, Tableau, and Excel. You will collaborate with IT and data teams to integrate BI with data lakes and cloud warehouses.

Qualifications

• Graduate of science/engineering courses related to data analytics.
• Internships or certifications in BI or data analytics are an advantage.
• Strong SQL, BI tool experience, and data modeling skills.

Responsibilities

• ETL data from ERP, MES, production systems into centralized data models.
• Design and optimize data models, queries, and database structures.
• Write and tune complex SQL queries and ETL workflows.
• Develop BI dashboards and reports using Power BI, Tableau, and Excel.
• Implement data governance with access controls, lineage, and QA.
• Collaborate with IT and data teams to integrate BI with data lakes/warehouses.
• Automate recurring reporting and analytics with scripting/workflows.
• Monitor BI infrastructure, optimize query performance and refresh cycles.
• Produce technical documentation of architectures, dictionaries, mappings, and workflows.
• Evaluate and deploy new BI/cloud analytics technologies.
• Support data-driven initiatives and business objectives.

Skills

SQL

Power BI/Tableau

Data Modeling

ETL/Data Integration

Cloud BI (Azure Synapse, Databricks, e

Data Governance & Security

Analytics & Problem Solving

Documentation & Stakeholder comm.

Education

Graduation in science/engineering related to data analytics (Statistics, Applied Mathematics, Data Science)

Tools

Power BI

Tableau

SQL

Azure Synapse

Databricks

AWS Redshift

Google BigQuery

Job description

Motolite is seeking a Business Intelligence Analyst to design and maintain data pipelines, models, and reporting that turn operational data into insights. You will build dashboards, optimize data flows, and enforce governance to empower cross-functional teams.

The role involves ETL from ERP and production systems, SQL querying, and deploying dashboards in Power BI, Tableau, and Excel. You will collaborate with IT and data teams to integrate BI with data lakes and cloud warehouses.