We are seeking a skilled BI Developer with strong expertise in T-SQL, SSAS, and Power BI to join our dynamic team. The ideal candidate will have an in-depth understanding of Business Intelligence processes, be able to support and optimize existing BI infrastructure, and ensure data-driven insights are delivered effectively. This role requires end-to-end knowledge of the BI environment, from data ingestion to visualization.
Key Responsibilities
- Develop and maintain T-SQL scripts for data manipulation and reporting.
- Utilize SQL Server Analysis Services (SSAS) to create and manage OLAP cubes and multidimensional data models.
- Design, develop, and implement Power BI reports and dashboards for data visualization and business insights.
- Support and troubleshoot existing BI processes to ensure smooth, efficient operation and data accuracy.
- Conduct data analysis to support decision-making processes, providing actionable insights and reporting improvements.
- Collaborate with cross-functional teams to gather requirements and optimize BI solutions.
Nice to Have
- Azure DevOps (CI/CD Pipeline). Experience with continuous integration and continuous deployment pipelines in Azure DevOps for streamlined BI solution delivery.
- Azure Data Factory. Knowledge of data integration and transformation in Azure, with an understanding of how to orchestrate data workflows and ETL processes.
- High-Performance Document Databases. Familiarity with Cosmos DB, DynamoDB, MongoDB, or similar NoSQL databases to support scalable, high-performance data storage solutions.
- Logical DBA Tasks. Understanding of database administration tasks, including backup and restore, performance tuning, and query optimization.
- SSRS and SSIS. Proficiency with SQL Server Reporting Services (SSRS) for report generation and SQL Server Integration Services (SSIS) for ETL processes.
Qualifications
- Proven experience with T-SQL, SSAS, and Power BI.
- Strong problem-solving skills and attention to detail in a data-driven environment.
- Ability to work independently and manage multiple priorities effectively.
- Excellent communication skills and a collaborative mindset.
Join us to make impactful data solutions that drive our business forward with clear insights and strategic intelligence. If you're passionate about BI and thrive in a dynamic environment, we’d love to hear from you!