3 months ago
Mississauga, CanadaStaff+
Base Salary
$121k - $171k/yr
Responsibilities
- Design, develop, and maintain scalable SQL Server database and data warehouse solutions.
- Build and optimize stored procedures, triggers, user-defined functions, and database queries.
- Monitor and tune database performance by identifying bottlenecks and implementing improvements.
- Develop and maintain ETL pipelines that integrate data from multiple source systems.
- Create logical and physical data models for complex business requirements.
- Partner with application developers, business analysts, and cross-functional stakeholders to deliver database solutions.
- Define and enforce standards for coding, testing, debugging, and implementation.
- Mentor mid-level engineers and analysts, provide technical direction, and allocate work.
- Manage technology delivery from requirements definition through production deployment.
Requirements
- 6+ years of experience in application development, systems analysis, or a closely related data engineering discipline.
- Deep expertise in SQL Server database development, including stored procedures, triggers, user-defined functions, and query optimization.
- Demonstrated ability to design and implement ETL processes for data warehouse environments.
- Proven data modeling experience covering logical and physical design.
- Experience delivering and managing technology projects through production deployment.
- Subject matter expertise in at least one application or database development area.
- Effective written and verbal communication skills with technical and non-technical stakeholders.
- A Master's degree in Computer Science, Information Systems, or a related field is advantageous.
- Experience with large-scale enterprise data warehouses, especially in financial services or regulated environments, is beneficial.
- Familiarity with data integrity frameworks, constraint design, validation rules, governance practices, and enterprise architecture concepts is beneficial.
Benefits
- Hybrid work model with 3 days in the office and 2 days remotely.
- Learning and development resources supporting technical growth and career progression.
- Opportunity to mentor and develop engineers while building leadership capability.
- Wellbeing and financial support programs.
- Exposure to global teams and large-scale systems at a leading financial institution.
- Full-time Vice President-level role.
Tech Stack
Microsoft SQL Server
Categories
Data 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.