Senior Power BI & DW/BI Administrator – Remote

GovCIO; Helena (MT); Remote; USD 170,000 - 190,000; Full time

Benefits offered by this job

Employee Assistance Program (EAP)

Corporate Discounts

Learning & Development platform

Certification Assistance

Referral Bonus Program

Internal Mobility Program

Pet Insurance

Flexible Work Environment

Job summary

Responsibilities include designing and delivering interactive Power BI dashboards, building data models, connecting diverse data sources, optimizing performance, and enforcing security and access controls. Collaboration with analysts and leadership is essential for data-driven decisions.

Qualifications

• Bachelor's degree with 12+ years of relevant experience or commensurate experience.
• Design, develop, and maintain interactive Power BI dashboards and reports.
• Build and optimize data models using Power Query (M) and DAX.
• Connect Power BI to data sources and manage data refresh schedules and permissions.
• Analyze and troubleshoot performance issues in reports and data models.
• Collaborate with analysts, engineers, and leadership to meet reporting needs.

Responsibilities

• Generates Ad-Hoc PBI Reports.
• Conducts PBI Training (Instructor-led Class Development, Delivery).
• Installs and configures DW/BI software to meet customer needs in accordance with enterprise architecture.
• Continuously tunes environment to optimize performance of DW/BI software.
• Designs, implements, and updates user management solutions for access control.
• Evaluates vendor software updates and patches to mitigate risks.
• Makes recommendations for changes to software/hardware for better DW/BI capabilities.
• Ensures smooth operations of DW/BI software through monitoring and patching.
• Supports user administration for role-based security.
• Performs upgrades to add features and ensure security and support.

Skills

Power BI

DAX

Data modeling

SQL Server

ETL

Performance tuning

Stakeholder collaboration

Education

Bachelor's degree

Tools

Power BI Service

Power BI Desktop

Oracle

Excel

APIs

Job description

Responsibilities include designing and delivering interactive Power BI dashboards, building data models, connecting diverse data sources, optimizing performance, and enforcing security and access controls. Collaboration with analysts and leadership is essential for data-driven decisions.