This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
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 Platforms, automating billing and chargeback processes, and developing insightful dashboards. The ideal candidate will be a technical leader with a strong background in data analytics & visualization, 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 ETL based reporting framework, focusing on data collection, transformation, and presentation
Utilize a robust technology stack including Databricks, 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, MongoDB and Snowflake for flexible data models
Develop and maintain automated job schedules using Autosys, Apache Airflow for seamless data pipeline execution
Ability to develop visualization reporting dashboards
Able to leverage enterprise approved productivity tools like Copilot, etc., in daily analysis & development tasks
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 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 strategic resolution
Participate in code reviews to ensure code quality, best practices, and security standards are met
Requirements
Bachelor's degree in Computer Science, Information Technology, or a related field
8+ years of experience in data engineering, software development, or a similar role, with at least 2 years in a lead capacity
Proven experience with ETL pipeline design and development
Expert proficiency in Python and Spark
Strong experience with advanced scripting
Deep knowledge of relational databases (Oracle) and NoSQL databases (MongoDB), Snowflake
Solid understanding of data modeling, data warehousing, and performance tuning
Experience with CI/CD pipelines and tools (e.g., Jenkins, GitLab CI, GitHub Actions)
Experience with monitoring, logging, and alerting tools (e.g., Prometheus, Grafana, ELK Stack, Splunk, Datadog)
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
Nice to have
Familiarity with Databricks, data visualization tools and dashboard development
Experience with IaC tools (e.g., Terraform, Ansible, CloudFormation)