Business Intelligence Solutions Analyst

At Armanino, you determine your career path. This means it's possible to pursue challenges you are passionate about, in industries you care about.

Armanino is proud to be Among the top 20 Largest Accounting and Consulting Firms in the Nation and one of the Best Places to Work. We have a community of resources that are ready and willing to support your ideas, build your skills and expand your professional network. We want you to integrate all aspects of your life with your career. At Armanino, we know you don’t check-out of life when you check-in at work. That’s why we’ve created a unique work environment where your passions, work, and family & friends can overlap. We want to help you achieve growth by giving you access to a network of smart and supportive people, willing to listen to your ideas.

This position bridges business requirements with technical implementation, focusing on translating client needs into effective Power BI reports, semantic models, and datasets within Microsoft Fabric and our partner's proprietary Dynamics 365 data warehouse solution.

Job Responsibilities

Work directly with customers to:

• Gather, document, and validate business requirements for reporting and analytics

• Translate business needs into functional specifications for Power BI semantic models and datasets in Microsoft Fabric

• Develop, enhance, and maintain Power BI reports and dashboards

• Build and optimize semantic models and datasets in Microsoft Fabric

• Perform data analysis and profiling to ensure data quality and accuracy

• Assist customers in creating effective measures, KPIs, and hierarchies using DAX

• Troubleshoot and resolve data accuracy, refresh, and visualization issues in Power BI

• Support user acceptance testing (UAT) and deliver user training for deployed solutions

• Collaborate with Data Engineers on Fabric Lakehouse/Warehouse modeling, ingestion pipelines, and performance optimization

• Provide guidance on Power BI governance, workspace management, and best practices within Fabric

Requirements

• Minimum 5 years of experience in data analytics, business intelligence, or related fields

• BA/BS degree in Business, Information Technology/Engineering, related major or equivalent work experience 

• Strong business analysis, requirements gathering, and customer-facing communication skills

• Expertise in Power BI development, including semantic modeling, DAX, visualization design, and data storytelling

• Hands-on experience with Microsoft Fabric (Lakehouse/Warehouse, semantic models, pipelines, Dataflows, and Data Engineering workloads)

• Proficiency with SQL and relational databases (T-SQL strongly preferred) and a solid understanding of data warehouse concepts and dimensional modeling

• Strong troubleshooting and analytical abilities

• Microsoft certifications including, Power BI Data Analyst Associate (PL-300), Fabric Analytics Engineer Associate (DP-600), or willingness to obtain

Preferred Qualifications

• Experience with Dynamics 365 or other ERP/CRM systems

• Experience with Azure Data Factory or similar ETL/ELT orchestration tools

• Python scripting for data wrangling, automation, or API integration

“Armanino” is the brand name under which Armanino LLP, Armanino CPA LLP, and Armanino Advisory LLC, independently owned entities, provide professional services in an alternative practice structure in accordance with law, regulations, and professional standards. Armanino LLP and Armanino CPA LLP are licensed independent CPA firms that provide attest services, and Armanino Advisory LLC and its subsidiary entities provide tax, advisory, and business consulting services. Armanino Advisory LLC and its subsidiary entities are not licensed CPA firms. 

Armanino provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Armanino complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training