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

Postuler à cette offre