Audit Business Intelligence Analyst Senior

WHO WE ARE: Service, Respect, and Connection are core to the individual and collective TRS experience. We know that great service rests on a foundation of relationships that connect us all to an empowering and rewarding career. At TRS, were inspired by our diverse community who bring authenticity and commitment to our mission to improve the retirement security of public education employees and retirees throughout Texas. As a group of achievers, we tap collaboration and innovation to raise the bar in performance, administering and counseling pensions and healthcare benefits to ensure certainty for the future of our members. We invite you to join us, where both personal and career growth are respected and where you can make a difference in our members lives every day. The Audit Business Intelligence Analyst Senior is responsible for performing advanced data analysis and research, and other consultative and audit-related work to identify issues regarding TRS participants, programs, rules, policies, processes, and procedures through data analytics. The incumbent will provide results and recommendations to business leaders and internal teams to ultimately improve the performance of TRS operations by researching and analyzing highly complex data regarding TRS pension benefits, healthcare, investments, finances, and information technology operations. This position will proactively work with the Internal Audit team and agency employees. This is a hybrid position requiring onsite work conducted at our TRS office in Austin, Texas, approximately two to three times a week or as required for business needs. WHAT YOU WILL DO: Business Intelligence and Data Analysis Employs data analytics techniques through programming (i.e. SQL, SAS, R, Python) to analyze relevant data file structures, design data-mining techniques, develop specific rule-testing logic and write scripts to facilitate continuous audit projects and achieve audit objectives. Oversees and identifies/analyzes data and other records in TRS and/or vendor systems for data quality, errors, inconsistencies and trend analysis, and compliance issues. Oversees and identifies/analyzes data to test business rules and system edits in TRS systems and identifies system control deficiencies, and provides recommendations for improvements, including system defect fixes and enhancements. Researches, analyzes and evaluates current business operations, practices, policies, procedures, guidelines, processes, systems, forms and documents; and develops and implements improvements and enhancements. Performs data mining and data analysis in support of projects in pension, healthcare, financial, benefits, investment, information technologies, and other operational areas, as assigned. Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data. Provides recommendations for improvements. Interprets query and test results to identify significant differences in data. Creates ad hoc summary reports, as needed. Provides Internal Audit team with data analytics support. Prepares concise, comprehensive technical reports to present and interpret data, identify alternatives, and make and justify recommendations on data revisions. Oversees and conducts research, compiles and analyzes data, and prepares ad hoc and periodic reports. Oversees and performs quality assurance and serves as a subject matter expert on data integrity, extraction, and compilation. Proactively engages with internal and external customers/vendors to identify business needs and areas of opportunity. Serves as a subject matter expert in data analysis to Internal Audit. Identifies needed training and trains others in learning general database queries and data relations, and data analytic tools. Proposes and contributes to quarterly and annual Busine s Intelligence project planning. Analyzes the impact of new legislation that affects TRS programs and other operations. Reviews industry trends and professional developments to identify emerging techniques or areas of opportunity. Audit, Consulting and Advisory Projects Leads and participates in special projects, task forces and committees for enterprise initiatives such as data modernization or system implementation projects. Conducts interviews with business owners and prepares system and data diagrams to identify manual and systems process interaction. Prepares reports dealing with complex and sensitive issues in a timely manner for internal and external audiences. Communicates the results of audits verbally or in writing to management, Audit, Compliance and Ethics Committee, and the Board of Trustees.