Tableau Developer

WHY WORK FOR DFPS?

The Texas Department of Family and Protective Services (DFPS) is responsible for protecting the unprotected — children, elderly, and people with disabilities — from abuse, neglect, and exploitation. DFPS accomplishes this responsibility by employing over 12,000 workers who live up to the agency's Mission, Vision, & Values in service to the citizens of Texas. DFPS is not only a qualifying organization for the Public Service Loan Forgiveness Program but also offers excellent health benefits, special discounts on many products and services through the Discount Purchase Program, longevity pay, generous paid leave, access to the Wellness program, lifetime retirement annuity, Texa$aver 401(k) and 457 Programs under the Employees Retirement System of Texas.

Brief Job Description:

Systems Analyst V / Tableau Developers - If you have great Tableau developer skills or you 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 data and SQL based / Tableau based reports 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).

Essential Job Functions (EJFs):

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 DFPS, and work to make that data available and consumable in order to help the agency make better data driven decisions.

The specific job functions:
-- The person in this position will 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 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, PIERS, 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 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 may train or mentor other analysts in DDS.
--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. 

Knowledge, Skills and Abilities (KSAs):

Knowledge of: 

Knowledge of relational databases.
Knowledge of and familiarity with personal computer hardware and peripheral equipment.
Knowledge of data processing practices and theory.

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.

Registrations, Licensure Requirements or Certifications:

NA

Initial Screening Criteria:

Required - Experience with creating Tableau dashboards - minimum 1 year

                Experience in writing SQL code.
                Experience in using Excel.

                Experience with TOAD, Oracle SQL Developer.
                Experience in data extraction and report layout and design.
Preferred - DFPS experience.

Additional Information:

Salary range is between $5,797.66 and $9,508.25 (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 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.

Work outside of regular hours, including occasional weekends, may be required. Occasional overnight travel to other work locations may be required. In compliance with the Americans with Disabilities Act (ADA), agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.
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.

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 .

In compliance with the Americans with Disabilities Act (ADA), HHS/DFPS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS/DFPS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.