What are the responsibilities and job description for the Data Architect position at Smith County?
Smith County Information Technology provides support for County offices and employees. We are seeking a qualified Data Architect with 2–3 years of hands-on experience that can contribute to our team here. This role involves managing and maintaining Smith County’s IT Data Systems to ensure secure, reliable, and efficient operations. This includes supporting critical systems across various departments, troubleshooting technical issues, implementing security measures, and coordinating system upgrades and migrations. The ideal candidate is a proactive problem solver and continuous learner who can work effectively both independently and as part of a team. This role requires a motivated and detail-oriented professional with a commitment to public service and technical excellence.
- Collaborate with County staff and external vendors to diagnose, resolve, and follow up on technical issues across key COTS systems such as Financial, Law Enforcement, GIS, Tax, Elections, and Justice applications.
- Implement and enforce data security, user access controls, and compliance measures
- Knowledge of Database Management Systems and scripting programming languages such as Python or SQL.
- Knowledge of data privacy law and compliance
- Utilizes debugging tools to resolve application issues.
- Knowledge of performance monitoring of data systems, identifying bottlenecks and improving areas to ensure efficient data management
- Basic understanding of Data Models, Data Integration and Data Architecture Frameworks
- Monitor database and application performance, apply updates and patches, and ensure backup, recovery procedures are implemented and tested regularly.
- Provide technical support to end-users and resolve hardware/software issues
- Work with cross-functional teams to plan and execute infrastructure upgrades and system migrations, ensuring clear documentation of all procedures
- Managing and maintaining SaaS solutions, including the installation, configuration, testing and upgrades
- Participate in an on-call rotation to provide after-hours support as needed and provide escalation support
- Other duties as assigned
- Ability to write and optimize scripts for automating administrative tasks and improving database query performance
- Proficiency in SQL applications
- Knowledge of Microsoft Management tools and Visual Studio
- Experience managing mixed OS environments, including Windows and Linux servers, and working within virtualized infrastructure
- Ability to support and troubleshoot API-based integrations between third-party applications and internal systems
- Strong problem-solving and analytical skills, with the ability to troubleshoot complex technical issues
- Excellent communication skills and the ability to work independently or collaboratively in a fast-paced environment.
- 2–3 years of professional experience as a Database Administrator, System Administrator, Data Architect or in advanced Application Support
- CompTIA A , Server , or a similar industry certification is preferred
- Microsoft certifications such as AZ-900, AZ-800, or Azure Administrator (or equivalent) are preferred.
- Strong troubleshooting skills and ability to work independently or as part of a team
- Excellent communication skills for supporting non-technical staff
- After Hours Oncall Support Rotation required
- Experience in a government or public-sector IT environment is preferred
- Familiarity with Microsoft and cloud environments
- Associate or Bachelor’s degree in Computer Science, Information Technology, or a related field
OR equivalent combination of education and relevant work experience
Salary : $83,000 - $94,000