TWDB - 25-26 - Junior Data Analyst/Power BI Specialist (Data Analyst I-II) (00046046) Organization: TEXAS WATER DEVELOPMENT BOARD Primary Location: Texas-Austin Work Locations: TWDB Stephen F Austin Bldg 1700 Congress Ave PO Box 13231 Austin 78711 Other Locations: Texas-Harlingen, Texas-Houston, Texas-Mesquite Job: Computer and Mathematical Employee Status: Regular Schedule: Full-time Standard Hours Per Week: 40.00 Travel: Yes, 5 % of the Time State Job Code: 0650 Salary Admin Plan: B Grade: 18 20 Salary (Pay Basis): 3,543.42 - 5,652.32 (Monthly) Number of Openings: 2 Overtime Status: Exempt Job Posting: Nov 18, 2024, 3:59:46 PM Closing Date: Dec 3, 2024, 5:59:00 AM Description Salary commensurate with experience and qualifications Salary Ranges: Data Analyst I - $3,543.42/monthly - $4,833.33/monthly Data Analyst II - $4,840.00/monthly - $5,652.32/monthly 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 Performs entry-level to routine (journey level) data analysis and data research work within the Texas Water Development Board’s (TWDB) Technical Systems Oversight (TSO) Department. Work involves conducting analysis of and research on data, providing results, visualizing data, and monitoring and implementing data quality. Analyzes and reports on the TWDB’s financial assistance and project information maintained within TxWISE, the agency-wide database. Identifies and interprets data patterns and trends and assesses data quality following standard procedures. Works within cross-divisional, cross-office teams in routine data gathering and analysis projects. Assists with building and maintaining visual tools and dashboard systems, including queries and reports. Assists other staff in the TSO team in completing and implementing long-term projects. Works under close supervision to moderate supervision under the guidance, of the TSO team’s Senior Data Analyst, with minimal to limited latitude for the use of initiative and independent judgment. Reports to the Manager of the Technical Systems Oversight Department. Essential Job Functions Writes and runs queries for data collection, extraction, and analysis using SQL-based programs and other data analytic software. Responds to requests for information on an ad hoc basis for internal and external customers. Contributes to and assists in maintaining a library of data analysis tools, queries, databases, and reports for the Technical Systems Oversight (TSO) team. Assists with developing software applications or programming as a means for improvements in operational efficiencies. Documents desktop procedures related to routine tasks and standard procedures. Works with cross-divisional teams to collaborate on long-term projects. Assists other staff of the TSO team in completing and implementing long-term projects and agency initiatives. Collects, produces, and maintain supporting documentation for data analysis and projects and maintain standards of source documents. 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 or Information Science, Statistics, Social or Political Science, Planning, Statistics, Mathematics, Engineering, Business, Finance, or a relate field. Work Experience: Data Analyst I - Relevant work experience in data analysis, business analysis, or a related field. Data Analyst II - One year of relevant work experience in data analysis, business analysis, or a related field. Experience with Microsoft Power BI, or similar software, building data visualization tools. Resides in Texas or willing to relocate to Texas at their own expense. Relevant education and experience can be substituted for each other on a year-for-year basis Preferred Qualifications Two or more years of progressive work experience with data analysis, business analysis, or a similarly related field. Two or more years of progressive work experience with financial assistance programs, procurements, and/or grants within the water industry, engineering field, finance industry, a governmental agency, and/or another related industry. Experience with SQL Server Management Studio, or similar software, building queries and reports. Experience building tables and manipulating data with Microsoft Excel. Experience with a GIS system analyzing and displaying geographic data. State agency database data entry experience. Knowledge, Skills, and Abilities (KSAs) Knowledge of local, state, and federal laws and regulations relevant to the Technical Systems Oversight (TSO) Department. Knowledge of the principles and practices of public administration. Knowledge of financial systems, word processing, database querying, and spreadsheets. Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar. Knowledge of state and federal financial assistance programs. 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 using Microsoft Teams, Project, Planner, and other organization software applications. Skills in identifying complex problems and reviewing related information to develop and evaluate options and implement solutions. Skills in interpersonal communications and the ability to interact effectively with a wide variety of customers and stakeholders. Ability to work accurately with numerical details in a fast-paced, high-volume setting. Ability to analyze and interpret financial data. Ability to communicate effectively both verbally and in writing. 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 provide prompt, courteous, and accurate assistance. Uses 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 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 in routine tasks. 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 BoardStephen F. Austin Building1700 North Congress AvenueAustin, Texas 78701hr@twdb.texas.govPhone: (512) 475-2142
