Business Intelligence Analyst

Lean Solutions Group; Philippines; On-site; PHP 420,000 - 720,000; Full time

Job summary

Lean Solutions Group (LSG) is seeking a Business Intelligence Analyst skilled in Power BI to design and implement end‑to‑end BI solutions, transforming data into actionable insights. You will ingest data from multiple sources, build data models, and develop KPI dashboards for operational teams and leadership.

Ideal candidates have 1–3 years in BI, strong Excel and Power Query skills, and fluent English for collaboration with international teams.

Qualifications

• Bachelor‑level technical degree or higher in Systems Engineering, Data, or related field.
• 1–3 years hands-on experience in data analysis, reporting, or BI roles.
• Demonstrable portfolio of end-to-end BI solutions in Power BI and Excel.
• Fluent English (B2 or higher) for international team collaboration.

Responsibilities

• Design and implement end-to-end BI solutions in Power BI covering ingestion, transformation, modeling, and visualization.
• Connect, clean, and transform data from CSV, Excel, SharePoint, and databases using Power Query.
• Develop relational data models and DAX measures to track complex KPIs.
• Create clean, business-oriented dashboards for ops to executives.

Skills

Power BI

Excel

SharePoint

Power Automate

DAX

SQL

Python/TypeScript

Data Modeling

Data Visualization

Education

Technical degree

Tools

Power BI

Excel

SharePoint

Power Automate

SQL

Azure Synapse

Job description

Join Our Team at Lean Solutions Group (LSG)!

Lean Solutions Group (LSG) is a next-generation solutions provider combining AI-driven automation, industry expertise, and tech-powered talent. Built in the demanding Supply Chain sector, our model now supports 600+ clients across multiple industries, powered by 10,000+ employees in five countries. We help businesses achieve immediate efficiency, long-term resilience, and scalable growth by integrating intelligent technology, optimized processes, and high-performance teams. At LSG, we believe in your talent and your potential. Join a multicultural, people-first environment where you can grow, sharpen your skills, and unlock new career opportunities. Here, every day brings fresh challenges, collaboration, and purpose.

Our Mission: Transform business challenges into lasting success through purpose-built teams, technology, and expertise.

Our Vision: A world where people, empowered by technology, turn any challenge into a catalyst for growth.

Position Description

The Business Intelligence Analyst is a strong technical professional specializing in Power BI with a focus on driving operational impact. This role is responsible for designing and implementing end-to-end BI solutions, transforming and modeling data, monitoring key performance indicators (KPIs), and identifying trends to support decision-making across operational teams and leadership. The position combines deep analytical rigor with effective presentation skills to translate complex data into clear, actionable business insights.

Functions

• Design and implement end-to-end BI solutions in Power BI Desktop covering data ingestion, transformation, modeling, and visualization autonomously.

• Connect, clean, and transform data from multiple sources (CSV, Excel, SharePoint, databases) using Power Query.

• Design and manage relational data models, table relationships, hierarchies, and build DAX measures to calculate complex KPIs.

• Develop clean, well-organized, business-oriented visual dashboards tailored for operational teams up to executive leadership.

• Continuously monitor operational KPIs, detect positive or negative trends, and issue proactive alerts when significant deviations occur.

• Present structured analytical results and insights to clients and leadership, translating complex data into actionable recommendations.

• Challenge and validate business requirements prior to solution development to ensure the core decision-making need is truly addressed.

• Collaborate with cross-functional departments to gather requirements, understand operational needs, and ensure data consistency and accuracy.

Qualifications and Requirements

• Technical degree, technologist, or professional degree in Systems Engineering, Data, Industrial Engineering, Business Administration, Statistics, Mathematics, Economics, or related fields.

• 1–3 years of hands‑on experience in data analysis, reporting, or Business Intelligence roles.

• Demonstrable portfolio or concrete experience developing end-to-end BI solutions in Excel and Power BI.

• Fluent English language proficiency (B2 level or higher, both spoken and written) for international team and client collaboration.

Technical Skills

• Core BI Tools: Power BI (Desktop & Service), DAX (Data Analysis Expressions), Power Query (M), Data Modeling (Star Schemas).

• Spreadsheets & Workflow Automation: Advanced Excel (Pivot tables, complex formulas), SharePoint (Lists, advanced fields, forms), Power Automate.

• Database & Querying (Nice to Have): SQL (Intermediate to advanced queries, table joins, data validation).

• Advanced Tech & Cloud (Nice to Have): Python or TypeScript, Power Apps, DAX Studio, Tabular Editor, Microsoft Fabric, Azure Synapse, Data Lakehouse environments.

Core Competencies

• Impact Orientation & Consultative Thinking: Ability to turn raw data into actionable insights and offer evidence-based recommendations that drive business decisions.

• Effective Communication: Clear, structured presentation skills to convey complex analytical findings to both technical and executive audiences.

• Analytical Thinking & Problem Solving: Skill in identifying patterns, trends, and anomalies, and validating business requirements before building solutions.

• Attention to Detail & Precision: Rigorous approach to data validation, ensuring consistency, accuracy, and data integrity across all dashboards.

• Proactivity & Collaboration: Initiative to anticipate data issues and raise alerts independently while working seamlessly with cross-functional teams.