Data Solutions Administrator

Palmer Holland - Westlake, OH

Full-time

Westlake, OH

Merchant Wholesalers, Durable Goods

About the position

The Data Solutions Administrator will be responsible for managing and optimizing relational databases, ensuring data integrity, performance, and security. This role involves supporting analytical needs across the organization and playing a key role in data governance initiatives, establishing standards for data quality and compliance.

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.

Requirements

• Over five years of experience in database design, development, and optimization.
• Expertise in reporting, analytics, data warehousing, and enterprise database design.
• Strong interpersonal and communication skills.
• Business process knowledge and business acumen.