FP&A; Analyst

Company: Empire Fence Group

Location: Aurora, Ontario

Reports To: VP Finance

Type: Remote | Full-Time

About the Company

We are a diversified group of businesses operating across Ontario within the commercial fencing and road safety infrastructure sectors. Our operations span multiple business units specializing in manufacturing, distribution, installation, and service delivery, each contributing to the development of secure, efficient, and reliable infrastructure solutions across industrial, commercial, and municipal markets.

With a strong reputation for quality, innovation, and execution, we are experiencing rapid growth and are investing heavily in technology, data, and analytics to strengthen decision-making and scalability across the organization.

Senior Data Analyst

Remote | Full-Time

About This Role

We are seeking an experienced Senior Data Analyst to join our dynamic, fast-paced team. In this role, you will design and build data pipelines, work across multiple ERP systems, and collaborate with cross-functional teams to transform complex data into actionable insights that drive business decisions. You'll thrive in an agile environment where priorities shift quickly, and you'll own the full Business Intelligence stack, from data ingestion and modeling through to reporting and visualization, while mentoring junior analysts in a collaborative, innovative setting.

Key Responsibilities

- Design, build, and maintain scalable data pipelines (ETL/ELT) that move and transform data across multiple ERP systems and source platforms
- Extract, integrate, and analyze data from multiple ERP systems to provide comprehensive business insights
- Own the full Business Intelligence stack end to end, including data modeling, warehousing, ETL/ELT orchestration, and the creation of interactive dashboards, diagrams, and graphs
- Acquire data from primary and secondary sources across various platforms, maintaining robust databases and data systems to ensure data integrity




- Develop and maintain applications and automated pipelines to streamline data file consumption and processing for internal systems
- Perform comprehensive data extraction, storage, manipulation, processing, and analysis using SQL and other data tools
- Provide solutions and consultancy services based on existing IT portfolio, recommending optimal approaches for business needs
- Manage stakeholder expectations during IT project implementation, clearly communicating deliverables and timelines in a quick-paced environment
- Quickly adapt to changing priorities and handle multiple concurrent projects while maintaining attention to detail
- Mentor and provide technical guidance to junior analysts, reviewing their work and helping develop their pipeline and BI skill sets
- Maintain up-to-date understanding of key technologies, platforms, ERP systems, and processes that support business operations
- Collaborate with stakeholders to understand data requirements and translate business needs into technical specifications
- Document and hand over completed IT solutions to support teams, providing comprehensive training to stakeholders

Required Qualifications

Education & Experience

- Bachelor's degree in Computer Science, Business Analysis, Data Science, Data Analytics, or related field
- 4+ years of relevant data analysis experience, including hands-on experience designing and building data pipelines

Technical Skills

- Experience working with ERP systems (NetSuite, Yardi, Jonas, Sage, or similar enterprise systems)
- Full BI stack expertise, including data warehousing,



ETL/ELT pipeline development, data modeling, and visualization tools (Power BI, Tableau)
- Advanced SQL skills including joins, CTEs, stored procedures, functions, sub-queries, tracing, and performance tuning
- Demonstrated experience architecting and maintaining ETL/ELT data pipelines, including scheduling, orchestration, and data quality/monitoring practices
- Programming experience with Python
- Experience with Microsoft Power Apps and Power Automate
- Knowledge of statistics and experience using statistical packages (Excel, SQL, SSIS, SAS, etc.)
- Strong knowledge of Microsoft technologies (Windows/SQL Server) and Microsoft cloud tools

Professional Competencies

- Demonstrated leadership mentoring or guiding junior analysts, with strong initiative in previous roles
- Ability to thrive in a fast-paced, dynamic environment with shifting priorities
- Strong time management skills with ability to handle multiple concurrent projects
- Growth mindset with a genuine passion for continuous learning
- Collaborative approach with ability to build strong relationships and skilled networks
- Agile and technically savvy, with natural problem-solving abilities
- Creative thinker with resourcefulness and innovative approach to challenges
- Strong training, facilitation, and presentation skills

Preferred Qualifications

- Experience working with multiple ERP platforms simultaneously
- Knowledge of ERP data structures and integration methodologies
- Experience working on small to medium-sized data migration projects
- Application development experience and knowledge of modern development technologies
- Experience with cloud-based data platforms and modern data architecture

Pay: $90,000.00-$100,000.00 per year

Benefits:

- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- Paid time off
- RRSP match
- Vision care

Work Location: In person

📌 Senior Data Analyst (Aurora)
🏢 Empire
📍 Aurora