Database Architect

Work Location

Hybrid.

Office: 4900 N. Lamar Blvd, Austin, TX 78751

Candidates must be local to Austin, TX or surrounding areas.**

Job Description

We are currently seeking a contract Database Architect to be a key resource on a technical services team for our client, the Texas Department of Family & Protective Services(DFPS).

Responsibilities

The Database Architect will serve as a technical advisor supporting the agency’s initiative with preparation to modernize to a new case management system. Client requires a data architect to work with client's technology and program divisions to assist with data architecture and solution design for transition to the new case management system. The Worker for the project will work with and assist client’s technology, data and program teams to support review of processes, policies, and practice.

The Database Architect will design, develop, and maintain complex data models that support child welfare data initiatives. This role requires expertise in data modeling, database design, and data governance to ensure accurate and efficient data storage, retrieval, and processing. This position will work with cross functional teams and external vendors to logically model the flow of data between agency systems. The ideal candidate will have experience in child welfare government data systems, working with relational and non-relational databases, and implementing best practices in data architecture.

The activities shall align with client’s compliance and federal and state regulations and its goal of providing uninterrupted services to the children and families it serves. Data architecture and management services are needed in support of data designing, modeling and cleansing efforts for the new system.

Qualifications

Minimum Requirements:

7 years of:

• Experience in data architecture, data modeling, and database design.
• Experience developing conceptual, logical, and physical data models.
• Experience with enterprise level data on prem and cloud projects and initiatives leveraging data best practices according to the industry standards.
• Experience designing and developing legacy modernization to cloud solutions.
• Excellent communication skills, both verbal and written.
• Proficiency in Oracle and Cloud data solutions.

4 years of:

• Ability to implement data governance frameworks and ensure data quality.
• Knowledge of ETL processes and data integration methodologies.
• Experience documenting requirements for IT and business solutions that will meet program and user needs.
• Experience working in cross-functional teams with business analysts, developers, and data engineers.
• Experience working with sensitive data in government sector

2 years of:

• Experience with child welfare case management systems and data.

Company Overview

Allied Consultants has been contracted with the Texas State Government for 34 years, we are a Top Ten ranked vendor, and premier provider of technical and business staffing solutions. Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan. Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check. Allied Consultants is an equal opportunities employer.