Gauteng: PowerBI Data Analyst posted by Pillango Placements

Core responsibilities of the position include maintaining reliable data flow between production machinery and SQL Server, performing maintenance and report writing on the SYSPRO/SQL Server database, and designing, building, and maintaining Power BI data models and dashboards.

The role also participates in SQL data activities across production equipment, shop-floor diagnostics, networking, and plant data-transfer processes, including publishing and maintaining dashboards in Power BI Service.

Key Responsibilities

• Provide hands-on IT support (L1/L2): user accounts/passwords, email (M365/Outlook), connectivity/WiFi, printers, endpoints.
• Monitor, troubleshoot, and restore data flows between factory machines and server/SQL databases.
• Investigate and resolve stoppages related to data capture or machine-to-server communication.
• Perform basic SQL Server admin: queries, joins, backups, permissions, performance checks, and data integrity fixes.
• Design, build, and maintain Power BI dashboards and reports (e.g., downtime, throughput, scrap, OEE): data modelling, DAX measures, Power Query transformations, refresh schedules, and publishing to Power BI Service.
• Create/maintain simple reports and data extracts for operations; automate where feasible (PowerShell/Python/ETL).
• Maintain asset inventory, patching, and routine health checks across PCs, HMIs, and network devices.
• Document incidents, root causes, SOPs, and data lineage for dashboards.

Required Skills & Experience

• Practical SQL Server skills: writing queries/joins, troubleshooting failed jobs/data loads, backups/restores.
• Comfortable on the factory floor: reading machine/HMI messages, following cables, checking switches, validating data capture.
• Strong Windows desktop support, Active Directory/Azure AD, M365, basic networking (VLANs/DHCP/DNS), and printers.
• Proven incident response under time pressure; clear communication with production teams.
• Power BI (Mandatory):
  • Hands-on experience building interactive dashboards and paginated/operational reports.
  • Strong DAX for measures and KPIs; Power Query/M for data shaping.
  • Star-schema/data modelling best practices; relationships, calculated columns, and KPIs.
  • Power BI Service: workspaces, sharing, refresh schedules/gateways, and basic RLS.
  • Performance tuning (model size, aggregations, incremental refresh) and basic governance/usage monitoring.

Nice to Have

• Exposure to MES/SCADA/PLC data flows, OPC/REST connectors, or historian tools.
• Scripting for automation (PowerShell, Python) and basic ETL experience.
• Experience with Wi-Fi in industrial environments and ruggedised devices.

Behavioural Competencies

• Ownership mindset, urgency in downtime situations, and calm communication.
• Practical problem-solver with strong troubleshooting structure and documentation habits.
• Collaborative with production, maintenance, and IT stakeholders.

SALARY 

The offer will be market related in line with your qualifications, skills, and experience. The role can offer up to R40 000 per month for candidates who are an exact fit and require minimal additional training or oversight.

Please apply online in the link provided. Unfortunately, we do not consider CVs on Whatsapp or email.