Senior Business Intelligence Architect

Woodard & Curran
United States
Remote

Who this role is best for

Best suited to candidates with deep Microsoft analytics expertise working in enterprise finance and operations environments.

Best fit for

  • Candidates with 10+ years of BI experience and a track record in enterprise-level analytics leadership
    — “10+ years of experience in business intelligence, analytics, reporting, or data solutions.”
  • Individuals who can bridge technical and business domains with a focus on finance and operations
    — “strong understanding of finance, project accounting, project delivery, forecasting, resource management, and business operations.”
  • Candidates experienced in mentoring and leading analytics teams with a collaborative mindset
    — “Mentor and develop analytics professionals while helping shape the future of data at Woodard & Curran.”

Things to consider

  • The role may require some travel, even though it is primarily remote.
    — “Travel: Up to 5%”
  • Compensation varies significantly based on geographic location, which could affect overall earnings.
    — “compensation range for this position may vary depending on where the successful candidate is located”

How to stand out

  • Highlight experience in leading analytics strategy and governance frameworks in your resume and interviews.
    — “shaping our analytics strategy, advancing reporting capabilities”
  • Demonstrate your ability to translate complex business needs into scalable technical solutions.
    — “translate business needs into scalable analytics solutions”
  • Showcase your hands-on Power BI and Microsoft Fabric experience with specific, measurable outcomes.
    — “7+ years of hands-on Power BI experience in a complex enterprise environment”
  • Emphasize your background in SQL performance optimization and semantic modeling.
    — “Advanced expertise in semantic modeling and dimensional data modeling”
  • Include examples of implementing CI/CD processes with Azure DevOps and Git in your portfolio.
    — “Implement source control, release management, and CI/CD processes using Azure DevOps and Git.”
Pace · SteadyCollaboration · HighAutonomy · MediumDecision Impact · Company

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

  • enterprise analytics strategy
  • reporting capabilities
  • data solutions
  • data governance
  • deployment best practices
Typical background
business intelligenceanalyticsreporting

Skills & requirements

Required

Power BIMicrosoft FabricDAXPower QuerySemantic ModelingSQL DevelopmentData GovernanceAnalytics ArchitectureSource ControlRelease ManagementCi/cd ProcessesData AccuracyPerformanceReliabilityData QualityPlatform Performance

Preferred

MentorshipContinuous Improvement

Stack & domain

Power BIMicrosoft FabricOnelakeDynamics 365DataverseAzureDAXPower QuerySemantic ModelingDimensional Data ModelingSQLData GovernanceAnalytics ArchitectureSource ControlRelease ManagementCI/CDGitCollaborationProblem-solvingCommunicationTeamworkMentoringBusiness IntelligenceEnterprise AnalyticsReportingData Solutions

About the role

Original posting from Woodard & Curran via Lever

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.

Mentor developers and analysts while promoting analytics best practices and continuous improvement.

Support executive leadership through strategic dashboards, KPI frameworks, and advanced business insights.

What will you need to succeed?

Required Qualifications 

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent experience.

10+ years of experience in business intelligence, analytics, reporting, or data solutions.

7+ years of hands-on Power BI experience in a complex enterprise environment.

Experience serving in a senior, lead, architect, or principal-level analytics role.

Advanced expertise in:  

Microsoft Power BI

Microsoft Fabric and OneLake

DAX and Power Query (M)

Semantic modeling and dimensional data modeling

SQL development and performance optimization

Data governance and analytics architecture 

Compensation:

Group A (MT, ME, FL) = $115,000 - $135,000

Group B (PA, MA, MO, GA, RI) = $130,000 - $150,000

Group C (CT, CO, NJ, Andover/Canton MA, CA, NY) = $140,000 - $175,000

The anticipated compensation range for this position is based on several factors, including the candidate’s qualifications, experience, education, skills, and primary work location. Final compensation will be determined based on these factors and adjusted, where applicable, by a geographic differential. Geographic differentials are percentage-based adjustments that reflect variations in labor market costs across locations. As a result, the compensation range for this position may vary depending on where the successful candidate is located and performs their work. The examples below illustrate how compensation for this role may differ across geographic markets. #LI-TB1

Source: Woodard & Curran careers (Lever)

Similar roles

More roles at Woodard & Curran