What are the responsibilities and job description for the business intelligence position at BURGEON IT SERVICES LLC?
Key Responsibilities
1.Architecture & Engineering
2.Design & Implement: Oversight over build out our Medallion Architecture (Bronze, Silver, Gold) using Fabric Lakehouses and Warehouses.
3.Providing best practices to data developers to insure fabric capacity is not over consumed and is optimized.
4.Data Integration: Develop efficient orchestration patterns using Data Factory pipelines and Dataflows Gen2, utilizing Shortcuts to minimize data duplication.
5.Design, implement and manage all connectivity to the MS Fabric including data load sources from SaaS providers Performance Tuning: Optimize semantic models for DirectLake mode to provide near-real-time reporting without the overhead of traditional Import modes.
6.CI/CD & DevOps: Establish deployment pipelines using Git integration to manage lifecycle transitions between Dev, Test, and Production.
Administration & Governance
1.Tenant Management: Configure and audit tenant settings, ensuring feature parity and security compliance across the organization.
2.Capacity Optimization: Monitor Fabric Capacity (F-SKUs) usage via the Capacity Metrics app; implement scaling strategies to balance performance and cost.
3.Security: Enforce fine-grained access control (RBAC), Row-Level Security (RLS), and Object-Level Security (OLS) across the Fabric ecosystem.
4.Purview Integration: Manage data discovery and lineage through Microsoft Purview to ensure data democratization remains compliant, design and enforce labels to ensure protection across Fabric.
5.Governance : Configure DLP policies to prevent unauthorized sharing or leakage of sensitive data from Lakehouses and Semantic Models.
6.Logging, Alerting & Capacity Management: Integrate Fabric with Azure Log Analytics for long-term auditing and trend analysis , proactive monitoring and manage throttling and smoothing events; identify "noisy neighbor" workloads and implement scaling or staggering strategies to ensure performance.
7.Power BI: Establishing standards and conduct training for non IT data access PowerBI users in support of our data governance programs