Business Intelligence Developer

Company Overview

Company information is not specified.

Job Summary

The Business Intelligence Developer will design, develop, and deploy end-to-end Business Intelligence (BI) solutions using the Microsoft Business Intelligence (MSBI) suite. This role focuses on creating data-driven solutions that support retail business units, enhancing operational efficiency and decision-making through robust reporting and analytics.

Responsibilities

• Design, develop, and deploy end-to-end BI solutions using the MSBI suite (SSIS, SSRS, SSAS).
• Create complex ETL packages in SQL Server Integration Services (SSIS) to extract, transform, and load data from various retail systems.
• Develop operational and analytical reports and dashboards in SQL Server Reporting Services (SSRS) to support retail business units such as sales, inventory, and supply chain.
• Build and maintain SQL Server Analysis Services (SSAS) cubes for multidimensional analysis and reporting.
• Collaborate with business analysts, data analysts, and stakeholders to gather BI requirements and convert them into technical specifications.
• Optimize data models and queries for performance and scalability.
• Ensure data accuracy, integrity, and consistency across all BI solutions.
• Monitor and troubleshoot BI processes and data issues.
• Stay updated with retail industry trends and BI best practices.

Qualifications

• Strong experience with MSBI tools: SSIS, SSRS, and SSAS.
• Solid understanding of data warehousing concepts and ETL frameworks.
• Proficient in T-SQL, stored procedures, functions, and query optimization.
• Hands-on experience with dimensional modeling (star/snowflake schemas).
• Experience working with large volumes of retail transactional data.
• Familiarity with Point of Sale (POS), inventory, Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), or loyalty systems in retail.
• Strong problem-solving and communication skills.
• Bachelor’s degree in Computer Science, Information Systems, or a related field.

Preferred Skills

• Experience with Power BI or other modern data visualization tools.
• Knowledge of Azure Data Factory, SQL Server on Azure, or other cloud BI solutions.
• Experience with Agile/Scrum methodologies.

Experience

Minimum experience requirements are not specified.

Environment

Typical work setting and location are not specified.

Salary

Salary details are not specified.

Growth Opportunities

Career advancement opportunities are not specified.

Benefits

Benefits are not specified.