Data Warehouse Developer – Luxembourg or New York Midtown

We are proud to partner once again with one of our longest standing clients in their search for a DWH Developer.

 

Our client has global operations in commodities trading and provides supply chain solutions to the metals and natural resources sectors.

The in-house Information Systems Team aims to drive control, efficiency and business intelligence by designing and building software and integrating best-in-class 3rd party solutions.

The role and 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
• 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)
• Participate in the technical design and implementation of  the global trading application, reporting, and analytics
• Design, maintain, configure, test and support proprietary reports – working in close collaboration with end users and/or with business analysts to maximize competitive advantage and business controls
• Definition of table structures, define attributes, dimensions, hierarchies and metrics in the Data Warehouse
• Ensure data integrity within our Data Warehouse, and develop procedures for increasing the quality and accuracy of information from multiple data sources
• Supporting a dynamic trading business by providing effective technical solutions to end users’ business needs – the successful candidate will be energized by the opportunity to
  work on real business requirements directly with business people
• Perform all the above in close partnership with other developers and business analysts in Luxembourg and New York as part of one global team
• Our client works in a small team environment in which the work is shared among the team members, providing an opportunity to collaborate and to learn from one another – as such, valuing teamwork above specialization or silos

 

Your experience / qualifications:
The ideal candidate will have the following experience and qualifications in order importance:

• Minimum 5+ years experience developing software across a variety of platforms in the financial or trading industry
• 3+ years of experience with database development in MS SQLServer
• 3+ years of experience in data warehousing with designing multi-layered data warehouses using both relational and dimensional modeling techniques
• Advanced knowledge of application, data and infrastructure architecture disciplines
• Working knowledge of data modeling, and understating various aspects of logical, conceptual and physical modeling of data warehouse projects required
• Experience with data preparation, integration and reporting automation (including data visualization platforms) – experience with BusinessObjects stack is a plus
• Collaborating in a team with other developers, using source code version control tools, project management tools, Jira (or similar) issue tracking tool
• Ability to evaluate trends in data by applying concepts such as probability, statistics, modeling, percentages, ratios, and proportions
• Experience with Agile SDLC methodology

 

Additional skills desired but not mandatory:

• ETL design and data processing with advanced SQL stored procedures and SSIS
• WebService / API / system integration experience
• Basic web development skills using JavaScript, Angular or similar
• Programming in .Net (C#) and other object-oriented languages
• Hands on experience with implementation, functionality and operation of enterprise systems including (ERP) or Commodity Trading & Risk Management Systems (ETRM/CTRM)

 

Personal & Professional Competencies:

• Strong analytical skills with precision and attention to detail in all aspects of written and verbal communication
• Strong teamwork within a distributed team in US and Europe – ability to delegate and/or help teammates in equal measure while inspiring teammates to partner and cooperate
• Strong business skills working directly with commercial, back office, and systems vendor staff
• Intellectual curiosity and ability to learn quickly and retain knowledge
• Demonstrable ability and determination to get to the root of the issue through strong analytical thinking skills
• Excellent time management skills with sharp focus on deadlines
• Disciplined work habits leading by example
• Accountable for professional and personal behavior – acting with honor and character

 

Education:

• Bachelor’s degree in computer science, software engineering, or a related discipline
• Languages:
  o English: Excellent business verbal and written proficiency