Sql jobs in Canada

Reporting to the Director, Resilience Data Analytics, the Data Analytics Senior Engineer (Full-Stack Developer) (DAE) will be a senior contributor to the overall success of the Technology Internal Controls and Regulatory Management for GTEP by ensuring goals, plans, and initiatives are executed and delivered in support of the team’s business strategies and objectives. The DAE conducts all activities in compliance with governing regulations, internal policies and procedures.

You are coming into this role to contribute to the technical solutions that will automate processes and enable new data functionality within the team. You will be the senior technical resource of a team of 3 to deliver to project objective. This will include the overall architecture and solution flow for the initiative. We hope to leverage your wide and varied skills to enhance our team’s overall performance.

• Help us improve our disaster recovery time compliance based on historical testing results. You will build a data model to help ingest data from history as well as interviews that can lead to improved forecasting.
• Help us build co-pilot interfaces to improve the textual base of our reporting.
• Help us automate the gathering and distribution of reporting.

You and your team will work to normalize the data and create dashboard to measure key metrics. You will create input mechanisms so that data can be captured with integrity and quality across multiple resources. You will design and create ETL that can absorb large amounts of data to create the story. You will design and automate the discovery, ingestion, and normalization of data into SQL databases and then work to present them to tell the story in Power BI.

The main function of a Developer is to design, develop, and implement applications using general languages and technologies to support business requirements. Job Responsibilities: Analyze highly complex business requirements; generate technical specifications to design or redesign complex software components and applications. Act as an expert technical resource for modeling, simulation and analysis efforts. Leverage industry best practices to design, test, implement and support a solution. Assure quality, security and compliance requirements are met for supported area. Be flexible and thrive in an evolving environment. Adapt to change quickly and adjust work accordingly in a positive manner.

• You have at least 8+ years of hands‑on technical working experience as a technical engineer / analyst in the development and maintenance of data driven solutions. This includes experience in API/ETL, and Data Visualization using most of the tools we use: Python, SQL, VBA, Power BI (Power Query, DAX), SharePoint and scripting languages.
• 5+ years of experience in conceptual & logical Data Modelling, Database Design, BI.
• You have 5+ years in Predictive Analytics.
• You have at least 2+ years of working experience presenting your solutions to architecture boards and other technical review bodies.
• You have at least 2+ years of hands‑on technical working experience with Agile methodologies and tools: Atlassian’s Bitbucket/Git, Jira Confluence, etc.

• You have 3+ years working as a team lead for a small development team and can lead through the software development life cycle (SDLC).
• You have experience working with back‑ups and restores to at least 2 backup solutions (NetBackup, Tivoli, Veritas, HP Solutions).
• Experience in writing for and presenting to a Director+ audience & can demonstrate the ability to synthesize quantitative & qualitative information and content for this audience.
• Fluency in Spanish.
• ITIL certifications with experience in a technology operations domain.
• Financial industry experience.
• Project Management & Risk Management.
• Exposure to Large Language Models (LLM), Machine Learning (ML), Google Cloud Platform (GCP), or other cloud technologies.

You have proven interpersonal and negotiation skills that allow you to build consensus and obtain co‑operation from both support teams and senior management.

• Excellent written, presentation, and verbal communication skills to be able to work well with technical peers and business stakeholders at different levels within the organization.
• Strong decision making, forward thinking and creative problem‑solving skills to anticipate and respond quickly to technological/market influences.
• Ability to work as part of a team, as well as work independently or with minimal direction.

You have completed a post secondary education in Computer Science, Engineering, or in a technology related discipline.