Database Architect (Child Welfare)

San R&D Business Solutions LLC • Austin, TX

1d • Hybrid

About The Position

The Database Architect will serve as a technical advisor supporting the agency’s initiative with preparation to modernize to a new case management system. This role requires a data architect to work with technology and program divisions to assist with data architecture and solution design for transition to the new case management system. The worker will collaborate with Family & Protective Services technology, data, and program teams to support the review of processes, policies, and practice. The Database Architect will design, develop, and maintain complex data models that support child welfare data initiatives, requiring 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 should have experience in child welfare government data systems, working with relational and non-relational databases, and implementing best practices in data architecture. All activities must align with the company's compliance, federal and state regulations, and its goal of providing uninterrupted services to children and families. Data architecture and management services are essential for data designing, modeling, and cleansing efforts for the new system.

Requirements

• 10 Years of Experience in data architecture, data modeling, and database design
• 7 Years of Experience developing conceptual, logical, and physical data models
• 7 Years of Experience with enterprise level data on prem and cloud projects and initiatives leveraging data best practices according to the industry standards
• 7 Years of Experience designing and developing legacy modernization to cloud solutions
• 7 Years of Excellent communication skills, both verbal and written
• 7 Years of Proficiency in Oracle and Cloud data solutions
• 4 Years of Ability to implement data governance frameworks and ensure data quality
• 4 Years of Knowledge of ETL processes and data integration methodologies
• 4 Years of Experience documenting requirements for IT and business solutions that will meet program and user needs
• 4 Years of Experience working in cross-functional teams with business analysts, developers, and data engineers
• 4 Years of Experience working with sensitive data in government sector
• 2 Years of Experience with child welfare case management systems and data

Responsibilities

• Serve as a technical advisor supporting the agency’s initiative with preparation to modernize to a new case management system
• Work with technology and program divisions to assist with data architecture and solution design for transition to the new case management system
• Work with and assist Family & Protective Services technology, data and program teams to support review of processes, policies, and practice
• Design, develop, and maintain complex data models that support child welfare data initiatives
• Ensure accurate and efficient data storage, retrieval, and processing through expertise in data modeling, database design, and data governance
• Work with cross-functional teams and external vendors to logically model the flow of data between agency systems
• Support data designing, modeling and cleansing efforts for the new system

What This Job Offers

• Career Level: Senior
• Education Level: No Education Listed