dentsu international
Senior Business Intelligence Consultant
Job Description
Company Description
We Dream. We Do. We Deliver.
As a full-service, data-driven customer experience transformation, we partner with Top 500 companies in the DACH region and in Eastern Europe. Originally from Switzerland, Merkle DACH was created out of a merger Namics and Isobar – two leading full-service digital agencies.
Our 1200+ digital enthusiasts are innovating the way brands are built, through providing expertise in Digital Transformation strategy, MarTech platforms, Creativity, UX, CRM, Data, Commerce, Mobile, Social Media, Intranet and CMS. We are part of the global Merkle brand, the largest brand within the dentsu group, who shares with us a network of over 66,000 passionate individuals in 146 countries.
Job Description
Job Description
- Participation in workshops with client’s stakeholders to validate goals, expected inputs & deliverables
- Doing requirements gathering, logical models, functional & technical designs
- Performing data analysis of business requirements, understanding source data and map them to the target/common data model
- Defining and implementing reports to visualize insights/KPIs on dashboards, using BI tools like PowerBI or Tableau
- Working with data engineers to productionize data pipelines and automate reports generation & distribution
Qualifications
Qualifications
- Previous experience in a 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 or other cloud-based environments is a big plus
- Business expertise in areas of Digital Marketing (AdTech), Marketing Automation, CRM or e-commerce is a significant advantage
- Understanding data workflow management and ETL tools like Informatica, Pentaho, Azure Data Factory, Airflow, NiFi, StreamSets, Glue, etc.
- Understanding of big data processing using technologies like Hadoop, Spark, etc.
- Proficiency in scripting languages like Python/JavaScript
Why should you work with us ?
- We are cooperating with 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 our people.
- You will be part of a startup-minded company branch with a solid and stable background in the Swiss/German headquarters.
- Your contributions will have a distinct impact on our clients
Additional Information
Additional information
Benefits and perks:
- Cutting Edge Technology & Latest IT tools;
- Software-house environment;
- Agile and Flexible working hours;
- Hybrid work system (remote friendly);
- Digital nomad policy;
- Focus on career development;
- Health insurance (also included for the household);
- Mental health support;
- Volunteering experiences and sustainable mindset;
- 25 vacation days + 3 wellness days per year;
- Beers (after 6pm), football, and ping-pong! #workhardplayhard
- Free breakfast every second Monday of the month;
- Employee discounts;
- Team & Company events 🎉
Inclusion & Diversity
We value the strength diversity brings to our business and are working hard to build a more inclusive workplace through partnerships with Stonewall, Business Disability Forum and Business in the Community’s race and gender equality campaigns. We are happy to discuss all flexible and agile approaches to working for all our roles – we can’t promise we will be able to offer you everything you want or need but we do promise to discuss it with you openly and honestly.
If you have any reasonable adjustment needs arising from a disability or medical condition to fully participate in the recruitment process, please discuss this with the recruiter who contacts you.
#LI-Hybrid
