This position, reporting to the division director, will perform complex tasks to administer the day-to-day operations of the Analytical Unit of the Division of Federal Fiscal Compliance and Reporting in the Office for Grants and Federal Fiscal Compliance. The position is responsible for supporting the division and department by assuring the integrity of project data, including data extraction, storage, manipulation, processing and analysis. The Analytical Unit is responsible for Analysis, Requirements Definition, Design, Build & Test, Conversion, User Acceptance Testing, Training and ongoing support including, but not limited to:
Works under limited supervision with considerable latitude for the use of initiative and independent judgment.
- Business analysis, system and process design;
- Analyzing data with standard statistical methods, interpreting the results, and providing written summary of data analyses;
- Developing user requirements, collecting/compiling data and providing technical reports;
- Collecting and collating appropriate data for usage in databases and conducting related research;
- Determining the data requirements and analysis procedures best suited to yield conclusive, consistent results
- Providing ongoing technical assistance, configuration/customization assistance including but not limited to: custom reports, data imports, data integration, custom scripting and third party software integrations;
- Providing expertise required to guide the organization in driving changes in data requirements to meet the needs of the division;
- Developing and manage daily/weekly/monthly/quarterly reporting;
- Proactively identify new processes and/or analysis in order to better support business management;
- Documenting and maintaining primary and secondary data elements, relationships, and sources for reference and to support cross-functional report reconciliation
- Gathering Public Information Requests (PIR) related to technical reporting;
- Responsible for creating, maintaining and updating the division website
Education: Graduation from an accredited four year college or university with major course work in Management Information Systems, Data Management, Computer Science, or Business Administration. Advanced degree preferred.
Experience: Six (6) years experience defining the overall application and business architecture for a division, ensuring data quality and accuracy.
Substitution: Experience and education may be substituted for one another.
Knowledge, Skills and Abilities (KSA's):
Knowledge of: Broad awareness of industry technologies and ability to understand applications from both technical and business perspective; familiarity and successful working experience with key process excellence and quality principles such as Six Sigma, LEAN, Change Management, Business Process Management and Process Enterprise; successful working experience with applicable industry standards such as PMP, CMM, ITIL, and ISO 9001.
Skill in: Excellent verbal and written communication skills; working effectively with TEA and Federal Program Compliance systems such as: SAS (Base/Advanced Programmer), MSCA SQL Server, MCSE Business Intelligence, PEIMS, PEIMS Edit Plus, eGrants, Personal Work Manager, ISAS, TGIF, GRIMS, and other applicable systems. Strong analytical skills to get the best out of the tools and to explain how the results were achieved; hands on experience with all aspects of the project lifecycle, including detailed deliverable development and team management at all levels.
Ability to: Interact professionally with a diverse group, executives, managers, and subject matter experts; support the Director; be flexible and adaptable to change; identify and elevate issues to the attention of the Director as well as present solutions/alternatives to those same issues; motivate self and others to acquire necessary knowledge, skills and expertise to be successful; demonstrate competency in successful and effective oral and written communications; and exhibit a positive attitude and positive behavior to support colleagues and the Director in achieving the agency, department, and division goals and objectives.
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 selective 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.