Database Architect 3

Top Skills & Years of Experience: IBM Data Stage 3-4 years and IBM Cloud Pack / Snowflake 2 years

Interview Process and Duration: WebCam Teams

Remote

Principal responsibilities include providing technical functions in support of data administration and integration along with managing data as an asset and to promote data-sharing statewide.

Responsible for evaluating user requests for new solutions, modifications to existing solutions, and system integration of off the shelf products. Solutions can be defined as data models, data conversion, or data integration. Reviews customer requests to determine if it requires creating new solutions or modifying existing solutions as it relates to the data. Performs research and gathers information to determine feasibility, appropriateness, cost and time required for solutions. Prepares detailed estimates in order to obtain approval to proceed. Prepares data requirements for solutions.

Analyzes and designs data models, coordinates database development, and performs in-depth data analysis by applying knowledge of data design standards and data quality practices. Identifies and resolves production and/or applications problems related to the design and/or quality of the data. Maintains the data models in the central repository by working the development teams across the state. Creates system and user documentation for solutions. Monitors production solutions and system performance.

Provides training and mentors less experienced team members. Data Modeler should be capable of working on large number of projects simultaneously while also providing production support.

The Data Modeler must be a fast learner with excellent communication, written, and problem solving skills, and able to work with minimal supervision as part of a multidisciplinary team. The Data Modeler must be able to work well with a diverse group of team members to deliver solutions on time, on budget and within specifications.

Responsibilities % of time, annualized

• Data Integration Development: Design, code, test, debug and document complex data integration solutions. Provide ETL and modeling solutions (IBM DataStage, Snowflake). Writes well-documented code to assure proper code maintenance in the future. Participate in code reviews and walkthroughs. Mentoring others in data integration. 30%
• Modeling and Reporting: Responsible for large and complex data models, creating complex data matrices, and mentoring others in reporting and data modeling. 20%
• Project Planning: Manages data analyst project tasks including providing estimates; customer management for data modeling, data integration, and reporting; promote data modeling and data sharing across the state; and supervising data analyst positions. 15%
• Analysis/Research: Perform business/quantitative analyses and re-engineer poor workflows. Evaluates and recommends a custom build solution versus use of a commercial off-the-shelf product. Research new approaches and evaluate new software tools and techniques. 15%
• Technical Support: Monitor mission critical systems and provide post-implementation and production support as an on-call programmer. 10%
• Personal development: Technology & I/T disciplines training, technical research, participate in team & other meetings. 10%