Systems Analyst V/Tableau Developers
About The Position
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. This 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). We’re looking for someone who wants to dedicate their data and reporting skills to serving and protecting the most vulnerable Texans. Someone who is excited to be a part of an established team of highly skilled, capable, and motivated individuals. We want someone who is intellectually curious, wanting to understand not just what is happening but why, and who’s not afraid to think outside the box for innovative and new ways of doing things. At DDS we take the data collected during the critical field work done by caseworkers, and work to make that data available and consumable in order to help the agency make better data driven decisions.
Requirements
- 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.
- Knowledge of relational databases.
- Knowledge of and familiarity with personal computer hardware and peripheral equipment.
- Knowledge of data processing practices and theory.
- 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 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.
Nice To Haves
- 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.
Responsibilities
- Provide cost estimation for work assigned, and develop a variety of reports and visualizations in an understandable, useable format after reviewing requirements and system review.
- Assist in the development and deployment of the DFPS online interactive data book.
- 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.
- Troubleshoot advanced technical issues and provide excellent customer support to staff with questions about agency dashboards.
- 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.
- Perform quality assurance tasks effectively to ensure accuracy of data in all report deliverables.
- Review work products of other analysts.
- Interact routinely with DFPS staff and analysts to ensure requirements are met and work products are appropriately validated.
- Serve as a lead on some assigned projects or any level of complexity.
- Train or mentor other analysts.
Benefits
- 100% paid health insurance for you, and 50% paid for eligible family members
- Retirement plans with lifetime monthly payments after five years of state service
- Options to save even more with 401(k) and 457 plans
- Paid vacation, holidays, and sick leave
- Optional dental, vision, and life insurance
- Flexible spending accounts for added tax savings on health and dependent care
- Employee discounts on things like gym memberships, electronics, and entertainment
- Public Service Loan Forgiveness
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
