What are the responsibilities and job description for the Power BI Administrator/Developer position at Merican Inc?
Power BI Administrator / Developer
Remote
We are seeking a Power BI Administrator / Developer with expertise in both the administration
and development aspects of Power BI. The ideal candidate will have a strong track record of
building impactful dashboards and reports, coupled with the ability to manage capacity
migrations and optimize data ecosystems. We're looking for someone proactive, self-driven, and
able to work independently without the need for handholding.
Key Responsibilities :
1. Power BI Administration :
o Manage and maintain Power BI workspaces, datasets, and dataflows.
o Administer and optimize Power BI Premium and Fabric capacities, ensuring
efficient utilization.
o Perform capacity planning, scaling, and migration from Power BI to Fabric
capacity.
o Ensure security, compliance, and governance of the Power BI / Fabric
environment.
o Troubleshoot performance and connectivity issues within Power BI / Fabric.
2. Dashboard and Report Development :
o Design and develop user-friendly, visually impactful dashboards and reports
tailored to business requirements.
o Ensure optimal performance of reports by implementing efficient data modeling
and DAX calculations.
o Collaborate with business stakeholders to gather requirements and deliver
actionable insights.
3. Data Integration and Migration :
o Lead the migration of Power BI capacity to Microsoft Fabric capacity, including
planning, execution, and post-migration validation.
o Integrate data from various sources into Power BI / Fabric for centralized
reporting.
o Develop and maintain reusable data pipelines and datasets.
4. Proactive Collaboration and Innovation :
o Identify opportunities for process improvements and automation within the BI
ecosystem.
o Stay up-to-date with the latest Power BI and Fabric features and implement best
practices.
o Act as a subject matter expert to train and mentor team members on Power
BI / Fabric.
Required Skills and Qualifications :
Experience :
o 5 experiences with Power BI administration.
o Hands-on experience with Microsoft Fabric capacity, including migration from
Power BI capacity.
o 5 experiences in building interactive dashboards, reports, and data models.
Technical Expertise :
o Strong understanding of DAX, Power Query, and advanced data modeling
techniques.
o Knowledge of Fabric architecture, capacity planning, and optimization.
o Familiarity with Azure Synapse, Data Lake, or other Fabric-related components is
a plus.
Soft Skills :
o Proactive, self-motivated, and capable of working independently.
o Strong problem-solving, analytical, and communication skills.
o Ability to collaborate with cross-functional teams and business stakeholders.
Preferred Qualifications :
Microsoft certifications in Power BI, Fabric, or related technologies.
Experience in automating administrative tasks using PowerShell or REST APIs.
Exposure to Agile methodologies and project management tools.
