DW/BI Architect (Remote)

United States Suitability/Public Trust Fully remote Information Technology Overview 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. 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. Qualifications Required Skills and Experience: 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 Posted Salary Range USD $170,000.00 - USD $190,000.00 /Yr. Company Overview GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens. But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer? What You Can Expect Interview & Hiring Process If you are selected to move forward through the process, here's what you can expect: During the Interview Process Virtual video interview conducted via video with the hiring manager and/or team Camera must be on 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 Employee Perks At GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and professional well-being, beyond the standard company offered health benefits, including: Employee Assistance Program (EAP) Corporate Discounts Learning & Development platform, to include certification preparation content Training, Education and Certification Assistance* Referral Bonus Program Internal Mobility Program Pet Insurance Flexible Work Environment *Available to full-time employees Our employees' unique talents and contributions are the driving force behind our success in supporting our customers, which ultimately fuels the success of our company. Join us and be a part of a culture that invests in its people and prioritizes continuous enhancement of the employee experience. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets. Posted Pay Range The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an "at-will position" and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors. GovCIO