The Sr. SQL Developer will collaborate with BI Developers, Data Architects and Data Engineering teams to build, maintain and optimize large scale SQL based solutions in our Snowflake Data Warehouse. Solid experience designing and developing high performance queries is required. The right candidate will need to have professional knowledge of developing writing SQL queries in Snowflake.
- Design, develop and maintenance of high-performance Snowflake SQL and Data Warehouse certified queries
- Design, develop and maintain complex query logic and Snowflake implementations such as virtual warehouses, semantic layers, etc.
- Participate in various requirements sessions with internal and external partners and convert business / functional requirements into technical solutions, along with supporting materials such as use cases, designs, flowcharts, models, specifications, and reports
- Provide technical support to requirements, development, testing, and training teams
- Work directly with project management, Business Intelligence and Data Engineering to develop end-user training and reference materials
- Collaborate with the BI Analysts to ensure data integrity and optimize custom queries develop for BI Insights and Reporting and support formulating queries and understanding the data contained in the data warehouse
- Follow the corporate data compliance guidelines, as well as adhere to industry regulations (CCPA, COPPA, GDPR, LGPD, etc.)
- Draft standards and procedures affecting data analysis and process modeling, as well as database design, maintenance, and management
- Support database initiatives related to security, capacity, scalability, performance, platform upgrades, service agreements, and disaster recovery
- Conduct performance tuning reviews for improvements and prepare written reports of findings, including recommendations and cost justification analysis
