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