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