Data Analyst

Job summary

The Data Analyst will develop and maintain operational, financial, and project reporting dashboards to support business decision-making. They will also analyze business data, automate reporting processes, and collaborate with IT and business teams to improve data accessibility.

Job details

North America Construction (1993) Ltd. – NAC Constructors Ltd. (NAC) is well known for our expertise in water and wastewater construction across Canada. Our self-performing team of almost 500 skilled professionals and experts in trades and engineering, comprehensively handles projects, from conceptualization to delivery. We also have extensive experience in fields such as civil, structural, process mechanical, building mechanical, electrical and instrumentation work. At NAC, our priority is to maintain the highest level of quality and safety. The depth of our resources is evident in the variety of projects we construct; from water filtration to wastewater treatment; dams to ethanol; we build it all….and more! NAC is currently seeking a Part-Time Data Analyst to join our IT team at our Head Office location in Morriston, ON. Position Summary: The Part-Time Data Analyst supports business decision-making through data collection, analysis, reporting, and dashboard development. This role works closely with business stakeholders to transform operational and financial data into actionable insights while maintaining high standards of data quality and governance. The successful candidate will leverage Power BI, SQL, Excel, and Microsoft 365 technologies to create reports, automate processes, and support continuous improvement initiatives across the organization \n Responsibilities: Develop and maintain operational, financial, and project reporting dashboards. Analyze business data to support decision-making and performance measurement. Create recurring and ad hoc reports for departments across the organization. Monitor data quality and resolve reporting discrepancies. Assist with KPI definition, tracking, and reporting. Automate manual reporting processes where possible. Support system implementations and data migration activities. Document reporting processes and data definitions. Collaborate with IT and business teams to improve data accessibility and reporting capabilities. Requirements: Advanced proficiency with Microsoft Excel including Pivot Tables, Power Query, and data modeling. Experience developing and maintaining Power BI dashboards, reports, and datasets. Strong understanding of data visualization principles and KPI reporting. Ability to write SQL queries for data extraction, validation, and analysis. Experience working with structured and unstructured data sources. Understanding of relational databases, data relationships, normalization, and dimensional models. Knowledge of Power Automate for report distribution and workflow automation. Familiarity with Microsoft Dataverse, SharePoint Lists, and Microsoft 365 data sources. Understanding of data governance, data quality, and reporting best practices. Ability to gather business requirements and translate them into meaningful reports and dashboards. Strong analytical and problem-solving capabilities. Ability to identify trends, risks, and opportunities from large datasets. Strong attention to detail and commitment to data accuracy. Excellent written and verbal communication skills. Ability to present findings to both technical and non-technical stakeholders. Strong organizational skills and ability to manage multiple priorities. \n NAC Offers: Competitive compensation Opportunities for career growth, development and advancement, including financial assistance Comprehensive benefit plan (dental, vision, health, etc.) Employee & Family Assistance Program Excellent company matched pension plan Registered Retirement Savings Plans Additional time off between Christmas and New Year’s Day Community involvement opportunities Friendly working environment Numerous team activities and various company events NAC is committed to providing equal opportunities for all individuals to achieve their goals. If you feel that you need accommodations during the recruitment and selection process because of illness/disability, please contact Human Resources for further information

What you’ll do

The Data Analyst will develop and maintain operational, financial, and project reporting dashboards to support business decision-making. They will also analyze business data, automate reporting processes, and collaborate with IT and business teams to improve data accessibility.

Requirements

Candidates must have advanced proficiency in Microsoft Excel and experience developing Power BI dashboards and datasets. Strong SQL skills, an understanding of data visualization principles, and the ability to translate business requirements into reports are also required.

Benefits

• Competitive compensation • Career growth and development opportunities • Financial assistance for education • Comprehensive benefit plan • Dental insurance • Vision insurance • Health insurance • Employee & Family Assistance Program • Company matched pension plan • Registered Retirement Savings Plans • Additional time off between Christmas and New Year’s Day • Community involvement opportunities

Listed skills

• Data visualization · Preferred
• Power BI · Preferred
• SQL · Preferred
• Problem solving · Preferred
• Microsoft Excel · Preferred
• Communication Skills · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Microsoft Excel
• Power BI
• SQL
• Data visualization
• KPI reporting
• Power Automate
• Microsoft Dataverse
• SharePoint Lists
• Data governance
• Data quality
• Analytical skills
• Problem-solving
• Data modeling
• Power Query
• Communication skills
• Organizational skills
• Ad Hoc Reporting
• Project Documentation
• Microsoft 365
• Organizational Skills
• Microsoft Power Automate
• Reporting Processes
• Workflow Automation
• Data Analysis
• Dashboard
• Business Requirements
• Decision Making
• Continuous Improvement Process
• Data Extraction
• Data Governance
• Data Migration
• Data Modeling
• Data Quality
• Data Visualization
• Relational Databases
• Instrumentation
• Pivot Tables And Charts
• Financial Data
• Governance
• Problem Solving
• Key Performance Indicators (KPIs)
• Wastewater
• Performance Measurement
• Sewage Treatments
• Microsoft SharePoint
• SQL (Programming Language)
• Unstructured Data
• Verbal Communication Skills
• System Implementation
• Detail Oriented

Job areas

• Data & Analytics
• Technology
• Construction
• Finance & Accounting
• Administrative
• Data Analyst
• Statistical, Mathematical and Related Associate Professionals
• Business Intelligence Analysts
• Data Scientists