Data and Analytics Developer

The Kendall Group; Seven Stars (PA); On-site; USD 80,000 - 120,000; Full time

Job summary

The Kendall Group is seeking a Data and Analytics Developer to design and implement SQL-based analytics solutions that bridge on-premise and web-hosted environments for reporting. You will support end-users, develop data pipelines, and help expand the technology stack.

You will work with cross-functional teams, leverage SQL Server, Python, and BI tools to deliver insightful analytics while documenting projects and improving data quality.

Qualifications

• Bachelor's degree in computer science or related field.
• Experience with Microsoft SQL Server 2016 or later.
• Proficiency in data visualization tools such as Tableau/Power BI and programming languages like Python/Java/Scala.

Responsibilities

• Develop SQL solutions to integrate on-premise and web-hosted environments for analytics and reporting.
• Support end-users and provide front-end reporting assistance.
• Research and test new technologies to expand the company's technology stack.
• Document data warehouse projects and data pipelines.

Skills

Cross-functional collaboration

Problem Solving

Communication Skills

Teamwork

Attention to detail

Education

Bachelor's degree in computer science

Tools

Microsoft SQL Server 2016+

Visual Studio

SQL Server SSMS

Tableau

Power BI

Python

Java

Scala

Azure

Job description

The Kendall Group is comprised of eight divisions with 75+ locations in ten states. Combined, we serve the Electrical, Automation, Pipe, Valve, and Fitting 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 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 Data and Analytics Developer is a key member of the Data and Analytics team. The person in this role will support end-users and assist in developing SQL solutions designed to integrate on-premise and web hosted environments to provide analytics/reporting for the organization. This role will also require research and testing of new technologies to expand the company technology stack and help create a connected enterprise.

About The Kendall Group

The Kendall Group is comprised of eight divisions with 75+ locations in ten states. Combined, we serve the Electrical, Automation, Pipe, Valve, and Fitting 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 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 Data and Analytics Developer is a key member of the Data and Analytics team. The person in this role will support end-users and assist in developing SQL solutions designed to integrate on-premise and web hosted environments to provide analytics/reporting for the organization. This role will also require research and testing of new technologies to expand the company technology stack and help create a connected enterprise.

Exciting work you will do:

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

• Develop a good working relationship with a wide range of stakeholders to support the design and implementation of new solutions that leverage SQL Server objects.
• Collaborate with peers and work on multiple projects in an agile environment.
• Independently research improvements, including but not limited to new technologies and methodologies, to improve existing architecture and expand technical capabilities.
• Provide front-end support to internal customers for reporting data and access issues.
• Assist in making modifications and enhancements to existing applications, reports, dashboards, and database objects to improve overall function and performance.
• Assist and provide support to enterprise architecture design and roadmap.
• Communicate with internal customers to adjust and validate report data.
• Develop and maintain data pipelines and processes to extract, transform, and load data from multiple sources into the data warehouse.
• Participate in QA testing procedures to ensure database integrity.
• Document new and existing data warehouse projects and resources.
• Other duties as assigned.

Competencies you possess:

• Problem Solving
• Teamwork and Collaboration
• Service Excellence
• Displaying Technical Expertise
• Creativity
• Accountability and Responsibility
• Results, Action Oriented

What you'll need:

• Work Experience: Experience with Microsoft SQL Server 2016 or later.
• Education: Bachelor's degree in computer science (or related field) or equivalent experience.
• Analytics/Computer Skills: Microsoft Office proficiency (particularly Excel); Visual Studio; SQL Server SSMS; understanding of CRUD operations; proficiency in programming languages such as Python, Java, or Scala; proficiency in data visualization tools such as Tableau, Power BI, or similar.
• Cross-functional skills: Ability to work collaboratively across the organization; flexible with changing demands and priorities.
• Organization Skills: Very detail oriented, organized, and effective in team environments with mixed skill sets.
• Communication Skills: Strong verbal and written communication skills; ability to explain technical information to non-technical staff.
• 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 travel if necessary.

Skills we prefer but don't require:

• Experience:
  • Machine learning methods
  • Experience with Microsoft SQL 2019
  • Microsoft Azure migration and maintenance
  • Integration with CRM, PIM, ERP, Google Analytics, Active Directory, Microsoft Graph API, custom Web API development
  • Epicor Eclipse ERP knowledge
  • NoSQL non-relational database experience
  • PowerShell
  • SSAS Tabular and Multidimensional model experience
  • SSRS reporting
  • Experience with Windows and Linux systems
  • Database administration experience

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.