Data Warehouse Developer - Madison, United States - Novalink Solutions LLC
Description
Data Warehouse Developer III
This position is responsible for the planning, development, implementation, and administration of systems for the acquisition, storage and retrieval of data. Staff occupying this position in have the experience to serve the data technology needs of the agency business areas as well extra-and inter-agency requirements.
Job Responsibilities (85% of time):
1. Discover, analyze, organize and document business data requirements.
2. Design, develop, install, implement, tune, plan capacity, and recover databases.
3. Design and implement data inventory and documentation approaches.
4. Install, upgrade and maintain database management systems software. Database systems
software problem identification, diagnosis and correction.
5. Provide technical support of data modeling tools, data design tools, GIS software, data
dictionaries, repositories, data warehouse extract/transform/load tools, data reporting tools.
6. Participate in the planning, drafting, and creation of data related policy, standards, guidelines,
manuals and procedures.
7. Develop and implement procedures to manage information with consistency and quality.
8. Design, develop, populate, maintain, plan capacity for, tune and otherwise administer data
warehouses, reporting data structures, and/or data marts with optimal performance goals.
9. Analyze, design, implement, and support data architectures.
10. Design training materials and teach others to use data analysis, design, and management
techniques and tools.
11. Study and provide recommendations on new database, data modeling, metadata repository,
ETL, reporting, or other data management tools, procedures, and methodologies.
12. Conduct complex analysis and display of data in a geographic dimension.
13. Develop and manage standard geographically-based datasets for use by others.
14. Support GIS work of others through training, material development, consultation and
research.
15. Research, select, support and oversee the installation of GIS software.
16. Design and implement techniques to use databases as an integration point between
applications.
17. Develop and monitor compliance with policies and procedures controlling integrity of and
access to data.
18. Assess security risks of networks and applications.
19. Develop and implement educational programs about security.
20. Participate in network and system design to ensure security.
21. Perform disk management for the installation and configuration of database management
system software – e.g., analyze and determine location of system executables, redo logs,
archive logs, system data files, application data files and index files.
22. Perform database object administration – e.g., create database instances, tablespaces,
tables, indexes, and views.
23. Perform database security administration – e.g., Create users, roles and profiles. Control
and monitor user access to databases.
Other duties (15% of time):
1. Use data models or data documentation tools to access information about data.
2. Use existing data structures and reporting tools to answer business questions.
3. Analyze data using business analysis and basic GIS software.
4. Participate in building or review of data models as a business representative.
5. Act as a data steward/custodian by granting access to data, defining data, identifying and
resolving data quality issues.
6. Provide business requirements for the application development process.
7. Use data policy, standards, guidelines, or procedures in the development of software
applications.
8. Use data warehouses, data marts, or other reporting data structures for reporting purposes.
9. Adhere to data-related standards, policies and procedures.