Data & Business Analyst

Are you excited about leveraging your data analysis skills to design and maintain impactful Power BI dashboards, and drive high-quality data insights for a leading real estate company? Realty Income Corporation, headquartered in San Diego, is a globally recognized leader in the S&P 200.  For over 50 years Realty Income has been a real estate partner to the world’s leading companies. Our dedicated team is growing, and we are looking for a Data and Business Analyst who embodies our company vision to be a preeminent S&P 100 enterprise that values creating long-term value for all stakeholders and employees.  The Data & Business Analyst based in San Diego will be responsible for performing business analysis, designing and maintaining Power BI dashboards, and implementing data governance standards and procedures. The central focus of this role is to deliver and promote high-quality data, analytics, and insights to the organization in support of the company’s growing enterprise data and business intelligence functions. This highly visible role will partner with internal stakeholders and company leadership to understand business needs and deliver impactful, well-aligned solutions. Specifically, the Data & Business Analyst will be responsible for:

• Perform data gathering and analysis functions using SQL, Excel, and other methods to identify trends, develop reports, and create visualizations of processed data.
• Understand and document the company’s enterprise data, analytics, and operational reporting needs to ensure optimal implementation of data projects.
• Execute high-priority, cross-functional projects to design, develop, and maintain robust, scalable, and accurate Power BI semantic models, reports, and dashboards.
• Analyze and visualize data to identify trends and anomalies, drawing insightful conclusions to support decision-making.
• Contribute to routine and ad-hoc presentations and demonstrations of recent analyses, reports, and Power BI dashboards to the wider company to transfer knowledge and ensure end-user adoption.
• Support and document data governance policies, procedures, and frameworks aligned with business objectives.
• Assist in developing processes to monitor and report on data governance performance, adherence to standards, and corrective actions.
• Maintain systems to classify and govern data, considering business usage, sensitivity, and availability.
• Maintain metadata repositories documenting enterprise data definitions, ownership, access, and usage.
• Map and document the flow of data across different systems within the organization, including its origin, transformations, and usage, to ensure data quality, compliance, and traceability throughout its lifecycle.

Performs other duties as assigned. This is a hybrid role, with Tuesday, Wednesday and Thursdays required in-office.What you need to be successful:

• It is expected to execute the duties of this position a qualified candidate will have a bachelor’s degree in business, economics, statistics, computer science, mathematics, engineering, or a related field, or equivalent related experience in a professional environment.
• Minimum of 1-year practical work experience in business intelligence with experience designing and executing technical projects.
• Minimum of 1 year of experience completing analytics in finance, economics or related.
• Proven experience writing complex SQL queries to join and transform multiple datasets.
• Skilled in working with large-scale databases and high-volume data environments.
• Ability to define business requirements and translate data into actionable insights.
• Experience with reporting and data visualization tools such as Power BI, Tableau, Quick Sight, or other BI packages.
• Understanding of ETL and Data Warehouse concepts.
• Knowledge of Microsoft Excel at an advanced level (including pivot tables, index/match, vlookup, power pivots, etc.).
• Proficiency in Word, PowerPoint, and other commonly used Microsoft 365 products.
• Rigorous attention to detail with an ability to understand complex systems and discern the relevance and impact of system variables.
• Excellent analytical and problem-solving skills, including the ability to independently diagnose and resolve technical issues.
• Strong communication skills, including the ability to adapt style to the audience and navigate technical and non-technical domains.
• Ability to collaborate with a diverse range of stakeholders and adapt to evolving business needs.
• Additionally, it is preferred that candidates have the following:
  • Experience using Python or R for data analysis is a strong advantage.
  • Preferred multi-year experience in developing and deploying Power BI semantic models and dashboards.
  • Demonstratable expertise in enterprise data governance, including principles, best practices, industry standards, and relevant technologies.
  • Familiarity with Snowflake, database, and data warehouse design, including the ability to implement data governance within this architecture.
  • Knowledge of commercial real estate reporting and analysis, including financial modeling, performance metrics, and market research. 
  • Experience with applying statistical methods to business problems.

 What You’ll get in Return:  

• Competitive Salary including potential for bonus and stock awards. 
• Best-in-class Benefit Package 
• Collaborative, team-oriented environment 
• Opportunities for Continuing Professional Development 

Additional information can be obtained from the corporate website at www.realtyincome.com.  The hourly pay range for this role is $31.11 – $36.83 – $42.48 Offers near the high end are uncommon but may be considered for candidates with exceptional experience and skills and are dependent on the facts and circumstances of each case. You may be eligible for an annual discretionary bonus and an annual discretionary stock award, to be discussed during the interview process. An annual pay rate and total compensation package is generally determined by the candidate's experience, knowledge, education, skills, performance, and abilities, as well as internal equity, company performance, and alignment with market data.    Most US-based full-time and part-time roles come with flexible schedules. We offer a best-in-class benefits package that includes healthcare, dental, and vision insurance for employees and eligible dependents. Our 401(k)-retirement plan has a company match of 50% up to 6% of eligible compensation. Realty Income also offers other wellness, financial, and work/lifestyle-specific benefits, along with 8.66 PTO hours every month; in addition to 12 paid holidays, and paid volunteer time. Realty Income’s purpose is to build enduring relationships and brighter financial futures, and this starts with you!