Data Services Manager & Architect

About the Department

Position Duties

• Supervise and mentor assigned staff, provide technical leadership, review work assignments, establish priorities, and manage vendor relationships. Works with County departments, cross-functional teams, and external vendors. Responsible for the architecture, governance, security, administration, integration, and operational management of enterprise databases, data warehouses, and analytics platforms. Develops and maintains enterprise data classification and standards. Architect scalable data solutions that support systems, analytics, regulatory compliance, and strategic decision-making. Develop and maintain conceptual, logical, and physical data models supporting transactional (OLTP), analytical (OLAP), reporting, and business intelligence systems. Administer, monitor, secure, and optimize enterprise database platforms through performance tuning, capacity planning, backup and recovery, disaster recovery, patch management, and automation. Design and oversee data integration, ETL/ELT engineering processes, APIs, event-driven integrations, and data migration strategies supporting enterprise applications and legacy system modernization. Evaluate emerging database technologies, cloud services, and data management tools; recommend solutions that improve performance, scalability, security, and cost-effectiveness. Investigate data anomalies, perform root cause analysis, and implement corrective actions to improve data integrity and reliability. Ensure compliance with applicable security, privacy, regulatory, and records management requirements. Develop enterprise data standards, reference architectures, documentation, and operational procedures. Collaborate with infrastructure, cybersecurity, software development, GIS, and departmental stakeholders to ensure enterprise data solutions align with County technology strategy.
• Supervise and mentor assigned staff, provide technical leadership, review work assignments, establish priorities, and manage vendor relationships. Works with County departments, cross-functional teams, and external vendors.
• Responsible for the architecture, governance, security, administration, integration, and operational management of enterprise databases, data warehouses, and analytics platforms.
• Develops and maintains enterprise data classification and standards.
• Architect scalable data solutions that support systems, analytics, regulatory compliance, and strategic decision-making.
• Develop and maintain conceptual, logical, and physical data models supporting transactional (OLTP), analytical (OLAP), reporting, and business intelligence systems.
• Administer, monitor, secure, and optimize enterprise database platforms through performance tuning, capacity planning, backup and recovery, disaster recovery, patch management, and automation.
• Design and oversee data integration, ETL/ELT engineering processes, APIs, event-driven integrations, and data migration strategies supporting enterprise applications and legacy system modernization.
• Evaluate emerging database technologies, cloud services, and data management tools; recommend solutions that improve performance, scalability, security, and cost-effectiveness.
• Investigate data anomalies, perform root cause analysis, and implement corrective actions to improve data integrity and reliability.
• Ensure compliance with applicable security, privacy, regulatory, and records management requirements.
• Develop enterprise data standards, reference architectures, documentation, and operational procedures.
• Collaborate with infrastructure, cybersecurity, software development, GIS, and departmental stakeholders to ensure enterprise data solutions align with County technology strategy.

Minimum Qualifications

• Bachelor’s degree in computer science, Information Systems, Data Management, or a related field; equivalent combination of education and experience may be considered. At least 7+ years of experience in enterprise data, with a focus on data architecture, administration, management, support, and optimization. Prior experience in a leadership or management role is highly preferred. Significant experience architecting, designing, implementing, and administering enterprise database and data warehouse solutions. Experience with relational and non-relational databases, cloud data platforms, ETL/ELT processes, and enterprise reporting environments. Experience leading technical projects and coordinating cross-functional teams. Enterprise data architecture, database design, and data modeling. Database administration, performance tuning, backup and recovery, high availability, and disaster recovery. Data warehousing, business intelligence, analytics, and data integration methodologies. Data governance, metadata management, master data management, and data quality practices. Cloud data platforms and hybrid architectures. SQL and database automation; experience with scripting languages such as C#, Python, or PowerShell is desirable. Information security, privacy, and regulatory compliance related to enterprise data. Strong analytical, problem-solving, project management, and organizational skills. Ability to communicate complex technical concepts to technical and non-technical audiences. Ability to build collaborative relationships, lead technical initiatives, and drive continuous improvement across the County's enterprise data environment.
• Bachelor’s degree in computer science, Information Systems, Data Management, or a related field; equivalent combination of education and experience may be considered.
• At least 7+ years of experience in enterprise data, with a focus on data architecture, administration, management, support, and optimization. Prior experience in a leadership or management role is highly preferred.
• Significant experience architecting, designing, implementing, and administering enterprise database and data warehouse solutions.
• Experience with relational and non-relational databases, cloud data platforms, ETL/ELT processes, and enterprise reporting environments.
• Experience leading technical projects and coordinating cross-functional teams.
• Enterprise data architecture, database design, and data modeling.
• Database administration, performance tuning, backup and recovery, high availability, and disaster recovery.
• Data warehousing, business intelligence, analytics, and data integration methodologies.
• Data governance, metadata management, master data management, and data quality practices.
• Cloud data platforms and hybrid architectures.
• SQL and database automation; experience with scripting languages such as C#, Python, or PowerShell is desirable.
• Information security, privacy, and regulatory compliance related to enterprise data.
• Strong analytical, problem-solving, project management, and organizational skills.
• Ability to communicate complex technical concepts to technical and non-technical audiences.
• Ability to build collaborative relationships, lead technical initiatives, and drive continuous improvement across the County's enterprise data environment.

Technical Skills

• Enterprise relational databases (Microsoft SQL Server, Oracle, MySQL, and other current and emerging technologies) administration, backup, disaster recovery, high availability, and performance tuning. Cloud data platforms (Microsoft Azure and other cloud platforms) Data Fabric/Warehouses, Data lakes, and Lakehouse architecture ETL/ELT platforms and orchestration tools C#, SQL, Python, PowerShell, or similar scripting languages REST APIs, messaging platforms, and data integration technologies Business Intelligence and visualization platforms (Power BI, Tableau, Looker, or equivalent) Data governance, metadata management, and master data management Security frameworks, identity management, encryption, and regulatory compliance Skills Matrix Skill/Experience Proficiency Level Enterprise Data Architecture Advanced Database Administration (DBA) Advanced Data Engineering & Integration Advanced Data Governance & Quality Intermediate Cloud Data Platforms Intermediate Analytics & Business Intelligence Advanced Performance & Capacity Management Advanced Security & Compliance Intermediate Automation & DevOps Proficient Project Management (Agile, Scrum) Proficient Leadership & Team Management Advanced Communication & Stakeholder Management Advanced
• Enterprise relational databases (Microsoft SQL Server, Oracle, MySQL, and other current and emerging technologies) administration, backup, disaster recovery, high availability, and performance tuning.
• Cloud data platforms (Microsoft Azure and other cloud platforms)
• Data Fabric/Warehouses, Data lakes, and Lakehouse architecture
• ETL/ELT platforms and orchestration tools
• C#, SQL, Python, PowerShell, or similar scripting languages
• REST APIs, messaging platforms, and data integration technologies
• Business Intelligence and visualization platforms (Power BI, Tableau, Looker, or equivalent)
• Data governance, metadata management, and master data management
• Security frameworks, identity management, encryption, and regulatory compliance
• Skill/Experience
• Proficiency Level
• Enterprise Data Architecture
• Advanced
• Database Administration (DBA)
• Data Engineering & Integration
• Data Governance & Quality
• Intermediate
• Cloud Data Platforms
• Analytics & Business Intelligence
• Performance & Capacity Management
• Security & Compliance
• Automation & DevOps
• Proficient
• Project Management (Agile, Scrum)
• Leadership & Team Management
• Communication & Stakeholder Management

Benefits

• Adams County provides a comprehensive benefits package to employees that goes above and beyond what is offered at most organizations. Benefits You Expect: AFLAC Supplemental Medical Insurance Basic Term Life & Optional Term Life Insurance Deferred Compensation Plan Dental/Vision/Medical Plans Generous Vacation/Sick leave Long-Term Disability Retirement Plan Short-Term Disability Plus some you might not expect: Employee Assistance Program Employee Fitness Center Employee Health Clinics Flexible Work Schedules Recreation Center Discounts Training & Tuition Reimbursement Programs Wellness programs Lactation friendly certified workplace
• AFLAC Supplemental Medical Insurance
• Basic Term Life & Optional Term Life Insurance
• Deferred Compensation Plan
• Dental/Vision/Medical Plans
• Generous Vacation/Sick leave
• Long-Term Disability
• Retirement Plan
• Short-Term Disability
• Employee Assistance Program
• Employee Fitness Center
• Employee Health Clinics
• Flexible Work Schedules
• Recreation Center Discounts
• Training & Tuition Reimbursement Programs
• Wellness programs
• Lactation friendly certified workplace

Supplemental Questions