Remote MS/Snowflake SQL Developer

Summary

Join our client's high-achieving team as a Senior Developer, focusing on MS SQL and Snowflake development, optimization, and database design. The selected candidate will lead SQL development efforts, enforce coding standards, and work closely with team members to optimize application SQL queries.

Requirements

• 6+ years of professional SQL development experience
• Deep expertise in T-SQL and Microsoft SQL Server
• Proficiency in Snowflake and dbt development
• Working knowledge of HTML and JavaScript
• Experience with Transparent Data Encryption (TDE)
• Strong skills in query performance tuning and optimization
• Excellent communication and problem-solving abilities
• Ability to work both independently and in team settings
• Familiarity with NoSQL databases

Responsibilities

• Lead SQL development efforts, enforcing coding standards and best practices
• Develop and maintain efficient T-SQL code, including stored procedures, functions, triggers, and optimized views
• Analyze and improve existing database structures to enhance performance
• Troubleshoot and resolve database access and performance bottlenecks
• Work closely with team members to optimize application SQL queries
• Design and implement database schemas aligned with application requirements
• Orchestrate data migrations across different systems
• Create robust scripts for data manipulation, ETL processes, and reporting
• Develop and implement database security protocols and optimization strategies

Preferred Qualifications

• Experience with SQL Server Reporting Services, Power BI, SSAS, and SSIS
• Knowledge of web application development
• Understanding of Data Analysis Expressions (DAX)
• Familiarity with Azure SQL, Redgate, and advanced analytics tools