Senior Python Developer

Celestial Systems Inc.Vancouver, CA
Published on

About Us

At Celestial Systems, we partner with leading enterprises to modernize legacy applications, drive digital innovation, and deliver measurable business value through cutting-edge software services. With deep expertise across cloud, data, and AI, we empower organizations to transform their technology landscapes.

About the Role

We are seeking a Senior Python Developer who will transform stored procedures and database schemas (SQL Server, T-SQL based) into Python and Snowflake based solutions. This role involves optimizing database performance and troubleshooting issues related to data integrity and efficiency. You will collaborate with cross-functional teams to enhance analytics capabilities and improve business decision-making. Ensure best practices in software development, including code reviews, testing, and documentation, while working with large datasets, especially in financial data processing.

About the Candidate

The ideal candidate should be a core development backend engineer with strong Python programming skills and a solid background in SQL Server/database schemas development. An exposure to data lakes, particularly Snowflake, is preferred along with good experience in implementing Snowflake Best Practices. A minimum of 5-7 years of backend programming experience is required, and proficiency in SQL Server and T-SQL for complex queries is essential. Good problem-solving and communication skills are required to interact with both technical and non-technical stakeholders. Familiarity with data visualization tools (like Tableau, PowerBI) and Python libraries (e.g., Pandas, NumPy, Matplotlib, Plotly) is a plus. AWS cloud experience is also advantageous.

Company Culture and Benefits

Join us for a collaborative and dynamic work environment where innovation thrives. We offer a competitive compensation package along with benefits, and we provide growth opportunities in a rapidly evolving industry.