Job Description

Company Description

With more than 2,400 locations nationwide, Public Storage is the leader in the self-storage industry, and given our number of tenants, we may very well be the world's largest landlord. We've experienced unprecedented growth over the past four decades, and it's in no small part due to the dedicated team that has helped us become an S&P 500 industry leader, the country's largest real estate investment trust (REIT), and the most recognizable name in self-storage.

Job Description

The Senior Business Intelligence Developer engages directly with our IT organization and vendors to ensure the successful design, development and delivery of technology based solutions including a specialization in enterprise data warehouse space technologies. More specifically, Microsoft technologies (SQL Server, SSRS, SSIS, SSAS) and other BI tools like Cognos, Tableau, PowerPivot, Power BI, or Pyramid

This individual will be a key asset in the software change and release management processes, assisting with the overall maturity of the software development lifecycle. This requires driving on-time, high quality development deliverables to multiple environments including operations engagement and production release, while working with cross-functional teams. In addition, she/he will assist in the definition and maturation of processes to optimize efficiency and quality.

Responsibilities

  • Solicit data requirements from end-users.
  • Design and create ETL processes to retrieve data from the key systems into the data warehouse system.
  • Design, develop and maintain OLAP cubes using Microsoft Analysis Services.
  • Design and develop and modify reports using Microsoft SQL Server Reporting Services.
  • Create ad hoc reports when required.
  • Maintain documentation for ETL processes and OLAP data bases including technical documentation and end-user documentation.
  • Train users
  • Analyze and validate data for accuracy and consistency, working closely with the business users to make sure the data meets their expectations.
  • Troubleshoot data and technical issues with ETL processes and OLAP cubes.
  • Solves highly technical and complex incidents/ business problems and/or drives efforts to resolve incidents
  • Develops/designs integrated solutions within a broad technical context
  • Reviews documents of others; looks to automate processes and create efficiencies 
  • Serves as an expert on projects 
  • Establishes successful working and support relationships with cross-functional leaders and staff as well as third party vendors
  • Not only resolves problems as an individual contributor, but helps others resolve problems by providing real time coaching, advice and feedback
  • After resolving highly technical issues, looks to educate others to solve the issues independently in the future
  • Leads brainstorming sessions with associates to determine best solutions
  • Independently researches new technologies and can prepare a business case

Qualifications

  • 7-10 years experience, 5-7 in specific technologies below
  • Expert level Microsoft Analysis Services, Microsoft Reporting Services, and SQL Server Integration Services 2008 or above (SSAS, SSRS, SSIS)
  • Powershell or other scripting language
  • T-SQL
  • OLAP cubes
  • Experience with data warehouse modeling techniques and environments (Star, Snowflake, 3NF)
  • Business intelligence software (Cognos, Tableau, PowerPivot, Power BI, Pyramid)
  • Excellent communication and can build rapport with business partners
  • Functions as a highly regarded subject matter expert 
  • Responsible for solving technical and complex problems; go-to person for challenging technical issues
  • Where possible, automates work instead of manual execution
  • Ability to work independently or in a small group and serves as a teacher and mentor to other associates
  • Proven ability to deliver software deliverables on time
  • Understands technical solutions and business impact of the solution
  • Knows how to diplomatically present a challenging position; is able to positively influence others without resorting to authority
  • Develops/designs integrated solutions to resolve technical issues
  • Delivers a higher quality and quantity of work compared to intermediate associates
  • Familiarity with, and demonstrated understanding of, the general enterprise business and technical architectures
  • Experience in embracing and helping others to embrace change
  • Proven internal and external influencing skills
  • Experience with Waterfall and Agile methodologies
  • Expert level experience with Microsoft Project and Excel

Technologies and Skills

  • Experience working in an Agile environment preferred
  • Experience with SQL, T-SQL
  • Expert level Microsoft Analysis Services, Microsoft Reporting Services, and SQL Server Integration Services 2008 or above (SSAS, SSRS, SSIS)
  • Powershell or other scripting language
  • OLAP cubes
  • Experience with data warehouse modeling techniques and environments (Star, Snowflake, 3NF)
  • Business intelligence software (Cognos, Tableau, PowerPivot, Power BI, Pyramid)

Additional Information

All your information will be kept confidential according to EEO guidelines.

Privacy Policy

Req ID:743999692713692

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online