BI/DW Consultant

DescriptionAt Uni Systems, we are working towards turning digital visions into reality. We are continuously growing and we are looking for a BI/DW Consultant to join our UniQue team.What will you be doing in this role? Gather and analyze business requirements, advise the business and external IT suppliers, and participate in project meetings to ensure compliance with IT Governance standards and the Institution’s technical stack. Create and maintain Enterprise Data Warehouses (EDW) and Business Intelligence solutions, including Data Lakes and Data Lakehouses. Develop and maintain data pipelines and foundational datasets to support analytics, modeling, experimentation, and business/product needs. Design and build database architectures for large and complex datasets, balancing usability, computational efficiency, and cost. Design and develop reporting applications and scalable dashboards, primarily using Power BI, to support business objectives and enable data-driven decision-making. Design cloud (primarily Azure), hybrid, and on-premises architectures, including ETL processes using corporate-approved tools such as Microsoft Synapse. Perform physical database design and collaborate with DevSecOps teams for DB performance analysis. Design data quality and performance monitoring processes. Produce technical documentation, including architecture overviews and technical specifications. Support the Service Manager of the Institution’s Data Platform in daily activities. Collaborate closely with data science, engineering, and DevSecOps teams to enhance instrumentation and monitoring coverage, accuracy, and reliability. Assist DevSecOps teams with system deployment and configuration. RequirementsWhat do you need to succeed in this position? Master's degree with minimum of 9 years of relevant experience (or Bachelor's degree with minimum of 13 years of relevant experience). Minimum 2 years of experience in designing ETL/data pipelines using Microsoft Synapse. Certification on Microsoft Synapse (e.g., Microsoft Azure Data Engineer Associate) or a minimum of 3 years of hands-on experience with similar market products. At least 2 years of experience with data warehouse, data lake, and data lakehouse design. Minimum 2 years of experience with relational database systems applied to data warehouses. Excellent ability to produce requirements documents for data analytics systems. Strong knowledge of non-relational database technologies; specific knowledge of vector databases used to store embeddings in AI-based solutions (e.g., RAG) is considered an asset. At least 2 years of experience with access rights management in data warehouses/data lakes, including row-level access segregation based on user roles. Minimum 2 years of experience with SQL. Very good knowledge of Python and Apache Spark; knowledge of R is considered an asset. Minimum 2 years of experience in business intelligence reporting tools; specific knowledge of Microsoft Power BI is considered an asset. At least 1 year of experience with cloud-based design; knowledge of Microsoft Azure is considered an asset. At least 2 years of experience with online analytical processing (OLAP) and data mining tools. Good knowledge of written and spoken English is required (B2 level). At Uni Systems, we are providing equal employment opportunities and banning any form of discrimination on grounds of gender, religion, race, color, nationality, disability, social class, political beliefs, age, marital status, sexual orientation or any other characteristics. Take a look at  or more information.