TPWD – Data Analyst III (Business Intelligence Analyst)

Organization

: PARKS AND WILDLIFE DEPARTMENT 

Primary Location

: Texas-Austin 

Work Locations

: DW-TPWD Headquarters 4200 Smith School Road  Austin 78744 

Job

: Computer and Mathematical 

Employee Status

: Regular 

Schedule

: Full-time Standard Hours Per Week: 40.00 

Travel

: Yes, 10 % of the Time State Job Code: 0652  Salary Admin Plan: B Grade: 22  

Salary (Pay Basis)

: 6,521.00 – 6,521.00 (Monthly) 

Number of Openings

: 1 

Overtime Status

: Exempt 

Job Posting

: Nov 20, 2024, 10:11:55 PM 

Closing Date

: Dec 12, 2024, 5:59:00 AM 

Description

TPWD MISSION

To manage and conserve the natural and cultural resources of Texas and to provide hunting, fishing and outdoor recreation opportunities for the use and enjoyment of present and future generations.

PLEASE NOTE: 

All applications must contain complete job histories, which includes job title, dates of employment (month/year) and hours worked per week, name of employer, supervisor’s name and phone number and a description of duties performed. 

Job history and volunteer experience should be listed in the work history section of the application to receive credit towards meeting the minimum requirements.  Part-time experience credit is prorated based on the duration and hours worked per week.  Please indicate hours worked for part-time/temporary/seasonal experience. If this information is not submitted, your application will be considered incomplete.

Applications with “See attached” or “See resume” will not be accepted in lieu of a completed application.  Omission of data can be the basis for disqualification; you may state ‘unknown’ for any incomplete fields. If education is used to meet the minimum requirements of the job posting, a copy of a college transcript(s) issued from the registrar must be provided if you are selected for an interview. 

WATCH OUR VIDEO ON HOW TO APPLY FOR JOBS

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, go to CAPPS Recruit to register or login. CAPPS Recruit, https://capps.taleo.net/careersection/ex/jobsearch.ftl?lang=en  

MILITARY OCCUPATIONAL SPECIALTY CODES:

Job Classification

Service

Military Specialty

Data Analyst I-VI

Army

25B, 35F, 35G, 35L, 35M, 255A, 350F, 350G, 351L, 351M, 352N

Data Analyst I-VI

Navy

CT, CTN, CIT, IS, IT, ITS, 181X, 182X, 681X, 682X, 781X, 782X

Data Analyst I-VI

Coast Guard

IS, IT, ISM, ISS, SEI15

Data Analyst I-VI

Marine Corps

0271, 0239, 2652, 2659, 6046, 6049, 8051, 8825, 8846, 8848, 8850

Data Analyst I-VI

Air Force

1N0X1, 1N1X1, 1N4X1, 1N7X1, 2R0X1, 3DOX1, 3D0X2, 3D0X4, 8K000, 14NX, 16KX, 15AX, 65FX, 65WX, 86P0

*More information on military occupational specialty codes can be found below:

https://www.onetonline.org/crosswalk/MOC/ https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MilitaryCrosswalkGuide.pdf

MILITARY EMPLOYMENT PREFERENCE:  If you choose to claim military employment preference as outlined by the State of Texas, you must attach the required documentation referenced below at the time your application is submitted. If you have questions regarding this requirement, please visit our Military Employment Reference page at https://tpwd.texas.gov/jobs/veterans/.

Required forms that will need to be attached with application for Military Employment Preference:

1. Veteran- DD214 showing honorable discharge or Statement of Service (only for transitioning service members who have not reached their date of separation).
2. Surviving spouse of a veteran who has not remarried- Marriage Certificate and DD Form 1300 or appropriate documentation.
3. Orphan of a veteran killed while on active duty- Birth Certificate and DD Form 1300 or appropriate documentation.
4. Spouse of a member of the US Armed Forces/Texas National Guard serving on Active Duty- Marriage Certificate and copy of spouses active duty military orders.
5. Spouse of a veteran with disability and is the primary income for household- Marriage Certificate, Veterans DD214, and VA Benefits Summary Letter showing disability rating.

Documentation must be attached to the application before military preference can be granted.

BENEFITS:

Texas Parks and Wildlife offers a variety of benefits for employees such as generous paid time off, group insurance, retirement and pension, and frequent training and staff development opportunities.  Other benefits include longevity pay, merit pay, deferred compensation, flexible benefit plans, 401K/457 retirement plans, direct deposit,  telework, staggered work hours, Employee Assistance Program and a Return to Work Program. For new employees or rehires, health insurance is available the 1st of the following month after a 60-day waiting period. Click HERE to view our Benefits page.

HIRING CONTACT: Tim Bradle, (512) 389-8560

PHYSICAL WORK ADDRESS: TPWD Headquarters, 4200 Smith School Road, Austin, TX 78744

GENERAL DESCRIPTION

Under the direction of the Business Management Program Director, this position provides data analytics, statistical analyses, financial monitoring, and data interpretation in support of driving business decisions within Business Management and the State Parks Division.  Performs moderately complex (journey-level) data analysis and data research work.  Ensures validation and integrity of park and site data in the reservation database and business system with report preparation.  Monitors and assists with implementing analytics and performance metrics of various inputs and key performance indicators. Provides expertise to Business Management personnel on creating and deploying data procurement and data sourcing techniques and collection of information related to park visitors. Work involves data analysis and data reporting related to park visitor demographics, revenue-generation, customer service, marketing and outreach, leased concessionaire performance, organizational operations, financial analysis, and enterprise programs associated with the public use of State Parks.  Provides summary of analysis to leadership through presentations or written correspondence.  Additional duties require utilizing compiled research and statistical methods to identify user trends, user satisfaction, data correlations, service needs and business opportunities.  Performs data reporting to include various techniques such as statistical analysis, forecasting, automated report generation, text mining, and data visualization.  Work also includes design and assisting with the development of administrative and financial reports for use by program management utilizing multiple systems, such as Excel, PBS, Aspira, SAS, ESRI Business Analyst, Power BI and Tapestry.  Bridges business problems with internal/external technology support and solutions.  Works under general supervision, with limited latitude for the use of initiative and independent judgment.  Performs additional duties as assigned.  Complies with all Agency, Division and Branch rules, regulations and procedures.

Qualifications

MINIMUM QUALIFICATIONS:

Education:

Graduation from an accredited college or university with a Bachelor’s degree.

Experience:

Three years of experience in data analytics, such as: sourcing, analyzing, visualizations, and reporting data, business management or budget or financial analysis.

NOTE:  Experience may be obtained concurrently.

Licensure:

Applicant must possess a valid State driver’s license.

NOTE:  Retention of position contingent upon obtaining and maintaining required license

ACCEPTABLE SUBSTITUTIONS:

Education:

One additional year of the required experience in data analytics such as: sourcing, analyzing, visualizations, and reporting data, business management or budget or financial analysis may substitute for 30 hours of the required education, with a maximum substitution of 120 semester hours.

PREFERRED QUALIFICATIONS:

Education:      

Graduation from an accredited college or university with a Bachelor’s degree in Data Analytics, Business, Business Administration, Accounting, Finance, or closely related field.

Experience: 

One year of leadership/supervisory experience;

Experience in budget, financial, management analyses and examination procedures;

Experience in advanced use of Microsoft Excel to include complex formula writing, pivot tables, and/or use of Macros;

Experience in project management;

Experience in data tools such as SAS, SQL, Python, Power BI and/or other. 

KNOWLEDGE, SKILLS, AND ABILITIES:

Knowledge of principles and processes involved in business and organizational planning, coordination and execution;

Knowledge of management practices and standards;

Knowledge of analytical programs and software;

Knowledge of marketing and business analytics;

Knowledge of data models, database design development, data mining, and segmentation techniques;

Knowledge of recordkeeping, including security procedures for handling, protecting, and distributing confidential data;

Knowledge in data forecasting techniques;

Skill in SAS and ESRI Business Analyst with Tapestry;

Skill in data analytics coding language(s);

Skill in advanced use of MS Excel or Power BI;

Skill in data visualization and producing reports and presentations;

Skill in automated reporting techniques for routine requirements;

Skill in effective verbal and written communication;

Skill in managing resources, people and workload;

Skill in establishing and maintaining effective work relationships with co-workers and work-related contacts;

Skill in making independent, sound and timely decisions;

Skill in identifying, researching and compiling information;

Skill in critical thinking and problem solving;

Skill in evaluating and translating large amounts of data;

Ability to identify, compile and analyze financial and business data;

Ability to lead and develop a team within a program;

Ability to create and implement a strategic plan;

Ability to complete projects timely and accurately;

Ability to manage multiple projects simultaneously;

Ability to interpret regulations and statutes;

Ability to communicate effectively.

WORKING CONDITIONS

Required to work from 8:00 a.m. to 5:00 p.m., Monday through Friday;

Required to work overtime, as necessary;

Possibility to work remotely two days per week after the first 6 months;

Must conform to TPWD dress and grooming standards, work rules, and safety procedures;

Required to travel 10% with possible overnight stays;

Non-smoking environment in State buildings and vehicles.

TPWD IS AN EQUAL OPPORTUNITY EMPLOYER

WATCH OUR VIDEO ON HOW TO APPLY FOR JOBS