The ideal experience includes a solid mix of the following skills:
- Intermediate to strong understanding of the MS SQL Server environment (5+ years of experience)
- Solid T-SQL skills
- Ability to create complex functions, scripts, stored procedures and triggers to support application development.
- Experience with aggregating large data sets, specifically within a data warehouse environment.
- Intermediate to strong understanding of execution plans and plan caching.
- Strong critical thinking and problem solving skills, including a proactive disposition towards identifying problems and providing solutions.
- Familiar with report development paradigms.
- Ability to complete development projects on time without day to day oversight of the task by the project leads.
- Must be able to review and optimize large pieces of SQL code.
- Must be able to work well within a skilled development team. Able to provide and receive peer review.
- Familiar with MS SQL best practices involved with OLTP and data warehouse (OLAP) environments.
- SSAS and PowerBI experience is a bonus.
- Experience with predictive analytics development using Python or R in SQL Server is a bonus.
- Microsoft SQL Server (2005-2019)
- Microsoft SQL Server Integrated Services (SSIS)
- Microsoft SQL Server Analysis Services (SSAS)
- SSMS/Visual Studio/SSDT (any versions)
- Redgate toolset (SQLPrompt, SQLSearch, SQL Source Control, etc.)
- EXCELLENT communication skills