Power BI and Network Systems Administrator
Aspen Custom Trailers
- Leduc, AB
- Permanent
- Full-time
- Network and infrastructure administration
- Business intelligence development and reporting
- ERP-related integrations and workflow automation
- Practical use of modern AI-enabled productivity tools
- Administer and maintain plant and corporate network infrastructure (Cisco switches, VLANs, firewalls)
- Support segmented shop-floor networks and connectivity
- Manage Ubiquiti wireless environments supporting production devices
- Maintain virtualization platforms (VMware ESX or equivalent)
- Administer Active Directory and Azure AD (user access, security groups, group policy)
- Support Microsoft 365 and user provisioning
- Ensure reliability and uptime of systems critical to manufacturing operations
- Develop and maintain Power BI dashboards supporting:
- Production metrics and throughput
- Work order tracking and scheduling
- Inventory management
- Cost and margin analysis
- Sales reporting and forecasting
- Develop and optimize SQL queries and reporting views
- Maintain SSRS reports and scheduled operational reports
- Collaborate with operations and finance teams to translate business needs into dashboards
- Support workflow automation using Power Apps and Power Automate
- Maintain integrations (VB.NET/VBA/VB6 and REST APIs)
- Assist with ERP-related system enhancements
- Support EDI and vendor/customer data exchanges
- Document reporting logic and system integrations
- Support implementation of Microsoft Copilot tools to improve reporting and productivity
- Assist with Microsoft Fabric and modern data architecture initiatives
- Leverage AI tools for report generation, trend analysis, and process insights
- Maintain appropriate data governance and security standards
- Assist with escalated help desk issues
- Provide support to plant and office personnel, both on-site and in remote locations
- Support workstations, printers, scanners, and shopfloor devices
- Collaboration with Managed IT and Managed security vendors
- Stable, reliable plant network operations
- Improved production and financial reporting dashboards
- Increased automation of routine reporting tasks
- Well-documented system architecture and integrations
- Active Directory and Azure AD administration
- Cisco networking experience
- Virtualization platforms (VMware or equivalent)
- Advanced SQL skills
- Power BI and SSRS experience
- Power Apps and Power Automate
- Experience with REST-based integrations
- Comfortable supporting both office and production-floor users
- Manufacturing or industrial environment experience
- ERP system exposure
- Experience integrating operational and financial data
- Monday to Friday 8:00 am - 4:30 pm
- Onsite in Leduc, AB
- Comprehensive benefits package
- Collaborative team environment
- Competitive Medical & Dental Benefits including RRSP and EFAP
- Direct exposure to operations and leadership