Senior Business Intelligence Architect

New
W
Woodard & CurranBusiness intelligence
Anywhere in USFull-TimeSenior
Salary115,000 - 175,000 USD per year
Apply NowOpens the employer's application page

Job Details

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.
Required Skills
SQLMicrosoft Power BIAzure DevOps

Requirements

  • 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 in a senior, lead, architect, or principal-level analytics role.
  • Advanced expertise in Microsoft Power BI, Microsoft Fabric, and OneLake.
  • Advanced expertise in DAX, Power Query (M), semantic modeling, and dimensional data modeling.
  • Advanced expertise in SQL development and performance optimization.
  • Expertise in data governance and analytics architecture.
  • Experience supporting Microsoft Dynamics 365 Finance & Operations and enterprise ERP reporting.
  • 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.
  • Ability to influence stakeholders, lead technical initiatives, and mentor team members.
  • Preferred: Microsoft Power BI and/or Microsoft Fabric certifications; experience with Dataverse, Azure Data Services, Data Factory, Lakehouse, Warehouse solutions, Power Apps, or Power Automate.

Responsibilities

  • 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.
  • Mentor developers and analysts while supporting executive leadership with strategic dashboards, KPI frameworks, and business insights.
View Full Description & ApplyYou'll be redirected to the employer's site
115,000 - 175,000 USD per year
Apply Now