MGR, Reporting & Analysis

AFL is a global leader in fiber optics providing integrated solutions in engineering construction installation and repair services for broadband networks. Known for its innovation AFL began in 1984 with a single product and has grown into a billion-dollar company serving telecom oil and gas and utilities markets worldwide.

AFL is committed to environmental responsibility employee well-being and community engagement through grants service projects and sustainability initiatives. Backed by Fujikura Ltd. a $6 billion company with over 128 years of innovation AFL offers a culture of collaboration growth and stability with operations across Canada the U.S. Mexico Europe Asia and Australia.

Join our team as a Manager of Reporting and Analysis and put your skills in the Microsoft Power Platform to work driving data-powered this hands-on development role youll translate business needs into innovative technical solutions combining creative solutioning with a focus on making business processes more efficient. Youll design and build intuitive Power BI dashboards Power Apps and other tools that automate manual processes leverage AI and turn complex data into clear actionable insights. Youll work closely with data warehouse sources to monitor performance optimize analytics platforms and continuously improve BI systems for maximum impact. Alongside the technical work youll mentor and upskill junior team members fostering Power Platform expertise across the team. From troubleshooting data models to delivering polished high-quality reports youll help drive smarter strategies stronger teams and transformative business outcomes.

Your initial key focus will be to support our Civil Construction teams in optimizing their existing and prototype solutions to optimize their front-end operations. As your knowledge of our business domain expands your role will grow to help transform our entire business by working on transformational projects that are prioritized and sponsored by our executive leadership exciting role offers you the opportunity to truly grow your career and make an impact.

SPECIFIC RESPONSIBILITIES AND RESULTING OUTCOMES

• Lead and mentor junior analysts providing technical guidance task prioritization and quality assurance across multiple programs
• Govern and support a portfolio of Power Platform solutions including Power Automate cloud flows Power BI datasets and dashboards and embedded Power Apps
• Manage third-party vendors and cloud hosting platforms (e.g. Intermedia Upwork) including billing oversight and issue escalation for business-critical systems
• Maintain and evolve Power BI assets by managing refresh schedules fixing dataflows updating gateways and responding to user requests
• Build and maintain advanced Power Automate workflows integrating external platforms (Vitruvi Smartsheet Twilio Salesforce JIRA etc.) using REST APIs
• Maintain and enhance a proprietary legacy system (Microsoft Access front end SQL Server backend) including development of new SQL procedures and views
• Own engineering data integration processes into construction management systems and proprietary applications ensuring proper formatting validation and delivery
• Administer department-owned SharePoint sites managing structure permissions and embedded flows for document and task automation
• Liaise with client-side system owners to coordinate API integrations and digital tool alignment across platforms like JIRA Salesforce and Appian
• Collaborate cross-functionally with engineering construction supply chain and PMO leadership to align technology with operational needs
• Participate in requirements gathering testing deployment and rollout of new internal tools and solutions

QUALIFICATIONS

Knowledge & Experience

• Post-secondary degree or diploma in general science computer science business or statistics; or equivalent working experience
• Experience leading teams and managing complex digital solutions
• Expert in Microsoft Power Platform (Power Apps Power BI Power Automate Dataverse)
• Skilled in SQL Server and API-based data integration
• Industry knowledge in telecommunications and construction is an asset

Skills and Abilities

• Leadership and mentoring capabilities
• Strong analytical thinking and problem-solving skills
• Detail-oriented with ability to manage multiple priorities
• Effective communicator and collaborator across business units
• Adaptable to fast-paced environments and evolving technologies
• Creative and innovative thinker with ability to translate complex data into actionable insights

SYSTEMS & PLATFORMS USED

Microsoft Ecosystem:

• Power Platform (Power Automate Power BI Power Apps Dataverse)
• SQL Server (on-prem)
• Microsoft Access (legacy support)
• SharePoint (site administration document library setup metadata flows permissions)
• Office 365 (Outlook Teams Excel OneDrive)

Project Construction & Workflow Platforms:

• Vitruvi (fiber construction platform)
• FTTxPro (proprietary Access/SQL application)
• Smartsheet (project & data tracking for MxU program)
• Twilio (automated call and SMS workflows)
• OpenAI (automated customer service interactions via Power Automate)
• Intermedia (hosting FTTxPro)
• Upwork (FTTxPro admin)
• NeverBounce (email/phone validation tool API used in permission automation)

• Salesforce (CRM and project workflow access)
• JIRA (MxU projects legacy SxU schedules)
• Google Workspace / G Suite (API integrations for TELUS Marketing)
• KONG (API gateway for client-side services future development)
• Appian (business process workflow engine TELUS migration from JIRA)
• DOMO (external dashboarding and reporting platform XLS outputs to SFTP or manual extraction)

CODING SCRIPTING & QUERY LANGUAGES REQUIRED

1. T-SQL SQL Server views stored procedures performance tuning
2. DAX Power BI measures and analytics
3. Power Fx Logic and validation in Power Apps
4. M Language Data transformation in Power BI
5. JSON Power Automate expressions REST API payloads
6. REST API / HTTP Protocols API integration and authentication
7. JavaScript DOMO widgets Google Apps Script webhook configurations
8. HTML / CSS Email templates embedded apps Twilio UI
9. Python(optional) API testing data manipulation integration enhancements

LOCATION & WORKSTYLE:

Location: Calgary or Surrey

Hybrid (min. 2-3 days per week in-office)

Why AFL AFL is a global leader in the telecommunications industry providing cutting-edge network technology and solutions to customers around the world. At AFL were committed to diversity and inclusion recognizing that our team members unique contributions help us provide superior service and create better solutions. We provide best-in-class training to ensure you have everything you need to succeed and grow.

Additional Perks:

• Annual merit increases
• Excellent training and professional development opportunities
• A supportive and diverse team environment
• Opportunity to work in a dynamic rapidly changing industry.
• RRSP matching plans
• Health dental vision and health benefits
• Employee Assistance Programs

• Work Perks

Ready to Join Us If youre passionate about data and analytics have expertise with tools and business acumen with a passion for problem solving and enjoy data drive solutions work we want to hear from you! AFL offers you the chance to grow your career with a leader in the field while being part of a team that values innovation safety and continuous learning.

We welcome diversity and encourage individuals of all backgrounds to apply!

We provide reasonable accommodations for individuals with disabilities. If you need accommodations during the application process contact We are an equal opportunity employer and value diversity not discriminating based on race religion color national origin gender sexual orientation age marital status veteran status or disability