Cloud BI and Data Warehouse Specialist

  • Vicara Infotech Group AG
  • Switzerland
  • 02/05/2022
Full time Data Science Data Engineering Data Analytics Big Data Data Management Statistics Data Warehouse

Job Description

If you’re looking for a position that brings personal growth and fulfillment then Vicara is the right place for you. For you to thrive in this environment; you should be dynamic, willing to collaborate with our clients and provide solutions based on the understanding of customer needs.

We are looking to fill this position urgently and this position is only open to Swiss and EU citizens or with a valid work permit. Our requirement is for a Cloud Business Intelligence and Data Warehouse Expert with strong analytical and problem-solving skills, along with interpersonal skills to work across the organization and with external partners to drive forward projects and recommendations. Regional travel maybe required for this position.


  • Ability to provide innovative, performance ready and integrated cloud based BI technical solutions for business problems
  • Understand business requirements and owning technical design and solution and migrating traditional BI setups to the cloud (such as Azure)
  • Responsible for various project requirements, from high level business requirements to detailed functional and non-functional specifications. The individual will also be assisting in mock-up / design of solution, and managing the requirements for any changes and conflicting prioritization
  • The individual will have to serve as the Lead Designer of all ETL activities for projects and work closely with project Business Analyst and Data Modeler to ensure that the end to end designs meet the business and data requirements
  • Coordinating with teams across different functions/platforms and streams for multiple projects
  • Own the roadmap to deliver scalable and robust data infrastructure and BI capabilities across all operations
  • Maintain a strong understanding of evolving data warehouse and provide technical guidance across all operations

Mandatory Qualifications and Skills:

  • Master's degree in Computer Science or Information Science, or related field
  • 5+ years’ experience in a data architecture role as leading senior technical staff in demanding customer contexts
  • 5+ years in the areas of Data Quality, Data Governance, data integration (ETL, ELT) and Data Security
  • Experience with Enterprise workload migration to one or more Cloud platforms
  • Experience with Azure, Azure SQL Data Warehouse, BI tools on Azure
  • Advanced knowledge of data architecture principles, methods, and techniques
  • Demonstrated awareness of new systems technologies and how they could be leveraged to benefit customers and new business strategies
  • Experience with BI concepts (i.e metadata and master data management, data standardization, data pipeline, and integration of data silos) and data warehousing methodologies (i.e dimension models, data marts, and normalized repositories)
  • Expert knowledge of OLAP, modeling tools (such as Erwin and/or Rational Rose), business intelligence tools and ETL tools (Informatica, Data Stage, Data Manager, SSIS, or other)
  • Excellent Data Profiling abilities
  • Good knowledge in Reporting tools
  • Expert knowledge of SQL and related query and procedure languages
  • Experience in managing data warehouse project and lifecycle initiatives
  • Strong verbal & written communication skills in English
  • Excellent interpersonal and presentation skills with a proven ability to effectively communicate in both written and verbal formats across various levels of management and peer
  • Able to work with divergent and virtual team with a proven ability to influence
  • Ability to work with resources across the region
  • Action orientated with ability to work quickly and efficiently in a fast-paced environment
  • Possess the qualities, business acumen and discipline to ensure business and systems architecture alignment

Preferred Skills:

  • Subject matter expertise in Financial Services
  • Experience with Big Data and NoSQL technologies