TMD - Programmer III (Business Intelligence Developer) (00008209)
Organization: TEXAS MILITARY DEPARTMENT
Primary Location: Texas-Austin
Work Locations: Camp Mabry Training Site 2200 W 35th STREET Austin 78703
Job: Computer and Mathematical
Employee Status: Regular
Standard Hours Per Week: 40.00
Travel: Yes, 5 % of the Time
State Job Code: 0243
Salary Admin Plan: B
Salary (Pay Basis): 5,500.00 - 6,083.33 (Monthly)
Number of Openings: 1
Overtime Status: Exempt
Job Posting: Dec 3, 2019, 11:32:41 AM
Closing Date: Ongoing
APPLICATIONS SHOULD BE FILED ONLINE THROUGH CAPPS RECRUIT AT:
APPLICATIONS SUBMITTED THROUGH WORK IN TEXAS:
Applicants may submit applications through Work In Texas (WIT), however applicants must complete the supplemental questions in CAPPS Recruit to be considered for the position. In order to complete the supplemental questions, please register and/or login to CAPPS Recruit and access your profile. Go to CAPPS Recruit to Sign In (Link: https://capps.taleo.net/careersection/ex/jobsearch.ftl?lang=en)
NOTES TO THE APPLICANT:
Your job application must be complete and thorough including responding to all the supplemental questions. Your application must contain complete job histories, which includes job titles, dates of employment, name of employer and a description of duties performed. If this information is not submitted, your application may be rejected because it is incomplete. Resumes do not take the place of this required information.
Who We Are: The Texas Military Department (TMD) is commanded by The Adjutant General of Texas, the state's senior military official appointed by the governor, and is comprised of the Texas Military Department (State & Federal Civilian Employees), the Texas Army National Guard (TXARNG), the Texas Air National Guard (TXANG) and the Texas State Guard (TXSG).
Our Vision: America’s premier state military organization comprised of professional mission-ready forces, fully engaged with our communities, and relevant through the 21st century.
Our Mission: Provide the Governor and the President with ready forces in support of state and federal authorities at home and abroad.
BRIEF POSITION SUMMARY
Performs highly complex (senior-level) computer programming. Work involves coordinating report development projects, helping provide automated insights to the financial teams for now and possibly others in the future, working to provide technical assistance, and working with users and Business Services staff, individually as well as in team settings. Reports to the CAPPS and Business Intelligence Manager and works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES
Performs report development activities (including data analytic reports): design, code, test, implement, maintain, and improve.
Provides on-demand reports in various output formats.
Creates data models, reports dashboards, and visualizations.
Monitors database performance.
Produces technical document/specification.
Performs light scripting for process automation and data analysis.
Gathers user requirements and change specifications.
Analyzes, plans, and creates procedures to automate processes.
Provides technical expertise to assist with new tools implementation.
Trains end users on the usage of reports and BI reporting tool.
Provides accurate development estimates based on high-level and/or technical requirements.
Performs all assigned tasks in a timely manner.
May supervise the work of others.
Attends work regularly and observes approved work hours in accordance with agency state employee policies & procedures handbook.
May occasionally work evenings, weekends or holidays.
Performs other duties as assigned.
Work hours are 8:00AM to 5:00PM, 40-hour week, Monday – Friday.
Graduation from an accredited four-year college or university is required.
Graduation from an accredited four-year college or university with major course work in data processing, computer science, information technology, management information systems, engineering, or a technical related field is preferred.
Four years of experience in programming is required.
Experience using Microsoft applications to include Microsoft Word and Excel is required
Three years of SQL experience is preferred.
One year of programming in a modern programming language, e.g. Python, Java, Java Script, C, C++, or C# is preferred.
One year of data warehouse management experience is preferred.
One year of Business Intelligence (BI) reporting experience is preferred.
REGISTRATION, CERTIFICATION OR LICENSURE:
Valid driver’s license is required. *If not currently a Texas resident, must obtain a Texas Driver's License within 30 days after entering Texas as a new resident. A satisfactory driving record is required for driving state or personal vehicles to conduct agency business.
Selected candidate must pass a federal security background investigation. The process includes a National Agency Check and Inquiry (NACI) and fingerprinting. New employees must complete and sign the Office of Personnel Management (OPM) Form SF85. Completed forms are submitted to the OPM for the background investigations.
Must be able to obtain a Common Access Card (CAC). Selected candidate must pass a federal security background investigation. The process includes a National Agency Check and Inquiry (NACI) and fingerprinting. New employees must complete and sign the Office of Personnel Management (OPM) Form SF85.
The Immigration Reform and Control Act of 1986 requires all new employees to present proof of eligibility to work in the United States within three (3) days of being hired. The Texas Military Department participates in E-Verify and will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS), with information from each new employee's Form I-9 to confirm work authorization; For more information, see: E-Verify Poster.
Upon hire with the State of Texas, males between the ages of 18 through 25 must provide proof of registration or exemption with the Selective Service. For further information, visit the Selective Service website at https://www.sss.gov/RegVer/wfVerification.aspx.
KNOWLEDGE, SKILLS AND ABILITIES
the principles, practices and techniques of computer programming and systems analysis;
computer operations procedures and systems;
knowledge of ETL and data warehouse concepts and processes; and
of computer programming languages.
computer programming; and
in the operation of computers and their hardware and software.
analyze problems and develop solutions;
code, test and debug computer programs;
determine report issues;
communicate effectively; and
train and supervise the work of others.
Work is typically performed inside in a sedentary office setting. Work may involve sitting, standing, walking, stooping, kneeling, climbing or crawling. Work requires regular use of a computer and telephone. This position may periodically require the ability to lift, carry, move and/or set up equipment and materials that weigh up to 50 pounds.
VETERANS EMPLOYMENT PREFERENCE
If you qualify for a Veteran Employment Preference, it is mandatory that you provide the required documentation at the time of applying. Documentation must be provided before a Veteran Employment Preference can be granted.
Currently Serving U.S. Military Member - Statement of Service Memo;
Veteran – DD Form 214 (or Equivalent) or;
Surviving Spouse of a Veteran who has not remarried - Marriage Certificate and DD Form 1300 or;
Orphan of a Veteran who was killed during active duty – Birth Certificate and DD Form 1300
Disabled Veteran - VA Civil Service Preference Letter
Use your military skills to qualify for this position or other jobs. Go to www.texasskillstowork.com to translate your military work experience and training courses into civilian job terms, qualifications, and skill sets.
Veterans, Reservist or Guardsmen with an MOS or additional duties that fall in the following fields or other related fields pertaining to the minimum experience requirements may meet the minimum qualifications for this position and are highly encouraged to apply:
United States Army – 25B Information Technology Specialist
United States Navy – IT Information Systems Technician
United States Coast Guard – IT Information Systems Technician
United States Marine Corps –0673 Applications Developer
United States Air Force – 3D0X4 Computer Systems Programming
Additional Military Crosswalk information can be accessed at: http://www.hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_ProgramManagement.pdf
Contact TMD’s Veteran's Liaison, Carlos Cardozo if you have questions at (512)782-6822 or HR@military.texas.gov
The Texas Military Department does not discriminate of the basis of race, color, national origin, sex, religion, age, genetic information, or status as an individual with a disability or protected veteran status in employment or in the provision of services.