Sr. Power BI Developer & Data Analyst (19360

Job Details Level: Experienced

Job Location:

7272 E INDIAN SCHOOL RD STE 400 - SCOTTSDALE, AZ 85251

Position Type:
Full Time

Education Level: 4 Year Degree

Travel Percentage:
Up to 25%

Job Shift: Day

Job Category:
Information Technology

Cornerstone Advisors is a nationally recognized management and technology consulting firm serving banks, credit unions, and financial services organizations across the United States. For more than two decades, we have partnered with executive leadership teams to solve complex business challenges, optimize operations, and deliver innovative strategies that drive measurable results. Our culture is built on collaboration, integrity, innovation, and a commitment to helping both our clients and our employees succeed.

The Senior Power BI Developer and Data Analyst serves as Cornerstone Advisors' lead Business Intelligence professional, responsible for designing, developing, and maintaining enterprise Business Intelligence solutions that transform complex data into actionable insights supporting strategic decision-making across the organization.

This role partners closely with executive leadership, consulting teams, and business stakeholders to understand organizational objectives and translate complex business challenges into scalable analytical solutions. Leveraging expertise in Microsoft Power BI, SQL Server, Azure data technologies, cloud analytics, and modern Business Intelligence practices, the Senior Power BI Developer and Data Analyst delivers secure, scalable, and high-performing reporting solutions that improve operational performance, enhance client delivery, and support organizational growth.

As the organization's Business Intelligence subject matter expert, this position establishes enterprise reporting standards, promotes data governance best practices, advances analytics capabilities, and provides technical leadership for Microsoft's modern analytics platform to ensure enterprise data is trusted, accessible, and actionable.

• Lead the design, development, deployment, and continuous enhancement of enterprise Business Intelligence solutions utilizing Microsoft Power BI.
• Design and maintain scalable semantic models, dimensional data models, and enterprise datasets that support consistent reporting and self-service analytics.
• Develop, maintain, and optimize ETL/ELT pipelines, SQL databases, and Azure-based data integration solutions supporting enterprise reporting and analytics.
• Build executive dashboards, operational scorecards, KPI reporting, and self-service reporting capabilities that enable informed business decisions.
• Analyze large and complex datasets to identify trends, operational efficiencies, customer insights, business opportunities, and performance improvement initiatives.
• Develop advanced analytical models using forecasting, trend analysis, customer segmentation, regression analysis, and predictive analytics techniques to support strategic planning.
• Partner with executive leadership, consultants, and business stakeholders to define reporting requirements, establish key performance indicators (KPIs), and translate business objectives into scalable Business Intelligence solutions.
• Develop and optimize complex T-SQL queries, stored procedures, DAX measures, calculated columns, Power Query transformations, and reusable reporting components.
• Administer and optimize the Microsoft Power BI Service environment, including workspace governance, semantic models, deployment pipelines, gateway management, security administration, and report lifecycle management.
• Establish and maintain enterprise reporting standards, data governance policies, Row-Level Security (RLS), documentation, metadata, and quality assurance processes that ensure data accuracy, consistency, and compliance.
• Support reporting, analytics, and integrations involving Microsoft Dynamics 365 and other enterprise applications.
• Identify opportunities to automate manual reporting processes and modernize Business Intelligence capabilities through scalable technologies and best practices.
• Evaluate emerging Microsoft technologies—including Microsoft Fabric, One Lake, AI-assisted analytics, Microsoft Copilot, and cloud data platforms—and recommend practical solutions that enhance organizational effectiveness.
• Provide technical leadership, mentoring, and subject matter expertise to analysts, developers, consultants, and project teams while promoting Business Intelligence best practices throughout the organization

Expert knowledge of Microsoft Power BI architecture, semantic modeling, DAX optimization, Power Query, and enterprise reporting best practices.

Advanced understanding of relational databases, dimensional modeling, data warehousing, and enterprise data architecture.

Strong knowledge of Microsoft Azure data services and cloud analytics platforms.

Working knowledge of Microsoft Fabric, One Lake, and Microsoft's modern…