We are seeking an experienced BI Developer with expertise in T-SQL, SSAS, and Power BI to support and enhance existing processes while delivering insights through business intelligence solutions. This role requires a comprehensive understanding of the end-to-end BI environment, encompassing data integration, analysis, and reporting. The ideal candidate will also have experience with modern Azure tools and CI/CD pipelines for streamlining development workflows.
Key Responsibilities
- Support and maintain existing BI processes to ensure consistent performance and data integrity.
- Develop, deploy, and manage SSAS solutions for multidimensional and tabular data models.
- Design and create Power BI dashboards, reports, and data visualizations to drive business decision-making.
- Write and optimize T-SQL queries for data extraction, transformation, and reporting.
- Work closely with business stakeholders to understand requirements and deliver actionable insights.
- Ensure seamless integration across the BI environment, maintaining high availability and performance of data solutions.
Nice-to-Have Skills
- Azure DevOps (CI/CD Pipelines). Experience in automating deployment and continuous integration processes, ensuring smooth delivery of BI solutions.
- Azure Data Factory. Ability to design, build, and manage data pipelines for integrating and transforming large datasets.
- Document Databases. Understanding of high-performance document databases such as Cosmos DB, DynamoDB, or MongoDB.
- Logical DBA Tasks. Familiarity with database administration tasks such as performance tuning, backups, and indexing.
- SSRS & SSIS. Experience with SQL Server Reporting Services (SSRS) for report generation and SQL Server Integration Services (SSIS) for data migration and ETL processes.
Required Experience
- Proven track record of working with T-SQL, SSAS, and Power BI in a BI environment.
- Strong analytical and problem-solving skills, with the ability to work independently and in a team.
- Excellent communication skills to collaborate with stakeholders and explain complex data insights.
This is a dynamic role for someone with a passion for data-driven decision-making and continuous improvement in BI processes. If you are an individual with a solid understanding of business intelligence and a drive for optimizing data workflows, we encourage you to apply!