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.
In this role, you will be responsible for maintaining our relational databases, ensuring data integrity, performance, and security while supporting analytical needs across the organization. You will also play a key role in data governance initiatives, establishing and enforcing standards for data quality, accessibility, and compliance. A critical part of this position will be preparing and structuring organizational data to enable advanced analytics and future AI-driven solutions. Your work will help ensure our data is not only reliable and well-managed today but also positioned to support innovative technologies such as predictive analytics, machine learning, and automation tomorrow. Strong interpersonal and communication skills, along with business process knowledge and business acumen, are essential.
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
Qualifications
Bachelor's degree in computer science, Information Technology, or a related field5+ years of experience in relational database development, particularly with Microsoft SQL Server and ERP systemsFamiliarity with enterprise database designs, data warehousing, and archiving solutionsProficiency in T-SQL syntax and database modelingExperience in performance tuning and optimization techniques in SQL ServerStrong interpersonal and communication skills to effectively collaborate with team members and stakeholdersFamiliarity with Microsoft reporting tools (e.g., Power BI) and analytic development is a plusStrong analytical and problem-solving skillsPalmer Holland is a tobacco and drug free, professional environmentPhysical Requirements
Satisfactory motor skills relevant to positionAbility to sit for long periods of timeAbility to lift up to 25 poundsPalmer Holland is an equal opportunity employer. Referrals increase your chances of interviewing at Palmer Holland by 2x.
J-18808-Ljbffr