Power BI Developer
Salary
Annual
- Power BI
- Manufacturing
- ERP
- Power BI: 3+ years of hands-on experience with Power BI Desktop and Power BI Service
- SQL Server: Strong T-SQL skills with experience querying complex relational databases
- DAX: Proficiency in writing advanced DAX formulas for time intelligence, filtering, and aggregations
- Data Modelling: Experience with star schema design and data warehouse concepts
- ERP Systems: Previous experience working with ERP data structures, particularly food industry systems (eg, Sage, SAP, Microsoft Dynamics, or similar)
- Design and build interactive Power BI dashboards and reports connected to a SQL Server ERP database
- Create data models optimized for industry metrics including inventory, production, quality control, and finance.
- Develop custom DAX measures and calculated columns.
- Implement row-level security to ensure appropriate data access across departments
- Write efficient SQL Server queries and stored procedures to extract and transform data from the ERP system
- Optimize data refresh schedules to balance performance with Real Time reporting needs
- Create and maintain dataflows for commonly used datasets
- Document data lineage and transformation logic
- Conduct requirements gathering sessions with department heads (operations, quality assurance, procurement, sales)
- Translate business requirements into technical specifications
- Provide training and documentation for end users
- Understanding of manufacturing workflows (procurement, production, packaging, distribution, finance)
- Familiarity with manufacturing industry compliance requirements (lot tracking, expiration dates, quality metrics)
- Excellent communication skills with ability to explain technical concepts to non-technical users
- Strong analytical and problem-solving abilities
- Attention to detail, particularly regarding data accuracy
- Ability to work independently and manage project timelines
- Knowledge of Power Query (M language) for advanced data transformation
- Familiarity with Power BI deployment pipelines and version control