> Markdown version of [/jobs/ext/219788-sr-business-intelligence-data-architect-power-bi-azure-federal-agency](https://www.wearedevelopers.com/jobs/ext/219788-sr-business-intelligence-data-architect-power-bi-azure-federal-agency). 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). --- # Sr. Business Intelligence Data Architect (Power BI & Azure - Federal Agency) - **Company:** Aalis Management Consulting - **Location:** Washington, DC, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Query Performance, Microsoft Word, Microsoft Excel, Business Analytics Applications, Microsoft Azure, Microsoft Outlook, Cloud Computing, Software Documentation, Information Systems, Data Architecture, Data Governance, Extract Transform Load (ETL), Data Systems, Data Visualization, Database Design, Dimensional Modeling, Executive Information Systems, Python (Programming Language), Microsoft Office, SQL Azure, Microsoft PowerPoint, Power BI, SQL Databases, Systems Architecture, Information Technology, Data Pipelines - **Published:** May 16, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=a427e2726f3ca34e ## About the Role Do you have experience in SQL?, Do you have a Bachelor's degree?, * Bachelor's degree in Informatics, Information Systems, Computer Science, Data Science, or a related field. * Minimum of 8 years of experience in business intelligence, data architecture, or analytics development. * Advanced experience with Power BI, Azure, SQL, and Python. * Experience designing enterprise data warehouses and cloud-based analytics platforms. * Strong knowledge of ETL/ELT development, dimensional modeling, and database design. * Excellent analytical, problem-solving, and communication skills. * Proficiency in the Microsoft Office, including Excel, PowerPoint, Word, Outlook, and Teams., * Microsoft Certified: Power BI Data Analyst Associate. * Microsoft Azure Data Engineer or Azure Solutions Architect certification. * Experience supporting federal agencies and Public Trust environments. * Familiarity with healthcare, engineering, or capital improvement data. ## Description Aalis Management Consulting seeks a highly qualified Sr. Business Intelligence Data Architect (Power BIAzure) to support a Federal Agency by designing, developing, and maintaining enterprise business intelligence and data architecture solutions. This position will play a critical role in transforming complex data into actionable insights through scalable data pipelines, cloud-based data warehouses, and executive dashboards. The successful candidate will collaborate with program managers, technical teams, and government stakeholders to architect data solutions that support reporting, analytics, and strategic decision-making. The ideal candidate will possess deep expertise in Microsoft Power BI, Microsoft Azure, SQL, and Python, along with strong communication and systems architecture skills., * Design and implement scalable data pipelines, ETL/ELT workflows, and enterprise data warehouses. * Develop interactive dashboards, scorecards, and reports using Power BI. * Architect cloud-based analytics solutions using Azure services, including Azure SQL, Data Factory, and Synapse Analytics. * Integrate and transform data from multiple internal and external sources. * Optimize data models and query performance for analytics and reporting. * Collaborate with stakeholders to gather requirements and translate business needs into technical solutions. * Prepare executive briefings and data visualizations to support decision-making. * Establish data governance, quality assurance, and documentation standards. * Troubleshoot and resolve data and reporting issues. * Identify opportunities to improve reporting processes and analytical capabilities. ## Related Videos - [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) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [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) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)