Job description

Realty Income Corporation aims to be a globally recognized leader in the S&P 100, committed to creating long-term value for all stakeholders. The Data & Business Analyst will be responsible for performing business analysis, designing and maintaining Power BI dashboards, and implementing data governance standards to deliver high-quality data insights for the organization. Responsibilities • 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. Skills • 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. • 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. Education Requirements • Bachelor's degree in business, economics, statistics, computer science, mathematics, engineering, or a related field, or equivalent related experience in a professional environment. Benefits • Healthcare, dental, and vision insurance for employees and eligible dependents • 401(k)-retirement plan has a company match of 50% up to 6% of eligible compensation • Other wellness, financial, and work/lifestyle-specific benefits • 12 PTO hours every month • 12 paid holidays • Paid volunteer time Company Overview • Realty Income is a company providing shareholders with monthly income. It was founded in 1969, and is headquartered in Escondido, California, USA, with a workforce of 201-500 employees. Its website is http://www.realtyincome.com/. Company H1B Sponsorship • Realty Income Corporation has a track record of offering H1B sponsorships, with 1 in 2025, 1 in 2023, 2 in 2022. Please note that this does not guarantee sponsorship for this specific role.

Requirements