Sr. Power BI Developer

Job Description

The Power BI Developer will be responsible for designing, developing, and maintaining business intelligence solutions using Microsoft Power BI, with a strong emphasis on manufacturing industry data. This role involves close collaboration with cross-functional teams to transform complex data into actionable insights that drive strategic decisions, especially in areas like production efficiency, supply chain management, and quality control. Key Responsibilities Develop and maintain Power BI data models customized to the manufacturing sector, focusing on data sets such as production metrics, inventory levels, and supply chain KPIs. Design and implement interactive dashboards and reports that visualize production performance, yield rates, equipment downtime, and overall manufacturing efficiency. Execute ETL processes to ensure data accuracy and integrity across key operational systems, such as MES, ERP, Salesforce, and CRM systems used in manufacturing. Integrate Salesforce data (such as customer orders, service requests, and sales performance) into Power BI dashboards to provide end-to-end visibility from order to delivery. Work on BI projects where Salesforce acted as a primary or secondary data source, ensuring proper mapping and transformation of Salesforce objects for manufacturing analytics. Work with stakeholders from engineering, production, supply chain, and finance teams to understand business requirements and translate them into effective BI solutions. Optimize Power BI dashboards to handle high-frequency data typical in manufacturing settings, using techniques like incremental data refresh and direct query optimization for real-time insights. Ensure compliance with data governance and security policies in line with industry standards for manufacturing. Train end-users, especially production and engineering teams, to interpret Power BI insights effectively for operational decisions. Document and maintain BI solution architecture, data lineage, and user guidelines, ensuring transparency and consistency in manufacturing metrics. Required Qualifications 9+ years of experience as a Power BI Developer, preferably within the manufacturing industry. Proficiency in Power BI with advanced DAX calculations, data modeling, and manufacturing-specific report development. Strong expertise in SQL, with experience in querying manufacturing data sources and integrating with ERP, MES, and supply chain management systems. Familiarity with advanced Power BI capabilities like composite models and incremental refresh, essential for managing high-volume, time-sensitive data in manufacturing. Hands-on experience with Power BI Service, including workspace management, app deployment, and secure report sharing within a manufacturing organization. Strong expertise in SQL, with experience in querying manufacturing data sources and integrating with ERP, MES, Salesforce, and supply chain management systems. Hands-on experience in consuming Salesforce data via APIs, OData feeds, or data connectors, and integrating it into Power BI solutions focused on operational metrics. Proven ability to optimize Power BI performance for complex data models and high-frequency manufacturing data. Knowledge of data governance, compliance, and cybersecurity practices relevant to the manufacturing sector. Strong analytical and problem-solving skills tailored to manufacturing challenges, such as yield improvement, downtime reduction, and inventory optimization. Excellent communication skills, with the ability to convey technical insights to both technical and non-technical stakeholders in manufacturing. Key Competencies Advanced expertise in the Microsoft BI stack with a strong understanding of the data dynamics and requirements of the manufacturing industry. Precision in data modeling, focusing on creating insights essential for operations, such as production tracking, predictive maintenance, and quality assurance. Ability to translate operational and production data into actionable insights, enabling data-driven decisions for process improvements. Strong collaboration skills, working closely with production, supply chain, and engineering teams to align BI solutions with business goals. Show more Show less