SQL Developer - Job at The Kendall Group in Conshohocken, PA

SQL Developer

Conshohocken, PA

Posted 6 days ago

Email Job

Job Description

Position: SQL Developer

Location:

Conshohocken, PA

Job Id: 1989

# of Openings: 1

SQL Developer

About The Kendall Group

The Kendall Group, seeks a talented, creative, self-motivated individual for our SQL Developer position. The Kendall Group is comprised of seven divisions with 75+ locations in eleven states. Combined, we serve the Electrical, Automation, Pipe, Valve, and Fittings products, Steam, Lighting, Industrial Controls, and Instrumentation Industries. The Kendall Group is a 100% employee-owned company. Kendall offers a great opportunity for a rewarding career.

Why The Kendall Group?

Our employee ownership model is the core of who we are. You will not only own part of the company, but you will own your future. At Kendall, you'll have opportunities to learn and grow while being coached and mentored along the way. We're that company where people stay! We're proud to say that more than 60% of our associates have more than 5 years of tenure, and more than 40% have greater than 10 years. At Kendall, you will be valued and supported, your ideas will be heard, your voice will matter, and you'll work alongside incredible people who care about your success.

Role Summary:

Reporting to the Manager of Data and Analytics, the SQL Developer is a key member of the Data and Analytics team. The person in this role will be required to develop, optimize, and ensure the stability of new & legacy SQL data, jobs & scripts. This role will also be required to assist in developing SQL solutions designed to integrate on-premise and web hosted environments to provide analytics and reporting for the organization and create a connected enterprise.

Exciting work you will do:

The essential duties and responsibilities of the SQL Developer will consist of, but are not limited to, the following:

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

Competencies you possess:

Teamwork and collaboration
Service Excellence
Displaying Technical Expertise
Creativity
Decision Quality
Accountability and responsibility
Results, Action Oriented

What you'll need:

Work Experience: 4 years' experience with Microsoft SQL Server 2016 or later
Education: Bachelor's Degree in Computer Science (or related field) or equivalent experience

Analytics/Computer Skills: Visual Studio, SQL Server Installation and configuration tools, SSMS, Microsoft Office application proficiency (Particularly Excel) , understanding of CRUD operations ,Collaborative source code management system, SSIS and SSAS project experience; strong understanding of database design principles, normalization and data modeling

Organization Skills: ; excellent analytical and problem-solving skills
Cross-functional skills: Ability to work well collaboratively with the entire organization; flexible with change of demands and priorities
Communication Skills: Strong verbal and written communication skills; ability to present information in a manner that non-technical staff can understand
Physical, Mental and Visual Skills: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disability to perform the essential functions.
- Ability to see, talk and hear
- Ability to sit for 8 hours a day
Physical Environment: Normal office environment
Travel: Must be willing to work occasional weekends or off hours and willing to travel if necessary; minimal overnight

Skills we prefer but don't require:

Experience:
- 4+ years of experience with Microsoft SQL 2019
- Database Administrative role experience
- SSAS Tabular and Multidimensional data model experience
- Experience integrating with any or all of the following: 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
Education/Certifications: Microsoft certified, Azure Data Engineer Associate

The Kendall Group is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, gender, gender identity, sexual orientation, age, physical or mental disability, citizenship, military status, protected veteran status, genetic information, or any other characteristic protected under applicable federal, state, or local law.

Apply for this Position

Job Summary

Company

The Kendall Group

Start Date

As soon as possible

Employment Term and Type

Regular, Full Time

Required Education

Bachelor's Degree

Required Experience

4+ years