Data Analyst

emergiTEL Inc.; Calgary; On-site; CAD 70,000 - 90,000; Full time

Job summary

A technology solutions firm in Calgary is seeking a Data Migration and Reporting Lead who will execute migration and develop reporting tools. The ideal candidate will have 2-5 years in a data or business analyst role and experience in systems implementations. Key responsibilities include hands-on execution of data migration and analytics development using tools like Tableau and SQL. This position demands strong analytical skills and a proactive approach in a collaborative environment.

Qualifications

• Minimum 2-5 years of experience in a data analysis, business analysis, or systems analyst role.
• Experience supporting a major software implementation or data migration project is strongly preferred.
• Strong proficiency in building reports and dashboards.

Responsibilities

• Work hands-on with SMEs and vendor technical teams to execute the data migration process.
• Partner with stakeholders to validate and finalize data migration and reporting requirements.
• Design, build, deploy, and create documentation for custom reports and interactive dashboards.

Skills

Analytical Mindset

Consultative & Collaborative Approach

Project Execution & Initiative

Data-Driven Insights

Systems Thinking & Adaptability

Education

Degree in business, economics, computer science or related field

Tools

Tableau

Google Data Studio

Power BI

SQL

Job description

Overview

You will be a key leader in executing our transition to a modern technology ecosystem. You will build on discovery work that has already been completed, supporting the data migration, executing validation tasks, and building required reports. Working closely with the Implementation Manager, Workplace Technology and Data and key stakeholders, you will design, develop and deploy key reporting and dashboards for Facilities and Real Estate management, leveraging the new Integrated Workplace Management System (IWMS). You will also develop and document key project artifacts, such as data mapping, data strategy, testing plans, and data input processes ensuring long term data integrity, to support the technology ecosystem's implementation.

This role requires an individual with initiative and the ability to develop a strong understanding of both the old and new IWMS and their data structure. You will work to understand how the two systems support our users with their processes, reporting and insights. You will be a hands-on executor of migration and reporting tasks. This position emphasizes hands-on execution of data migration, system integration, and the development of in and out of system reporting and dashboards to meet business requirements.

Responsibilities

• Data Migration Execution: Work hands-on with SMEs and vendor technical teams to execute the migration process, from data mapping and validation to final upload and verification.
• Requirements Finalization: Partner with stakeholders to validate and finalize data migration and reporting requirements, building on the discovery already completed and identifying any gaps. Conduct pre and post-migration data quality assurance.
• Reporting & Analytics Development: Design, build, deploy, and create documentation for custom reports and interactive dashboards for SMEs, translating complex data into actionable insights. This will primarily be done within Tableau and Planon (IWMS).
• System & Project Acclimation: Proactively learn the existing project status, technology (IWMS, SAP), and data landscape to effectively contribute to active migration and reporting timelines.
• Data Quality Facilitation: Partner with PP&S stakeholders to format, clean, and validate datasets before migrating them into the selected IWMS system. Develop strategy to drive continued data integrity.

Top Skills

• Analytical Mindset: Demonstrate proactive critical thinking through analytical problems and subject matter. Partner with SMEs to understand their subject matter, and provide solutions to analytical needs.
• Consultative & Collaborative Approach: Excellent communication and stakeholder management skills. Ability to work as a trusted partner with diverse business units, translating technical concepts to ensure alignment.
• Project Execution & Initiative: A proactive, self-starter attitude. Proven ability to manage project tasks, take initiative, and work with a high degree of autonomy to meet key milestones.
• Data-Driven Insights: Strong analytical skills with the ability to validate business requirements and a proven ability to develop reporting tools and dashboards that drive insights.
• Systems Thinking & Adaptability: The ability to learn and understand new systems, data structures, and complex process workflows to effectively execute and make recommendations

Qualifications

• Experience: Minimum 2-5 years of experience in a data analysis, business analysis, or systems analyst role. Experience working with Facilities or Real Estate data is an asset.
• Implementation Experience: Experience supporting a major software implementation or data migration project is strongly preferred.
• Education: A degree in business, economics, computer science or a related field is preferred.
• Technical Proficiency: Strong proficiency in building reports and dashboards (e.g., Tableau, Google Data Studio, Power BI, or in-system reporting tools). Strong data querying and manipulation skills (e.g. SQL).
• Industry Knowledge: Willingness to learn about real estate, construction, and facilities management within a project management context is advantageous.
• Project Description: Implementation of a new Integrated Workplace Management System, and Integrated Health System