What are the responsibilities and job description for the TPWD - Programmer II (Reports Developer/Power BI Developer) position at PARKS AND WILDLIFE DEPARTMENT?
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
Programmer I-VI
Army
25B, 255A, 255S, 26B
Programmer I-VI
Navy
CT, CTR, IT, 181X, 182X, 681X, 682X, 781X, 782X
Programmer I-VI
Coast Guard
IT, CYB10, CYB11, ISM
Programmer I-VI
Marine Corps
0673, 2652, 2653, 8846
Programmer I-VI
Air Force
3D0X4, 8K000, 16KX
- 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.
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: Thomas (Wayne) Baker, (713) 397-2804
PHYSICAL WORK ADDRESS: Application Development, 4200 Smith School Road, Austin TX 78744
GENERAL DESCRIPTION:
Under the direction of the Strategy/Business Development Manager, this position performs complex (journey-level) computer programming 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 the 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.
MINIMUM QUALIFICATIONS:
Education:
Graduation from an accredited college or university with a Bachelor’s degree.
Experience:
Three years full-time experience in a Power BI report development role.
One year experience developing Power BI paginated reports.
PREFERRED QUALIFICATIONS:
Education:
Graduation from an accredited college or university with a Bachelor’s degree in Computer Science or Data Science.
Experience:
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 PowerApps, Power Automate, RPA, and Power Pages.
Experience with Oracle, SQL, the Dataverse, data warehousing, and ETL processes.
Two years of the required experience performing Power BI report building is from a Texas government agency.
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.
Knowledge of developing applications for compliance with Section 508 of the U.S. Rehabilitation Act.
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.
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 real-time and batch fulfillment jobs, including night-time batch fulfillment that updates databases.
Skill in managing data refresh schedules to ensure up-to-date information.
Skill in optimizing data models for faster query performance.
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 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 the best practices for improving report performance.
Ability to conduct testing, verification, troubleshoot and performing root cause analysis.
Ability to understand statistical concepts, methods, 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.
This position is suitable to telework two days per week and the candidate may be allowed to telework with supervisor approval.
Must conform to TPWD dress and grooming standards, work rules, and safety standards.
May be required to operate a State vehicle.
Required to travel 5% 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
