SQL Server Developer at Kelly Mitchell
New Albany, OH Job Detail - KellyMitchell
About the Job
SQL Server Developer
New Albany, OH | IT
Job ID: 101725
Listed on 10/27/2020
KellyMitchell matches the best IT and business talent with premier organizations nationwide. Our clients, ranging from Fortune 500 corporations to rapidly growing high-tech companies, are exceptionally served by our 1500+ IT and business consultants. Our industry is growing rapidly, and now is a great time to launch your career with the KellyMitchell team.
SQL Server Developer
Job Summary
- Design and develop database schema based on data modeling of business requirements and entities
- Write advanced/complex and optimized queries to support analytical applications
- Build multidimensional cubes and/or tabular models for analytical data warehouse
- Develop ETL data flow processes and frameworks including data extraction from source systems to staging, relational, and dimensional databases
- Optimize processes involving large data sets to improve performance
Desired Skills/ Experience
- 5+ years MS SQL Server development experience required
- High level of proficiency with T-SQL syntax, Stored Procedures, Views, UDFs and triggers
- Query Tuning/Optimization, using native monitoring and troubleshooting tools
- Minimum of 5 years of hands-on experience on Microsoft BI stack (SSAS and SSIS)
- Experience in creating Multidimensional cubes and Tabular models using SSAS
- Experience in creating SSIS packages to perform ETL functionalities
- Deep understanding of SQL Server product suite and architecture
- Have strong data warehouse and data mart knowledge and concepts
- SQL server reporting services (SSRS)
- Experience working with cloud databases and architectures such as Snowflake, AWS or Azure
- Experience working in an Agile environment
- Code versioning tools such as Git
*mjp123