Location:
1000 Red River
Austin, Texas, 78701
United States
Investment Accounting Data Quality Analyst Senior
| Requisition ID: |
req1186 |
Employment Type: |
Unclassified Regular Full-Time (URF) |
| Division: |
Investment Accounting |
Compensation: |
98,214.00 - 122,767.00, Annual Salary |
| Location: |
TRS |
Job Closing: |
March 3rd at 5:00 pm, CST |
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 Investment Accounting Data Quality Analyst Sr. is responsible for coordinating and maintaining the quality for investment related data, resolving data quality problems, and collaborating with database developers to improve systems and database designs. The incumbent will optimize the efficiency and quality of the data being collected and stored, perform data analysis, create and enhance data collection and storage procedures, and prepare data quality reports. This position will proactively work with the Investments Data and Systems team in the Investment Management Division, Information Technology Division, as well as the Accounting and Reporting team and Analytics and Financial Insight Groups in the Financial Service Division.
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:
Data Quality
•Leads the creation of validated data sets that produce known results and that can be used to automate testing for investment accounting system.
•Coordinates and participates in the creation, design, and maintenance of reusable datasets for use by data analysts.
•Coordinates, identifies, records, documents, and tracks defects.
•Identifies areas of improvement in data quality processes in the investment accounting system and coordinates solutions to enhance data accuracy and reliability.
•Conducts functional, integration, regression, and performance testing of database systems using industry standard technologies (SQL, Python, etc.)
•Assesses new data sources to better understand availability and quality of data.
•Coordinates, develops and executes manual and automated test cases for software applications to ensure the reliability of data pipelines, ETL processes, and data transformations.
•Designs, implements, and enhances data integration processes to investment accounting system.
•Coordinates, designs, monitors and maintains QA reports, KPIs & quality trends for data.
•Assists in developing and maintaining data governance policies and standards around data quality.
•Maintains source code repository of scripts (SQL, Python) and other data products (dashboards, reports, etc.).
•Work with technology teams to understand data capture and testing needs.
•Automates and improves creation/maintenance of reports and dashboards.
•Performs statistical tests on large datasets to determine data quality and integrity.
•Runs data queries to identify coding issues and data exception, implementing solutions to resolve any issues.
•Troubleshoots and optimizes stored procedures using Microsoft SQL Server.
•Works in partnership with business analysts to ensure proper integration of new solutions into existing environments.
•Provides training, technical assistance, data interpretation, and advice to managers and staff.
Departmental Support
•Mentors other analysts, providing guidance and support.
•Collaborates with senior management and stakeholders to align data quality initiatives with organizational goals.
•Identifies and mitigates risks associated with departmental operations.
•Assisting with fostering innovation within the department by exploring new methodologies and technologies.
•Assists with evaluating and improving departmental processes and tools.
•Participates on related agency committees and special projects as assigned.
•Performs related work as assigned.
WHAT YOU WILL BRING:
Required Education
•Bachelor’s degree from an accredited college or university in finance, economics, data management, or a closely related field.
•High school diploma or equivalent and additional full-time experience in working with SQL and relational databases including queries, database definition and schema design, or related experience may be substituted on an equivalent year-for-year basis.
Required Experience
•Six (6) years of full-time directly related, progressively responsible experience in working with SQL and relational databases including queries, database definition and schema design, or related experience.
•Six (6) years of full-time directly related, progressively responsible experience in administering an investment accounting system.
•Four (4) years of full-time directly related, progressively responsible experience in writing and maintaining ETL on a variety of structured and unstructured source, or related experience.
•Two (2) year of full-time directly related, progressively responsible experience in with Microsoft Business Intelligence Suite (Microsoft SSAS, SSIS, SSRS) and modern data visualization tools (Power BI, Tableau) in an in-depth capacity.
•Experience may be concurrent.
•A master's degree or doctoral degree in a closely related field may be substituted on an equivalent year-for-year basis.
Required Registration, Certification, or Licensure
•None.
Preferred Qualifications
•Master's degree in finance, economics, data management, or a related field.
•Basic experience with Azure analytics.
•Basic understanding of Pension Fund Investment Operations or Asset Management
•Experience with scripting languages such as Python, Visual Basic, NodeJS, etc.
Knowledge Of
•Advanced data quality process improvement.
•Data processing concepts like mapping documents and complex data relationships.
•SQL and relational databases including queries, database definition and schema design.
•Investment accounting reporting requirements.
•Investment concepts, terminology, styles, models, strategies, and fundamental investment factors.
Skills In
•Analyzing detailed accounting/financial/investment records, troubleshooting associated problems, and interpreting and applying applicable laws, policies, and procedures.
•Working effectively with cross-functional teams
•Listening to business problems and translating into technical vision, strategies, and goals.
•Analyzing and evaluating complex information technology programs, policies, and issues.
•Writing and maintaining ETL on a variety of structured and unstructured sources.
•Microsoft 365 Suite of collaboration products, including Microsoft Access.
•Microsoft Power Platform.
•Advanced experience with Azure analytics.
•Working in Agile SCRUM teams.
Ability To
•Engage with product owners and development leads to create testing strategies.
•Communicate effectively, verbally and in writing.
•Effectively interact with data users, managers, and other stakeholders.
•Analyze, evaluate, and integrate business rules into system requirements.
•Exercise sound judgment in making critical decisions.
Military Occupational Specialty (MOS) Codes:
Veterans, Reservists or Guardsmen with experience in the Military Occupational Specialty (
https://www.trs.texas.gov/files/trs-military-crosswalk.xlsx
) 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.
