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.
ثبت مشکل و تخلف آگهی
ارسال رزومه برای گروه زرین رویا