Technical Analyst (Quicksight, SQL and Redshift)

Closing Date (MM/DD/YYYY):

Worker Type:

Language(s) Required:

Term Duration (in months):

Salary Range (plus eligible to receive a performance based incentive, applicable to position) :

Why FCC?

At FCC, we’re proud to be 100% invested in Canadian agriculture and food. As a federal Crown corporation, we provide financing, knowledge resources and business management software to over 103,000 customers nationwide.

Here’s what you can expect when you join our team:

• Competitive total rewards packages: market-aligned and performance-based salary and incentive programs, flexible and comprehensive group benefit and savings plans, and well-being support through benefits and wellness programs

• Purpose-driven work: We build strong relationships, share knowledge and support the people who feed the world

• Growth:Learning and development opportunities to help you thrive

• Hybrid work options

How you’ll make an impact

As a Technical Analyst, you’ll ensure the reliability, performance, security and scalability of our cloud ecosystem within Amazon Web Services. With a strong customer focus, you’ll work closely with stakeholders to gather and translate business requirements into practical, high-quality, well-tested and aligned technical solutions.

In this role, you’ll manage, support and optimize our data environments built using native AWS technologies. You’ll make a tangible impact by developing new tools, implementing and supporting technology process automation, and continuously improving existing systems. Your work will help streamline processes, enhance integration, and improve how technology supports FCC’s corporate and operational teams’ reporting, ultimately enabling better service for our customers.

We’re looking for a technical problem solver who thrives under pressure, enjoys tackling complex challenges, and can clearly communicate technical concepts in plain language. If you’re innovative, customer-focused, and excited to work with modern cloud and integration technologies in a broad, user- and business-driven environment, this role offers the opportunity to make a meaningful and lasting impact.

What you’ll do

• 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, escalate 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

What you’ll bring to the team

Required qualifications:

• 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

Preferred qualifications:

• AWS certifications (e.g., Cloud Practitioner, Data Engineer or Solutions Architect)
• Scripting experience with Python/Boto3 and TypeScript
• Experience with DevOps or DataOps practices
• Experience coaching, mentoring or leading people
• Experience leading demos and presentations

Not sure you meet every requirement? We encourage you to apply anyway. 

You belong here 
At FCC,we’re committed to creating an inclusive,equitable and accessible workplace – one that reflects the communities where we live, work and play. Our team is made stronger through diversity, andwe’re dedicated to building a workforce that brings together a range of backgrounds,abilities and perspectives. 
  
We encourage qualified applicants to apply, including members of these four employment equity groups: 
• Indigenous Peoples 
• Members of visible minority groups 
• Persons with disabilities 
• Women  

Accessibility and accommodations   

To support an inclusive and accessible candidate experience, we encourage anyone needing an adjustment or accommodation during any stage of the recruitment process to email us at: TalentSupplyRecherch@fcc-fac.ca. An HR partner will respond and work with applicants who requesta reasonable accommodation. Information received in relation to accommodation requests will notimpact hiring decisions.