You will be responsible for designing, developing, and maintaining scalable, high-performance database solutions to support business and operational needs. This includes writing and optimizing SQL, PL/SQL, and Python code, managing Snowflake-based data environments, and ensuring database performance, reliability, and security. Your role will involve collaborating with cross-functional teams to translate business requirements into technical solutions. Familiarity with modern AI-assisted development tools such as Cursor and GitHub Copilot is expected to enhance coding efficiency and overall development quality. Additionally, you will contribute to documentation, automation, and continuous improvement of database systems. **Key Responsibilities:**
**Database Design and Development:**
Design, develop, and optimize scalable SQL and Python scripts, PL/SQL programs, and database solutions. - Create and manage Snowflake-based database solutions for high performance and reliability. - **AI-Assisted Development:**
Utilize modern AI tools like Cursor and GitHub Co-pilot for efficient coding and debugging. - Stay updated on emerging AI-driven technologies to enhance development efficiency. - **Performance Optimization:**
Identify and optimize database performance bottlenecks for improved execution time. - Debug and troubleshoot performance issues across Snowflake and SQL servers. - **Coding and Code Reviews:**
Write, review, and maintain high-quality, clean, and efficient SQL/PL-SQL & Python code. - Conduct in-depth code reviews with team members to ensure adherence to best practices. - **Data Management and Collaboration:**
Collect requirements, understand business objectives, and translate them into technical solutions. - Ensure data integrity and security while complying with regulatory requirements. **Qualifications Required:**
4+ years in SQL engineering role. - Demonstrable experience with Python. - Solid understanding of database architecture, design, and security best practices. - Prior experience with high-performance database systems in financial services or related industries is desirable. - Familiarity with AWS cloud services. The company, Allvue Systems, is committed to providing equal employment opportunities for all employees and applicants. They value diversity and inclusivity, celebrating and supporting differences in backgrounds, experiences, and perspectives. Allvue Systems prohibits discrimination and harassment based on various factors and provides reasonable accommodations for individuals with disabilities. You will be responsible for designing, developing, and maintaining scalable, high-performance database solutions to support business and operational needs. This includes writing and optimizing SQL, PL/SQL, and Python code, managing Snowflake-based data environments, and ensuring database performance, reliability, and security. Your role will involve collaborating with cross-functional teams to translate business requirements into technical solutions. Familiarity with modern AI-assisted development tools such as Cursor and GitHub Copilot is expected to enhance coding efficiency and overall development quality. Additionally, you will contribute to documentation, automation, and continuous improvement of database systems. **Key Responsibilities:**
**Database Design and Development:**
Design, develop, and optimize scalable SQL and Python scripts, PL/SQL programs, and database solutions. - Create and manage Snowflake-based database solutions for high performance and reliability. - **AI-Assisted Development:**
Utilize modern AI tools like Cursor and GitHub Co-pilot for efficient coding and debugging. - Stay updated on emerging AI-driven technologies to enhance development efficiency. - **Performance Optimization:**
Identify and optimize database performance bottlenecks for improved execution time. - Debug and troubleshoot performance issues across Snowflake and SQL servers. - **Coding and Code Reviews:**
Write, review, and maintain high-quality, clean, and efficient SQL/PL-SQL & Python code. - Conduct in-depth code reviews with team members to ensure adherence to best practices. - **Data Management and Collaboration:**
Collect requirements, understand business objectives, and translate them into technical solutions. - Ensure data integrity and security while complying with regulatory requirements. **Qualifications Required:**
4+ years in SQL engineering role. - Demonstrable experience with Python. - Solid understanding of database architecture, design, and security best practices. - Prior experience with high-performance database systems in financial services or related industries is desirable. - Familiarity with AWS cloud services. The company, Allvue Systems, is committed to providing equal employment opportunities for all employees and applicants. They value diversity and inclusivity, celebrating and supporting differences i