We are seeking an experienced Senior Business Intelligence Architect to lead the design and evolution of enterprise analytics and reporting solutions. In this role, you will serve as a technical authority on Microsoft Power BI and Microsoft Fabric, transforming complex business data into actionable insights that support strategic and operational decisions. You will collaborate with business leaders, finance teams, ERP stakeholders, developers, and data professionals to build scalable, secure, and reliable analytics solutions. Your expertise will help optimize reporting capabilities across financial management, project accounting, forecasting, resource planning, and business operations. You will also establish data governance standards, improve platform performance, and drive modern development practices across the analytics ecosystem. This remote opportunity is ideal for a strategic technical leader who combines advanced data architecture expertise with business acumen, stakeholder engagement, and a passion for mentoring others.
- Enterprise analytics architecture: Lead the architecture, development, governance, optimization, and ongoing support of enterprise-wide Power BI and Microsoft Fabric solutions, ensuring scalability, reliability, and alignment with business objectives.
- Data modeling and reporting: Design and maintain semantic models, dimensional data models, data marts, datasets, dashboards, KPIs, and executive reporting frameworks that provide actionable insights to business stakeholders.
- Business requirements and stakeholder collaboration: Partner with business leaders, finance teams, ERP stakeholders, developers, and data teams to understand reporting needs and translate business requirements into scalable analytics solutions.
- ERP and financial analytics: Support reporting and analytics for Microsoft Dynamics 365 Finance & Operations and Project Operations, covering financial performance, project accounting, forecasting, utilization, resource management, and operational efficiency.
- Power BI development and optimization: Develop, maintain, and optimize Power BI datasets, DAX calculations, Power Query (M) transformations, dataflows, and reporting frameworks to improve performance and usability.
- Data governance and security: Establish and maintain analytics governance policies, development standards, access controls, security models, and deployment best practices to ensure data integrity, consistency, and compliance.
- Development lifecycle and automation: Implement and manage source control, release management, version control, and continuous integration and continuous delivery (CI/CD) processes using Azure DevOps and Git.
- Data quality and platform reliability: Ensure data accuracy and consistency with authoritative source systems, monitor production analytics environments, manage refresh processes, troubleshoot issues, and optimize platform performance.
- Technology innovation: Evaluate emerging Microsoft technologies and analytics capabilities, recommending improvements that strengthen the organization's data architecture and reporting environment.
- Technical leadership and mentoring: Mentor analytics developers and business intelligence professionals, promote best practices, and support continuous improvement across the analytics function.
- Executive decision support: Collaborate with senior leadership to develop strategic dashboards, KPI frameworks, and advanced business insights that inform planning, forecasting, resource allocation, and organizational performance.
Requirements
- Education: Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent professional experience.
- Professional experience: At least 10 years of experience in business intelligence, analytics, reporting, or data solutions, including 7 or more years of hands-on Power BI experience in complex enterprise environments.
- Technical leadership: Previous experience in a senior, lead, architect, or principal-level analytics role, with a demonstrated ability to lead technical initiatives, influence stakeholders, and mentor team members.
- Microsoft Power BI: Advanced expertise in Power BI architecture, dataset development, dashboards, reporting frameworks, DAX, and Power Query (M).
- Microsoft Fabric and OneLake: Strong knowledge of Microsoft Fabric and OneLake, including their application in enterprise data integration, storage, modeling, and analytics architectures.
- Data architecture and modeling: Deep understanding of semantic modeling, dimensional data modeling, data marts, analytics architecture, and enterprise reporting design.
- SQL and performance optimization: Advanced SQL development skills, with the ability to optimize queries, troubleshoot data issues, and improve performance across large or complex datasets.
- ERP and financial systems: Experience supporting Microsoft Dynamics 365 Finance & Operations and enterprise ERP reporting, with a strong understanding of finance, project accounting, forecasting, utilization, resource management, and operational reporting.
- Governance and security: Proven experience implementing analytics governance frameworks, security models, deployment pipelines, and enterprise reporting standards.
- DevOps and source control: Hands-on experience with Azure DevOps, Git, version control, release management, and CI/CD practices.
- Communication and stakeholder management: Excellent communication, analytical, and problem-solving skills, with the ability to explain complex technical concepts and translate business needs into effective data solutions.
- Microsoft certifications: Power BI and/or Microsoft Fabric certifications are preferred.
- Azure data ecosystem: Familiarity with Dataverse, Azure Data Services, Azure Data Factory, and lakehouse and warehouse solutions is an advantage.
- Power Platform: Experience with Power Apps and Power Automate is desirable.
- Digital transformation: Experience supporting ERP implementations, enterprise system upgrades, or digital transformation initiatives is beneficial.
- Industry experience: Background developing enterprise reporting solutions for project-based businesses or professional services organizations is preferred.
- Continuous improvement: A proactive approach to evaluating emerging technologies, improving analytics practices, and promoting a data-driven culture.
Benefits
- Competitive annual salary: Compensation ranging from $115,000 to $175,000, depending on geographic location, qualifications, experience, education, and skills.
- Location-based compensation: Salary ranges vary by geographic market:
- Group A (Montana, Maine, Florida): $115,000–$135,000.
- Group B (Pennsylvania, Massachusetts, Missouri, Georgia, Rhode Island): $130,000–$150,000.
- Group C (Connecticut, Colorado, New Jersey, specified Massachusetts locations, California, New York): $140,000–$175,000.
- Remote work flexibility: The opportunity to work remotely from anywhere in the United States.
- Strategic impact: The opportunity to shape enterprise-wide analytics architecture and influence executive decision-making through modern data solutions.
- Advanced technology exposure: Hands-on work with Microsoft Power BI, Fabric, OneLake, Dynamics 365, Dataverse, Azure, and related technologies.
- Professional development: Opportunities to pursue relevant Microsoft certifications, expand technical expertise, and stay current with emerging analytics technologies.
- Leadership opportunities: The ability to mentor analytics professionals, establish technical standards, and influence the organization's long-term data strategy.
- Collaborative environment: A culture focused on innovation, continuous improvement, teamwork, and meaningful business outcomes.
- Limited business travel: Travel requirements of up to approximately 5%.
