Cloud BI Analyst: Quicksight, SQL & Redshift

FCC / FAC; Regina; Híbrido; CAD 83.000 - 112.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Hybrid work options

Descripción de la vacante

FCC / FAC is hiring an experienced Technical Analyst in Canada to ensure the reliability, performance, security and scalability of our cloud ecosystem within AWS. You will work with stakeholders to translate business requirements into practical technical solutions and support data environments built on native AWS technologies.

You’ll manage BI platform administration, access provisioning and ETL processes while collaborating with data engineering and business teams to improve end-user experience

Formación

• A bachelor’s degree in computer science, software engineering or information technology.
• Minimum five years of SQL experience
• Minimum two years of experience with AWS technologies and concepts: AWS Data Pipeline, DMS, Glue, Step Functions, Lambda, S3, Redshift and QuickSight
• Proven experience in ETL and BI support or data analytics roles
• Understanding of data warehousing concepts
• Proven ability to assess complex technical solutions, identify issues and resolve incidents
• Extensive knowledge of computer programming, systems analysis, design concepts, development methodologies and industry trends

Responsabilidades

• Be responsible for Business Intelligence platform administration, user governance and collaboration with data engineering and business stakeholders
• Manage user access provisioning and monitor data processes and system health
• Manage version control and deployment between environments (DEV/ITE/PRD)
• Ensure compliance with internal data governance standards
• Use AWS CloudWatch for monitoring and automate dataset refresh failure resolution
• Collaborate with colleagues and partners to simplify and streamline processes that improve the end-user and operational experience
• Support senior analysts by identifying and escalating technical or design challenges related to solution configuration or integration with existing frameworks and environments
• Triage production incidents, analyze logs and metrics, elevate complex issues to data engineering teams, document recurring issues and recommend automation improvements
• Develop scripts to automate monitoring tasks and improve alerting thresholds and notification workflows
• Optimize ETL job performance and cost efficiency
• Write complex SQL queries, stored procedures and views, and optimize SQL
• Participate in an on-call rotation, if applicable

Conocimientos

SQL

BI support

ETL

Data analytics

Data warehousing

Problem solving

Systems analysis

Educación

Bachelor’s degree in computer science, software engineering or information technology

Herramientas

AWS Data Pipeline

DMS

Glue

Step Functions

Lambda

S3

Redshift

QuickSight

Descripción del empleo

FCC / FAC is hiring an experienced Technical Analyst in Canada to ensure the reliability, performance, security and scalability of our cloud ecosystem within AWS. You will work with stakeholders to translate business requirements into practical technical solutions and support data environments built on native AWS technologies.

You’ll manage BI platform administration, access provisioning and ETL processes while collaborating with data engineering and business teams to improve end-user experience