Databricks/Snowflake/Python

Capgemini • Montreal, QC

19h • CA$80,000 - CA$100,000 • Onsite

About The Position

The team develops applications to provide services for Wes Regulatory Reporting groups to report and file important disclosures to regulatory bodies across the globe. These applications include highly flexible and scalable Java services, large scale computational processing of datasets, warehouse reporting, and the Axiom regulatory reporting tool. The technology team practices agile development and uses a multitude of languages including Java, Python, SQL, etc. The team is working on a front-to-back initiative to replatform and renovate key streams of data. It addresses regulatory and audit findings thematically, providing an efficient framework for better control and reporting over time. The objectives of the projects include: Consolidate data sourcing, integration, and verification across Control Functions to ensure consistent, controlled, and auditable outputs. Onboard and configure Axiom solution templates for regulatory reports (e.g., 14A, DFAST, SEC FOCUS, Brazil DLO SPED) including mapping, validation, and deployment support. Analyze platform hygiene and DevOps gaps and define a prioritized remediation plan, standards, CICD, monitoring, and environment controls. Implement and optimize business logic and data transformations using Scala/Spark with testing and performance considerations. Build and maintain Power BI dashboards and KPIs, data quality reconciliations, SLA/operational metrics with reliable refreshes. You will be expected to work as a member of the development team and participate in all aspects of the software development lifecycle with automated testing tools and shared libraries development. The ideal candidate will possess solid technical and problem-solving skills, as well as the drive to learn more about the business and new technologies. Candidate should be open to work from front to back on applications and must have a sound grasp of development best practices and system architecture. You will be expected to drive standardization and architecture discussion across the team and be responsible for high-quality implementations. Expertise in any one of the following business domain would be preferable: Regulatory, Accounting, Finance, and Control Functions. This position requires working closely with the local/global project manager, colleagues, and internal clients within Finance. The candidate will be involved in all stages of the development life cycle from requirements gathering to post-release and ongoing L3 support as escalation point.

Requirements

• Experience with Azure cloud technologies such as Databricks
• Database experience such as SQL RDBMS platform like Snowflake DB preferred Postgres
• Python Scripting
• Software development experience in Java/Scala
• Experience incorporating AI-assisted development tools (e.g., GitHub Copilot, Claude) with an engineering approach
• Bachelors or related field experience

Nice To Haves

• Regulatory Reporting tool Axiom or Suade
• Experience with PowerBI
• Knowledge of Unix commands/shell scripting
• Knowledge of Job Automation/Scheduling concept with Autosys or Apache Airflow
• Knowledge of CICD methodology
• Experience working in an agile team with focus on continued integration and automated testing
• Practical experience delivering AI-enabled usecases not just experimental

Responsibilities

• Consolidate data sourcing, integration, and verification across Control Functions to ensure consistent, controlled, and auditable outputs.
• Onboard and configure Axiom solution templates for regulatory reports (e.g., 14A, DFAST, SEC FOCUS, Brazil DLO SPED) including mapping, validation, and deployment support.
• Analyze platform hygiene and DevOps gaps and define a prioritized remediation plan, standards, CICD, monitoring, and environment controls.
• Implement and optimize business logic and data transformations using Scala/Spark with testing and performance considerations.
• Build and maintain Power BI dashboards and KPIs, data quality reconciliations, SLA/operational metrics with reliable refreshes.
• Participate in all aspects of the software development lifecycle with automated testing tools and shared libraries development.
• Drive standardization and architecture discussion across the team and be responsible for high-quality implementations.
• Involved in all stages of the development life cycle from requirements gathering to post-release and ongoing L3 support as escalation point.

Benefits

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level