Systems Analyst V

The Foster Care Litigation Data Unit (FCLDU) is a unit within the Office of Data and Systems Improvement (ODSI). FCLDU works to support ongoing efforts by the Department of Family & Protective Services (DFPS) to demonstrate substantial compliance with remedial orders issued as part of a federal class-action lawsuit against DFPS on behalf of children in the Permanent Managing Conservatorship of DFPS. FCLDU also works to support the rollout and implementation of Community Based Care (CBC) across the state and assists other ODSI units as needed.

The FCLDU partners with other divisions within DFPS and external partners in the production, and gathering of said data, and also partners with DFPS leadership to provide data to inform decision-making at the highest levels of the agency as well as for our community partners, legislative oversight entities, and the general public.

The FCLDU routinely interacts with Single Source Continuum Contractors (SSCC's). These local service networks are responsible for finding foster homes or other living arrangements for children in state care and providing them with a full range of community-based care services, including case management. These privatization efforts are active in four separate areas as of Summer 2023, and Texas expects to expand Community-Based Care to all of Texas by 2029. The FCLDU is responsible for working with these SSCC's to ensure they are providing the data required by the court-appointed monitors.

The division is responsible for conducting quality assurance reviews of data to be released outside the agency related to the remedial orders to ensure validity and consistency of reported data. The division also works with other ODSI divisions in the development of data warehouse online reports and the supporting of specialized tables and/or elements.

This position will act as a FCLDU Systems Analyst. The FCLDU Systems Analyst performs advanced (senior-level) computer systems analysis work. Work involves coordinating the planning and analysis of system requirements, procedures, and problems to automate processing or to improve existing systems, designing and implementing designs using software programming languages. May supervise the work of others. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

Essential Job Functions: We're looking for someone who wants to dedicate their talents and abilities to serving and protecting the most vulnerable Texans. Someone who is excited to be a part of a team of highly skilled, capable, and motivated individuals. We want someone who is intellectually curious, eager to create original code and evaluate and/or modify existing programs at varying levels of complexity and who's not afraid to look for innovative and new ways of doing things. We need someone who can engage a variety of people across the agency, building strong relationships and support for the work of our division. Attention to detail and ability to meet critical timeframes is essential for this position.

The specific job functions include:

• Designing, validating, and implementing report methodologies for multiple areas of specialization while documenting processes and procedures for technical and non-technical users.
• Developing programming code and report design to ensure user requests are properly translated into useful reports.
• Participating in data system design meetings for new agency initiatives to provide strategic guidance and ensure the agency's ability to report relevant data.
• Interacting routinely with agency program staff, division managers, regional staff, other analysts, and external partners to provide strategic guidance so requirements are met, and work products are appropriately reviewed and validated.
• Performing quality assurance tasks to ensure accuracy of reports created by colleagues within the division, and external partners, for distribution to the agency or the public.
• Serving as a lead analyst on assigned projects of any level of complexity and acting as mentor and on-the-job trainer for new and junior analysts when capable., As a state agency, DFPS is required by Texas Administrative Code (TAC 206 and 213) to ensure all Electronic Information Resources (EIR) follow accessibility standards. The staff must be familiar with the WCAG 2.1 AA and Section 508 to create accessible content including but not limited to; Microsoft Office documents, Adobe PDFs, webpages, software, training guides, video, and audio files.

DFPS uses E-Verify. You must bring your I-9 documentation with you on your first day of work. Employees must provide documentation to DFPS to show their identity and authorization to work in the US. Please review the following link for authorized documents: https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents .

Understanding of and demonstrated skill in relational databases, data processing practices.

• Ability to analyze, consolidate, and interpret complex data, procedures, and systems; and to write or revise program code as required.
• Comprehension of data solutions, reporting methodologies, math, and statistical report design.
• An ability to creatively solve complex data problems, apply new technology, and perform detailed work accurately under stressful conditions while managing multiple projects and tight deadlines.
• Technical Skills - in using SQL code, Excel, and the willingness to learn selected software as required by the division possibly including Tableau, Python, R, and more.
• Communication Skills - the ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, and effectively.
• Ability to work the hours needed to meet defined deadlines and support the agency's mission critical reporting requirements.

Initial Screening Criteria: * Experience in writing SQL code.

• Experience in using Excel.
• Experience in data extraction and report layout and design.
• DFPS experience preferred

Additional Information:

Work outside of regular hours, including occasional weekends, may be required on rare occasions. Occasional overnight travel to other work locations may be required, such as to support DFPS leadership at court hearings. Applicants selected for interview will be required to complete a written exercise to demonstrate knowledge, skills, and abilities.

Pulled from the full job description

• Loan forgiveness

• 401(k)

• Employee discount

• Vision insurance

• Dental insurance

• Flexible spending account

• Gym membership, The Texas Department of Family and Protective Services (DFPS) works to build on strengths of families and communities to keep children and vulnerable adults safe, so they thrive. We do this through investigations, services, and referrals. What You Get Beyond Your Paycheck When you join the State of Texas, your monthly paycheck is just one part of your real income. Our benefits provide extra value that many private employers simply don't match-often adding hundreds of dollars each month to what you take home or save. Here's what you get as a full-time employee:

• 100% paid health insurance for you, and 50% paid for eligible family members-saving you hundreds every month in out-of-pocket medical costs

• Retirement plans with lifetime monthly payments after five years of state service, plus options to save even more with 401(k) and 457 plans

• Paid vacation, holidays, and sick leave so you can recharge and take care of life outside work (that's time off you're actually paid for)

• Optional dental, vision, and life insurance-at rates much lower than most private plans

• Flexible spending accounts for added tax savings on health and dependent care

• Employee discounts on things like gym memberships, electronics, and entertainment

You also might qualify for Public Service Loan Forgiveness, which could help you pay off federal student loans faster. You can see all the details here: ERS recruitment brochure, Other Locations: Austin; Abilene; Alamo; Alice; Alpine; Alvin; Amarillo; Anahuac; Andrews; Angleton; Anson; Aransas Pass; Archer City; Arlington; Athens; Atlanta; Bacliff; Ballinger; Bandera; Bastrop; Bay City; Baytown; Beaumont; Bedford; Beeville; Bellville; Big Spring; Boerne; Bonham; Borger; Bowie; Brady; Breckenridge; Brenham; Brownfield; Brownsville; Brownwood; Bryan; Burnet; Caldwell; Cameron; Canton; Canutillo; Carlsbad; Carrizo Springs; Carrollton; Carthage; Center; Centerville; Childress; Clarksville; Cleburne; Cleveland; Coldspring; Columbus; Conroe; Copperas Cove; Corpus Christi; Corsicana; Crockett; Crosby; Crystal City; Cuero; Cypress; Daingerfield; Dallas; Decatur; Del Rio; Denton; Dickinson; Dumas; Duncanville; Eagle Pass; Eastland; Edinburg; El Paso; Elgin; Elsa; Ennis; Fabens; Falfurrias; Floresville; Fort Stockton; Fort Worth; Fredericksburg; Gainesville; Galveston; Garland; Gatesville; Georgetown; Giddings; Gilmer; Goliad; Gonzales; Graham; Granbury; Grand Prairie; Grapevine; Greenville; Hallettsville; Hamilton; Harlingen; Haskell; Hearne; Hemphill; Hempstead; Henderson; Hereford; Hillsboro; Hondo; Houston; Humble; Huntsville; Hurst; Irving; Jacksonville; Jasper; Johnson City; Jourdanton; Karnes City; Katy; Kaufman; Kerrville; Killeen; Kingsville; Kingwood; Kirbyville; La Grange; Lake Jackson; Lake Worth; Lamesa; Lampasas; Lancaster; Laredo; Levelland; Lewisville; Liberty; Linden; Littlefield; Livingston; Llano; Lockhart; Longview; Lubbock; Lufkin; Lumberton; Madisonville; Marble Falls; Marfa; Marlin; Marshall; Mcallen; Mckinney; Mercedes; Meridian; Mesquite; Mexia; Midland; Mineola; Mineral Wells; Mission; Monahans; Mount Pleasant; Mount Vernon; Nacogdoches; Navasota; New Boston; New Braunfels; Odessa; Orange; Palestine; Pampa; Paris; Pasadena; Pearland; Pearsall; Pecos; Perryton; Pharr; Pittsburg; Plainview; Plano; Pollok; Port Arthur; Port Lavaca; Presidio; Quitman; Raymondville; Refugio; Richardson; Richmond; Rio Grande City; Robstown; Rockwall; Rosenberg; Round Rock; Rowlett; Rusk; San Angelo; San Antonio; San Benito; San Juan; San Marcos; San Saba; Schertz; Seguin; Seminole; Seymour; Sherman; Silsbee; Sinton; Snyder; Socorro; Sonora; South Houston; Stephenville; Sugar Land; Sulphur Springs; Sweetwater; Taylor; Temple; Terrell; Texarkana; Texas City; The Woodlands; Tomball; Trinity; Tyler; Uvalde; Van Horn; Vernon; Victoria; Waco; Washington; Watauga; Waxahachie; Weatherford; Webster; Weslaco; Wharton; Wichita Falls; Woodville; Zapata MOS Codes: 0171,8848,8858,181X,182X,1D7X1,255A,255S,25B,25D,25H,26B,62E,681X,682X,781X,CTI,CTM,CTR,CYB10,CYB11 ISM,IT,Z Prefix