Senior Business Analyst (Capital Markets Risk) – SQL & Data Mapping

Senior Business Analyst (Capital Markets / Risk) SQL & Data Mapping

Strategic hybrid role in Toronto for a seasoned Business Analyst with deep expertise in financial risk and capital markets. Requires strong SQL data mapping and experience in Agile environments. Leverage tools like Azure Synapse and OpenAI while bridging business and technical domains in the insurance industry.

What is in it for you :

Salaried : $45-53 per hour.

Incorporated Business Rate : $55-63 per hour.

9-month contract.

Full-time position : 37.50 hours per week.

Weekday schedule from 9 am to 5 pm.

In-office presence required from Tuesday to Thursday.

Remote work available on Mondays and Fridays.

Responsibilities :

Develop and maintain detailed data mapping and data flow diagrams to support financial risk and capital markets initiatives.

Translate complex business requirements into actionable technical specifications and business requirement documents.

Collaborate closely with Agile squads to deliver high-impact solutions in a dynamic environment.

Perform advanced SQL queries for data extraction transformation and analysis.

Create source-to-target mappings for data integration across systems.

Utilize Azure Synapse and Azure OpenAI for scalable data analytics and reporting.

What you will need to succeed :

Bachelors degree in Information Technology Finance Computer Science Business Administration or a related field.

Masters degree in a relevant discipline (nice to have).

Certifications in Agile methodologies financial risk or data analytics tools (nice to have).

5 years of experience as a Senior IT Business Analyst in Financial Services Risk Management or Capital Markets.

Strong understanding of financial risk metrics and regulatory frameworks.

Advanced proficiency in SQL data mapping and data flow documentation.

Experience working in Agile delivery models.

Proficiency with Azure Synapse and Azure OpenAI platforms.

Demonstrated ability to produce high-quality business requirement documents.

Excellent analytical problem-solving and communication skills.

Experience with additional cloud platforms data visualization tools or regulatory reporting systems (nice to have).

Technical expertise in Azure Databricks PySpark and Python (nice to have).

Why Recruit Action

Recruit Action (agency permit : AP-2000003) provides recruitment services through quality support and a personalized approach to job seekers and businesses. Only candidates who match hiring criteria will be contacted.

# MFCJP

Required Skills :

Cloud Security Architect Drive AWS cloud security strategy in the insurance industry with a senior-level role focused on secure architecture compliance and automation. Leverage your expertise in AWS services threat detection and identity management in a hybrid multi-account environment. Opportunity to lead security-by-design in a regulated sector. What is in it for you : Salaried : $90-95 per hour. Incorporated Business Rate : $104-109 per hour. 12-month contract with the potential for permanent employment. Full-time position : 37.50 hours per week. Hybrid model 3 days per week on-site. Attendance on Tuesday and Wednesday is mandatory. Responsibilities : Design and implement secure landing zones using AWS Control Tower AWS Organizations and Service Control Policies (SCPs). Define multi-account security guardrails for shared services workloads and sandbox environments. Create reference architectures covering security zones network segmentation and cross-account communication (PrivateLink AWS WAN). Lead threat modelling and risk assessments for new workloads and services including Lambda ECS EC2 S3 RDS and DynamoDB. Develop security-by-design templates integrated into Infrastructure as Code (IaC) pipelines. Partner with compliance teams to maintain continuous alignment with CIS Benchmarks and organizational risk frameworks. Implement federated access and single sign-on with AWS IAM Identity Center (AWS SSO) Okta and Azure AD. Manage cross-account roles STS trust policies and temporary credentials for developers and third parties. Automate secret and credential rotation with AWS Secrets Manager and AWS Systems Manager Parameter Store. Enforce encryption at rest using AWS KMS CloudHSM and envelope encryption patterns. Ensure encryption in transit (TLS 1.2 / 1.3) across internal and public endpoints. Manage key rotation cross-region replication and HSM-based root of trust. Implement S3 Object Lock Macie for data discovery and classification and Access Points for fine-grained data access. Implement PrivateLink AWS WAN and Route 53 Resolver endpoints for service-to-service isolation. Configure Web Application Firewall (WAF) and AWS Shield Advanced for DDoS mitigation. Enforce egress control through Cloud NAT AWS Gateway Load Balancer (GWLB) or custom proxies. Deploy and integrate AWS Security Hub GuardDuty Macie and Inspector for proactive threat detection. Configure Amazon Detective for forensic investigation and anomaly correlation. Integrate findings into SIEM / SOAR platforms such as FortiSOAR or Azure Sentinel. Automate response playbooks with AWS Step Functions Lambda and SNS alerts. Implement AWS Config rules and Conformance Packs to enforce compliance with benchmarks like CIS AWS Foundations. Use AWS Artifact for vendor assurance and control documentation. Manage compliance dashboards via Security Hub Trusted Advisor and Control Tower drift detection. What you will need to succeed : Bachelors degree in Computer Science Information Security or related field. AWS Certified Security Specialty. AWS Certified Solutions Architect Professional. CISSP CISM CCSP GCSA or GIAC Cloud Security Automation certification. 8 years of experience in cybersecurity. 4 years of experience in AWS cloud security architecture. Deep understanding of the AWS Well-Architected Framework (Security Pillar). Strong hands-on expertise in AWS identity and access management encryption network segmentation and compliance. Familiarity with AWS security services including GuardDuty Inspector Security Hub and Macie. Experience automating security controls using AWS native tools and IaC pipelines. Proficiency in incident response using Step Functions Lambda and Systems Manager. Experience integrating with SIEM / SOAR platforms such as FortiSOAR or Azure Sentinel. Why Recruit Action Recruit Action (agency permit : AP-2504511) provides recruitment services through quality support and a personalized approach to job seekers and businesses. Only candidates who match hiring criteria will be contacted. # AVICJP

Key Skills

Cyber Security,Business Administration,LTE,Content Management,Archicad

Employment Type : Full Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 45 - 53