Sr. Business Intelligence Analyst for Internal Audit

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, we’re 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 Senior Business Intelligence Analyst for Internal Audit is responsible for performing data analysis and research, and other consultative and audit-related work. The work involves researching and analyzing highly complex data regarding TRS pension benefits, healthcare, investments, finances, and information technology operations. This position will proactively partner with the Internal Audit team and business stakeholders to identify issues regarding TRS participants, programs, rules, policies, processes and procedures through data analytics. By leading and conducting audit-related projects, the incumbent will provide results and recommendations to business leaders and internal teams to ultimately improve the performance of TRS operations. This position reports to the Director of Business Intelligence for Internal Audit.

WHAT YOU WILL DO:

• 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 Business 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.

• Leads and participates in special projects, task forces and committees for TEAM program related 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.
• Manages outsourced projects, including working with external service providers in developing statement of work, scheduling meetings, data gathering, and monitoring the contract execution and deliverables.
• Complies with IIA professional standards and Government audit standards in professional conduct and performing audit procedures, project documentation, including internal quality controls standards through the review of working papers of individual projects.
• Participates in the identification and evaluation of risks in agency operations and provides input to the Annual Audit Plan.
• Performs audit procedures, including reviewing and analyzing relevant information, collecting and evaluation evidence, documenting business processes and procedures, and completing audit documentation as required by professional standards and internal procedures.
• Conducts audits and consulting projects of TRS operations and key risk areas as identified in the Audit Plan.
• Participates in the data governance workgroup in an advisory role to review and provide input to the agency database development and data governance standards and procedures.

• Performs related work as assigned

WHAT YOU WILL BRING:

• Bachelor’s degree from an accredited college or university.
• High School diploma or equivalent and additional full-time work experience in healthcare, accounting, claims processing, benefit processing, or related experience which includes interpreting, applying, and communicating complex laws, regulations, and policies may substitute for the required education on an equivalent year for year basis.

• Six (6) years of full-time data analyst, auditing, financial analysis, or related experience requiring programming (i.e. SAS, SQL, R, Python), compilation, reconciliation and/or analysis of detailed system information, or related experience.
• Two (2) years of lead or project management experience.
• Experience may be concurrent.

• Experience analyzing data related to health insurance claims, health plan administration, or pension administration.
• Experience with SAS, ACL, SQL and visualization tools such as PowerBI and Tableau.
• Experience with relational databases and/or computer programming in any programming language.
• Master’s degree in data analytics, computer science, information systems, business administration, or a related field.
• Certification related to data analysis, such as ACDA (ACL Certified Data Analyst), SAS Certification, Certified Analytics Professional (CAP)
• Certification related to information technology, healthcare, benefits, auditing, investigations, project management, or a related field.

• Extensive knowledge of analyzing data sets; writing queries, report writing, and presenting findings; of data models, database design development, data mining, and segmentation techniques; and of record keeping, including security procedures for handling, protecting and distribution confidential data.
• Skill in the use of computers and applicable software, in analyzing problems and devising effective solutions, in conducting data searches, in evaluating and translating large amounts of data, and in critical thinking.
• Ability to compile, review, and analyze data; to prepare reports; to maintain accuracy and attention to detail; to communicate effectively; and to train others.

• Reviewing documentation; interpreting and applying complex laws, regulations, rules and policies; and making decisions based on sound judgment.
• Project management, including planning, organizing, and prioritizing work assignments to manage a high-volume workload in a fast-paced and changing environment.
• Completing detailed work with a high degree of accuracy.
• Providing quality customer service.
• Analyzing problems and devising effective solutions.
• Utilizing a computer in a Windows environment with Microsoft Office word processing, spreadsheet, and other business software and applications.
• Effective written and verbal communications, including preparing and delivering complex correspondence, reports, and presentations.

• Establish and maintain harmonious working relationships with co-workers, agency staff, and other external contacts.
• Work effectively in a professional team environment.

Military Occupational Specialty (MOS) Codes:
Veterans, Reservists or Guardsmen with experience in the Military Occupational Specialty ( http://www.hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_AdministrativeSupport.pdf ) along with the minimum qualifications listed above may meet the minimum requirements and are highly encouraged to apply. Please contact Talent Acquisition at careers@trs.texas.gov with questions or for additional information.

To view all job vacancies, visit www.trs.texas.gov/careers or www.trs.csod.com/careersite.

For more information, visit www.trs.texas.gov.