Junior Data Analyst

GTT; Richmond; On-site; CAD 55,000 - 70,000; Full time

Job summary

GTT is looking for a Junior Data Analyst to transform data into actionable insights using Power BI. You will develop interactive dashboards, collaborate with teams, and ensure data quality. This role offers an opportunity to grow in a fast-paced environment.

Qualifications

• At least 1 year of experience in a data-related role or internship is preferred.
• Microsoft Certified: Data Analyst Associate (PL-300) certification is a plus.

Responsibilities

• Design, develop, and maintain interactive dashboards and reports in Power BI.
• Collaborate with stakeholders to understand reporting requirements.
• Validate and ensure the accuracy of data used in reports.

Skills

Analytical Skills

Problem-Solving

Communication

Attention to Detail

Education

Bachelor’s degree in a relevant field

Tools

Power BI

SQL

Power Query

Job description

About GTT
GTT is a leading networking and security as a service provider for multinational organizations, simply and securely connecting people and machines to data and applications – anywhere in the world. We serve thousands of organizations, bringing together the right people, partners and technology to reduce the burden on IT teams and solve the most pressing networking and security challenges.

Built on our top-ranked global Tier 1 network, GTT Envision is a single global technology platform to connect, orchestrate, virtualize and automate enterprise networks, enabling customers with consumable solutions to achieve business missions and meet ongoing demand when, where and how needed. Our portfolio includes SASE, SD-WAN, security, internet, voice and other connectivity options, complemented by a suite of professional services and exceptional sales and support teams in local markets around the globe. We partner with our customers to deliver Greater Technology Together. For more information, please visit www.gtt.net.

Role Summary

GTT is seeking a motivated and detail-oriented Junior Data Analyst to join our dynamic team. In this role, you will be instrumental in transforming data into actionable insights through the development of interactive dashboards and reports using Power BI. You will collaborate with cross-functional teams to understand their reporting needs and contribute to data-driven decision-making across the organization.

This is an excellent opportunity for a highly analytical individual to develop their skills in a fast-paced environment and play a key role in shaping our data visualization and reporting capabilities.

Duties And Responsibilities

1. Dashboard and Report Development: Design, develop, and maintain interactive dashboards and reports in Power BI to visualize key performance indicators (KPIs) and business metrics.
2. DAX Development: Write and optimize DAX (Data Analysis Expressions) measures and calculated columns to implement complex business logic and calculations within Power BI.
3. Data Extraction and Querying: Use custom SQL and Power Query (M language) within Power BI dataflows to extract, filter, and transform data from sources including PostgreSQL, Excel/CSV files from shared drives, and other structured data sources—ensuring performance, accuracy, and consistency throughout the data pipeline.
4. Data Quality Assurance: Validate and ensure the accuracy, consistency, and reliability of data used in reports and dashboards by implementing data quality checks and controls.
5. Requirements Gathering and Collaboration: Collaborate with stakeholders from departments such as Supply Chain, Inventory Management, Vendor Management, and Operations to understand reporting requirements and translate them into meaningful visualizations.
6. Documentation: Create and maintain clear documentation of data sources, data models, transformation logic, and reporting processes to support transparency and knowledge sharing.
7. Continuous Improvement: Stay up to date with the latest Power BI features and best practices, proactively seeking opportunities to enhance existing reports and improve data workflows.

Required Experience/Qualifications

Technical Skills:

• Proficiency in Power BI, including DAX, calculated columns, and data modeling concepts.
• Proficiency in writing SQL queries for data retrieval, filtering, and aggregation.
• Familiarity with relational databases and data warehousing principles.
• Working knowledge with of Power Query (M language) for transforming and shaping data within Power BI and dataflows.

Analytical Skills

• Strong analytical and problem-solving skills with the ability to interpret complex data sets.
• Ability to translate business requirements into technical specifications for reporting solutions.

Soft Skills

• Strong communication and interpersonal skills, with the ability to explain technical topics to non-technical stakeholders.
• Eagerness to learn new technologies and adapt to changing business needs.
• Strong attention to detail and commitment to maintaining high-quality, reliable reporting.
• Ability to work independently and as part of a team.
• Team Collaboration: A strong commitment to working collaboratively, recognizing that your success is tied to the success of the team.
• Resilience and Persistence: A willingness to navigate complex data challenges with patience and a problem-solving mindset.
• Open Communication: A dedication to transparent and honest communication with colleagues and stakeholders.
• Growth Mindset: A proactive approach to learning and professional development, embracing opportunities to expand your skills and knowledge.

Desirable Experience/Qualifications

• Bachelor’s degree in a relevant field (e.g., Computer Science, Information Systems, Business Analytics, Mathematics, Statistics, Economics) or equivalent practical experience.
• At least 1 year of experience in a data-related role or internship is preferred.
• Microsoft Certified: Data Analyst Associate (PL-300) certification is a plus.
• We Value Your Skills: While a degree can provide a strong foundation, we recognize that practical skills, curiosity, problem-solving ability, and willingness to learn are equally important. We highly value candidates who can demonstrate a proven ability to perform the key responsibilities of this role, regardless of their formal education. If you have a portfolio of projects, relevant work experience, or have demonstrated self-taught expertise, we encourage you to apply.

Universal Competencies

• Continuous Improvement: Knowledge of transformation initiatives to drive fundamental changes, enhance responsiveness and efficiency to core business practices. Ability to drive cultural changes from best effort to results oriented.
• Customer First (Non-Customer Facing): Knowledge of internal customer interactions, creating a culture of accountability, collaboration, and partnership. Ability to build an environment supporting internal customer value creation at every level.
• Operational Excellence: Understanding the system-driven processes for consistency and scalability. Ability to re-focus processes and systems from integration activity to maximizing a positive customer impact and anticipating future trends.

EEO Statement

GTT provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, GTT complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

GTT expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of GTT’s employees to perform their job duties may result in discipline up to and including discharge.