Engineering Lead Analyst, Citi

Citi

Location:
Canada, Mississauga

Category:
IT - Software Development

Contract Type:
Employment contract

Salary:

120800.00 - 170800.00 USD / Year

Save Job

Apply Position

Job Description:

CITI Bank Enterprise Analytical Services organization is seeking a highly skilled and experienced Lead Developer for the Reporting Framework. This critical framework is essential for collecting and analyzing utilization metrics from our Analytical Services Platform, automating billing and chargeback processes, and developing insightful dashboards. The ideal candidate will be a technical leader with a strong background in big data technologies, ETL design, and performance optimization. As the Lead Developer, you will be a key driver of the reporting framework's success, responsible for its design, development, and maintenance. You will play a pivotal role in shaping our data reporting capabilities and providing crucial business intelligence to stakeholders.

Job Responsibility:

Design, develop, and implement a ETL based reporting framework, focusing on data collection, transformation, and presentation
Utilize a robust technology stack including Spark, Hive, Ozone, and Hadoop to process large volumes of data efficiently
Write and optimize complex ETL jobs using PySpark and advanced Python scripting
Design and manage data storage in various databases, including Oracle for structured data and MongoDB for flexible data models
Develop and maintain automated job schedules using Autosys for seamless data pipeline execution
Hands-on experience on developing reporting dashboards using enterprise BI products
Act as the technical subject matter expert (SME) for the reporting framework, providing guidance and mentorship to the development team
Lead requirements gathering discussions with business stakeholders and product owners to understand reporting needs and translate them into technical solutions
Coordinate closely with the QA team to ensure thorough testing and data validation, maintaining high standards of data accuracy and integrity
Collaborate with other development teams and data engineers to ensure data sources are integrated correctly and efficiently
Design the framework with an 'ETL design mindset,' focusing on modularity, scalability, and maintainability
Proactively identify and resolve performance bottlenecks in data pipelines and queries
Ensure the framework's code is optimized for high performance and low latency
Apply advanced Unix scripting for automation, system administration, and data management tasks
Timely analyze and resolve user issues and incidents related to the reporting framework as a development SME
Conduct root cause analysis for production issues and implement long-term fixes
Participate in code reviews to ensure code quality, best practices, and security standards are met

Requirements:

10+ years of experience in data engineering, software development, or a similar role, with at least 2 years in a lead capacity
Extensive experience with big data technologies such as Spark, Hive, Hadoop, and Ozone
Proven experience with ETL pipeline design and development
Hands-on experience with scheduling tools like Autosys
Expert proficiency in Python and PySpark
Strong experience with advanced Unix scripting
Deep knowledge of relational databases (Oracle) and NoSQL databases (MongoDB)
Solid understanding of data modeling, data warehousing, and performance tuning
Excellent problem-solving and analytical skills, with a keen eye for detail
Strong communication and leadership skills, with the ability to manage and mentor a team
Proactive and self-driven, with a strong commitment to delivering high-quality, reliable solutions
Ability to thrive in a fast-paced, collaborative, and results-oriented environment
Bachelor's degree/University degree or equivalent experience

Nice to have:

Familiarity with data visualization tools and dashboard development is a plus
Master's degree preferred

What we offer:

Opportunity to grow your career
Give back to your community
Make a real impact
Global benefits designed to support well-being, growth and work-life balance

Additional Information:

Job Posted:
September 24, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

Engineering Lead Analyst