Solutions Architect (Data)/ Hybrid

Job Title: Solutions Architect (Data)

Location: Nashville, Tennessee

Hybrid

The Data Architect for the General Sessions Data Repository will play a pivotal role in strategically designing, developing, and implementing the data model for this critical enterprise-level data warehouse. This repository integrates diverse data sources from General Sessions courts across Tennessee into a unified platform to enable comprehensive reporting and analysis. This individual will be the primary advocate for data modeling methodologies and data processing best practices within the context of the repository. The Data Architect will work across conceptual, logical, business areas (court operations), and application layers to ensure robust and efficient data architecture that supports the Administrative Office of the Court s (AOC) strategic goals for data-driven decision-making.

Formal Education & Certification:

Bachelor's degree in computer science, information systems, data science, or a related field.
Relevant certifications in data warehousing, data modeling, or database administration (e.g., Certified Data Management Professional (CDMP), AWS Certified Data Analytics Specialty,

Microsoft Certified: Azure Data Engineer Associate) are a plus.

Knowledge & Experience:

5 years of work experience as a data architect, data warehouse architect, or similar role, with a focus on data integration and reporting.
Hands-on experience with data architecting, data modeling (dimensional modeling, relational modeling), ETL/ELT processes, and requirements gathering/analysis, preferably within a complex data environment.
Direct experience in implementing data management processes, procedures, and decision support systems, ideally within a government or judicial context.
Database Administration and Performance Tuning: Knowledge of database management systems and techniques for optimizing performance.
Strong understanding of relational data structures, theories, principles, and practices, as well as data warehousing concepts.
Demonstrated expertise with data warehouse design, development, and data and information system lifecycle methodologies.
Experience with business requirements analysis, entity-relationship modeling, dimensional modeling, database design for reporting and analytics, and the creation of reporting structures.
Ability to manage data migration into a data warehouse environment.
Experience with various database platforms (e.g., Microsoft SQL Server, Oracle)
Understanding of data security principles and best practices relevant to sensitive data.
Experience with data processing flowcharting techniques and data flow diagrams.
Proven ability to work independently and collaboratively within a team environment.