Senior Business Intelligence Architect

Woodard & Curran; Oregon; Hybrid; USD 115.000 - 175.000; Vollzeit

Benefits dieser Stelle

Remote opportunity

Travel up to 5%

Mentor analytics professionals

Competitive compensation

Zusammenfassung

Woodard & Curran is seeking a Senior Business Intelligence Architect to lead design, governance, and optimization of the enterprise analytics and reporting environment. You will serve as the Power BI and Microsoft Fabric SME, partnering with leaders, ERP stakeholders, developers, and data teams to deliver scalable analytics and decision support.

The ideal candidate brings deep technical expertise with finance, project accounting, forecasting, and resource management, shaping analytics strategy

Qualifikationen

• Bachelor's degree or equivalent experience in a related field.
• 10+ years of experience in business intelligence, analytics, or data solutions.
• 7+ years of hands-on Power BI in a complex enterprise environment.
• Senior/lead/architect-level analytics experience.
• Expertise in Power BI, Fabric, OneLake, DAX, Power Query, semantic and dimensional modeling.
• SQL development and performance optimization.
• Data governance and analytics architecture.

Aufgaben

• Lead architecture, development, governance, and support of enterprise Power BI and Fabric solutions.
• Design and maintain semantic models, data marts, dashboards, KPIs, and executive reports.
• Gather requirements with stakeholders and translate into scalable analytics solutions.
• Support reporting for Dynamics 365 Finance & Operations and Project Operations.
• Develop and optimize Power BI datasets, dataflows, DAX, Power Query, and reporting frameworks.
• Establish analytics governance, security models, and deployment standards.
• Implement source control, release management, and CI/CD with Azure DevOps and Git.
• Ensure data accuracy, performance, reliability, and alignment with source systems.
• Monitor production analytics environments, refresh, data quality, and performance.
• Evaluate new Microsoft technologies and suggest analytics improvements.
• Mentor developers and analysts on analytics best practices.

Kenntnisse

Power BI

Microsoft Fabric

OneLake

DAX

Power Query

Semantic modeling

Dimensional modeling

SQL optimization

Data governance

Dynamics 365 Finance

Ausbildung

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

Tools

Azure DevOps

Git

Jobbeschreibung

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
• Experience supporting Microsoft Dynamics 365 Finance & Operations and enterprise ERP reporting.
• Strong knowledge of finance, project accounting, forecasting, utilization, resource management, and operational reporting.
• Experience implementing analytics security, governance, deployment pipelines, and enterprise reporting standards.
• Hands‑on experience with Azure DevOps, Git, source control, and CI/CD practices.
• Proven ability to influence stakeholders, lead technical initiatives, and mentor team members.
• Excellent communication, problem‑solving, and analytical skills.

Preferred Qualifications

• Microsoft Power BI and/or Microsoft Fabric certifications.
• Experience with Dataverse, Azure Data Services, Data Factory, Lakehouse, and Warehouse solutions.
• Experience supporting ERP implementations or digital transformation programs.
• Experience with Power Platform technologies, including Power Apps and Power Automate.
• Experience building enterprise reporting solutions in project-based or professional services organizations.

Compensation

$115,000 - $175,000 a year
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.