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 were 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 103000 customers nationwide.

Heres 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 youll make an impact

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

In this role youll manage support and optimize our data environments built using native AWS technologies. Youll 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 FCCs corporate and operational teams reporting ultimately enabling better service for our customers.

Were looking for a technical problem solver who thrives under pressure enjoys tackling complex challenges and can clearly communicate technical concepts in plain language. If youre 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 youll 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 youll bring to the team

Required qualifications:

• A bachelors 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.