We are seeking an experienced T-SQL, SSAS, and Power BI Developer to support and enhance our existing business intelligence (BI) processes. The ideal candidate will have a comprehensive understanding of the end-to-end BI environment and be proficient in T-SQL, SQL Server Analysis Services (SSAS), and Power BI for data analysis, reporting, and visualization.
Key Responsibilities
- Support existing BI processes. Maintain and improve current BI solutions, ensuring seamless data flow and high-quality reporting.
- End-to-end understanding of BI environment. Oversee the complete data lifecycle, from data collection and modeling to reporting and visualization, using tools like Power BI, SSAS, and T-SQL.
- Data analysis and reporting. Create, maintain, and optimize complex T-SQL queries, stored procedures, and views for effective data analysis.
- Develop and manage SSAS models. Design, develop, and maintain OLAP cubes, data models, and multidimensional expressions (MDX) to support reporting needs.
- Power BI reports. Create interactive dashboards and reports to provide business insights to stakeholders, ensuring performance optimization.
Nice to Have
- Azure DevOps – CI/CD pipeline. Experience with building and managing CI/CD pipelines for BI deployments, ensuring automated and continuous delivery of BI solutions.
- Azure Data Factory. Knowledge of data integration and orchestration using Azure Data Factory for transforming and loading data into the BI system.
- High-performance document DBs. Familiarity with NoSQL databases like Cosmos DB, DynamoDB, or MongoDB, and their integration with BI platforms.
- Logical DBA tasks. Understanding of logical DBA responsibilities, such as optimizing database performance, managing database security, and ensuring data integrity.
- SSRS and SSIS. Experience with SQL Server Reporting Services (SSRS) for custom reports and SQL Server Integration Services (SSIS) for data integration and ETL processes.
Qualifications
- Proven experience in T-SQL, SSAS, and Power BI development.
- Knowledge of Azure DevOps, Azure Data Factory, and document databases is a plus.
- Experience in SSRS and SSIS is desirable.
- Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
- Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
This job role is perfect for individuals with a solid foundation in BI tools and technologies, who are eager to expand their expertise with Azure services and high-performance databases.