TWDB - 24-135 - Data Services Analyst (Data Analyst III)

Job Description

Salary commensurate with experience and qualifications

This position requires an in office presence in downtown Austin once a week and as needed per managers request.

TEXAS WATER DEVELOPMENT BOARD'S MISSION

Leading the state's efforts in ensuring a secure water future for Texas.

WORKING AT THE TWDB

See why our work makes an impact and why the TWDB is a great place to work!

The Texas Water Development Board (TWDB) endorses telecommuting and hybrid workplace plans, in addition to other flexible work alternatives. We offer competitive compensation and benefits package including medical, dental, vision, 401(k), flexible spending, and flexible work hours so you can have a work/life balance! For more information about these benefits and more visit:

http://www.twdb.texas.gov/jobs/benefits.asp.

Please visit TWDB Career Page: http://www.twdb.texas.gov/jobs/ for more information.

MILITARY EMPLOYMENT PREFERENCE

Veterans, Reservists or Guardsmen with an MOS or additional duties that fall in the fields of 25B Information Technology Specialist, 183X Intelligence Officer, 15AX Operations Analysis Officer, or other related fields pertaining to the minimum experience requirements may meet the minimum qualifications for this position and are highly encouraged to apply.

Additional Military Crosswalk information can be accessed at https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_PlanningResearchandStatistics.pdf

Job Description Summary

The Texas Water Development Board is a data driven agency with highly motivated and engaged employees. Our agency's mission is to lead the state's efforts in ensuring a secure water future for Texas and its citizens. We are currently seeking a talented Data Analyst to join our Data Services Department.

This individual will perform moderately complex (journey-level) data analysis and data research work. Work involves delivery of quality reporting and business intelligence solutions to the agency. Assists client teams by providing insight to make informed, data driven decisions. Engages in all phases of the data management lifecycle. Gathers and analyze requirements, researched, collects, processes, stores and secures data. Shares, communicates, archives, reuses and repurposes data. May train others. Works under general supervision, with limited latitude for the use of initiative and independent judgment. Reports to the Manager of the Data Services Department.

Essential Job Functions

• Elicits business requirements for data analysis, development of technical specifications and UAT specs.
• Delivers analysis solutions.
• 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.
• Coordinate Data Governance efforts with Data stewards and cross functional teams across the agency. Contribute to Data Governance agenda and roadmap.
• Coordinates the analysis of program policies and procedures to determine their effect on automated systems and system functional areas.
• Coordinates and/or analyzes user requirements, procedures, and problems to automate or improve existing systems.
• Analyzes computer system capabilities, workflow, and scheduling limitations.
• Conducts fit gap analysis.
• Identifies opportunities for improving business processes through automation.
• Assists in the preparation of proposals to develop new systems.
• Designs and implements data analysis and reports using SSRS, Power BI, MS Excel or other reporting tools.
• Implements efficient defect management, root cause analysis, and resolution processes.
• Assists in setting technical direction for the team and analyzes data using standard statistical tools, methods, and techniques.
• 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.
• Implements Data Quality check routines and exceptional handling.
• Assists in defining, developing, and implementing data standards.
• Develops databases, data collection systems, data analytics, and other strategies that optimize efficiency and quality for M/L, AI algorithms.
• Develops goals and objectives for the use and improvement of an efficient and cost-effective data system.
• Maintains confidential and sensitive information.
• Ensures individual and team files (electronic and hard versions) are appropriately maintained and timely disposed of in accordance with the agency's records retention procedures and schedule.
• Maintains required certifications and licenses and meets the continuing education needs and requirements of the position to include, attending mandatory training courses.
• May be required to operate a state or personal vehicle for business purposes.
• Performs other duties as assigned.

Qualifications:

Minimum Qualifications

• Graduation from an accredited four-year college or university with a bachelor's degree in Data Science, Business Analytics, Computer Science, Information Science, Information Technology, or a related field.
• Three years of relevant work experience in Data Analysis, SQL, Business requirements gathering, or BI reporting.
• Willingness/ability to work in office in downtown Austin once a week and as needed per managers request.
• Relevant education and experience can be substituted for each other on a year-for-year basis.

Preferred Qualifications

• Experience in developing ETL pipelines in Python and cloud-based data technologies (AWS, Snowflake, Azure).
• Experience in Project Management, Data Governance
• Candidates currently in or willing to relocate to the Austin Metro area.

Knowledge, Skills, and Abilities (KSAs)

• Knowledge of local, state, and federal laws and regulations relevant to Data Services Department.
• Knowledge of the principles and practices of public administration.
• Knowledge of Windows Server 2012/2016/2019.
• Knowledge of data modeling concepts (star schema, snowflake, denormalization, M/R/HOLAP).
• Knowledge of project management and software development lifecycle.
• Knowledge of features and limitations of current Internet/Intranet web development technologies including .NET, C#, VBScript and JavaScript.
• Skills in using Microsoft Office programs such as Word, Excel, and Access.
• Skills in use of internet, email, word processing, spreadsheet, presentation, and database software.
• Skills in constructing stored procedures and performance optimization techniques.
• Ability to adhere to work schedules, follow procedures with respect to leave and submit accurate timesheets by prescribed deadlines.
• Ability to make mature, objective decisions and identify areas of potential problems.
• Ability to perform effectively and willingly when changes occur in scope and nature of the work and work environment.
• Ability to perform routine and non-routine work assignments accurately and on-time with little or no supervision.
• Ability to perform assigned duties and improve work habits and/or output.
• Ability to complete assigned work, on time, neatly and with infrequent errors.
• Ability to interpret policies, procedures, and regulations.
• Ability to provide prompt, courteous and accurate assistance and clear and concise communication to internal and external stakeholders both verbally and in writing.
• Ability to work and cooperate with others in a team environment.
• Ability to manage multiple tasks.
• Ability to stand/sit/move to perform activities such as retrieve/replace files in a large file system for boxes up to 30 lbs.
• Ability and willingness to travel 5% of the time, primarily within the State of Texas.
• Ability to operate a vehicle (state or personal) for state business and maintain a driver's license and driving record that complies with state and agency requirements.
• Ability to work shifts that may exceed 8 hours, including early mornings, nights, and weekends.
• Ability to train others.

REMARKS

• A copy of required academic transcripts and/or licensures and driving record must be submitted at the time of hire. Failure to provide required documentation will result in no further consideration for employment.
• Important Notice: Otherwise qualified candidates who are ultimately considered for potential employment with the Texas Water Development Board may be the subject of a request for any criminal history record information maintained by the Texas Department of Public Safety (DPS). Evidence of a criminal conviction or other relevant information obtained from the DPS shall not automatically disqualify an individual from employment with the Texas Water Development Board.

APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS

• Work In Texas (WIT) applicants must complete the supplemental questions to be considered for the posting. To complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile.

EQUAL OPPORTUNITY

• The Texas Water Development Board does not discriminate on basis of race, color, national origin, sex, religion, sexual orientation, age, or disability in employment or provision of services, programs, or activities.

SELECTIVE SERVICE

• Males born on or after January 1, 1960, will be required to present proof of Selective Service registration on the first day of employment or proof of exemption from Selective Service registration requirement.

FINAL EMPLOYMENT OFFERS

• All offers of employment are contingent upon the candidate having legal authorization to work in the United States. Failure to present such authorization within the time specified by the U.S. Department of Labor will result in the offer being rescinded.

FOREIGN CREDENTIALS

• An evaluation of your coursework must be uploaded if you have obtained a degree(s) from a school outside of the United States; otherwise, you will not receive credit for degree progress and completion.

SPONSORSHIP

• Candidates must be eligible to work in the United States without requiring sponsorship.

STATE OF TEXAS APPLICATION

• Resumes will not be accepted in place of a completed State of Texas application unless indicated.

E-VERIFY

• TWDB participates in E-Verify! Information from each new employee's Form I-9 will be provided to the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) to confirm work authorization.

EMPLOYMENT AT-WILL

• Employment with the Texas Water Development Board (TWDB) is on an at- will basis.

AMERICANS WITH DISABILITIES ACT

• The TWDB is in compliance with the Americans with Disabilities Act and makes reasonable accommodations for applicants and employees with disabilities. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits of employment, please contact the Human Resources Division for assistance at (512) 475-2142. Deaf and hard of hearing applicants may contact our office via Relay Texas at 1-800-735-2989 (TTY/TDD).

HEADQUARTER LOCATION AND CONTACT INFORMATION

Texas Water Development Board

Stephen F. Austin Building

1700 North Congress Avenue

Austin, Texas 78701

hr@twdb.texas.gov

Phone: (512) 475-2142