- Must have the ability to gather requirements analyze systems develop solutions test and document changes working in collaboration with other team members.
- Develop and design logical and physical data models of varying degrees of complexity.
- Participate in communication with end-users and subject matter experts to understand information needs and imbed into a logical data model in support of data warehouse/business intelligence initiatives.
- Participate in data model reviews with developers architects business analysts and subject matter experts to collaborate and gain consensus.
- Keep the logical and physical model synchronized and understand how information translates between the two models.
- Evolve the logical data model over time and work with developers to ensure it is leveraged across all projects.
- Advocate for the practice of modeling in technology and communicate the benefits to Tarrant County.
- Drive metadata documentation and make it available to those that depend upon it.
- Write moderately to complex SQL queries to database for data manipulation and reporting.
- Maintain business process procedures in conjunction with the process owners.
- Analyze and resolve moderate to complex data model problems.
Required Skills:
Knowledge of relational database technology transaction processing and data warehouse design and modeling and design tools is required. Strong knowledge of Structured Query Language (SQL) XML schema design metadata registry master data management data dictionaries data warehousing and relational databases is preferred.
Education Experience and Licensing:
Minimum five (5) years of experience in information technology including experience or training in database systems.
Must have the ability to gather requirements analyze systems develop solutions test and document changes working in collaboration with other team members. Develop and design logical and physical data models of varying degrees of complexity. Participate in communication with end-users and subject ma...
- Must have the ability to gather requirements analyze systems develop solutions test and document changes working in collaboration with other team members.
- Develop and design logical and physical data models of varying degrees of complexity.
- Participate in communication with end-users and subject matter experts to understand information needs and imbed into a logical data model in support of data warehouse/business intelligence initiatives.
- Participate in data model reviews with developers architects business analysts and subject matter experts to collaborate and gain consensus.
- Keep the logical and physical model synchronized and understand how information translates between the two models.
- Evolve the logical data model over time and work with developers to ensure it is leveraged across all projects.
- Advocate for the practice of modeling in technology and communicate the benefits to Tarrant County.
- Drive metadata documentation and make it available to those that depend upon it.
- Write moderately to complex SQL queries to database for data manipulation and reporting.
- Maintain business process procedures in conjunction with the process owners.
- Analyze and resolve moderate to complex data model problems.
Required Skills:
Knowledge of relational database technology transaction processing and data warehouse design and modeling and design tools is required. Strong knowledge of Structured Query Language (SQL) XML schema design metadata registry master data management data dictionaries data warehousing and relational databases is preferred.
Education Experience and Licensing:
Minimum five (5) years of experience in information technology including experience or training in database systems.
View more
View less