This position reports to the Entitlement Manager in the division of Grants Administration. Performs advanced and/or supervisory computer systems analysis work supporting the division's fiscal management of grant entitlements and grant applications for specific programs as assigned. Work involves analyzing user requirements, procedures, and problems to automate processing or to improve existing systems. Works under minimal direction with considerable latitude for the use of initiative and independent judgment.
Responsibilities include, but are not limited to the following activities:
- Performs advanced computer systems analysis and design work supporting the divisions fiscal management of grant entitlements and grant applications
- Collaborates with supervisor and appropriate division staff to formulate logical descriptions of problems; devises and implements optimum solutions
- Assists with the development and maintenance of grant formulas for distributing federal education funding to local education agencies with a focus on IDEA and Title VI Rural and Low Income grant programs
- Serves as CEMS systems administrator for assigned grant programs
- Serves as a technical liaison between the division and the Agencies Information Systems Division during maintenance of software systems, troubleshoots and resolves computer system and data issues and assists with process improvements
- Analyzes requirements, procedures, change requests, performs user acceptance testing and trains division staff prior to and guidance during computer systems implementations and enhancements
- Manages grant entitlements, grant applications and financial/student data for federal and state education funds to local education agencies in accordance to federal guidelines
- Provides divisional support for data analysis and data extraction queries from Agency database systems for ad hoc reporting, including but not limited to eGrants, ISAS, TGIF, AMS, and CEMS
- Technical resource for the division when evaluating, trouble shooting, developing and maintaining Agency computer systems and databases required for the division's day to day operations
- Serves as the divisional support lead for EKTRON updates to Agency web sites for content delivery, web correspondence and report posting
- Performs other duties as assigned
Education: Graduation from an accredited four year college or university.
Experience: Five (5) years of relevant professional experience. Prefer 3+ years of professional experience in a software development environment. Prefer experience working with multiple data sources and complex formulas.
Substitution: Education and experience may substitute for one another on a year-for-year basis.
Note: A practical exam may be administered at time of interview.
Knowledge, Skills, and Abilities (KSA):
Knowledge of: Principles of computer systems design; relational database management systems; data analysis techniques; general programming techniques including SQL database query development.
Skill in: Analyzing data and data patterns; problem solving using reasoning, logic and math; process improvement identification; deriving business rules from data models; manage technical resources in fast paced environment.
Ability to: Design mathematical formulas and documents for requirements validation and development; communicate effectively with technical and non-technical staff; remain calm and professional while multi-tasking across multiple assignments; interpret complex laws/regulations, develop written procedures in compliance with statutory requirements; provide entitlement process leadership; prepare documentation for reporting to oversight offices, agencies, committees, or other entities; work comfortable with senior management and/or auditing staff; meet strict deadlines.
This job description is not an employment agreement or contract. Management has the exclusive right to alter this job description at any time without notice.
Salary is dependent on qualifications.
Positions exempt from the Fair Labor Standards Act (FLSA) will earn compensatory time off rather than overtime for hours in excess of 40 per week. May be required to work hours other than 8 to 5. May be required to work weekends and holidays.
In accordance with applicable federal and state equal opportunity laws, it is TEA's policy that no person shall be excluded from consideration for recruitment, selection, appointment, training, promotion, retention or any other personnel action, or be denied any benefits or participation in any educational programs or activities which it operates on the grounds of race, religion, color, national origin, sex, disability, age or veteran status (except where age, sex, or disability constitutes a bona fide occupational qualification necessary to proper and efficient administration).
The Immigration Reform and Control Act requires all new employees to present proof of identity and eligibility to work in the United States. TEA does not sponsor H1-B work visas. Males, 18 to 25 years of age, are required to present proof of selection service registration (or exemption) prior to being employed by any state agency.
There is a 90-day waiting period for health insurance coverage and retirement contributions for new hires and re-hires.
This position requires the applicant to meet Agency standards and criteria which may include passing a pre-employment criminal background check, prior to being offered employment by the Agency.