Data Analyst V

The Texas Department of Family and Protective Services (DFPS) is currently seeking a senior Data Analyst within the Chief Technology Office (CTO) team of ITS Department to perform advanced data analysis, research and data governance work.

Performs advanced data systems analysis, research and data governance work. Work involves coordinating the planning and analysis of data modeling; conducting detailed analysis of and extensive research on data, providing results to implement and manage database systems, data warehouses, and data analytics, ensuring data quality; and working in a team environment in designing strategies and setting standards for development, operations and programming.

The mission of DFPS is to protect children, the elderly, and people with disabilities from abuse, neglect, and exploitation by involving clients, families, and communities. We are looking to grow our teams with people who share our energy and enthusiasm to get behind our mission of protecting those among us who are most in need.

The Data Analyst works under minimal supervision, with considerable latitude for the use initiative and independent judgement.

Essential Job Functions:

• Performs highly complex (senior-level) data analysis and data research work. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment.

• Guide the selection of data management tools and the development of standards, usage guidelines, and procedures for those tools.

• Define, develop, and implement data and reporting standards

• Implements data archival and data retention policies.

• Develop data quality measures, analyze data quality results, and implement necessary changes to ensure data quality improvement

• Develop software applications or programming to use for statistical modeling, data analysis, and graphic analysis.

• Implementation experience of data protection and data encryption techniques.

• Help set/inform standards and compliance for Data Security and Privacy

• Experience applying security principles to data management and governance processes.

• Analyzes data using standard statistical tools, methods, and techniques.

• Consults with internal and external customers to identify user needs.

• Compiles and queries data.

• Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.

• Interprets results to identify significant differences in data. Identifies and interprets data patterns and trends and assesses data quality.

• Cleans and prunes data to discard irrelevant information.

• Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions.

• May develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.

• Knowledge of statistics and analyzing data sets; of running queries, report writing, and presenting findings; of data models, database design development, data mining, and segmentation techniques; and of record keeping, including security procedures for handling, protecting, and distributing confidential data.

• Skill in the use of a computer and applicable software, in analyzing problems and devising effective solutions, in conducting data searches, in evaluating and translating large amounts of data, and in critical thinking.

• Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; to communicate effectively; and to provide guidance to others.

• Performs related work as assigned.

• Skill in analyzing and eliciting business requirements, to translate them and develop business a business centric view of data management.

• Build use case requirements for data, data quality management, business data glossary management.

• Leverage tools and technology to develop an agency wide access point for key program terminology.

• Participate in the agency's data governance program and work with business stakeholders to identify key datasets as candidates for MDM and define associated data quality rules and measures.

• Contribute ideas and explore new technology while gaining excellent insights into the core functions of the agency to facilitate adoption of data governance policies within IT processes and project management activities.

• Provide data management and governance guidance and best practices in new, changing, and complex technology environments: cloud and on premise.

• Assist in implementation and maintenance of Business Metadata by entering new and/or updating existing business/logical names, definitions, and valid values in a business metadata repository.

• Recommend deployment of tools to monitor and control data quality to business data owners and determine the level of business impact for data quality issues.

• Work with IT Data management team to establish, monitor and maintain data processes and provide recommendations to support integration of data security and privacy standards for agency data platforms.

Knowledge Skills Abilities:

• Bachelor's degree in relevant field; Information Technology, Computer Science or Engineering

• Strong SQL skills are required. SQL queries and PL/SQL development (creating packages, procedures, etc.)

• Data warehousing processes (refreshing and freezing data, Unix scripting, ETL processes, etc.)

• Informatica ETL development

• Report building and automation (.ASP files, automated reporting, Tableau, etc)

• Python development skills

• R programming skills

• Data management, data governance and MDM implementation experience

• Experience interacting with master data management and data quality tools.

• Experience with data modeling tools.

• Strong knowledge and working experience of data governance concepts and frameworks

• Must have experience with relational database systems, data architecture and data modeling

• Data profiling experience

• Excellent communication skills verbally and in writing used when leading development activities, presenting to leadership, and training less experienced IT staff. keen attention to detail

• Experience performing problem analysis for data-related issues and developing solutions to resolve data quality issues

• Ability to develop positive and collaborative relationships with business partners and effectively communicate with both business and technology data stakeholders

• Experience with data/reporting tools like

• Microsoft Power BI

Registration or Licensure Requirements:

Initial Selection Criteria:

• Graduation from a four-year college or university with major coursework in computer engineering, computer science, information systems, information technology or related field. Work experience may be substituted for education on a year-for-year basis.

• Data management, data governance and MDM (Master Data Management) implementation experience

• Experience with relational database systems, data architecture and data modeling

• Experience performing problem analysis for data-related issues and developing solutions to resolve data quality issues

Additional Information:

MOS Code:

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include 25B, 255A, 255S, IT, 182X, 682X, 782X, 275, 26, 030, C4|10, C4|11, ISM, 0171, 8846, 8858, 3D0X4. All active duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information see the Texas State Auditor's Military Crosswalk at http://www.hr.sao.state.tx.us/Compensation/JobDescriptions.aspx.

As a state agency, DFPS is required 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.

HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.

I-9 Form

• Click here to download the I-9 form.

In compliance with the Americans with Disabilities Act (ADA), HHS 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.