{"schemaVersion":"jobsearcher.job.v1","id":"bdb6d74c17ab401d8ae58692","url":"https://jobsearcher.com/jobs/bdb6d74c17ab401d8ae58692","canonicalUrl":"https://jobsearcher.com/jobs/bdb6d74c17ab401d8ae58692","title":"Data Analyst","description":"Data Analyst\nSecurity Public Storage | Full-Time | Hybrid\nAbout the Role\nSecurity Public Storage (SPS) is looking for a Data Analyst to join a small, high-impact team focused on revenue management, pricing strategy, and operational intelligence across our 53-facility portfolio. This role sits at the intersection of data engineering and business analysis — you'll help build and maintain the data infrastructure we rely on, then use it to answer the questions that drive how we price, promote, and operate.\nThis role has two distinct phases. In the first several months, the focus will be on foundational build work: validating and refining our data warehouse, developing core dashboards, and formalizing the analytical frameworks we use to measure pricing and promotional effectiveness. Over time, the role evolves toward ongoing analysis, forecasting, and continuous optimization — so we're looking for someone who is equally comfortable writing SQL at 9am and presenting insights to an ops team at 2pm.\nKey Responsibilities\nPricing & Revenue Analysis\nAnalyze property-level performance including occupancy, move-ins/move-outs, pricing trends, and revenue yield\nSupport pricing strategies across the portfolio to optimize the balance between revenue and occupancy\nEvaluate discounting strategies and promotional programs — including move-in specials, concessions, and rate adjustments — and provide recommendations on when and where to deploy or reduce them\nDevelop frameworks to measure promotional effectiveness (e.g., occupancy lift vs. revenue trade-offs, duration of stay, conversion rates)\nMonitor competitive pricing and market trends within the self-storage industry\nAssist in forecasting revenue and occupancy performance\nRevenue Management Models\nWork with and maintain existing revenue management models\nIdentify opportunities to refine and enhance model logic based on observed outcomes and changing market conditions\nData Infrastructure & Reporting\nPartner with internal stakeholders on the design, validation, and ongoing maintenance of the company's Microsoft Fabric data warehouse\nDevelop dashboards and reports in Power BI to provide visibility into KPIs and trends across the portfolio\nEnsure data accuracy and integrity across reporting systems\nConduct ad hoc analysis on pricing, promotions, and customer behavior\nCross-Functional Collaboration\nPartner with operations and finance teams to translate data insights into actionable strategies\nCommunicate findings clearly to non-technical stakeholders through polished reports and presentations\nRequired Skills & Experience\nData & Analytics\nAdvanced SQL — complex queries using CTEs, window functions, and joins; T-SQL preferred\nStrong data modeling fundamentals — star schema, dimensional modeling, relationships and cardinality\nETL/ELT pipeline logic and data quality practices\nExperience with revenue analysis, pricing models, or operational KPIs\nMicrosoft Fabric & Power BI\nFamiliarity with Microsoft Fabric — including Lakehouses, Warehouses, data pipelines, and the OneLake architecture\nPower BI — DAX for measures and calculated columns, data modeling, report design, and Row-Level Security (RLS)\nPower Query / M for data transformation\nUnderstanding of DirectLake mode and performance optimization in Power BI\nAnalytical & Communication\nAbility to translate business questions into data problems and structure analysis independently\nStrong data storytelling — able to present findings clearly to non-technical audiences\nExperience designing or validating measurement frameworks (A/B tests, lift analysis, conversion analysis)\nAttention to data integrity and documentation habits (naming conventions, lineage tracking)\nNice to Have\nPython for data processing and notebook-based analysis\nExperience with medallion architecture (Bronze → Silver → Gold) or lakehouse design patterns\nAzure fundamentals — Fabric runs on Azure and basic familiarity is helpful\nGit / version control for managing analytical assets\nBackground in real estate, self-storage, or other asset-intensive industries\nExperience with revenue management systems or dynamic pricing tools\nAbout Security Public Storage\nSecurity Public Storage (SPS) is a family-owned self-storage company operating 53 facilities across multiple states. We're a lean, data-driven organization investing in the infrastructure and talent to make smarter decisions at scale. This role is an opportunity to have real impact — you'll be one of a small number of people building the analytical foundation of how we run the business.\nPay: $115,000.00 - $125,000.00 per year\nBenefits:\n401(k) 4% Match\nHealth insurance\nHealth savings account\nLife insurance\nPaid time off\nAbility to Commute:\nSan Francisco, CA 94107 (Required)\nWork Location: Hybrid remote in San Francisco, CA 94107","company":"Security Public Storage","rawCompany":"security public storage","city":"Millbrae","state":"CA","isRemote":false,"isActive":false,"createdAt":"2026-07-21T11:29:33.350Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-2051.01","title":"Business Intelligence Analysts","slug":"business-intelligence-analysts"},{"code":"15-2051.00","title":"Data Scientists","slug":"data-scientists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"},{"code":"541690","title":"Other Scientific and Technical Consulting Services","slug":"other-scientific-and-technical-consulting-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Analyst","description":"Data Analyst\nSecurity Public Storage | Full-Time | Hybrid\nAbout the Role\nSecurity Public Storage (SPS) is looking for a Data Analyst to join a small, high-impact team focused on revenue management, pricing strategy, and operational intelligence across our 53-facility portfolio. This role sits at the intersection of data engineering and business analysis — you'll help build and maintain the data infrastructure we rely on, then use it to answer the questions that drive how we price, promote, and operate.\nThis role has two distinct phases. In the first several months, the focus will be on foundational build work: validating and refining our data warehouse, developing core dashboards, and formalizing the analytical frameworks we use to measure pricing and promotional effectiveness. Over time, the role evolves toward ongoing analysis, forecasting, and continuous optimization — so we're looking for someone who is equally comfortable writing SQL at 9am and presenting insights to an ops team at 2pm.\nKey Responsibilities\nPricing & Revenue Analysis\nAnalyze property-level performance including occupancy, move-ins/move-outs, pricing trends, and revenue yield\nSupport pricing strategies across the portfolio to optimize the balance between revenue and occupancy\nEvaluate discounting strategies and promotional programs — including move-in specials, concessions, and rate adjustments — and provide recommendations on when and where to deploy or reduce them\nDevelop frameworks to measure promotional effectiveness (e.g., occupancy lift vs. revenue trade-offs, duration of stay, conversion rates)\nMonitor competitive pricing and market trends within the self-storage industry\nAssist in forecasting revenue and occupancy performance\nRevenue Management Models\nWork with and maintain existing revenue management models\nIdentify opportunities to refine and enhance model logic based on observed outcomes and changing market conditions\nData Infrastructure & Reporting\nPartner with internal stakeholders on the design, validation, and ongoing maintenance of the company's Microsoft Fabric data warehouse\nDevelop dashboards and reports in Power BI to provide visibility into KPIs and trends across the portfolio\nEnsure data accuracy and integrity across reporting systems\nConduct ad hoc analysis on pricing, promotions, and customer behavior\nCross-Functional Collaboration\nPartner with operations and finance teams to translate data insights into actionable strategies\nCommunicate findings clearly to non-technical stakeholders through polished reports and presentations\nRequired Skills & Experience\nData & Analytics\nAdvanced SQL — complex queries using CTEs, window functions, and joins; T-SQL preferred\nStrong data modeling fundamentals — star schema, dimensional modeling, relationships and cardinality\nETL/ELT pipeline logic and data quality practices\nExperience with revenue analysis, pricing models, or operational KPIs\nMicrosoft Fabric & Power BI\nFamiliarity with Microsoft Fabric — including Lakehouses, Warehouses, data pipelines, and the OneLake architecture\nPower BI — DAX for measures and calculated columns, data modeling, report design, and Row-Level Security (RLS)\nPower Query / M for data transformation\nUnderstanding of DirectLake mode and performance optimization in Power BI\nAnalytical & Communication\nAbility to translate business questions into data problems and structure analysis independently\nStrong data storytelling — able to present findings clearly to non-technical audiences\nExperience designing or validating measurement frameworks (A/B tests, lift analysis, conversion analysis)\nAttention to data integrity and documentation habits (naming conventions, lineage tracking)\nNice to Have\nPython for data processing and notebook-based analysis\nExperience with medallion architecture (Bronze → Silver → Gold) or lakehouse design patterns\nAzure fundamentals — Fabric runs on Azure and basic familiarity is helpful\nGit / version control for managing analytical assets\nBackground in real estate, self-storage, or other asset-intensive industries\nExperience with revenue management systems or dynamic pricing tools\nAbout Security Public Storage\nSecurity Public Storage (SPS) is a family-owned self-storage company operating 53 facilities across multiple states. We're a lean, data-driven organization investing in the infrastructure and talent to make smarter decisions at scale. This role is an opportunity to have real impact — you'll be one of a small number of people building the analytical foundation of how we run the business.\nPay: $115,000.00 - $125,000.00 per year\nBenefits:\n401(k) 4% Match\nHealth insurance\nHealth savings account\nLife insurance\nPaid time off\nAbility to Commute:\nSan Francisco, CA 94107 (Required)\nWork Location: Hybrid remote in San Francisco, CA 94107","datePosted":"2026-07-21T11:29:33.350Z","dateModified":"2026-07-21T11:29:33.350Z","hiringOrganization":{"@type":"Organization","name":"Security Public Storage","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Millbrae","addressRegion":"CA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"bdb6d74c17ab401d8ae58692"},"url":"https://jobsearcher.com/jobs/bdb6d74c17ab401d8ae58692"}}