> Markdown version of [/jobs/ext/2870466-sql-power-bi-analyst](https://www.wearedevelopers.com/jobs/ext/2870466-sql-power-bi-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # SQL Power BI Analyst - **Company:** PFSCM - **Location:** Woerden, Netherlands - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Analysis of Variance (ANOVA), Business Intelligence Development, Data Validation, Data Cleansing, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Structures, Data Visualization, Data Warehousing, Relational Databases, Database Queries, Dimensional Modeling, PostgreSQL, MySQL, Operational Data Store, Power BI, SQL Stored Procedures, SQL Databases, Transact-SQL, Freeform SQL, Microsoft Power Automate, Sql Optimization, Powerquery, Information Technology, Data Analytics, Performance Monitor, Real Time Data - **Published:** September 13, 2026 - **Apply:** https://www.adzuna.nl/details/5881168309 ## About the Role Professional and Technical Knowledge * Bachelor's degree in Computer Science, Data Analytics, Information Technology, Statistics, or a related field. * 4+ years of dedicated hands-on experience in BI development, data visualization, and database querying. * Expert-level proficiency in Microsoft Power BI (Desktop & Service), DAX, and Power Query. * Advanced SQL skills (PostgreSQL, MySQL, T-SQL) with demonstrated ability to query large relational databases efficiently. * Application of AI in reporting. * Solid understanding of relational database design, star schemas, dimensional modeling, and data warehousing principles. * Experience with supply chain, logistics, or ERP data environments is a strong advantage. * Must be eligible to work in the Netherlands. Interpersonal skills/Communication * Excellent verbal and written English skills, with the ability to explain technical dashboard features clearly. Priority Setting, Problem Solving, & Detail Orientation * Strong problem-solving skills and rigorous attention to detail. * Ability to prioritize tasks in a fast-paced, time-sensitive environment. ## Description The Partnership for Supply Chain Management (PFSCM) focuses on strengthening and managing secure, reliable, cost-effective, and sustainable global supply chains to enhance health and well-being in low- and middle-income countries by increasing access to quality and affordable health products. We assist governments, non-profit organizations, commercial firms, and humanitarian agencies in achieving their public health objectives through cost-saving procurement, efficient logistics, pharma-grade storage, last-mile delivery solutions, and real-time data tracking. PFSCM is dedicated to customer satisfaction and service excellence, which is reflected in our adherence to an ISO 9001:2015 certified Quality Management System and alignment with ISO 20400 for Sustainable Procurement, which underpins all our processes and services. PFSCM, an affiliate of JSI Research & Training Institute, Inc. (JSI), a leading international public health and education consultant company in the U.S., operates from its project management headquarters in Washington D.C., and has an operational facility in Woerden, Netherlands. Additionally, we leverage the extensive network of 25 JSI offices around the world, allowing us to access their technical and operational expertise. PFSCM's global team includes a diverse array of professionals from various countries who contribute to the effectiveness of our services. This diversity enriches our ability to connect with clients and collaborate internally. We believe our mission can be achieved by fostering a purpose- and results-driven culture. We strive to create an environment where our values of collaboration, learning, proactivity, problem-solving, and outcome orientation are reflected in our daily work. Overall responsibilities Designs, develops, and maintains interactive Power BI dashboards, reports, and underlying data models to convert raw supply chain and operational data into actionable business insights. The SQL Power BI Analyst works closely with the Lead Data Analyst and business stakeholders to write optimized SQL queries, construct star-schema data models, build complex DAX measures, and enforce data accuracy across internal and external reporting platforms. Specific responsibilities Data Visualization & Reporting * Design, construct, publish, and maintain visually compelling, intuitive Power BI dashboards and executive reports. * Establish standardized visual layouts and user-friendly interface designs that facilitate data exploration for non-technical users. * Maintain and refresh existing enterprise reports, optimizing performance and query speeds. SQL Querying, Data Modeling & ETL * Write, test, and optimize complex SQL queries, views, and stored procedures to extract and transform data from relational databases and data warehouses. * Connect Power BI to diverse data sources, utilizing Power Query and Power Automate for robust Data Transformation and Data Cleaning (ETL). * Develop robust relational data models within Power BI, utilizing star schemas, relationships, and advanced DAX measures/calculated columns. Stakeholder Collaboration & Technical Analysis * Gather and refine reporting requirements from business units (Logistics, Sourcing, Finance, QA), translating them into functional technical specs. * Conduct variance analysis, trend modeling, and KPI tracking to support operational efficiency initiatives. * Assist users across the organization by providing technical training and documentation on published Power BI reports. Data Integrity & Governance * Conduct rigorous testing and validation of data outputs to ensure full accuracy before deploying dashboards. * Align data structures with PFSCM's overall Data Governance Framework and security access policies. * Troubleshoot reporting errors, broken data feeds, or calculation discrepancies promptly. * Other duties as assigned. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Software Developer Salary in The Netherlands [2023]](https://www.wearedevelopers.com/magazine/217-software-developer-salary-in-the-netherlands-2023) - [Best Companies in the Netherlands: Top 25 Companies in 2023 ](https://www.wearedevelopers.com/magazine/193-best-companies-in-the-netherlands-top-25-companies-in-2023) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)