ETL Development and Architecture-----------------Need GC and USC
At a glance
Mid-level Data Engineering role at USM. Greenwich · no salary stated · we estimate $112,500–$160,000 across the United States.
USM has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Set the direction for data warehouse and ETL platforms, then lead projects that put ETL tools into use
- Gather user needs and turn functional specifications into ETL designs, code, tests and documentation
- Work with the BI team to deliver solutions and make sure BI designs work with the warehouse and ETL
- Oversee the design and delivery of internal and external reports, following change-control and documentation practices
What you bring
- At least eight years working hands-on with data warehouse and ETL processes, data architecture, and requirements analysis
- Expertise in an ETL tool, with SSIS preferred and specifically required in the role summary
- Strong SQL skills and familiarity with warehouse design approaches such as Kimball or Inmon
- Experience implementing enterprise warehouse and ETL processes, decision-support systems, and ad hoc reporting
Who this fits
This role suits a senior data warehouse and ETL practitioner who can gather complex needs, communicate across teams, and mentor colleagues while managing their own workload. You’ll work onsite in Greenwich on a three-year contract. U.S. citizens or green card holders are required.
From the employer
USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.
Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.
Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.
USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.
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
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.