1 day ago
Mississauga, CanadaMid Level
Base Salary
$79k - $111k/yr
Responsibilities
- Identify and implement system enhancements using script tools and code analysis.
- Write, maintain, debug, and optimize production-grade shell scripts for automation, data processing, file handling, and system operations.
- Build, support, troubleshoot, and validate ETL pipelines and financial data workflows.
- Write and optimize SQL queries across large financial datasets and support relational database operations.
- Configure and support enterprise job scheduling, dependencies, calendars, and failure alerting.
- Analyze applications for vulnerabilities and security issues and conduct testing and debugging.
- Consult with users, clients, developers, data engineers, business analysts, and other technology groups to recommend programming solutions.
- Resolve production issues involving scripts, data pipelines, and job scheduling configurations.
- Serve as an advisor, coach, and subject matter resource for junior analysts and other team members.
- Assess operational risk, support compliance with applicable laws and policies, and protect Citi, client, and firm assets.
Requirements
- At least 2 years of relevant Financial Services industry experience, including at least 2 years in hands-on application development or scripting/automation.
- Expert proficiency in Shell scripting, including Bash, Ksh, or Sh, in Unix/Linux environments.
- Strong SQL skills, including complex query development, debugging, optimization, joins, aggregations, filtering, and data validation.
- Hands-on experience with Oracle, SQL Server, MySQL, or PostgreSQL, including schemas, indexing, and query performance optimization.
- Experience building and supporting ETL pipelines and data workflows using shell-based scripting and related automation tools.
- Proficiency in Python for data manipulation, file parsing, and automation; JSON parsing and processing is a strong plus.
- Experience with Autosys or Control-M for enterprise job scheduling, including dependencies, calendars, and failure alerting.
- Fluency in Unix/Linux system environments, including file systems, process management, permissions, cron jobs, and environment variables.
- Experience parsing, transforming, and validating CSV, JSON, and XML using awk, sed, grep, and cut.
- Solid debugging and troubleshooting skills across shell scripts, data pipelines, and job scheduling configurations.
- Experience using Git for scripts, configuration files, and automation code.
- Basic understanding of capital markets, trade life cycles, financial data flows, reconciliation, and data controls; Financial Services experience is preferred.
- Clear written and verbal communication, problem-solving, decision-making, deadline management, and ability to work under pressure.
- Bachelor’s degree or university degree, or equivalent experience.
Benefits
- Full-time position.
- Primary location salary range is $79,320.00–$110,680.00.
- Opportunity to work on technology supporting Citi’s global financial operations and to advise and coach junior analysts.
Tech Stack
Categories
BackendData Engineering
About Citi
Citi is a public financial-services company offering consumer and institutional banking, credit cards, wealth management, treasury and trade solutions, and capital-markets services. It serves individuals, corporations, financial institutions, and governments in more than 160 countries and jurisdictions, earning interest and fee income from lending, payments, trading, and advisory. Founded in 1812 and headquartered in New York, it trades on the NYSE under the ticker C.