Business Intelligence Developer

As a Business Intelligence Developer you will be responsible for desigining, developing and maintaining the company’s Data Warehouse and analytical OLAP and Tabular models while supporting the team as an IT department member according to IT procedures and commitments.

ACCOUNTABILITES

• Evolutive design and maintenance of corporate Data Warehouse based on MS SQL 2014 to fulfil company and customer specific data requirements. • Development of ETL procedures to gather required data using SSIS. • Design of analytical OLAP solutions models based on Microsoft SQL Server Analysis Services Multidimensional and Tabular. • Building of reports, scorecards and dashboards for sales, finance and customer service. Available frontend tools are Pyramid Analytics, Power BI and Excel 2016 KNOWLEDGE AND KEY SKILLS

Essential • +1 year designing ETL packages with MS SQL Server Integration Services (SSIS); Alternatively, +2 years working with other BI integration tools. • +2 years of professional knowledge with MS Excel 2013/2016; additional experience with Power BI and PowerPivot is a plus. • +1 year designing dashboards, reports and scorecards with analytical front-end tools such as Tableau, Qlikview, Pyramid Analytics, Microstrategy, SAP BO, etc. • +2 years designing relational data models and optimized queries to extract data and perform an integration across platforms. • English at intermediate level (B2 / First Certificate), specially written skills to communicate and to contribute to team documentation.

Desirable

• +2 years designing multidimensional OLAP data models. Experience with Microsoft SQL Server Analysis Services is a plus. • +2 years working with CRM data models for sales, customer service or support such as Salesforce CRM. • Proficient in the MDX language • Proficient in the T-SQL language and query fine tuning, analysing execution plans, SQL Server Profiler stats, I/O stats, etc. • IT graduate/undergraduate degree. • Previous working experience in the Contact Center environment as a consultant or technician.

Personal abilities:

• Team work is a must. • High capacity for analysis. • Very good communication skills. • High organizational capacity to deal with variable workload. • Flexible to change.

We offer

• Full-time contract, 39 hours/week, Monday to Friday • Temporary contract + Indefinite Contract • Opportunity to work in an international company

_Los procesos de reclutamiento y las personas que participan en ellos (los reclutadores y gerentes de proyecto) no discrimina ninguna candidatura Debido a la edad, la discapacidad, la condición étnica, estado civil, sexo, nacionalidad, ideología, política, raza, religión y orientación sexual