DPS - FIN - Senior Financial Data Analyst - 0654

Please paste the following URL into a browser to view the entire job posting on the CAPPS Careers page.https://erphcmprd.cpa.texas.gov/psp/candidateportal/EMPLOYEE/HRMS/c/HRS\_HRAM\_FL.HRS\_CG\_SEARCH\_FL.GBL?Page=HRS\_APP\_JBPST\_FLandAction=UandFOCUS=ApplicantandSiteId=1andJobOpeningId=106573andPostingSeq=1Job DescriptionPLEASE NOTE: All applications must contain complete job histories, which includes job title, dates of employment, name of employer, supervisor's name and phone number 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.SUBMITTED THROUGH WORK IN TEXAS: Work In Texas (WIT) applicants must complete the supplemental questions to be considered for the posting. In order to complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile. Go to CAPPS Recruit to Sign In https://erphcmprd.cpa.texas.gov/psc/candidateportal/EMPLOYEE/HRMS/c/HRS\_HRAM\_FL.HRS\_CG\_SEARCH\_FL.GBL?FOCUS=ApplicantandGENERAL DESCRIPTION: Performs highly complex (senior-level) data analysis, configuration and data research work related to agency financial applications and business processes. Work involves conducting detailed analysis of and extensive research on data, providing results and reports, and monitoring data quality. May supervise others. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment.The following Military Occupational Specialty codes are generally applicable to this position. Applicants must fully complete the summary of experience to determine if minimum qualifications are met. https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC\_PlanningResearchandStatistics.pdfESSENTIAL DUTIES / RESPONSIBILITIES:1. Develop goals/objectives and oversee the detailed reporting of financial information of the agency, not limited to expenditures, encumbrances, pre-encumbrances, revenues, or other information as requested.2 .Coordinate the planning, design, development, implementation, support, and maintenance of agency dashboards, primarily utilizing Tableau or Salesforce or other Financial Software applications.3. Lead report/ dashboard development projects to completion with minimal guidance and document the process related to the dashboard implemented.4. Compiles financial data using advanced processes while interpreting the results to identify discrepancies and or anomalies with the data and research implied logic to ensure accuracy of information utilized by agency leadership.5. Oversee the query development/deployment as well as identification of errors and production related issues to the agency financial applications as directed. Run, create and update queries to gather appropriate financial data for routine and/or adhoc purposes. Prepare concise, comprehensive financial reports to present and interpret data, identify alternatives, and make and justify recommendations.6. Develop and deploy queries to identify errors and production issues in agency applications. Develop standard reports and adhoc queries to interpret data.7. Coordinate agency financial innovation discussions to continue to streamline and automate financial business processes to improve transparency and visibility.8. Guide the selection of data management tools, the development of standards, usage guidelines and procedures for those tools. Define, develop, and implement data standards9. Provide advanced user assistance to all agency personnel by analyzing issues, testing financial business processes changes, triaging all user requests and all modules in the agencys financial applications. This includes testing all functionality, change notices, maintenance upgrades, outages, and communicating as needed. 10. Analyze and resolve agency financial application issues to ensure all appropriate workflows and functionality are operational.11. Coor inate the training of agency staff prior to the implementation of all agency financial applications (Tableau, Salesforce or other Financial Software app) and or business processes. Define and provide technical and/or other expertise related to computer systems and offer advice or guidance during the implementation of financial process related to the agency financial systems which includes development of job aids and other training documentation.12. Coordinate the planning, design, development, implementation, support, and maintenance of financial information and ensure technology security measures are in place to safeguard departmental information.13. Support all external interfaces to the agencys financial applications to ensure stability. Maintain current, Tableau, Salesforce, and other financial environments for all existing business processes and continue required testing for systemwide upgrades and deployments. Maintain legacy application support if required or requested.14. Coordinate and/or participate in the development and execution of financial enterprise level strategies and technical direction, including establishing processes and procedures for executing and maintaining financial technology road maps.15. Maintain day-to-day operations of Tableau, Salesforce or other financial application functionality for the agency.16. Coordinate studies and the preparation of reports that include study findings, recommendations, and instructions for proposed system implementations; formulate logical descriptions of problems; and devise and implement optimum solutions related to the agency financial application.17. Coordinate projects that cross functional agency systems and other state entities that require coordinating, planning, and scheduling during project development and implementation stages.18. Develop and implement strategic planning actions and policy decisions related to the agency financial systems and make recommendations concerning the direction related