Business Intelligence Lead

Public Storage•Frisco, TX

10d•Hybrid

About The Position

The Business Intelligence Lead is a senior individual contributor on Public Storage’s Operations FP&A and Transformation team. The role turns operational, financial, and workforce data into actionable insights that improve business performance and support organizational decision-making. The Lead independently owns assigned initiatives from problem definition through solution design, development, testing, deployment, adoption, and ongoing support. They are the primary day-to-day owner for project scope, requirements, milestones, stakeholder coordination, data investigation, technical delivery, documentation, and training, working with limited day-to-day direction and involving the manager for strategic alignment, approvals, or help removing organizational roadblocks. This hands-on technical and business leadership role requires strong business acumen and advanced skills in Power BI, SQL, data modeling, reconciliation, and analytical problem-solving. The successful candidate can translate business questions into technical solutions, analysis into insight, and insight into clear recommendations. The position has no formal people-management responsibilities. Public Storage teammates are expected to work in the office five days per week, with the option to use up to three flexible remote-work days each month. Work authorization sponsorship is not available; candidates must be authorized to work in the United States without restrictions or current or future sponsorship.

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 ability to independently lead 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, including 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, evaluating alternatives, 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, including managing multiple priorities, dependencies, stakeholders, and delivery commitments with limited day-to-day support.
Clear and confident written and verbal communication skills, including adapting technical and analytical concepts for business and senior leadership audiences.
Good judgment about when to act independently, seek approval, or escalate risks, decisions, or stakeholder issues.
Ability to describe an end-to-end analytics or dashboard solution they owned, including its business problem, stakeholder requirements, technical approach, data challenges, key decisions, final recommendation, and measurable business outcome.

Nice To Haves

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.

Responsibilities

Own business intelligence and analytics initiatives end to end, including problem definition, requirements, scope, planning, milestones, solution design, development, testing, business validation, deployment, documentation, training, adoption, and post-launch support.
Serve as the primary day-to-day contact for stakeholders in Operations, Finance, HR, and IT, translating business needs into analytical requirements, measures, data products, dashboards, and decision-support solutions.
Build, maintain, and improve Power BI dashboards, scorecards, semantic models, and reporting solutions for operational, financial, workforce, and strategic decisions.
Write and optimize SQL queries to extract, validate, reconcile, analyze, and troubleshoot large datasets across enterprise systems and databases.
Reconcile disparate data sources and establish trusted, repeatable datasets and metric logic for management reporting and business decisions.
Investigate data discrepancies and root causes, resolve issues within the role’s authority, and escalate material risks or cross-functional dependencies with a clear recommendation.
Analyze performance trends, risks, opportunities, and business drivers; form and test hypotheses; and convert findings into practical recommendations and measurable next steps.
Manage project scope, priorities, dependencies, and delivery commitments; identify changes or constraints early and recommend options balancing business value, accuracy, timing, and maintainability.
Support transformation initiatives through KPI development, process analysis, performance measurement, reporting modernization, and adoption of scalable analytical practices.
Maintain documentation for requirements, metric definitions, data lineage, business rules, testing results, known limitations, operating procedures, and ownership.
Ensure data quality, accuracy, consistency, usability, and appropriate controls across reporting and analytical environments.
Mentor project contributors and share technical and business knowledge when appropriate, without formal people-management responsibilities.