We are looking for a skilled BI Developer with expertise in T-SQL, SSAS, and Power BI. This role involves supporting existing processes, creating and optimizing reports, and maintaining an end-to-end understanding of the BI environment. The ideal candidate will possess technical depth, analytical skills, and a collaborative mindset to drive insights and improvements in data-driven decision-making.
Key Responsibilities
- Process Support. Manage and support existing data processes, ensuring data integrity, performance, and reliability across BI systems.
- Data Analysis and Reporting. Design, develop, and maintain SSAS cubes and Power BI reports to support business intelligence needs.
- End-to-End BI Environment Understanding. Gain a comprehensive understanding of the BI environment, from data sourcing to reporting and visualization.
- Data Optimization. Analyze and optimize T-SQL queries and stored procedures for improved performance and efficiency.
Required Skills
- T-SQL. Advanced knowledge of T-SQL for data querying, manipulation, and performance optimization.
- SSAS (SQL Server Analysis Services). Experience in creating, managing, and maintaining SSAS cubes.
- Power BI. Proficiency in Power BI for data visualization and report building.
Nice-to-Have Skills
- Azure DevOps. Familiarity with CI/CD pipelines to support the deployment and automation of BI solutions.
- Azure Data Factory. Knowledge of Azure Data Factory for data integration, pipeline development, and workflow automation.
- High-Performance Document Databases. Understanding of document databases like Cosmos DB, DynamoDB, or MongoDB.
- Logical DBA Tasks. Experience in basic database administration tasks, such as performance tuning, indexing, and backups.
- SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services). Hands-on experience with SSRS for reporting and SSIS for ETL processes.
Qualifications
- Experience. 3+ years in BI development, including hands-on experience with T-SQL, SSAS, and Power BI.
- Education. Bachelor’s degree in Computer Science, Information Systems, or a related field.
Why Join Us?
- Innovative Environment. Work on cutting-edge BI technologies to support data-driven decision-making.
- Growth Opportunities. Expand your skill set with access to Azure tools, document databases, and DevOps practices.
- Impactful Work. Play a vital role in delivering insights that shape business strategies and outcomes.
This is a great opportunity for someone passionate about data, technology, and creating impactful solutions. Apply today to join our team!