We are looking for an experienced BI Developer to support and enhance our Business Intelligence (BI) environment. This role involves working closely with various teams to maintain and support existing processes, develop new insights, and provide comprehensive BI solutions that drive our data strategy forward.
Key Responsibilities
- Support Existing BI Processes. Troubleshoot and optimize current BI processes, ensuring they are efficient, accurate, and aligned with business goals.
- End-to-End Understanding of BI Environment. Develop and maintain a holistic view of the BI environment, encompassing data sourcing, transformation, storage, and reporting.
- T-SQL Development. Create and optimize T-SQL queries for data extraction, transformation, and load (ETL) processes to facilitate reporting and analytics.
- SSAS (SQL Server Analysis Services). Develop and maintain SSAS cubes to provide multidimensional analysis, supporting advanced data modeling requirements.
- Power BI Reporting. Design and implement Power BI dashboards and reports that provide actionable insights to stakeholders across the organization.
Nice-to-Have Skills
- Azure DevOps (CI/CD Pipelines). Experience with Azure DevOps, particularly in setting up CI/CD pipelines for seamless BI solution deployment.
- Azure Data Factory. Knowledge of Azure Data Factory for orchestrating data workflows and automating data movement across various sources.
- High-Performance Document Databases. Familiarity with high-performance document databases such as Cosmos DB, DynamoDB, or MongoDB, understanding their applications and performance optimization techniques.
- Logical DBA Tasks. Understanding of logical DBA tasks, such as database configuration, indexing, performance tuning, and backup management.
- SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services). Experience with SSRS for paginated reports and SSIS for ETL processes is an added advantage.
Ideal Candidate Profile
- Proficiency in T-SQL, SSAS, and Power BI, with a deep understanding of the BI lifecycle.
- Demonstrated experience in supporting and enhancing BI processes to ensure data accuracy and process efficiency.
- A collaborative team player with strong problem-solving skills, attention to detail, and a proactive approach to identifying and addressing BI-related challenges.
- Experience in a DevOps-driven BI environment and familiarity with cloud-based data solutions (Azure) is preferred.
Benefits
- Opportunity to work in a dynamic, data-driven environment
- Support for continuous learning and skill enhancement
- Collaborative work culture that values innovation and teamwork