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.
Responsibilities:

• Full-Lifecycle Development:

• 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.

• Technical Leadership & Collaboration:

• 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.

• Performance & Optimization:

• 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.

• Issue Resolution & Support:

• 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.

Qualifications:

• Experience:

• 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.

• Technical Skills:

• 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.
• Familiarity with data visualization tools and dashboard development is a plus.

• Soft Skills:

• 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.

Education:

• Bachelor's degree/University degree or equivalent experience
• Master's degree preferred

Job Family Group: Technology
Job Family: Systems & Engineering
Time Type: Full time
Primary Location Full Time Salary Range: $120,800.00 - $170,800.00
Most Relevant Skills Please see the requirements listed above.
Other Relevant Skills For complementary skills, please see above and/or contact the recruiter.
Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.
If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review .
View Citi's and the poster.

Skills Required