Data and Analytics Developer

Galloup•Conshohocken, PA

2d•Onsite

About The Position

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.

Requirements

Experience with Microsoft SQL Server 2016 or later.
Bachelor’s degree in computer science (or related field) or equivalent experience.
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.
Ability to work collaboratively across the organization; flexible with changing demands and priorities.
Very detail oriented, organized, and effective in team environments with mixed skill sets.
Strong verbal and written communication skills; ability to explain technical information to non-technical staff.
Ability to see, talk, and hear
Ability to sit for 8 hours a day

Nice To Haves

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

Responsibilities

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.