SQL Developer

The Kendall Group - Conshohocken, PA

Full-time - Mid Level

Conshohocken, PA

51-100 employees

Merchant Wholesalers, Durable Goods

About the position

The SQL Developer at The Kendall Group is a vital member of the Data and Analytics team, responsible for developing, optimizing, and ensuring the stability of SQL data, jobs, and scripts. This role involves interpreting business requirements, designing and implementing database solutions, and collaborating with various stakeholders to enhance data management and reporting capabilities. The position offers opportunities for professional growth within a supportive employee-owned company.

Responsibilities

• Interpret business requirements to design, develop & test processes that ensure high quality data & optimal system performance
• Independently research & make recommendations for improvements to enhance methodology, capability, ease-of-use & efficiency
• Assist & provide support to Enterprise architecture design & roadmap
• Design and implement database solution to store and organize data efficiently
• Collaborate with peers and work on multiple projects in an agile environment
• Develop a good working relationship with a wide range of stakeholders to support the design & implementation of new solutions that leverage SQL Server objects
• Plan and coordinate migration of legacy SQL Server data objects
• Make modifications & enhancements to existing queries and applications for error correction, breaking changes (updates) and to improve overall function & performance
• Document new and existing data warehouse resources and architecture
• Perform data analysis to identify trends, patterns and insights to inform business decisions
• Oversee SQL Server monitoring & scheduling
• Manage SQL backup and retention jobs and procedures
• Other duties as assigned

Requirements

• 4 years' experience with Microsoft SQL Server 2016 or later
• Bachelor's Degree in Computer Science (or related field) or equivalent experience
• Proficiency in Visual Studio, SQL Server Installation and configuration tools, SSMS, Microsoft Office applications (particularly Excel)
• Strong understanding of CRUD operations, collaborative source code management system, SSIS and SSAS project experience
• Strong understanding of database design principles, normalization and data modeling
• Very detail oriented, organized, ability to work independently as well as collaboratively in a team environment
• Excellent analytical and problem-solving skills
• Strong verbal and written communication skills; ability to present information in a manner that non-technical staff can understand

Nice-to-haves

• 4+ years of experience with Microsoft SQL 2019
• Database Administrative role experience
• SSAS Tabular and Multidimensional data model experience
• Experience integrating with CRM, PIM, ERP, Google Analytics, Active Directory, Microsoft Graph API, custom Web API integration and development
• SSIS Zappysys and/or Kingswaysoft SSIS component experience
• Microsoft Azure migration and maintenance
• NoSQL non-relational database experience
• Machine Learning methods
• SSRS reporting
• Epicor Eclipse ERP Knowledge
• Powershell Experience
• Linux/Unix based systems with Universe BASIC/UNIBASIC/Pick Basic experience
• Rocket U2 Database knowledge
• HTML, CSS, Javascript
• Microsoft certified, Azure Data Engineer Associate

Benefits

• Employee ownership model
• Opportunities for learning and growth
• Coaching and mentoring
• Supportive work environment
• Long tenure of employees