Lead Python and Database Developer

Python and Database Developer We are seeking a skilled and motivated Python and Database Developer to join our dynamic technology team. The ideal candidate will possess strong programming skills in Python, a solid understanding of database systems, and the ability to design, develop, and maintain efficient and scalable applications. Responsibilities Participate in design and development of data pipelines for ingestion, transformation, and loading of data from various sources into our data warehouse/lake, ensuring seamless data flow and accessibility. Develop data models that support business requirements and analytical needs. Optimize data models for query performance and data accessibility. Write optimized and maintainable SQL queries and leverage SQL Alchemy for efficient database interaction, ensuring high performance and data accuracy. Implement robust data quality checks and monitoring systems to ensure data integrity and accuracy, proactively identifying and resolving data issues. Contribute to the design and implementation of data governance policies and procedures, ensuring compliance with regulatory requirements and internal standards. Continuously research and implement new technologies and best practices to improve the efficiency, scalability, and resilience of our data platform. Take ownership of the deployment and monitoring of data pipelines and related infrastructure on cloud platforms such as OpenShift, ECS, or Kubernetes, ensuring optimal performance and reliability. Occasionally work non-standard shifts, including nights and/or weekends, and/or have on-call responsibilities to support critical data operations. Required Skills and Qualifications 6+ years of hands‑on experience in a Data Engineering role. Ability to conceptualize, develop, and lead the execution of strategic AI initiatives that align with key business objectives and drive measurable value. Experience with data visualization tools and techniques for presenting data insights effectively. Familiarity with agile development methodologies and experience working in agile teams. Strong proficiency in Python (version 3.6+), with experience in Python packaging and shared libraries such as Pandas and NumPy. Experience implementing REST APIs in Python using microframeworks like Flask. Extensive experience working with relational databases and NoSQL databases. Hands‑on skills in writing complex SQL and optimizing queries for performance. Experience with workflow management tools like Airflow (experience with PySpark or PyFlink is a major plus). Solid understanding of data warehousing concepts and experience working with large datasets, including data modeling and ETL processes. Experience working in a Continuous Integration and Continuous Delivery environment and familiarity with tools such as Jenkins, TeamCity, SonarQube, OpenShift, ECS, or Kubernetes. Proficient in industry‑standard best practices such as design patterns, coding standards, coding modularity, and prototyping. Design, develop, and maintain database schemas and models. Write and optimize SQL queries for data retrieval, manipulation, and reporting. Communicate technical concepts and solutions effectively to both technical and non‑technical audiences. Provide technical support and troubleshooting for production systems. Stay up to date with the latest trends and technologies in Python development, database systems, and data engineering. Evaluate and recommend new tools and technologies to improve development efficiency and product quality. Contribute to the continuous improvement of development processes and practices. Guide and mentor junior developers, fostering a collaborative team environment and promoting professional growth. Strong communication skills, both written and verbal, with the ability to explain complex technical concepts to both technical and non‑technical audiences. Education Bachelor's degree in computer science, software engineering, or a related field. #J-18808-Ljbffr Citigroup Inc.