BI Developer

The main responsibilities of our BI Developer include designing, implementing, maintaining, and continually improving our BI infrastructure. They must collaborate with BI Analysts and Data Analysts to ensure high-quality and easily accessible data, while maintaining security and acceptable performance levels. They should possess the vision to design a roadmap for incremental, dynamic, high fault-tolerance, and high-performance pipelines, in collaboration with platform developers.

•  Experience in designing data warehouses using various methodologies, such as the data bus (Kimball), Data Vault, etc.

•  Experience in creating dynamic pipelines with SSIS and stored procedures.

•  Proficiency in writing complex queries and familiarity with SQL objects like Stored Procedures, Functions, etc., to implement business logic in pipelines.

•  Experience in designing SSAS databases and writing measures in DAX.

•  Expertise in performance tuning of SQL Server and queries.

•  Experience in monitoring BI infrastructure, including OS, SQL Server, SSIS, SSAS, and Power BI Server.