PowerBI Data Analyst

SUMMARY:
Ready to take your IT career to the next level? A top-tier fast growing manufacturing company in Alberton is on the hunt for a PowerBI Data Analyst who is ready to dive into real-time problem solving and data-driven innovation!

POSITION INFO:
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/Wi‑Fi, 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.

• 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.

• 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.

• 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.