Business Intelligence Developer - (80-100%) (w|m|d) - Zurich - Hybrid Work

Company Description

Welcome to SMG Swiss Marketplace Group AG
We are a pioneering network of online marketplaces and a leading European digital company that simplifies people's lives with forward-looking products.

Job Description

As the new Business Intelligence Developer, you will be part of the Group Data Team (GDT). You will work together with data engineers, data architects, data product owners and diverse business domain stakeholders to make group-wide data more accessible, well-governed and understood.

As a contributor to the GDT, you will be responsible for delivering data products for our internal customers. To be effective in this position, you must be comfortable working with various business domains, a bottom-up management approach and be able to get up to speed with new technologies quickly.
 

Role Ratio:

• 60% Backend - data extraction, loading and transformation (ELT)
• 40% Frontend - data visualization (charts and dashboard building)

Your Responsibilities:

• Make use of the cloud infrastructure created by data engineers to extract, load and transform (ELT) data from different sources/domains into the Group Business Intelligence platform
• Develop reusable data assets (marts, reports, metrics, metadata) that reflect the business's needs and follow data protection guidelines
• Apply data warehousing best practices to the data assets and monitor them to guarantee data completeness, uniqueness, consistency, validity, accuracy and timeliness
• Follow naming standards guidelines and perform technical data documentation in order to have data assets metadata flowing into the group data catalogue and downstream tools
• Version code, deploy using continuous integration and continuous delivery tools, review code and test changes assuring data quality and business requirements satisfaction.
• Implement business-defined metrics and key performance indicators as a single source of truth
• Work closely with the BI Team Lead, Data Product Owner and Stakeholders to understand their needs/requirements in order to design data visualizations that bring value, business insights capabilities and help the teams measure the impact of their work
• Develop charts and dashboards using a cloud data visualization tool incorporating usability best practices and following SMG branding guidelines when designing it
• Collaborate with the remote teams making transparent your activities' progress and keeping Kanban board updated to keep track of tasks and documentation for future support on troubleshooting
• Participate and collaborate with the data engineering, data product enablement and business intelligence teams in different workshops to define objectives and key results (OKRs) that are achievable in order to promote innovation and learning

Qualifications

• You have a Bachelor’s or Master’s Degree in Information Technology, Data Analytics, Management Information Systems, Computer Science, Artificial Intelligence, Data Science or a related technical/data field
• You have at least 2 years of professional experience working with Structured Query Language (SQL ansi)
• You have at least 2 years of professional experience working with one data warehousing architecture (E.g. Star schema, Snowflake schema, One Big Table, Data Vault, Data Lake, etc)
• You have at least 1 year of professional experience working with business intelligence or/and analytics engineering or/and data engineering or/and data analysis
• You have experience with at least one modern cloud data warehousing tool. E.g. BigQuery (preferably), Azure, Redshift, Snowflake, etc. 
• You have experience with at least one data visualization tool. E.g. Looker (preferably), Tableau, Power BI, etc.
• You have experience with at least one code versioning tool. E.g. git (preferably), svn, etc.
• You have experience with at least one code repository platform. E.g. Github (preferably), Bitbucket, etc.
• You have strong interpersonal and collaboration skills, organization and attention to detail
• You have the ability to take initiative and engage in discussions related to requirements and data products
• Good verbal and written communication skills in English. German is a plus.

Nice to have experience with:

• Online marketplaces and/or digital businesses
• Google Cloud Platform data warehousing and business intelligence tools (BigQuery sql syntax, Looker as a LookML developer)
• Data Build Tool (dbt core) as a data transformation tool
• The git protocol and Github for code versioning and repository platforms
• Agile methodologies (E.g. Kanban, Scrum, Lean, etc)
• Continuous integration and continuous delivery (CI/CD)
• Atlan data catalogue tool
• Data mesh decentralized data architecture
• Python
• Notion
• Jira

Additional Information

Benefits you'll love and why you should join us
Your new team and the people you work with will consist of an international and diverse group of fantastic people.
We live a hybrid working model without fixed office days. You are welcome to work in our modern and spacious office in Zurich, or from your home base in Switzerland.

In addition, SMG offers you:

• 6 weeks of holidays (with the possibility to buy up to 10 additional days)
• 40-hour week (flexitime) We take work-life balance seriously
• 4 months' notice after the probationary period
• SBB Half-Fare Card
• You travel 1st class by train between SMG sites in Switzerland
• 18 weeks maternity and 6 weeks paternity leave (also in case of adoption)
• Professional accident and supplementary insurance (100% covered by SMG)
• No fixed office days (teams organize themself regarding onsite presence)
• Independent counselling centre for personal and psychological problems
• Gender-neutral fair pay with clearly defined career profiles
• Choose your hardware (Mac or Windows + 2 monitors for home)
• Choose your mobile phone (iPhone, Samsung or Pixel)
• Free Gym Facilities (Flamatt office only)

Apply Now! We are looking forward to getting to know you!

SMG Swiss Marketplace Group Ltd. is a pioneering network of online marketplaces and an innovative European digital company that simplifies people’s lives with groundbreaking products.

SMG Swiss Marketplace Group Ltd. provides customers with the best tools to meet their life decision needs. The portfolio includes Real Estate (ImmoScout24, Homegate, Immostreet.ch, home.ch, Acheter-Louer.ch), Automotive (AutoScout24, MotoScout24, CAR FOR YOU), General Marketplaces (anibis.ch, tutti.ch, Ricardo) and Finance & Insurance (FinanceScout24). The company is owned by TX Group AG (31%), Ringier AG (29.5%), La Mobilière (29.5%), and General Atlantic (10%).