What are the responsibilities and job description for the Data Solutions Administrator position at Palmer Holland?
Brief 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.
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
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
- 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
- Satisfactory motor skills relevant to position
- Ability to sit for long periods of time
- Ability to lift up to 25 pounds