Data and Analytics Developer

Kendall Electric, Inc.

Conshohocken, PA

JOB DETAILS
SKILLS
Analysis Skills, Application Programming Interface (API), Automation, CRM Integration, Coaching, Communication Skills, Computer Science, Computer Skills, Cross-Functional, Customer Support/Service, Customer/Client Research, Data Analysis, Data Management, Data Quality, Data Visualization Tools, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Database Technology, Detail Oriented, ERP (Enterprise Resource Planning), Electricity, Enterprise Architecture, Google Analytics, Help Desk, Instrumentation, Java, Linux Operating System, Machine Learning, Mentoring, Microsoft Active Directory, Microsoft Office, Microsoft SQL Server, Microsoft Visual Studio, Microsoft Windows Azure, Microsoft Windows Operating System, Multitasking, NoSQL, Organizational Skills, Physical Demands, Power BI, Presentation/Verbal Skills, Problem Solving Skills, Programming Languages, Protocol Independent Multicast (PIM), Python Programming/Scripting Language, Quality Assurance, Relational Databases (RDBMS), Reporting Dashboards, SQL (Structured Query Language), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Scala Programming Language, Tableau, Team Player, Testing, User Interface/Experience (UI/UX), Web Programming, Windows PowerShell, Writing Skills
LOCATION
Conshohocken, PA
POSTED
30 days ago

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.

About the Company

K

Kendall Electric, Inc.