Launch Your Career with Cook Systems
Ready to elevate your career? Cook Systems, a certified veteran owned IT consulting firm, has been transforming businesses and careers since 1990. Whether you're aiming to work with a Fortune 500 company or a small business, we've got you covered.
Our core values: integrity, investment, and innovation drive everything we do, ensuring you grow and succeed in a dynamic, supportive environment. We understand the importance of work life balance and personal growth. Our cutting edge IT consulting partners and FastTrack talent program are designed to help you excel.
Join our forward thinking team where excellence and creativity are valued every day. Check out what our associates have to say on Glassdoor. Ready to take your career to new heights? Cook Systems is where your journey to success begins!
Max 2 submittals
Preferred to be Near /local to Nashville ? Market-rate compensation package based on experience
Job Overview:
This position will be required to work in the office 2 days a week and can work remote 3 days a week.
Description:
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.
Responsibilities:
Strategy & Planning:
? Develop and deliver a long-term strategic vision and standards for the data architecture of the General Sessions Data Repository, in collaboration with data users, court personnel, IT teams, and other stakeholders within the AOC.
? Create short-term tactical solutions and an overall data management roadmap specifically for the General Sessions Data Repository initiative.
? Establish and enforce processes for governing the identification, collection, and use of metadata related to court data; implement measures to ensure metadata accuracy and validity within the repository.
? Define methods and procedures for tracking data quality, completeness, consistency, and identifying areas for improvement within the integrated data.
? Conduct data capacity planning, lifecycle management, usage requirements analysis, and feasibility studies specific to the General Sessions Data Repository.
? Contribute to strategies and plans for data security, backup, disaster recovery, business continuity, and archiving related to the repository data.
? Ensure that data strategies and architectures for the General Sessions Data Repository adhere to relevant state and federal regulations and AOC policies.
Acquisition & Deployment:
? Ensure the successful integration of various data sources into the General Sessions Data Repository.
? Liaise with vendors and service providers for any tools or services related to the data repository, ensuring they align with the AOC's needs.
Operational Management:
? Assess and determine governance, stewardship, and frameworks for managing data within the General Sessions Data Repository.
? Develop and promote data management methodologies and standards specific to data warehousing and reporting within the AOC environment.
? Select and implement appropriate tools, software, applications, and systems to support the data technology goals of the General Sessions Data Repository.
? Oversee the mapping of data sources, data movement processes (ETL/ELT), interfaces, and analytics related to the repository, with a strong focus on ensuring data quality and accuracy.
? Collaborate closely with project managers, business analysts, and court personnel on all projects involving data from the General Sessions Data Repository.
? Address data-related problems concerning systems integration, data compatibility across disparate court systems, and multi-platform integration into the data warehouse.
? Act as a leader and advocate for data management best practices related to the General Sessions Data Repository, potentially providing guidance to other staff involved in data-related activities.
? Develop and implement key components and testing criteria to guarantee the fidelity and performance of the General Sessions Data Repository architecture.
? Document the data architecture and environment of the General Sessions Data Repository to maintain a current and accurate understanding of the data landscape.
? Identify and develop opportunities for data reuse, migration, or retirement within the context of the General Sessions Data Repository.
? Data Governance and Security: Ensuring data quality, accuracy, consistency, and security within the data warehouse.
Position Requirements:
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.
Personal Attributes:
? Excellent written and oral communication skills, with the ability to clearly articulate complex technical concepts to both technical and non-technical audiences.
? Strong presentation and interpersonal skills, with the ability to effectively communicate with court personnel and other stakeholders.
? Ability to present technical ideas in a user-friendly language.
? Strong analytical and problem-solving skills.
? Attention to detail and a commitment to data quality.
Why Work with Us
Benefits
At Cook Systems, we don't just offer jobs we build futures. Our team is the heart of everything we do, and we're committed to supporting you with benefits that go beyond the basics. We want you to feel secure, valued, and empowered from the very beginning of your journey with us. When you join Cook Systems, here's what you can look forward to:
Your Health, Your Way: Choose from two comprehensive medical plans through Blue Cross Blue Shield, complete with dental and vision coverage. With access to one of the nation's largest networks, you'll get the care you need for yourself and your family wherever life takes you.
Peace of Mind, Every Step of the Way: Protect what matters most with life, critical illness, and accident insurance through Unum. Because your loved ones deserve security no matter what the future holds.
Flexibility for Life's Needs: Save money and plan ahead with a Flexible Spending Account and Daycare FSA through Navia, helping you manage healthcare and dependent care expenses on your terms.
Bridging the Gaps: Unexpected costs? No problem. Our Health Gap Insurance through Sunlife helps ensure you're covered when it counts.
Your Future Starts Now: Dream big with our 401(k) retirement plan through The Standard. After just six months, you will be eligible to participate, because your future deserves a strong foundation.
At Cook Systems, you're not just another employee you're family. Here, your ideas matter, your contributions shine, and your career will thrive. Together, we innovate, grow, and celebrate success every step of the way. Are you ready to be part of something bigger? Let's build the future together at Cook Systems.