Job Description:Merkle, a dentsu company, powers the experience economy. For more than 35 years, the company has put people at the heart of its approach to digital business transformation. As the only integrated experience consultancy in the world with a heritage in data science and business performance, Merkle delivers holistic, end-to-end experiences that drive growth, engagement, and loyalty.Merkle’s expertise has earned recognition as a “Leader” by top industry analyst firms, in categories such as digital transformation and commerce, experience design, engineering and technology integration, digital marketing, data science, CRM and loyalty, and customer data management. With more than 16,000 employees, Merkle operates in 30+ countries throughout the Americas, EMEA, and APAC. For more information, visit .This is not a current open role. Please apply to this ad if you would like to join our Talent Community and be considered for future potential openings.We are looking for Senior Business Intelligence Consultants to join our Talent Community.Please apply to this ad if you would like to be considered for our Business Intelligence Talent Community, and to be kept in the loop on future job openings in our team.We have hybrid offices in Zurich, St. Gallen, Geneva and Lausanne.Job DescriptionWe are looking for an enthusiastic Senior Business Intelligence Consultants to join our team of Data Heroes. You will help our clients to get new insights from data, analyse and visualise their business to enable smarter decisions and better products & services delivery. Your primary focus will be in understanding business goals/KPIs, data ingestion, analysis and visualisation in cloud-based reporting tools.You will cooperate with other data roles (architects, scientists and engineers) in the team on large international projects for the biggest world brands. You should be a versatile self-starter eager to support data-driven businesses, and also a great team player able to work within our international team with a positive, startup-minded attitude.Here are some of the exciting tasks awaiting you:

• Participation in initial workshops with client’s stakeholders to validate goals, expected inputs & deliverables
• Doing initial requirements gathering, logical models, functional & technical designs
• Performing data analysis of business reqs., understanding source data and map them to the target/common data model
• Defining and implementing reports to visualise insights/KPIs on dashboards, using BI tools like PowerBI or Tableau
• Working with data engineers to productionize data pipelines and automate reports generation & distribution

QualificationsA mix of the following is the person we are looking for:

• Previous experience in similar BI functional role (5+ years) preferably in telco, financial or digital marketing services industry
• Past experience in using BI tools like PowerBI, Tableau, Qlick Sense, Keboola
• Solid proficiency in data warehousing concepts (ETL, Stage/Core layer, Dimensional Modelling, Data Marts etc.) and SQL programming
• Experience with SQL databases, such as Oracle or MS SQL Server
• Strong analytical and communication skills, data-oriented personality

Preferred Skills:

• Hands-on experience in MS Azure, AWS, Snowflake or other cloud-based environments is a big plus
• Experience with NoSQL databases such as MongoDB, Cassandra, Hadoop, HBase
• Proficiency in scripting languages like Python/Javascript
• Understanding of big data processing using technologies like Hadoop, Spark, etc.
• Understanding of data workflow management and ETL tools like Informatica, Pentaho, Azure Data Factory, Airflow, NiFi, StreamSets, Glue, etc.
• Business expertise in areas of Digital Marketing (AdTech), Marketing Automation, CRM or e-commerce is a significant advantage
• Fluency in French or German is a plus

Additional informationWhy you should work with us?!

• We are cooperating with an all types and sizes of clients from all around the world which allows us to provide a very diverse portfolio of projects and technologies to choose from to our people.
• You will be part of a startup-minded branch of a company with a very strong and stable background of the Swiss headquarters.
• Your contributions will have a distinct impact on our clients

We work with motivated people, who support and enrich each other. We live the possibilities of the digital world through home office, meaning you can work anywhere (within Switzerland) with flexible (annual) working hours. We also value face-to-face exchanges – coffee or tea, biscuits or fruit are all welcomed on board and shared throughout our offices.If you ever feel the need to take a break from the digital world, we love to get hands-on together and use pens, paper, and whiteboards for brainstorming sessions. Need to clear your head? Hit the foosball table, PlayStation, massage bench or yoga mat. For networking and (brain) food, we offer regular exchange formats, like meetings, tech labs and more. Not enough? We are full believers in education and support training, whether it be internally or externally. We supportyou.These are some of the things we offer:

• 40-hour week & overtime compensation
• Independent home office management
• Flexible working hours model (flextime)
• Additional days-off on top of holidays (wellness days, volunteer days)
• State-of-the-art, creative office space with ergonomically equipped workstations
• Wide range of further education and development opportunities through our in-house Academy
• Various discounts e.g. for lunch options

We value diversity and therefore welcome all applications – regardless of gender, nationality, ethnic and social origin, religion/worldview, disability, age, as well as sexual orientation and identity.#LI-MERKLELocation: Geneva – 20 Quai Ernest – AnsermetBrand:Time Type: Full timeContract Type: Permanent