02 Sep
Investments Systems Analyst (Data Analysis, SQL)
Texas, Austin

Vacancy expired!

Connecttel, Inc - Investments Systems Analyst (Data Analysis, SQL)

Investments Systems AnalystAustin, texas - Hybrid (2 days at the office and 3 days from home)6 months ContractResponsibilities & Skills• A strong development background, with knowledge of back-office investment operations • Builds complex SQL queries against base and aggregate tables• Reviews queries for Investment system performance issues• Participates in the design, development, and integration of Investment databases • Maintains metadata, business glossaries for the Data Warehouse, and participates in data quality and data governance initiatives• Implements data management standards, monitoring , processes and technologies• Documents data dictionary and data mapping/transformation rules• Works extensively with business analysts and investment professionals to analyze business problems• Supports daily activity of the investment control systems areas by creating and maintaining custom reports and programs and by providing technical support for system and software issues• Assists customer in creating and running test scripts for data loads and report development• Strong communication, presentation and interpersonal skill.• Proficient ability to explain technical information to a non-technical audience• Ability to learn new concepts, systems, and software independently and quickly• Willingness to take initiative, seeing problems through to final completion • The ability handle diverse situations and rapidly changing priorities with deadlines Additional Preferred Skills:• Experience in general accounting, investment accounting, account reconciliation, and writing procedures• Experience working in ‘R’ statistical programming language• Experience working in PACE as a developer writing uploader and exporter code• Familiar with all aspects of the Eagle PACE warehouse, including scheduling, report writing, data stewardship, portal, and data model/schemas• Familiar with Eagle Modules (Message Center, Scheduler, Workflow Manager, Security reference Manager, etc.)• Hands on and extensive experience with many of the following technologies: Crystal Reports, .Net (VB or C#), MS SQL Server, MS Access/Excel. FIX, SWIFT, and XML Minimum Requirements:• Graduation from an accredited four-year college or university. Each year of related experience over the required may be substituted for one year (30 semester hours) of required college credit• 5 years data analysis• 5 years SQL experience• 3 years SSAS experience

Vacancy expired!