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