About the job
Power BI Administration:
- Oversee and manage the Power BI service, including workspaces, datasets, reports, and dashboards.
- Continuously monitor and optimize Power BI performance, including data refresh schedules and query efficiency.
- Implement and uphold security protocols, including row-level security (RLS) and role-based access control (RBAC).
- Diagnose and resolve issues related to Power BI reports, data sources, and gateways.
- Collaborate closely with business users to design and implement Power BI solutions that align with organizational requirements.
- Keep abreast of the latest Power BI features and updates, implementing best practices accordingly.
SSIS (SQL Server Integration Services) Administration:
- Design, develop, and maintain robust ETL (Extract, Transform, Load) processes utilizing SSIS.
- Monitor and enhance SSIS package performance while troubleshooting any failures.
- Manage the SSIS catalog, overseeing the deployment and scheduling of packages.
- Ensure data integrity and accuracy through effective data validation and error handling practices.
- Work in tandem with database administrators and developers to integrate SSIS with other systems.
SSAS (SQL Server Analysis Services) Administration:
- Administer and maintain SSAS instances, including both multidimensional and tabular models.
- Optimize SSAS cube performance through strategies like partitioning, aggregations, and processing schedules.
- Establish and manage security roles and permissions within SSAS.
- Troubleshoot and resolve issues related to SSAS processing, queries, and connectivity.
- Collaborate with data architects and analysts to design and deploy effective SSAS solutions.
General Responsibilities:
- Monitor the health, performance, and availability of BI tools and services.
- Perform routine backups, updates, and patches for BI tools and related systems.
- Document processes, configurations, and best practices for efficient BI administration.
- Provide technical support and training to end-users and stakeholders.
- Work with cross-functional teams to ensure BI tools align with business objectives.
- Stay informed about industry trends and emerging technologies in BI and data analytics.
- Develop Analysis Services reporting models.
- Migrate Self-Service Reports from Oracle BI and Tableau to Power BI Self-Service.
- Transfer Reports and Dashboards from Oracle BI to Power BI.

