Systems Analyst V/Tableau Developers

Systems Analyst V / Tableau Developers - If you have great Tableau developer skills and are a strong SQL coder, here is an exciting opportunity to be part of the Data and Decision Support (DDS) division within the Office of Data and Systems Improvement (ODSI) at the Department of Family and Protective Services (DFPS) agency. ODSI’s mission is to ensure effective coordination, communication and consistency around data reporting and how it’s used in understanding and improving performance and outcomes. DDS supports that mission by providing Tableau-based reports (as well as other outputs) that empower DFPS leadership and stakeholders to the best decisions backed by relevant, high-quality information. The person in this position reports to the manager of the DDS Data Reports Engineering Analytics Management team (DREAM)., * The person in this position will, after reviewing requirements and system review, provide cost estimation for work assigned, and develop a variety of reports and visualizations in an understandable, useable format. They will assist in the development and deployment of the DFPS online interactive data book. They will also use their flexible skill set to complete many other special projects assigned to the unit.

• The person in this position will perform advanced (senior level) computer systems analysis work involving analyzing and identifying user requirements, procedures, and problems to automate processing or to improve existing systems.
• The person in this position will help troubleshoot advanced technical issues and provide excellent customer support to staff with questions about agency dashboards.
• The person in this position will extract data from IMPACT, and other agency and external databases, and document, design, validate and implement reports for multiple areas of specialization using selected DFPS methodology and reporting tools, such as with Tableau Desktop and SQL queries.
• The person in this position will perform quality assurance tasks effectively to ensure accuracy of data in all report deliverables, review work products of other analysts and will interact routinely DFPS staff and analysts to ensure requirements are met and work products are appropriately validated.
• The person in this position will serve as a lead on some assigned projects or any level of complexity and may train or mentor other analysts. .
• The person in this position will perform their job duties remotely (telework, work from home) and will keep regular work hours in accordance with agency policy., Salary range is between $5,797.67 and $9,508 (monthly) depending on the level at which the position is filled and the department budget. The position is filled in accordance with agency policies.

The position is filled in accordance with agency policies. The person in this position will perform their job duties remotely (telework, work from home) within the state of Texas and will keep regular work hours in accordance with agency policy.

Agency has the discretion to identify the general or specialized experience, education, or certifications required for positions and may tailor qualification requirements to be specific and meet the agency’s business needs.

Work outside of regular hours, including occasional weekends, may be required. Occasional overnight travel to other work locations may be required.

Applicants selected for an interview will be required to complete a written exercise to demonstrate knowledge, skills, and abilities.

Review our Tips for Success when applying for jobs at DFPS, DSHS and HHSC.

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor’s Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor’s Office - Job Descriptions. You may also contact the DFPS Military Liaison at dfpsmilvets@dfps.texas.gov with additional questions.

Applicants selected for hire must pass a background check and if applicable a driver’s record check.

State of Texas employees are required to maintain the security and integrity of critical infrastructure as defined in Section 117.001(2), State of Texas Business and Commerce Code. Applicants selected for hire comply with this code by completing related training and abiding by agency cybersecurity and communications system usage policies.

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 .

Knowledge of relational databases.

Knowledge of and familiarity with personal computer hardware and peripheral equipment.

Knowledge of data processing practices and theory.

Knowledge of Bitbucket, Informatica or Data Bricks.

Skill in:

Skill in using selected software such as Tableau Desktop, Tableau Prep, SQL, PL/SQL, Excel, TOAD and/or Oracle SQL Developer.

Skilled in critical thinking.

Skills in utilizing Microsoft Office Suite of products. Skill in computer systems, coding, management reporting, and data warehouse functions.

Skill in analyzing problems and devising effective solutions.

Ability to:

Ability to effectively manage workload and work schedule while working remotely.

Ability to be customer service focused.

Ability to analyze systems, procedures and troubleshoot problems to help develop solutions.

Ability to perform detailed work accurately.

Ability to learn and apply new technology.

Ability to draft concise reports, with visual representations, and to make oral presentations to a variety of audiences.

Ability to work constructively in a team, and on one’s own.

Ability to adapt and modify behavior in response to changes in situations or priorities.

Ability to analyze complex procedures and data.

Ability to evaluate technical data and develop logical conclusions.

Ability to prepare and present comprehensive reports and recommendations in written and oral form.

Ability to communicate, coordinate and gain rapport with external and internal business partners.

Ability to analyze functional/design requirements and to develop solutions to implement the requirements.

Ability to perform detailed work accurately and in accordance with standards., * An accredited bachelor’s degree applicable to the position

• Experience with creating Tableau dashboards - minimum 1 year
• Experience in writing SQL and/or PL/SQL code.
• Experience with TOAD, Oracle SQL Developer.
• Experience in data extraction and report layout and design.
• Experience in using Excel.

Agency also may substitute experience and education for one another, if appropriate and allowed by statute.

Preferred:

DFPS experience preferred.

DFPS Experience as a Systems Analyst IV is accepted with consistently exhibiting skills equivalent to the higher experience level.

Knowledge of Bitbucket, Informatica, or Databricks

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: Abilene; Alamo; Alice; Alpine; Alvin; Amarillo; Anahuac; Andrews; Angleton; Anson; Aransas Pass; Archer City; Arlington; Athens; Atlanta; Austin; 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

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.