SUMMARY
The Strategic Investments Group combines our unparalleled deal sourcing platform with the flexibility to capture an evolving opportunity set …
Performs complex (journey-level) data collection and data analysis work. Work involves collecting, processing, automating, auditing, reconciling, and analyzing quantitative and fundamental investment data, and supporting the development of improvements in analytic techniques and capabilities. Additional duties include providing assistance in data entry and managing the ongoing development of the investment research management system (IRMS). Works under moderate supervision, with moderate latitude for the use of initiative and independent judgment.
Job Posting #93001.16 Canidates must apply online to be considered at: http://www.comptroller.texas.gov/careers/
MINIMUM QUALIFICATIONS REQUIREMENTS:
Bachelor's degree in quantitative discipline (Business Administration, Engineering, Math, Statistics, Econometrics, Finance, Economics, Accounting, or Computer Science). Complete copies of college transcripts must be furnished to the divisional hiring representative at the time of the interview for positions requiring a college degree, and/or specific educational credits
Minimum Experience:
Investment Analyst I
One (1) year of full-time equivalent experience (1000 hours total) transforming and analyzing data for use in business decisions.
One (1) year of full-time equivalent experience (1000 hours total) analyzing data using Excel including advanced functions (e.g. index/match, vlookup, sumifs, linest, logical functions, array functions, etc.)
Preferred Experience:
All applicants must submit responses to each question below and a resume along with their application. The responses and resume must be e-mailed to mary.herrera@cpa.texas.gov or delivered to Comptroller of Public Accounts, Human Resources, 111 E. 17th Street, Austin, TX 78711 Attn: Mary Herrera within two (2) days of the date of application (Electronic or hard copy).
Question 1:
Question 2:
Question 3:
Provide evidence of your interest in a career in the financial field.
Question 4:
For each that is applicable, briefly describe your experience level and an example project for each of:
Job Posting #93001.16 Canidates must apply online to be considered at: http://www.comptroller.texas.gov/careers/
ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES:
- Automates, audits, and reconciles collection of data provided from various sources, including consulting or coordinating with custodian, consultants, data providers, and third-party contractors.
- Develops, maintains, and improves reports and tools to standardize data received from various sources, including querying databases. Support the structuring of data sets to support other predictive analytics/modeling efforts.
- Identifies and interprets patterns and trends, assesses data quality and eliminates irrelevant data. Supports the development of improvements in analytic techniques and capabilities.
- Assists Investment staff with data acquisition, reconciliation, and normalization. Contributes to preparation and validation of reports prepared for external constituents. Represents TTSTC with the highest integrity, ethics and professionalism. Performs related work as assigned.
MINIMUM QUALIFICATIONS REQUIREMENTS:
Bachelor's degree in quantitative discipline (Business Administration, Engineering, Math, Statistics, Econometrics, Finance, Economics, Accounting, or Computer Science). Complete copies of college transcripts must be furnished to the divisional hiring representative at the time of the interview for positions requiring a college degree, and/or specific educational credits
Minimum Experience:
Investment Analyst I
One (1) year of full-time equivalent experience (1000 hours total) transforming and analyzing data for use in business decisions.
One (1) year of full-time equivalent experience (1000 hours total) analyzing data using Excel including advanced functions (e.g. index/match, vlookup, sumifs, linest, logical functions, array functions, etc.)
Preferred Experience:
- SQL/Database Management
- VBA
- Matlab
- Statistical Packages (SAS, Stata, R, Gauss)
- Programming and Data Tools (VBA, C++, C#, Python, Java, Java Script, HTML, .NET, Hadoop, Hive, Pig)
- Experience using Financial Data Tools (Factset, Bloomberg, Rimes) Notes: All applicants must submit responses to each question below and a resume along with their application.
Preferred Certification:
- Certification in (or working towards) one or more of the following designations:
- Chartered Financial Analyst (CFA)
- Chartered Alternative Investments Analyst (CAIA)
- Financial Risk Manager (FRM)
All applicants must submit responses to each question below and a resume along with their application. The responses and resume must be e-mailed to mary.herrera@cpa.texas.gov or delivered to Comptroller of Public Accounts, Human Resources, 111 E. 17th Street, Austin, TX 78711 Attn: Mary Herrera within two (2) days of the date of application (Electronic or hard copy).
Question 1:
Describe the experience you have that fulfills the "transforming and analyzing data for use in business decisions" requirement. Specifically address:
- the position(s), coursework or other source of this experience
- examples of projects worked on while acquiring this experience
- the techniques you used to screen / clean / reconcile / analyze data.
Question 2:
Describe the experience you have that fulfills the "analyzing data using Excel including advanced functions" requirement. Specifically address:
- the job(s), coursework or other source of this experience
- examples of projects worked on while acquiring this experience
- examples of the functions / tools in Excel utilized. Question 3: Provide evidence of your interest in a career in the financial field.
Question 3:
Provide evidence of your interest in a career in the financial field.
Question 4:
For each that is applicable, briefly describe your experience level and an example project for each of:
- SQL/Database Management
- VBA
- Matlab
- Statistical/Data Analysis Packages (SAS, Stata, R, Gauss)
- Programming Languages and Data Tools (VBA, C++, C#, Python, Java, Java Script, HTML, .NET, Hadoop, Hive, Pig)
- Experience using Financial Data Tools (Factset, Bloomberg, Rimes)
Employees
Related Investment Jobs
In The News
Hedge Funds
Private Equity
