Data Warehouse Architect

Local candidates only

DWD seeks a Data Warehouse Architect (Lead/Senior Level) to work with DWD's information technology division, under general direction, carrying out a wide variety of complex technical analysis and implementation planning of a new data warehouse. This individual will be reporting to a DWD Application Systems Analyst and Programming Manager who oversees the IT Data Group. More specifically, DWD is seeking senior experience that will work beside the data team in establishing a wide range of data assists to be built once the data warehouse environment is implemented. The agency's over-arching data strategy is to make the agency's data more actionable by making it more accessible. The first tactical step in that journey is the establishment of dashboards for the purpose of monitoring the health of the agency's unemployment system. The range of dashboards include visualization into business transactions (new and historical), the various business backlogs and outstanding workloads, employee performance and if possible, workload projections. DWD seeks an individual who can bring senior level experience necessary to setup the data schemas, the bridging of data from core systems as well as the cleansing and staging of data for business use (business analysis, visual aids and reporting). More importantly, DWD seeks an individual who can guide and educate an IT Data Team on effective designs and procedures using current industry standards and best practices.

DWD is just getting started with our data warehouse and dashboarding strategies. We have a strong understanding of the data but are looking for expertise in getting that data into our Azure Synapse subscription. Through another project the data warehouse has been created.

Essential Job Responsibilities

The essential functions of this role are as follows:

Participate with a Product Owner (PO) and/or Business Analyst (BA) in gathering business requirements.

Participate with a team of business stakeholders, junior Tableau developer(s), BA and PO in developing wireframes and other dashboard mockups.

Provide guidance and experience to best practice in designing Data Lakes, Data Marts, and other data assets to be presented to the business.

Develop data mappings, data flows and data cleansing procedures.

Provide education and guidance to other data group members in effective data asset development.

In general, act as a lead in effective data designs starting with data selection from core system, data transfer and cleansing, to final data presentation.

Participate with other Data Analyst(s) as needed to define minimal viable data assets in support of the visual needs.

Assist the PO in estimating scope and time as it relates to development of data transfers, cleansing and promotion, and as it relates to staffing level.

Assist the PO and/or BA in doing Inspect & Adapt reviews with the business.

Advice management as needed of any shortcomings with current tools and/or approaches related to the business initiatives.

Requirements

Extensive knowledge of information systems design principles and new systems design techniques.

Extensive knowledge of policies, standards, procedures, and techniques used for data application development.

Ability to perform problem solving and analytical analysis on complex issues.

A very strong understanding of system development using a lean agile approach.

Extensive knowledge of both system and business applications and competent to work at the highest technical level of all phases of data applications systems analysis and developing activities.

Willingness to train/educate other Data Analysts, Business Analysts and other data team members in effective data designs/approaches.

Willingness to train/educate junior Data Analysts in effective data transfer and development.

Experience in using a wide range of ETL tool Talend and Data Factory.

Some experience in using the Tableau Studio tools is desired.

Extensive knowledge of the most recent advancement in data transfer, cleansing and promotion.

Ability to read and understand complicated technical instructions.

Ability to manage multiple application development assignments and priorities.

Ability to communicate effectively, both orally and in writing.

Supervisory Responsibilities/Direct Reports

This role does not provide direct supervision to direct reports. At most, this position is a coach to others in the IT Data Group in understanding the best practices/approaches to data transfer, cleansing and promotion.

The Data Warehouse Architect (Lead/Senior Level) performs a broad range of activities within a state-of-the-art Information Technology area. Although most of the effort will center around building data assets from scratch, work involves using considerable judgment in selecting the most pertinent guidelines to follow and in-depth analysis of multiple variables to fit various circumstances of a medium to complex enterprise-wide system. Incumbent applies general Software Development Life Cycle (SDLC) principles and industry standards to accomplish agency automation goals.

Responsibility

The Data Warehouse Architect (Lead/Senior Level) work has a direct influence and impact on the agency's ability to successfully administer the business operation to achieve agency mission, policy and/or practice. Technical instruction is generally not needed; however, employee may seek guidance when unique problems arise. Work is reviewed for adherence to deadlines and compliance with policies, standards, procedures, and achievement of the desired objectives.

Personal Work Relationships

This individual will be expected to partner with both agency and contracted personnel and related stakeholders working towards completion of assigned functions. Exceptional customer service is provided to agency partners and/or the general public.

Competencies

Acquiring Information

Communicating Effectively

Critical Thinking

Delivering High Quality Work

Testing and Troubleshooting

Displaying Technical Expertise

Adapting to Change

Accepting Responsibility

Training Others

SQL

Azure Synapse

Data Factory

Talend, Data Factory and other ETL tools

Tableau Studio

Jira

App Dynamics

Confluence

System Development using Lean Agile

Data Modeling

Data Mapping

Data Cleansing Schemes