• Full BI development cycle, an understanding of how to implement end to end DataWarhouse and business intelligence projects • In-depth understanding of database management systems, OLAP and ETL framework • SQL database for table creation and data optimization • Advanced TSQL to write complex queries • DataWarehouse design (dimensional modelling, architecture, data mining) • Translate business needs to technical specifications • Designing, developing, deploy, documenting and maintaining BI solutions • Design and develop data mappings and ETL scripts • Dashboarding • Evaluate and improve existing BI systems, tools, maintenance and procedures • Designing and implementing reporting solutions • Aligning key performance indicators, reporting and analytics. • Develop and update business & technical documentation • Writing relational and multidimensional database queries • Debugging, monitoring and troubleshooting BI solutions and able to work on multiple projects. • Ability to solve problems, analyze incidents and attend to customer queries. • Great OO skills, including strong design patterns knowledge. • Experienced with using source control in a collaborative team setting. • Ability to communicate technical ideas to business users and other teams. • A strong communicator, that loves to investigate and find the best solutions for our clients. • Experience in high-volume, fast moving, deadline-driven studio environment. • Strong Tableau Experience Data Preparation Assess the effectiveness and accuracy of new data sources and data gathering techniques Extend the company’s data with third party sources of information when required Enhancing data collection procedures to include information that is relevant for building analytic systems Processing, cleansing and verifying the integrity of data used for analysis Identify valuable data sources and automate collection processes Undertake pre-processing of structured and unstructured data Analysis and Model Building Mine and analyses data to drive optimization and improvement of product development, marketing techniques and business strategies. Analyze large amounts of information to discover trends and patterns Optimize customer experiences, revenue generation & targeting and other business outcomes Develop custom data models to apply to data sets Combine models through ensemble modelling Develop company testing framework and test model quality