Python & SQL Developer (Data Platform & Automation Expert)

Software Requirements

Required Skills:

• Python (minimum 3.x versions, with experience developing in production environments)
• Shell Scripting (Bash or similar)
• SQL (Sybase or MySQL) with practical experience in query optimization and data manipulation

Preferred Skills:

• Experience with API development and integration
• Familiarity with containerization or automation tools (e.g., Docker, Jenkins)
• Exposure to Agile/Scrum methodologies and tools

Overall Responsibilities

• Develop, test, and deploy front-end and back-end data processing modules and APIs
• Enhance and maintain existing data platforms for scalability, security, and performance
• Integrate multiple application services via messaging platforms and event streaming technologies
• Design and implement unit, integration, and functional tests to ensure software quality and reliability
• Write comprehensive documentation for developed solutions, including technical specifications and user guides
• Collaborate with cross-functional teams to understand data needs and deliver technical solutions aligned with business goals
• Continuously optimize scripts and workflows for performance, maintainability, and resource efficiency

Technical Skills (By Category)

Programming Languages:

• Required: Python; Shell scripting (Bash or similar)
• Preferred: Experience with other scripting languages or additional programming skills (e.g., Java, C)

Databases/Data Management:

• Experience with SQL-based systems, specifically Sybase or MySQL
• Ability to write complex queries, optimize database performance, and manage data formatting and file processing

Cloud Technologies:

• Not explicitly required, but familiarity with cloud environments (e.g., AWS, Azure) is a plus

Frameworks and Libraries:

• Basic understanding of REST API development and consumption in Python
• Familiarity with messaging platforms (e.g., Kafka, RabbitMQ) (preferred)

Development Tools and Methodologies:

• Version control systems (e.g., Git)
• Agile methodologies and collaborative development practices
• Script automation and deployment pipelines

Security & Protocols:

• Awareness of secure coding practices and data privacy fundamentals

Experience Requirements

• 5+ years of professional experience in software development, specifically with Python and SQL in a data or systems environment
• Proven experience in building or maintaining financial or similar enterprise-grade platforms
• Familiarity with scripting for automation, data integration, and system interfacing
• Experience working in Agile teams and environments preferred

Alternative Experience Paths:

Candidates with significant hands-on experience in data platform development using Python and SQL, even outside of direct financial industries, are encouraged to apply. Experience in managing large datasets and integrating multiple data sources is valued.

Day-to-Day Activities

• Develop and enhance data processing scripts and platforms to meet project requirements
• Support the deployment and monitoring of APIs and data workflows
• Collaborate with team members during daily stand-ups, sprint planning, and reviews
• Conduct code reviews, troubleshoot issues, and implement performance improvements
• Document software designs, processes, and technical instructions for ongoing support
• Engage with stakeholders to gather technical requirements and deliver solutions accordingly
• Optimize existing scripts and workflows for efficiency and reliability

Qualifications

Educational Requirements:

• Bachelor’s or Master’s degree in Computer Science, Engineering, Information Technology, or related field

Certifications (Optional but Preferred):

• Relevant certifications in Python programming, API development, or database management

Training & Development:

• Demonstrated commitment to continuous learning in data management, scripting, and software engineering best practices

Professional Competencies

• Strong analytical and problem-solving skills for debugging and optimizing data processes
• Clear communication and presentation skills for articulating technical concepts
• Ability to work effectively within teams and across functions in an Agile environment
• Adaptability to evolving technology landscapes and project priorities
• Attention to detail and a focus on delivering high-quality, maintainable code
• Time management skills with an emphasis on meeting deadlines and managing priorities