Business Intelligence Lead

The Business Intelligence Lead is a senior individual contributor and key member of the Operations FP&A and Transformation team. This hands-on technical and business leadership role transforms operational, financial, and workforce data into actionable insights that improve business performance and support decision-making. The Lead independently owns assigned initiatives from problem definition through ongoing support, operating with limited day-to-day direction and engaging the manager for strategic alignment and approvals. Company: Public Storage, the world's largest owner and operator of self-storage facilities. Work arrangement: office five days per week, with the option of up to three flexible remote-work days each month. Sponsorship for work authorization is not available for this posting.

Responsibilities

Own assigned business intelligence and analytics initiatives end to end, including problem definition, requirements, scope, planning, solution design, development, testing, deployment, documentation, training, adoption, and post-launch support; Serve as primary day-to-day point of contact for stakeholders across Operations, Finance, HR, and IT; Build, maintain, and improve Power BI dashboards, scorecards, semantic models, and reporting solutions; Write and optimize SQL queries to extract, validate, reconcile, and analyze large datasets across enterprise systems; Reconcile disparate data sources and establish trusted, repeatable datasets and metric logic; Investigate data discrepancies and root causes, and escalate material risks with clear recommendations; Analyze performance trends, risks, and business drivers, and convert findings into practical recommendations; Manage project scope, priorities, dependencies, and delivery commitments; Support transformation initiatives through KPI development, process analysis, and reporting modernization; Establish and maintain documentation for requirements, metric definitions, data lineage, business rules, and operating procedures; Ensure data quality, accuracy, consistency, and appropriate controls; Mentor project contributors without formal people-management responsibilities

Requirements

Bachelor's degree in Business Analytics, Finance, Economics, Statistics, Mathematics, Information Systems, Computer Science, or a related field; Eight or more years of progressive experience in business intelligence, analytics, reporting, FP&A, financial analytics, operations analytics, or a related discipline; Demonstrated experience independently leading complex analytics or business intelligence initiatives from problem definition through deployment, adoption, and ongoing support; Advanced SQL skills, including querying, reconciling, validating, troubleshooting, and analyzing large datasets from multiple sources; Strong hands-on proficiency with Microsoft Power BI, including dashboard and report development, data modeling, semantic models, DAX, visualization design, performance considerations, and deployment practices; Advanced Microsoft Excel skills for analysis, reconciliation, validation, and communication; Strong business and financial acumen, with the ability to connect operational and financial performance, interpret KPI movement, and recommend practical actions; Excellent analytical, problem-solving, and critical-thinking skills, including identifying root causes and making sound recommendations under ambiguity; Exceptional attention to detail and commitment to data accuracy, documentation, and consistent metric definitions; Strong project ownership and organizational skills, managing multiple priorities, dependencies, stakeholders, and delivery commitments with limited day-to-day support; Clear and confident written and verbal communication skills, tailoring technical and analytical concepts for business and senior leadership audiences; Good judgment on when to act independently, seek approval, or escalate; Ability to describe an analytics or dashboard solution owned end to end, including business problem, requirements, technical approach, data challenges, key decisions, recommendation, and measurable outcome

Nice to have

Experience working with SAP, Workday, payroll systems, and Google BigQuery; Experience supporting Operations, FP&A, workforce analytics, or business transformation initiatives; Experience establishing or improving KPI definitions, data governance, reporting standards, or analytical operating processes; Experience presenting findings and recommendations to Directors or Vice Presidents