ETL Development and Architecture-----------------Need GC and USC
USM Business Systems · Greenwich, CT, us ·
- Employment
- Contract
- Experience
- 3+ years
- Visa sponsorship
- No
USM Business Systems · Greenwich, CT, us ·
ETL Development and Architecture
Greenwich, CT
3 Years contract
Need GC and USC
Top Three Skills:
1. ETL Development and Architecture expertise leveraging SSIS on a SQL Server platform. (SSIS is a must have) Any knowledge of other ETL tools would be a plus as well.
2. Hedge Fund/Financials work experience, understanding of investment data and terminology from the Buy Side*.
3. Business facing with excellent communication and the ability to gather complex requirements from various teams across the organization.
4. Attribution Analysis and Asset Allocation expertise in prior projects will be a major plus within this organization.
Job Description:
The Information Technology Group of AQR Capital Management is seeking an experienced Data Warehouse and Business Intelligence professional to help the firm expand its use of data and BI tools to meet corporate goals and objectives. The individual will be providing optimal DW/ETL architecture and design for the enterprise DW environment. This includes gathering requirements, designing, working with the BI team and rolling solutions to end users. This individual will act as an advocate of DW/ETL best practices. Candidate must have effective communication skills and the ability to interact professionally within a diverse group of staff and user community. Candidate must be able to work productively in teams and to mentor or instruct others while effectively prioritizing their own tasks. Successful candidates will have great technology and problem solving skills, a solid work ethic, and an eagerness to learn in a highly intellectual, collaborative environment.
ROLE
Responsible for leading the strategic design and maintenance of Data Warehouse and ETL platforms.
Direct, organize, and lead projects in the implementation and use of ETL software tools and systems.
Design, code, test, and document all new or modified ETL processes, applications, and programs.
Manage the design, development, architecture, and delivery of all AQR internal and external reports.
Assist in the design of BI solutions to ensure interoperability with DW/ETL solutions.
Assist in analyzing user requirements and, based on findings, design ETL processes based on the functional specifications.
Adhere to best practices in change control and documentation.
REQUIREMENTS
8+ years of hands-on experience with DW/ETL processes, data architecture and business requirements gathering/analysis.
Expert knowledge of one ETL tool (Informatica, SSIS, Ab Initio etc.) – preferably SSIS
Sound knowledge of data warehouse methodologies.
Sound knowledge of data warehouse design methodologies (Kimball, Inmon etc.)
Strong SQL skills.
Good understanding of financial markets and products.
Direct experience in implementing enterprise DW/ETL processes and decision support.
Strong ability to analyze user requirements and build DW/ETL processes to specifications.
Direct hands-on experience with ad hoc query programs and reporting software.
OPTIONAL (Nice to Have)
Knowledge of data mining and predictive analysis
Understanding of .Net (C#) and/or Java
Understanding of fund structures and strategies.
If you are interested please share your resume to preethib@usmsystems(dot)com or can directly call me on 703 468 0398