Job Description :
Avast Software (www.avast.com), a maker of the world's most popular antivirus, protects over 400 million computers and mobile devices with our security applications.
In business for over 25 years, Avast is one of the oldest companies in the computer security industry, with a portfolio covering everything from a free antivirus for PC, Mac, and Android, to premium suites and services for businesses offered in around 40 languages.
Based in Prague, the Czech Republic, with offices in many different countries, for example, Canada, Germany, USA, Holland and Taiwan, Avast Software employs some of the brightest new talents in the IT industry, from around 30 different countries.
For our team in HQ (Prague) we are currently looking for :
We are looking for an experienced BI Developer to join our Mobile Data team to help us build data platform from data produced by our apps for Android and iOS that are used by tens of millions of end customers.
You will be responsible for helping to create, maintain and evolve data pipelines, data cubes and reports used by other teams throughout the company (product teams, marketing, finance).
Currently we use a mixture of classical RDBMs (MS SQL Server, PostgreSQL) with technologies based on Hadoop platform (HDFS, Hive, Spark).
Data are then fed into MS Analysis Services (Tabular) and PowerBI / Excels.
Who are we looking for :
We are looking for a BI Developer who enjoys (big) data, enjoys to move them from one place to another and to shape them in an efficient way.
What we need :
At least two years of work as BI Developer with any of major BI stacks (we use MS SSAS, SSIS)
Practical knowledge of SQL handling large amount of data
Willingness and ability to learn new technologies
Knowledge of Hadoop platform and related technologies is not required (we will be happy to teach you)
To be proactive; self-starter
Experience with programming; we always try to simplify and get rid of repetitive work (java, spark, shell scripting)
Analytical and problem-solving skills with attention to detail to provide useful and usable output from ad hoc data analysis
What you will do :
You will write ETLs and manage data flows (used technological stack : Hive / Impala, Shell, Azkaban, Spark)
You will work with Hadoop infrastructure and multiple RDBMs
You will prepare new metrics from collected data
You will write checks and monitorings to ensure data quality
You will create and manage data cubes (MS Analyses services)
You might do ad hoc analyses motivated by business requests
What we offer :
Interesting job in an international team in a growing and a very successful company
Great benefits : food and drink provided all day by the company, game room, music studio, fitness center, golf simulator, library, great training system and much more
Flexible working hours, home office
Cafeteria benefit system, multisport card
25 days of holiday, 5 sick days
The chance to join a major global tech company
Opportunities for professional growth