> Markdown version of [/jobs/ext/2502746-dw-bi-architect-remote](https://www.wearedevelopers.com/jobs/ext/2502746-dw-bi-architect-remote). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # DW/BI Architect (Remote) - **Company:** GovCIO - **Location:** Trenton, NJ, United States (Remote available) - **Salary:** $190,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Application Programming Interfaces (APIs), Agile Methodology, Biometrics, Databases, System Configuration, Extract Transform Load (ETL), Data Warehousing, Microsoft SQL Server, Oracle (Applications), Query Optimization, Power BI, Cloud Services, Technical Data Management Systems, Powerquery, Hardware Infrastructure, User Administration - **Published:** August 2, 2026 - **Apply:** https://dejobs.org/x/x/9B0FFD603BA446FB83CADCB2E63E163F/job/ ## About the Role * Bachelor's with 12+ years (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. Preferred Skills and Experience: * Familiarity with Agile methodologies and project management tools. * Certifications in relevant technologies. Clearance Required: Ability to obtain and maintain a suitability/Public Trust, * A valid photo ID must be presented during each interview * During the Hiring Process * Enhanced Biometrics ID verification screening * Background check, to include: * Criminal history (past 7 years) * Verification of your highest level of education * Verification of your employment history (past 7 years), based on information provided in your application ## Description GovCIO is currently hiring a PowerBI Technical Administrator to ensure smooth operations of core software and infrastructures for data warehousing (DW) and business intelligence (BI) environments. This position involves installing, configuring, and optimizing software for DW and BI systems, including BI and ETL and data management software. This position is fully remote, located in the United States., * 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Biometric Phone Chargers, $40m Domain Names & AI Movies Winning Awards - Peter Kröner](https://www.wearedevelopers.com/videos/1810-biometric-phone-chargers-40m-domain-names-ai-movies-winning-awards-peter-kroner) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)