MGR, Reporting & Analysis

AFL

  • Surrey, BC
  • Permanent
  • Temps-plein
  • Il y a 13 jours
Description :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 decisions. In this hands-on development role, you’ll translate business needs into innovative technical solutions, combining creative solutioning with a focus on making business processes more efficient. You’ll 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. You’ll work closely with data warehouse sources to monitor performance, optimize analytics platforms, and continuously improve BI systems for maximum impact. Alongside the technical work, you’ll mentor and upskill junior team members, fostering Power Platform expertise across the team. From troubleshooting data models to delivering polished, high-quality reports, you’ll 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 team. This 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
QUALIFICATIONSKnowledge & 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 USEDMicrosoft 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 * T-SQL – SQL Server views, stored procedures, performance tuning
  • DAX – Power BI measures and analytics
  • Power Fx – Logic and validation in Power Apps
  • M Language – Data transformation in Power BI
  • JSON – Power Automate expressions, REST API payloads
  • REST API / HTTP Protocols – API integration and authentication
  • JavaScript – DOMO widgets, Google Apps Script, webhook configurations
  • HTML / CSS – Email templates, embedded apps, Twilio UI
  • Python (optional) – API testing, data manipulation, integration enhancements
LOCATION & WORKSTYLE:Location: Calgary or SurreyHybrid (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, we’re 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 PerksReady to Join Us? If you’re 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 NS-Recruitment@AFLglobal.com. 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

AFL