Associate Data Engineer Jobs in Murfreesboro, TN

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.