Senior Business Intelligence Architect

New
J
JobgetherBusiness intelligence
The opportunity to work remotely from anywhere in the United States.Full-TimeSenior
Salary115,000 - 175,000 USD per year
Apply NowOpens the employer's application page

Job Details

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.
Required Skills
SQLGitMicrosoft Power BIData modelingAzure DevOps

Requirements

  • Have a bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent professional experience.
  • Have 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.
  • Bring experience in a senior, lead, architect, or principal-level analytics role, including leading technical initiatives, influencing stakeholders, and mentoring team members.
  • Demonstrate advanced expertise in Power BI architecture, dataset development, dashboards, reporting frameworks, DAX, and Power Query (M).
  • Have strong knowledge of Microsoft Fabric and OneLake and their use in enterprise data integration, storage, modeling, and analytics architectures.
  • Understand semantic modeling, dimensional data modeling, data marts, analytics architecture, and enterprise reporting design.
  • Have advanced SQL development skills, including query optimization and troubleshooting across large or complex datasets.
  • Have experience supporting Microsoft Dynamics 365 Finance & Operations and enterprise ERP reporting, with knowledge of finance, project accounting, forecasting, utilization, and resource management.
  • Have experience implementing analytics governance frameworks, security models, deployment pipelines, and enterprise reporting standards.
  • Have hands-on experience with Azure DevOps, Git, version control, release management, and CI/CD practices.
  • Power BI and/or Microsoft Fabric certifications are preferred; familiarity with Dataverse, Azure Data Services, Azure Data Factory, lakehouse and warehouse solutions, Power Apps, and Power Automate is advantageous.

Responsibilities

  • Lead the architecture, development, governance, optimization, and ongoing support of enterprise Power BI and Microsoft Fabric solutions.
  • Design and maintain semantic models, dimensional data models, data marts, datasets, dashboards, KPIs, and executive reporting frameworks.
  • Partner with business leaders, finance teams, ERP stakeholders, developers, and data teams to translate reporting needs into analytics solutions.
  • Support reporting and analytics for Microsoft Dynamics 365 Finance & Operations and Project Operations, including financial performance, project accounting, forecasting, utilization, and resource management.
  • Develop, maintain, and optimize Power BI datasets, DAX calculations, Power Query (M) transformations, dataflows, and reporting frameworks.
  • Establish analytics governance policies, development standards, access controls, security models, and deployment best practices.
  • Implement source control, release management, version control, and CI/CD processes using Azure DevOps and Git.
  • Monitor production analytics environments, manage refresh processes, troubleshoot issues, and improve data quality and platform performance.
  • Evaluate emerging Microsoft technologies and recommend improvements to data architecture and reporting.
  • Mentor analytics developers and collaborate with senior leadership on dashboards and KPI frameworks for planning, forecasting, resource allocation, and organizational performance.
View Full Description & ApplyYou'll be redirected to the employer's site
115,000 - 175,000 USD per year
Apply Now