SQL Analyst

Description du poste

The Astek Group

Founded in France in 1988, Astek is a global player in engineering and technology consulting. With its expertise in various industrial and tertiary sectors, Astek supports its international clients in the intelligent deployment of their products and services, as well as in the implementation of their digital transformation.

Since its inception, the Group has based its development on a strong culture of entrepreneurship and innovation, and on the support and upskilling of its 7800 employees who are committed every day to promoting the complementarity between digital technologies and complex system engineering.

In Canada, the firm specializes in IT consulting services and engineering. Our teams successfully drive our clients’ development strategies. Around common values, we have gained their trust and address their business challenges by putting their needs at the center of our actions and priorities.

This ecosystem of expertise enables Astek Canada to adapt quickly to evolving technologies, and all employees participate collaboratively in their development.

Are you ready to take on a new challenge, give your career a boost, and participate in innovative and stimulating projects?

Join a rapidly growing Group in Canada and worldwide that achieved a turnover of €600 million in 2023.

What we will achieve together:

Our team develops financial models and processes required for measuring, transfer pricing, hedging product profitability, and financial management reporting.

The Treasury Analytics Group is embarking on a brand new initiative to build the next generation strategic platform for risk, valuations and analytics to meet the growing and future needs of the department. This is an exciting opportunity to work on cutting edge technologies including Big Data and NoSQL databases (Hadoop, Hbase, Hive, SPARK and MongoDB) to allow the business to gain advanced insight into their portfolios and valuation metrics.

Your mission would be:

• Analyze, document and validate business rules requirements from business users.
• As Spark SQL is used as a programming language for the business rules, a successful candidate is required to be able to write, test Spark SQL statements to translate the business requirements into the programming code.
• Optimize performance and tune Spark SQL statements.
• Use Visual Studio (SQL Integration Services) to analyze SSIS packages.
• Analyze multiple system builds by completing and updating project requirements documentation; understanding project scope; determining project priorities; ensuring efficient and on-time delivery of project tasks and milestones; following proper escalation paths.
• Collaborate closely with the technology team to implement the requirements, provide necessary guidance to testers during QA process.
• Assess business process and system inefficiencies.
• Ability to analyze and synthesize business requirements, including recognizing patterns and conceptualizing processes.
• Participate in standup and planning meeting as part of the Agile methodology framework.

Your profile:

• Experience working on large scale projects as well as handling day-to-day operational requests from the business.
• Familiarity with the general concepts of optimization and performance tuning of SQL statements.
• Familiarity with RDBMS (Oracle, SQL Server).
• Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills.
• Being comfortable working in a distributed teams environment.
• Strong problem solving skills.
• Experience in financial services industry, specifically in Capital Markets and Treasury (nice to have).
• Experience with Big Data and NoSQL databases (Hadoop/HBase/Spark) and Spark SQL is a bonus.

Let’s meet!
Do you like our common project?
Apply here and join our team!

Our Advantages
• A tailored CARE policy deployed by our HR teams for our employees.
• Our Diversity Charter.