Data Integration Specialist

Gallopade seeks a Data Integration Specialist to collect, manage, analyze and manipulate data from 3rd party application vendors and software for variety of internal functions. This position will be a key member of the team that oversees and supports Gallopade's growing digital education operations and is able to analyze Company's data operations and utilize technologies to support current and future integrations and needs. Gallopade partner with industry leaders for variety of digital needs, including creation, hosting, and delivery of online educational curriculum for 1 million teachers and students.

Desired candidate is a multi-talented individual who has the experience to come onboard and make immediate impact, and the drive to expand their knowledge by learning new skills and technologies.

Essential Functions:

• Build and use SQL, servers for data projects

• Use API to gather data from various 3rd party application partners and transform data for various internal users

• Build scripts to use API to automate processes with same applications

• Oversee data security including internal controls as well as delivery in/out of data transactions between customers according to Data Privacy and FERPA regulations

• Create scripts and tool for non-technical users to access data and/or put data into various formats for internal users

• Transform Data for departmental needs including customer registrations, product usage, newsletter communications, and more

• Communicate with Engineers/QA team at 3rd party partners

• Provide consultation on complex projects, often as the top level contributor/specialist from technical POV

• Assist team with QA, support, registration, and other items needed

• Assessment of software application issues.

Required Skills and Experience

• Computer Science degree and minimum of 3 years experience or 4 years of hand-on experience with non-related degree

• Proficiency in database development/management, specifically SQL server and MySQL

• Hand-on experience with API and API software and/or Python/PHP experience

• In-depth knowledge of JSON and rest API

• Database creation, migration and normalization

• Experience with Oauth2 or Authentications helpful

• Research and development of technical solutions, testing, and upgrading

• Accomplished presentation skills and ability to present data and information to both technical and non-technical audiences

• Effective communication skills including verbal, written and presentation skills

• Proven ability to work effectively both independently and in a team-based environment

• Demonstrated willingness to be flexible and adaptable to changing priorities.

To apply: This a full-time position. In addition to resume, apply by submitting a cover letter with salary requirements. Gallopade International, Inc. is an award-winning publisher of most 15,000 educational products focusing on social studies, science, and reading. Founded by author Carole Marsh in 1979. Gallopade is a second-generation family-family focused on providing high quality print and digital instructional materials. For over 40 years, Gallopade has been partnering with educators to provide resources that are fun, educational, and effective. Gallopade is an Equal Opportunity Employer __ ** Job Type: Full-time COVID-19 considerations: We are complying with CDC guidelines. Job Type: Full-time Benefits:

• Dental insurance

• Health insurance

• Life insurance

• Retirement plan

• Vision insurance

Schedule:

• 8 hour shift

• Day shift

• Monday to Friday

Education:

• Bachelor's (Preferred)

Experience:

• SQL: 3 years (Preferred)

• Data Warehouse: 3 years (Preferred)

Work Location:

• One location

Work Remotely:

• No