Back to Job Search Results

Data Warehouse Architect (Closed)

Date Posted: Jan 23, 2020

Job #1562968
Permanent
New York, New York, United States
Staff

Lucas Group is working with a leader in the Physical Commodities Trading industry that focuses on streamlining processes for their client’s product to market.

The client is looking for a Data Warehouse Developer with at least 5 years of experience. This individual will be working with a cross-functional team implementing exciting global projects.

This is a highly visible role where you will BOTH build from scratch and interact with the business all the way up to the C-Level Suite.

Key skills include Data Warehouse Development & Architecture, data mining, SQL, SSIS, and ETL (to name a few).

The ideal candidate comes from a Supply Chain, CPG (Consumer Packaged Goods), commodities trading, or financial/banking company, but is not required!

Key responsibilities: 

  • Design, build, and develop all components of a data warehouse, containing business critical information including trading P&L and positions, such as ETL processes, databases, and reports.

  • Designing, developing, testing and supporting (full-life cycle) proprietary applications and interfaces

  • Experience with deep dimensional database design and building Data Warehouses from scratch

  • Develop and automate ETL processes between trading applications and our Data Warehouse that involve data cleansing, reconciliation handling and process monitoring utilizing Microsoft SQL Server Integration Services (SSIS)