QuickSight Systems Analyst-061025

emergiTEL; Mississauga; On-site; CAD 70,000 - 90,000; Full time

Job summary

A technology company in Peel Region, Mississauga seeks a QuickSight System Analyst to develop and deploy robust data reports in Amazon QuickSight. This role requires 2+ years of experience in building reports, SQL proficiency, and ability to handle large datasets. Ideal candidates will have a proactive attitude and work collaboratively across teams. Competitive salary and benefits offered.

Qualifications

• 2 years experience building and deploying data reports in Amazon QuickSight.
• Proficient in SQL with experience accessing sources like DB2, PostgreSQL, and Amazon Aurora.
• Solid skills in configuring QuickSight datasets and filters.

Responsibilities

• Design and build reports in Amazon QuickSight.
• Manage report publishing and user access permissions via AWS IAM.
• Gather reporting requirements and document report logic.

Skills

Building and deploying data reports in Amazon QuickSight

SQL proficiency

Configuring QuickSight datasets

Publishing reports and managing access via AWS IAM

Handling large datasets

Requirement gathering

Familiarity with ETL concepts

Tools

Amazon QuickSight

DB2

PostgreSQL

Amazon Aurora

AWS IAM

AWS Glue

AWS Lambda

AWS S3

Job description

Role Summary

As we re-platform to a new innovative AWS ecosystem the QuickSight System Analyst is critical for ensuring our business has reliable actionable reporting at every step. Reporting to the Director of Technology on the Technology Team you’ll develop and deploy robust data reports in Amazon QuickSight enabling teams to access vital information and make smarter decisions as we migrate to the new platform.

Key Accountabilities

• Design and build reports in Amazon QuickSight that present complex data in a clear, accurate, and usable format.
• Configure datasets, calculated fields, filters, and parameters to ensure the data is relevant and accessible.
• Use SQL to connect to and extract from data sources like DB2, PostgreSQL, and Amazon Aurora.
• Manage report publishing and user access permissions via AWS IAM.
• Troubleshoot and optimize report performance, especially with large or complex datasets.
• Gather reporting requirements from stakeholders and translate business questions into effective technical solutions.
• Document report logic and processes to support knowledge transfer and long-term maintainability.
• Support teams in accessing, understanding, and using reports during and after the platform migration.
• Provide expertise in ETL concepts and basic data modeling as needed for report accuracy.
• Assist with aspects of AWS data pipelines (Glue, Lambda, S3) to ensure smooth integration with QuickSight.
• Ensure all reports are up-to-date and in sync with business needs throughout the migration.

Required Skills & Expertise

• 2 years experience building and deploying data reports in Amazon QuickSight.
• Proficient in SQL with experience accessing sources like DB2, PostgreSQL, Amazon Aurora or similar.
• Solid skills in configuring QuickSight datasets, calculated fields, filters, and parameters.
• Able to publish reports and manage access using AWS IAM.
• Comfortable handling and optimizing large datasets for report speed and reliability.
• Requirement gathering and translation skills for business questions.
• Familiarity with ETL concepts and basic data modeling.

Preferred

• Logistics or transportation reporting background (TMS, EDI shipment/tracking data).
• Exposure to AWS Glue, Lambda, S3.

Key Behavioral Components

• Highly detail‑oriented with a commitment to accuracy.
• Proactive and self‑motivated comfortable working independently.
• Strong communicator who can explain technical info in everyday language.
• Collaborative, enjoys working across teams to solve reporting challenges.

Performance Indicators

• Business users quickly get the reports they need with little friction or re‑work.
• Reports are accurate, maintained, and aligned with shifting business questions.
• Smooth knowledge transfer and minimal confusion as platform migration progresses.