Design and implement the data engineering solutions;
Design and implement data modelling, interfaces definition, technical and functional documentation;
Design, analyse, and implement of Business Intelligence components such as Data Warehouses, Data Lakes, Data Marts, ETLs, Reporting Tools, Analytics, Data Mining Tools;
Design and implement data cleansing, data preparation or other type’s data processing solutions using the available SAS, Oracle or other tools;
Write code, debug, test and improve;
Work in an agile/iterative way such as participate in drafting the backlog, user stories, definition of the sprints;
Follow up, coordinate and facilitate all data manipulation activities and initiatives;
Collect business requirements and interact with the business users;
Provide support and training on data manipulation and processing to the different stakeholders;
Draft and/or review technical requirements for a data analytics environment, both in terms of hardware and software and creation of functional architecture for a data analytics environment;
Contribute to the planning of related activities;
Draft progress and technical reports;
Follow-up on IT delivery, including the activities of external contractors;
Signal risks and propose measures to mitigate those risks;
Coordinate the stakeholders such as business users, infrastructure team.
Requirements
University degree in IT or a related field with minimum 13 years of professional IT experience;
Any of the following SAS certifications: SAS Certified Base programming specialist, SAS Certified Advanced Programming Professional, SAS Certified Clinical Trials Programmer, SAS Certified Data Scientist, SAS Certified Advanced Analytics Professional, SAS Certified Predictive Modeller;
Expert knowledge with a minimum of 5 years of experience with the SAS tools (SAS Vaya, SAS Enterprise guide, SAS Visual Analytics);
Minimum 5 years of expert knowledge in SAS programming language;
Expert knowledge with a minimum of 5 years of experience on identifying performance bottlenecks when working with big data, including in the non-SAS database layer, as well as tuning the SAS tools and code for better performance;
Expert knowledge with a minimum of 5 years of experience of database programming & data modelling;
A database programming certification shall be considered an asset;
Expert knowledge with a minimum of 5 years of experience on Data Warehousing techniques, designs and implementation;
Minimum 5 years’ experience in implementing projects in an agile way;
Minimum 3 years’ experience in estimating the hardware requirements needed to ensure the performance requirements of big data projects;
Minimum 3 years’ experience in gathering requirements from the business users, preparing test data and executing test cases interacting with the business users;
Minimum 3 years’ experience in working on projects involving a large number of stakeholders;
Ability to draft functional and technical documents, reports;
A background in statistics and experience with the SAS statistical functions are considered to be an asset;
Experience with other big data tools and languages (R, Python, Stata) is considered to be an asset.
