Email Opening
Title

Data Solutions Administrator  

About the Organization Palmer Holland is a quickly expanding international specialty chemical distributor based in Westlake, OH and operating in the United States and Canada. Palmer Holland represents many of the most recognized manufacturers from around the world. Our customers and principals are rooted in the Agriculture, CASE (coatings, adhesives, sealants, elastomers), Health & Nutrition, Lubricants, and Plastic industrial sectors.
As an independently-owned sales and marketing organization, we have the opportunity to make decisions which are in the best, long-term interest of the employees, customers, and principals we serve. Our sellers work with customers to solve problems and test and re-test different specialty products in order to find the one that will create what the customer needs. The dedication from our employees to continually improve their knowledge base and provide commitment to outstanding technical and customer service enables Palmer Holland to thrive as an industry leader.
As an employer, Palmer Holland's goal to remain independent is solidified through operating as a privately held Employee Stock Ownership Plan (ESOP) with an ownership team made entirely of employees. Palmer Holland views our employees as our most valuable asset, offering a healthy work-life integration and varying opportunities for professional development. We are known for having a culture that emphasizes having fun, being healthy, and working hard. Our office has advanced technology, a shuffleboard table, golf simulator, and treadmill workstations. In the field, our sales team has the tools to make critical decisions on the spot to better respond to customer needs, ultimately forming strong relationships. We believe in providing a work culture that engages employees, encourages growth, and promotes success.  
Category Information Technology  
Position Data Solutions Administrator  
Description

Position Overview:

We are seeking a skilled Data Solutions Administrator to join our dynamic team. The ideal candidate will have over five years of experience in database design, development, and optimization, with expertise in reporting, analytics, data warehousing, archiving, and enterprise database design. You will be responsible for maintaining our relational databases, ensuring data integrity, performance, and security while supporting analytical needs across the organization. Additionally, you will play a key role in data governance initiatives, establishing and enforcing standards for data quality, accessibility, and compliance. Strong interpersonal and communication skills, along with business process knowledge and business acumen, are essential.

 

Key Responsibilities:

  • Collaborate with software developers, analysts, and stakeholders to define data requirements and solutions.
  • Write and maintain complex T-SQL queries, stored procedures, and functions.
  • Enhance and expand existing ETL processes to unify data into a centralized repository for streamlined reporting
  • Oversee data governance and ensure data quality.
  • Optimize database performance and query efficiency.
  • Ensure data integrity and security through best database management practices.
  • Manage and support backup and recovery strategies.
  • Manage data warehousing solutions to support efficient data storage and retrieval.
  • Implement archiving strategies to enhance database performance and maintain compliance.
  • Maintain comprehensive documentation for data assets, data flows, and data dictionaries.
  • Develop user guides and training materials to assist end-users and IT staff in utilizing data solutions.
  • Troubleshoot and resolve database issues as needed.
  • Stay updated on industry best practices and emerging Microsoft database technologies.
 
Location Corporate Office  
Position Requirements
  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • 5+ years of experience in relational database development, particularly with Microsoft SQL Server and ERP systems.
  • Familiarity with enterprise database designs, data warehousing, and archiving solutions.
  • Proficiency in T-SQL syntax and database modeling.
  • Experience in performance tuning and optimization techniques in SQL Server.
  • Strong interpersonal and communication skills to effectively collaborate with team members and stakeholders.
  • Familiarity with Microsoft reporting tools (e.g., Power BI) and analytic development is a plus.
  • Strong analytical and problem-solving skills.

Palmer Holland is a tobacco and drug free, professional environment.

Physical Requirements

  • Satisfactory motor skills relevant to position
  • Ability to sit for long periods of time
  • Ability to lift up to 25 pounds
 
Full-Time/Part-Time Full-Time  
Exempt/Non-Exempt Exempt  
EOE Statement We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.


To perform this job successfully, an individual must be able to perform each essential job tasks satisfactorily. Palmer Holland is committed to the full inclusions of all qualified individuals and reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential job functions.  
Travel Requirements  

This position is currently not accepting applications.

To search for an open position, please go to http://PalmerHollandInc.appone.com


 


 
Click here for technical assistance.