Senior Business Intelligence Architect

About this role

What are we looking for? Woodard & Curran is seeking an experienced Senior Business Intelligence Architect to lead the design, development, governance, and optimization of our enterprise analytics and reporting environment. This role will serve as the organization's Power BI and Microsoft Fabric subject matter expert, partnering with business leaders, ERP stakeholders, developers, and data teams to deliver scalable analytics solutions that support strategic and operational decision-making.

The ideal candidate combines deep technical expertise with a strong understanding of finance, project accounting, project delivery, forecasting, resource management, and business operations. This individual will play a key role in shaping our analytics strategy, advancing reporting capabilities, and ensuring the reliability and performance of enterprise business intelligence solutions. What's in it for you? Opportunity to lead enterprise-wide analytics strategy and architecture.

Influence executive decision-making through modern reporting and data solutions. Work with leading Microsoft technologies, including Power BI, Fabric, OneLake, Dynamics 365, Dataverse, and Azure. Mentor and develop analytics professionals while helping shape the future of data at Woodard & Curran. Collaborative culture focused on innovation, continuous improvement, and business impact. Remote Opportunity Location: Anywhere in US Travel: Up to 5% What you will be doing at Woodard & Curran: Lead the architecture, development, governance, and support of enterprise Power BI and Microsoft Fabric solutions.

Design and maintain semantic models, data marts, dashboards, KPIs, and executive reporting solutions. Partner with business stakeholders to gather requirements and translate business needs into scalable analytics solutions. Support reporting and analytics for Microsoft Dynamics 365 Finance & Operations and Project Operations. Develop and optimize Power BI datasets, dataflows, DAX calculations, Power Query transformations, and reporting frameworks.

Establish analytics governance, development standards, security models, and deployment best practices. Implement source control, release management, and CI/CD processes using Azure DevOps and Git. Ensure data accuracy, performance, reliability, and alignment with authoritative source systems. Monitor and support production analytics environments, including refresh processes, data quality, and platform performance. Evaluate emerging Microsoft technologies and recommend improvements to analytics capabilities.