Data Analyst

Jazz Aviation; Halifax; On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading company is seeking a Data Analyst to transition reports from legacy tools to Power BI. This role involves designing new reports, ensuring data accuracy, and providing training to end-users. The ideal candidate will have a strong analytical background, excellent communication skills, and proficiency in data visualization tools.

Qualifications

• Bachelor's degree in Computer Science, Math, Engineering, or Business.
• Proficiency in Power BI, SQL, ETL processes, and scripting.

Responsibilities

• Analyze existing reports and design new reports in Power BI.
• Conduct data migration and ensure data accuracy.
• Provide training and support for end-users.

Skills

Analytical Skills

Communication Skills

Attention to Detail

Education

Bachelor's degree in Computer Science

Bachelor's degree in Math

Bachelor's degree in Engineering

Bachelor's degree in Business

Tools

Power BI

SQL

ETL processes

Python

C#

Job description

Basic Purpose of Position

The Data Analyst will be responsible for transitioning existing reports from legacy tools to new data visualization platforms, primarily Power BI. This role involves understanding current reporting requirements, designing and implementing new reporting solutions, and ensuring data accuracy and integrity throughout the migration process.

Key Responsibilities

1. Analyze Existing Reports: Review and understand current reports in legacy tools to identify key metrics and data sources.
2. Design New Reports: Develop new reports and dashboards in Power BI that meet business requirements and enhance data visualization.
3. Data Migration: Extract, transform, and load (ETL) data from legacy tools to Power BI, ensuring data accuracy and consistency. Leverage data marts, data warehouses, data lakes, and Microsoft Polybase Data Virtualization.
4. Collaboration: Work closely with stakeholders to gather requirements, provide updates, and ensure the new reports meet their needs.
5. Testing and Validation: Conduct thorough testing of new reports to ensure accuracy and reliability.
6. Training and Support: Provide training and support to end-users on using the new Power BI reports and dashboards.
7. Documentation: Maintain comprehensive documentation of the migration process, including data mappings, report specifications, and user guides.

Qualifications

Required

• Education: Bachelor's degree in Computer Science, Math, Engineering, or Business with a focus on data.
• Technical Skills: Proficiency in legacy tools, Power BI, SQL, ETL processes, scripting (Python), or development (C#). Experience with other data visualization tools is a plus.
• Analytical Skills: Strong analytical and problem-solving skills, with the ability to interpret complex data sets.
• Communication Skills: Excellent verbal and written communication skills, with the ability to explain technical concepts to non-technical stakeholders.
• Attention to Detail: High level of accuracy and attention to detail in all aspects of work.

Asset

• Experience: Proven experience as a Data Analyst, with a focus on reporting and data visualization.

We strive to make our workplace accessible for people with disabilities. We want to ensure that you are prepared for success and therefore request that you please let us know at [e-mail] if you would benefit from an accommodation during the recruitment process.

Jazz recognizes that the best talent includes people of all backgrounds, abilities, and points of view. To be a leader in our industry, Jazz celebrates diversity and values the uniqueness that each individual has to offer. We empower our people to foster an internal culture of inclusion, creating safe workspaces where everyone can be their authentic self. Meeting the needs of our diverse passengers is critical to our success, and we recognize the importance of a workforce that reflects the communities we serve.