BI Developer

Job Summary:
We are seeking a highly skilled Business Intelligence (BI) Developer with expertise in Microsoft SQL technologies, including SSIS, SSRS, and SSAS, as well as strong experience in SOAP API integration. The ideal candidate will be responsible for troubleshooting and optimizing the data flow from our POS/Retail franchise systems into our data warehouse. This role requires a deep understanding of C# to interact with SOAP APIs and ensure seamless data integration and reporting.

Key Responsibilities:

• Develop, maintain, and optimize ETL processes using SQL Server Integration Services (SSIS).
• Design, create, and manage reports and dashboards using SQL Server Reporting Services (SSRS).
• Develop and enhance analytical models and cubes with SQL Server Analysis Services (SSAS).
• Troubleshoot and optimize SOAP API integrations that feed POS/Retail data from franchises into the data warehouse.
• Develop and maintain C# applications to interact with SOAP APIs for seamless data exchange.
• nalyze and resolve data inconsistencies and performance issues in data integration and reporting.
• Work closely with database administrators, analysts, and business users to define data requirements and provide BI solutions.
• Ensure data accuracy, security, and integrity across all BI solutions.

Required Skills & Qualifications:

• Strong experience with Microsoft SQL Server BI stack (SSIS, SSRS, SSAS).
• Proven expertise in SOAP API integration and troubleshooting.
• Proficiency in C# (C Sharp) for developing and maintaining API interactions.
• Hands-on experience with data warehousing concepts and ETL processes.
• Strong analytical and problem-solving skills with the ability to diagnose and resolve technical issues.
• Experience with POS/Retail data is highly desirable.
• Excellent communication skills and ability to work collaboratively across teams.