Texas Water Development Board
TWDB - 25-26 - Junior Data Analyst/Power BI Specialist (Data Analyst I-II)
Texas Water Development Board, Austin, Texas, us, 78716
Please paste the following URL into a browser to view the entire job posting in the CAPPS Career Section: https://capps.taleo.net/careersection/ex/jobdetail.ftl?job=00046046 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
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 BOARDS MISSION Leading the states 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 of25B 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 Boards (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 TWDBs 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 teams Senior Data Analyst, with minimal to limited latitude for the use of initiative and independent judgment. Reports to the Manager of theTechnical 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 mainta ned and timely disposed of in accordance with the agencys 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 na
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 BOARDS MISSION Leading the states 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 of25B 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 Boards (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 TWDBs 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 teams Senior Data Analyst, with minimal to limited latitude for the use of initiative and independent judgment. Reports to the Manager of theTechnical 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 mainta ned and timely disposed of in accordance with the agencys 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 na