The agency is looking to solve the problem of ensuring the accuracy, consistency, and integrity of data across various systems within the organization, and to enhance data management practices.
Requirements
- Extensive knowledge of a wide range of IT standards, principles, concepts, methods, policies, system testing principles and methods.
- Extensive knowledge of authorized system approaches for IT pertinent to databases management.
- Extensive knowledge of and skill in applying analytical methods and practices, and requirement analysis principles and methods.
- Extensive knowledge in working with relational database technologies.
- Extensive knowledge in creating metadata/data dictionaries; designing and implementing reports.
- Extensive knowledge creating database views used for the purposes of establishing live data feeds as well as the development of data-driven dashboard.
- Extensive knowledge of software development life cycle (SDLC), as well as, managing small IT projects with minimal oversight.
Responsibilities
- Interfaces, independently, with high level stakeholders via meetings, emails, and phone calls to manage data projects. Gather and document requirements; and to gather sample data throughout all phases of the project to ensure data quality.
- Works with District agency resources to analyze, compile. verify, and query data as part of data warehousing services. Develops complex SQL queries used by reporting environments and data-driven dashboard applications Creates metadata and data dictionaries.
- Designs and documents methods to facilitate the implementation of new database systems. Designs and implements reports using SQL as well as a variety of reporting and business intelligence tools.
- Develops and administers data standards, policies and procedures; and develops new standards, methods, and techniques. Develops common approaches to problem solving and meeting processing requirements. Develops and analyzes new projects.
- Creates scripts to identify and correct common errors and data inconsistencies in incoming data. The incumbent will make extensive use of structured query language (SQL).
- Troubleshoots problems involved in the input, retrieval or modification of database information and the general operation and maintenance pertinent to any of the enterprise data system elements or sub-elements.
- Perform complex data analyses including experience validating data and identifying and correcting data inconsistencies and errors. Analyzes and defines requirements and specifications pertinent to Client and OCTO enterprise systems and applications.
Other
- Bachelor’s degree in IT or related field or equivalent experience
- 16+ years of experience
- Demonstrated ability to speak and write clearly and effectively when dealing with various technical and non-technical audiences.
- Ability to work with minimal oversight as a technical lead on data-driven reporting and applications development projects.
- Ability to keep abreast of current trends regarding all aspects of database management.
