Python/Transact SQL Software Engineer

Key responsibilities

• Developing, testing, and maintaining applications using Python.
• Designing, optimizing, and maintaining complex T-SQL queries, stored procedures, and functions.
• Collaborating with cross-functional teams (e.g., data scientists, analysts, front-end developers) to define requirements and deliver solutions.
• Performing data extraction, transformation, and loading (ETL) processes.
• Troubleshooting application and database performance issues and ensuring data integrity and security.
• Developing scripts for task automation and system integration.
• Creating and maintaining technical documentation and specifications.

Required Skills & Qualifications

• Proficiency in Python: Strong command of Python programming for backend development, data processing, and automation.
• Strong SQL/T-SQL Expertise: Experience with writing and optimizing complex queries, joins, CTEs, views, and stored procedures.
• Database Knowledge: In-depth knowledge of relational databases (e.g., Microsoft SQL Server) and data modeling principles.
• Problem-Solving Abilities: Strong analytical and problem-solving skills to diagnose and resolve software and data issues.
• Relevant Tools: ETL Tools (Navicat), Git, PyCharm or similar IDE.