Please paste the following URL into a browser to view the entire job posting in the CAPPS Career Section: You may apply to the job directly through the CAPPS Career Section. It is not necessary to apply both through Work In Texas and CAPPS Career Section This position is eligible for remote work within the state of Texas (subject to change). Must attend meetings/trainings at headquarters in Austin, TX as required by management. To apply for this position, complete an on-line application either through the Applicant Career Section through WorkInTexas. TxDMV does not accept paper applications. Applicants who require an accommodation for the interview process should contact Human Resources at when contacted to schedule an interview. GENERAL DESCRIPTION Our mission at the Texas Department of Motor Vehicles (TxDMV) is to serve, protect and advance the citizens and industries in the state with quality motor vehicle related services. We are a dynamic state agency dedicated to customer service, consumer protection and the success of motor vehicle-related industries. Under the direction of the Data Management Officer, performs complex (journey-level) data analysis and data visualization assignments for the Enterprise Data Management (EDM) team. Work involves conducting detailed analysis of data, including leveraging statistical techniques; developing proof of concept mockups to ensure data quality; and converting raw data into database table structures from a variety of source formats. Interprets business requirements to be used as input to performance measure visualizations and reports for large and complex agency programs. Mentors internal staff and trains others. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. Performs other duties as assigned. This position reports to the agency Data Management Officer. ESSENTIAL DUTIES Analyzes data using standard statistical tools, methods, and techniques. Identifies, collects, and analyzes data needed to develop reports, briefings, and presentations. Consults with internal and external customers to understand the business requirements that drive the analysis and design of visualizations and reporting solutions. Interprets, designs, develops, and maintains measures, dashboards, and reports utilizing data visualization tools. Compiles, queries, calculates and/or loads data using CSV files, SQL and other query languages from a variety of source formats. 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. Provides data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data; cleans and prepares data, as necessary. Maintains data dictionary and documentation for databases and reports that captures data mapping, transformation rules and business definitions. Actively contributes to the continuous improvement of TxDMV enterprise reporting through initiatives including: inventorying and mapping enterprise reports, creating and maintaining data dictionaries, automating manual reporting processes, and maintaining design consistency across multiple visualizations and reports. Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions. Assists in defining, developing, and implementing data standards. Assists in developing data quality measures, analyzing data quality results, and implementing necessary changes to ensure data quality improvement. Assists in developing software applications or programming t use for statistical modeling and graphic analysis. May develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality. May perform quality assurance and serve as a subject matter expert on data integrity, extraction, and compilation. May guide the selection of data management tools, and the development of standards, usage guidelines, and procedures for those tools. May assist with preparing and conducting presentations of performance visualizations and reports. May provide guidance to others. Travels up to 5% of the time. Travels by car (may include flying). May include overnight travel. May require working extended hours and some evenings and weekends, as needed. Required to attend work regularly and adhere to approved work hours in accordance with department policies and procedures. Performs related work as assigned. KNOWLEDGE, SKILLS, AND ABILITIES Knowledge of data visualization development, including data model creation, advanced calculations, and interactive visualizations. Knowledge of relational databases and database design. Knowledge of custom SQL Table/View creation with multi-level join conditions. 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. Knowledge of computer programming principles, spreadsheet macros, and design logic. Knowledge of basic concepts related to data warehousing and data marts. Knowledge of concepts related to Extraction, Transformation, and Loading (ETL) workflows. Skill in performing queries, extracting and joining data, and loading data using SQL and/or other query languages. Skill in creating graphical user interfaces, mockups, prototypes, and design documents. Skill in critical thinking and problem solving. Skill in using EXCEL or other spreadsheet software. 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. Ability to translate complex data into user-friendly information. Ability to identify problems, evaluate alternatives, and implement effective solutions. Ability to build, establish, and maintain effective working relationships and coalitions. Ability to plan, organize, and conduct data analytic projects. Ability to develop and interpret statistical data charts, maps, and tables. The above statements are not a complete list of all responsibilities, duties and skills held or performed by employees in this job. Employees may perform other related duties as assigned. Qualifications: MINIMUM REQUIREMENTS Education Graduation from an accredited four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field Experience Training Required Three (3) years experience in data analysis and visualization work. Experience in data analysis, research, compilation, and/or reporting work. Experience
data-dictionary Data Management Tools Data Marts data-integrity statistics Analytical skills data-management Data Querying Languages Attention to details data-collections transformation Communication Critical thinking extract data cleansing Microsoft Excel data-quality Data Analyst standards Problem-solving data-warehouse Quality Assurance (QA) data-visualization compilation Computer Skills database-design project-planning SQL data-mapping Relationship Management RDBMS Statistical tools