Sr. Power BI Developer & Data Analyst

Cornerstone Advisors of Arizona, LLC • Scottsdale, AZ

104d • Onsite

About The Position

The Senior Power BI Developer and Data Analyst serves as Cornerstone Advisors’ lead Business Intelligence professional, designing, developing, and maintaining enterprise Business Intelligence solutions that transform complex data into actionable insights for strategic decision-making. The role partners with executive leadership, consulting teams, and business stakeholders to translate organizational objectives and business challenges into scalable analytical solutions. It uses Microsoft Power BI, SQL Server, Azure data technologies, cloud analytics, and modern Business Intelligence practices to deliver secure, scalable, high-performing reporting that improves operations, client delivery, and organizational growth.

As the organization’s Business Intelligence subject matter expert, this position establishes enterprise reporting standards, promotes data governance, advances analytics capabilities, and provides technical leadership for Microsoft’s modern analytics platform. The role is onsite in Scottsdale, Arizona, and is a full-time day-shift position with no travel expected.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Business Analytics, Statistics, Mathematics, or a related discipline.
• At least 5 years of progressively responsible experience in Business Intelligence, Data Engineering, Analytics, or related technical roles.
• At least 3 years designing and developing enterprise Power BI solutions.
• Demonstrated experience designing enterprise semantic models, data warehouses, and scalable reporting environments.
• Advanced experience developing optimized T-SQL queries, stored procedures, and database objects.
• Experience developing cloud-based data integration solutions using Microsoft Azure technologies.
• Advanced proficiency in Microsoft Excel.
• Advanced 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.
• Advanced understanding of statistical analysis, predictive analytics, forecasting methodologies, and business performance measurement.
• Knowledge of enterprise data governance, information security, metadata management, and Business Intelligence lifecycle management.
• Understanding of Agile development methodologies, DevOps practices, and the Software Development Lifecycle.
• Ability to communicate complex analytical concepts effectively to executive leadership, consultants, clients, and non-technical stakeholders.
• Technical skills in Microsoft Power BI, Power BI Service administration, Microsoft SQL Server, advanced T-SQL, Azure Data Factory, Azure SQL, enterprise data modeling, data warehouse design, ETL/ELT development, statistical analysis, predictive analytics, performance optimization, and data visualization best practices.

Nice To Haves

• Working knowledge of Microsoft Fabric, OneLake, and Microsoft’s modern analytics ecosystem.
• Preferred technical skills: Microsoft Fabric, OneLake, Azure Databricks, Microsoft Dynamics 365, Python, R, Git, Azure DevOps, Tableau, Looker, Microsoft Copilot, and AI-assisted analytics.
• Microsoft Certified: Power BI Data Analyst Associate certification.
• Microsoft Certified: Azure Data Engineer Associate certification.
• Microsoft Certified: Fabric Analytics Engineer Associate certification.
• Microsoft Azure Fundamentals certification.
• Certified Analytics Professional (CAP) certification.
• Master’s degree in Computer Science, Data Science, Business Analytics, Information Systems, or a related discipline.
• Experience in financial services, community banking, fintech, or management consulting.
• Experience implementing enterprise reporting governance and self-service Business Intelligence programs.
• Experience leveraging Artificial Intelligence capabilities within Business Intelligence platforms.
• Experience serving as a technical lead or subject matter expert on enterprise analytics initiatives.

Responsibilities

• Lead the design, development, deployment, and continuous enhancement of enterprise Business Intelligence solutions using Microsoft Power BI.
• Design and maintain scalable semantic models, dimensional data models, and enterprise datasets for consistent reporting and self-service analytics.
• Develop, maintain, and optimize ETL/ELT pipelines, SQL databases, and Azure-based data integration solutions.
• Build executive dashboards, operational scorecards, KPI reporting, and self-service reporting capabilities.
• Analyze large and complex datasets to identify trends, operational efficiencies, customer insights, business opportunities, and performance improvement initiatives.
• Develop analytical models using forecasting, trend analysis, customer segmentation, regression analysis, and predictive analytics.
• Partner with leadership, consultants, and stakeholders to define reporting requirements and KPIs and translate business objectives into scalable BI solutions.
• Develop and optimize T-SQL queries, stored procedures, DAX measures, calculated columns, Power Query transformations, and reusable reporting components.
• Administer and optimize Power BI Service, including workspace governance, semantic models, deployment pipelines, gateway management, security administration, and report lifecycle management.
• Establish and maintain reporting standards, data governance policies, Row-Level Security, documentation, metadata, and quality assurance processes.
• Support reporting, analytics, and integrations involving Microsoft Dynamics 365 and other enterprise applications.
• Identify opportunities to automate manual reporting and modernize Business Intelligence capabilities.
• Evaluate emerging Microsoft technologies, including Microsoft Fabric, OneLake, AI-assisted analytics, Microsoft Copilot, and cloud data platforms, and recommend practical solutions.
• Provide technical leadership, mentoring, and subject matter expertise to analysts, developers, consultants, and project teams.
• Analyze and resolve complex business and technical challenges, including evaluating data sources, identifying trends, resolving data quality issues, and designing scalable BI solutions.
• Communicate analytical findings through dashboards, visualizations, presentations, and written recommendations.
• Promote data-driven decision-making, continuous improvement, and innovation through cross-functional partnerships.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior