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.
EXCELLENT 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, staggered work hours, Employee Assistance Program and a Return-to-Work Program. For new employees or rehires, health insurance is available on the 1st of the following month after a 60-day waiting period. Click HERE to view our Benefits page.
PLEASE NOTE:
All applications must contain complete job histories in the WORK HISTORY SECTION to include
- Job Title
- Dates of employment (month/year)
- Hours worked per week
- Name of Employer, Name of Supervisor and Phone Number
- Description of duties performed
- Volunteer experience credit is counted toward any experience requirement. Please list those experiences 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.
- Omission of data can be the basis for disqualification; you may state ‘unknown’ for any incomplete fields.
- College Transcripts are required at the time of interview (unless otherwise noted on the posting) 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.
- Applications with “See attached" or "See resume" will not be accepted in lieu of a completed application.
- Work In Texas (WIT) Applications: WIT applicants are required to complete the supplemental questions to be considered for the posting. To complete the supplemental questions, login to CAPPS Recruit.
IF THIS INFORMATION IS NOT SUBMITTED, YOUR APPLICATION WILL BE CONSIDERED INCOMPLETE.
MILITARY OCCUPATIONAL SPECIALTY CODES:
Job Classification
Service
Military Specialty
Systems Analyst I-VII
Army
25B, 25D, 25N, 255A, 255S, 26B
Systems Analyst I-VII
Navy
CT, CTM, CTR, IT, 181X, 182X, 681X, 682X, 781X, 782X
Systems Analyst I-VII
Coast Guard
IT, CYB10, CYB11, ISM
Systems Analyst I-VII
Marine Corps
0171, 8848, 8858
Systems Analyst I-VII
Air Force
3D0X2, 3D0X4
Systems Analyst I-VII
Space Force
Z Prefix, 62E
- 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:
- Veteran- DD214 showing honorable discharge or Statement of Service (only for transitioning service members who have not reached their date of separation).
- Surviving spouse of a veteran who has not remarried- Marriage Certificate and DD Form 1300 or appropriate documentation.
- Orphan of a veteran killed while on active duty- Birth Certificate and DD Form 1300 or appropriate documentation.
- 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.
- 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.
HIRING CONTACT: Wayne Baker, (512) 389-4516
PHYSICAL WORK ADDRESS: TPWD Headquarters, 4200 Smith School Road, Austin, TX 78744
GENERAL DESCRIPTION
Under the direction of the application development manager, this position performs complex (journey-level) computer systems analysis work including interacting closely with project management and customers to develop requirements, design, build and maintain custom reporting. The focus for this position will be on development of reports, views, and dashboards in a Power BI environment. Works under general supervision, with moderate 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:
Sixty semester hours from an accredited college or university.
Experience:
Three years full-time experience in a BI report development role.
At least one year of hands-on experience developing interactive reports and dashboards specifically within Microsoft Power BI.
NOTE: Experience may have occurred concurrently.
Licensure:
Applicant must possess a valid class “C” Texas driver’s license.
PREFERRED QUALIFICATIONS
Education:
Graduation from an accredited college or university with a Bachelor’s degree or higher in Computer Science or Data Science.
Experience:
Two years experience performing Power BI report building from a Texas government agency.
Experience in the Microsoft Power BI platform, including Power BI Service, Power BI Report Builder, and Power BI desktop;
Experience integrating Power BI reports into custom-built web applications with Oracle databases and Dataverse as the data sources;
Experience with paginated reports in producing government issued precise placement documents, such as titles, licenses, certificates, etc.;
Experience in related Microsoft apps such as Power Apps, Power Automate, RPA, and Power Pages;
Experience with Oracle, SQL, the Dataverse, data warehousing, and ETL processes;
Licensure:
Microsoft Power BI Data Analyst Associate certification (PL-300).
KNOWLEDGE, SKILLS AND ABILITIES
Knowledge of designing and implementing reports with Power BI Desktop, Power BI Service, and Power BI Report Builder;
Knowledge of the various Power BI report types and has clear understanding of their use cases;
Knowledge of Power Query, M code, and DAX;
Knowledge of current technological trends in Power BI and report development;
Knowledge of functional, business and architectural aspects of Power BI components for providing solutions;
Knowledge of Power BI best practices;
Knowledge of Power BI datasets, Apps report packages, Dataflow, Datamart, deployment pipelines, and Workspaces.
Knowledge of how to connect to various data sources;
Knowledge of Agile, Iterative and Waterfall project methodologies;
Skill in the Power BI platform and its capabilities;
Skill in creating various types of Power BI paginated reports, such as precise placement fulfillment paginated reports (certificate cards, title documents, coupons, etc), table layout detail paginated reports, summary paginated reports, and receipts.
Skill in creating different paginated report implementations and printing options, such as ensuring report compatibility with non-standard print sizes and OCR font printing, and configuring print tasks to select specific paper trays for output; producing PDF and Excel files for output.
Skill in integrating Power BI reports into custom-built web applications with both Oracle databases and the Dataverse as data sources;
Skill in creating and publishing visually appealing Power BI interactive reports, mobile reports, and dashboards;
Skill in developing ad hoc reports with variable selection criteria and visualizations, such as slicers, charts, graphs, maps, tables, etc.;
Skill in designing and developing data models, and optimizing data models for faster query performance;
Skill in data transformation, data cleanup, data consolidation, etc. using Power Query;
Skill in advanced data transformation tasks using M code;
Skill in creating custom calculations and measures using DAX;
Skill in connecting to a variety of data sources using connectors and creating custom connectors;
Skill in managing data refresh schedules to ensure up-to-date information;
Skill in managing permissions to reports, row level security, and sharing reports with stakeholders;
Skill in using pipelines and version control;
Skill in troubleshooting production issues;
Skill in using MS Excel, Word and Outlook;
Skill in effective verbal and written communication with both technical and non-technical audiences;
Skill in collaborating with other developers and developing in a multi-tier environment;
Skill in establishing and maintaining effective work relationships with co-workers and work-related contacts;
Skill in prioritizing tasks and meeting deadlines
Ability to work independently with little or no supervision;
Ability to integrate Power BI report technologies and methodologies into an existing application development environment;
Ability to understand and analyze requirements and provide solutions;
Ability to develop reports from ground up including designing database tables, user interfaces, and report delivery;
Ability to choose the right type of visualization for different data types and applications;
Ability to manage the data and report delivery ensuring data privacy and compliance with agency policies;
Ability to create documentation and user guides for reports and dashboards;
Ability to provide support and training to end-users;
Ability to implement best practices for improving report performance;
Ability to conduct testing, verification, troubleshoot and performing root cause analysis;
Ability to understand statistical concepts, methods, and KPIs and metrics;
Ability to perform detailed work accurately;
Ability to maintain flexibility and work with frequent interruptions and multiple changing priorities;
Ability to follow standards for report and software development;
Ability to perform the steps required of the System Development Life Cycle (SDLC);
Ability to process information logically;
Ability to manage several projects simultaneously;
Ability to participate in Joint Application Development sessions for requirements gathering;
Ability to conduct work activities in accordance with TPWD safety program.
WORKING CONDITIONS
Required to work from 8:00 a.m. to 5:00 p.m., Monday through Friday;
Required to work overtime as necessary.
Required to provide afterhours support as needed.
Required to pass a national fingerprint-based background check to maintain employment.
Applicants must be legally authorized to work in the United States and maintain that authorization throughout employment.
May be required to operate a State vehicle.
Required to travel 5% with possible overnight stays.
Must conform to TPWD dress and grooming standards, work rules, and safety standards.
Non-smoking environment in State buildings and vehicles.
TPWD IS AN EQUAL OPPORTUNITY EMPLOYER
