Power BI DW/BI Architect — Remote

GovCIO; United States; Remote; USD 170,000 - 190,000; Full time

Job summary

GovCIO is seeking a PowerBI Technical Administrator to ensure smooth operations of DW/BI environments across the enterprise. The role involves installing, configuring, and optimizing BI software, including ETL and data management workflows for a US-based, fully remote team.

You will design and maintain interactive Power BI dashboards, build data models with Power Query and DAX, and connect to SQL Server and Oracle sources while enforcing security and performance best practices.

Qualifications

• Bachelor's degree with 12+ years' experience or commensurate experience.
• Design, develop, and maintain interactive Power BI dashboards and reports, translating business requirements into clear, actionable visualizations for technical and non-technical stakeholders.
• Build and optimize data models using Power Query (M) and DAX, including creating calculated columns, measures, and relationships to support accurate and efficient reporting.
• Connect Power BI to various data sources (SQL Server, Oracle, Excel, cloud services, APIs) and manage data refresh schedules, gateways, and workspace/access permissions within the Power BI Service.
• Analyze and troubleshoot performance issues in reports and data models, applying best practices in query optimization, data model design, and visualization efficiency.
• Collaborate with business analysts, database engineers, and leadership to gather reporting requirements, ensure data accuracy, and support data-driven decision-making across the organization.

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 to provide the appropriate levels of access to individual users and user groups in accordance with enterprise user authentication systems and customer security requirements.
• Evaluates vendor software updates to plan and implement software patches to mitigate security and vendor support risks.
• Makes recommendations for changes to software and hardware configurations that improve performance and capabilities provided by current DW/BI environment.
• Ensures smooth operations of DW/BI software through continuous monitoring and patching.
• Supports user administration for role-based security in accordance with enterprise user security guidelines.
• Performs upgrades as needed to incorporate new features and assure high levels of security and support.

Skills

Power BI dashboards

Power Query

DAX

SQL Server

Oracle

Data modeling

Performance tuning

Stakeholder collaboration

Education

Bachelor's degree

Job description

GovCIO is seeking a PowerBI Technical Administrator to ensure smooth operations of DW/BI environments across the enterprise. The role involves installing, configuring, and optimizing BI software, including ETL and data management workflows for a US-based, fully remote team.

You will design and maintain interactive Power BI dashboards, build data models with Power Query and DAX, and connect to SQL Server and Oracle sources while enforcing security and performance best practices.