- Company Name
- GCS
- Job Title
- BI Specialist (SQL/Azure) - Perm (FTC) - Hybrid
- Job Description
-
**Job Title:**
BI Specialist (SQL/Azure)
**Role Summary:**
Design, build, and maintain enterprise‑grade Business Intelligence solutions on the Microsoft stack (SSAS, SSRS, Power BI) within an Azure environment. Ensure seamless integration with third‑party reporting tools, implement secure reporting practices, and collaborate with cross‑functional teams to deliver high‑quality analytics.
**Expectations:**
- Deliver performant SSAS models, SSRS reports, and Power BI dashboards meeting business requirements.
- Manage data refresh, security, and governance across Azure BI services.
- Enable interoperability with Tableau, Amazon QuickSight, and other platforms.
- Participate in CI/CD pipelines and DevOps processes for BI assets.
- Contribute to documentation, data standards, and continuous improvement initiatives.
**Key Responsibilities:**
- Design, develop, and maintain multidimensional and tabular SSAS cubes.
- Create and optimize SSRS data models and paginated reports.
- Build interactive Power BI dashboards using advanced DAX and Power Query.
- Configure row‑level security, role‑based access, and Azure AD integration.
- Integrate Microsoft BI tools with external reporting platforms via APIs or embedded solutions.
- Monitor and tune performance of data models and reports.
- Collaborate with data engineers, analysts, and product stakeholders to evolve reporting architecture.
- Support automated deployment of BI assets through Git and DevOps pipelines.
- Produce documentation and support data governance, cataloguing, and lineage efforts.
**Required Skills:**
- Strong hands‑on experience with SSAS (multidimensional & tabular).
- Proficiency in SSRS report development and maintenance.
- Expert-level Power BI skills: Power Query, DAX, visual design, service deployment.
- Advanced T‑SQL for data extraction and performance tuning.
- Familiarity with Azure SQL DB, Synapse Analytics, Data Factory, Azure Analysis Services.
- Experience with data refresh strategies, gateways, and secure Power BI environments.
- Ability to integrate Microsoft BI with Tableau, Amazon QuickSight, REST APIs, or Power BI Embedded.
- Knowledge of dimensional modelling, star/snowflake schemas, and data‑warehouse best practices.
- Understanding of CI/CD concepts for BI (Git integration, DevOps pipelines).
**Required Education & Certifications:**
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience).
- Preferred certifications: Microsoft DA‑100 (Analyzing Data with Power BI), DP‑500 (Designing and Implementing Enterprise‑Scale Analytics Solutions), MCSE: Business Intelligence, or similar.