Peoplesoft Business Analyst

Full time, permanent position at the Boston location of a global investment firm.

Qualifications:

- Must have experience/expertise with PeopleSoft Applications (A/P, G/L, Fixed Assets, Purchasing, Payroll).

- Must have experience/expertise implementing and supporting finance systems on a local and global scale.

- Must have experience/expertise with providing end-user training and support with the specific systems.

- Must be able to effectively gather and execute technical requirements.

- Excellent communication skills and ability to work well in a team environment are necessary.


Please contact Albert Barsoumian with qualified resumes via email at albertb@avidtr.com or via phone at 617-951-1893.

SQL Server Developer

Contract or Perm position at an investment management firm in Boston

Position Overview:

We are looking for a SQL Server Developer to join a team of 4 developers and architects to create innovative solutions for our investment divisions. You will be working with data and research departments, implementing a wide variety of databases used for research, portfolio construction and trading. This is a contract position.


Responsibilities:

Work closely with research analysts and portfolio managers to comprehend the data needs, and data usage.
Propose and design database solutions.
Implement database systems based on the solutions proposed and work closely with users to test and integrate the system into the current production environment.
Support the systems developed.


Skills:

College degree required.
4+ years of experience developing application with the focus on data and data access.
Proven track record building large scale SQL Server databases.
Expert level T-SQL skills.
Experience with performance tuning, execution plans, indexed views.
Basic familiarity with .NET for CLR stored procedure and SSIS development.
Experience with SQL Server 2008 would be a plus.
Methodical and pragmatic.
Self-starter, able to work in a fast paced environment with minimal supervision.
Excellent communication skills - both written and oral.
Must be detail-oriented and able to prioritize work and effectively manage multiple tasks.
Mathematics or other analytical background would be a plus.
Prior exposure to Financial Services would be a plus.

Please contact Albert Barsoumian with qualified resumes via email at albertb@avidtr.com or via phone at 617-951-1893.

Spotfire Developer

Contract at an investment firm in Boston

Qualifications:

* Minimum of 2-3 years of experience developing Spotfire Reports, Spotfire WebPlayer, Spotfire SDK
* 2-3 years of Strong Oracle and Sybase SQL experience
* Financial Domain experience preferred
* Programming Knowledge in Java, J2EE / VBA experience
* Bachelor's degree preferred
* Solid understanding of the business or function for which the application is designed
* Specific business background through training and application experience
* Full understanding of the software development process including analysis, design, coding, system and user testing, problem resolution and planning
* Applications/technology knowledge and expertise in one or a few areas
* Full competency in all relevant development and coding environments, languages, tools and platforms

Summary:

* Develops, modifies, integrates, and maintains software solutions.
* Provides business solutions by developing complex or multiple software applications.
* Uses business knowledge to translate the vision for divisional initiatives into business solutions by developing complex or multiple software applications.
* Conducts studies of alternatives; analyzes and recommends changes in project development policies, procedures, standards, and strategies to development experts and management.
* May work with minimal or without supervision
* Determines and develops approaches to solutions


Day-to Day duties:

* Understand and implement the business requirements in Spotfire
* Follow SDLC process and provide all necessary documentation for specific releases.
* Work on any enhancements of legacy projects which are implemented in Java/VBA programming languages.


Please contact Albert Barsoumian with qualified resumes via email at albertb@avidtr.com or via phone at 617-951-1893.

SQL Developer

Contract, contract to hire or permanent
Top tier asset management firm in Boston

The SQL DBA/ Developer will be responsible for providing guidance and direction on the database design, development, integration, and support of applications in support of client’s data management processes. The ideal candidate will have a strong development background, with an emphasis on SQL code. Experience as a SQL DBA would also be preferred.



· Undergraduate degree in technology discipline or equivalent experience

· An average of 10+ years total IT experience

· An average of 8-10+ years of SQL Development experience

· Understanding of the database development lifecycle, including database creation, table design, etc.

· Working knowledge of standard design methodologies and principles.

· Experience with T-SQL and ETL tools, primarily with SSIS 2005/2008

· Experience with architecting and implementing reports within SQL Server Reporting Services 2005 / 2008

· Experience with VLDB’s - 100+ GB databases, hundreds of DB’s in a highly transactional environment

· Familiar with the new facts of SQL Server 2005 / 2008 (e.g. table partitioning, mirroring, full-text management, indexed views, security management, etc)

· Familiar with query performance analysis, improvements and troubleshooting performance degradation

· Knowledgeable of operating systems (e.g. Windows 2003, 2007)

· Experience with resolving complex blocking and deadlocking issues



Please contact Albert Barsoumian with qualified resumes via email at albertb@avidtr.com or via phone at 617-951-1893.