Senior Data Warehouse Engineer

Information Technology Phoenix, AZ


Description

Are you interested in working with newest data warehouse technologies?  Would you find it compelling to have the opportunity to put YOUR stamp on the creation of a highly visible data warehouse? If so, we would love to hear from you!

 

Realty Income is looking for a Senior Data Warehouse Architect.  This pivotal role will be responsible to seek out the best ways to execute the company data strategies.  The Senior Data Warehouse Architect will be responsible for the planning and implementation of data warehouse including data feeds, creation, and continual enhancements of reporting capabilities.  Reporting to the Vice President, Data Architecture this role will contribute to establishing the company’s data practices and governance.

 

What you will work on day to day:

  • Develop, test, configure, optimize, document, and deploy database objects and data processing packages needed to Extract, Transform, and Load the layers of the data warehouse.
  • Develop and maintain mapping logic to ETL data sets from a variety of source systems.
  • Plan and coordinate Business Intelligence reporting using Power BI.
  • Support, maintenance, monitoring, troubleshooting, and resolution for data warehouse, reporting and database processes.
  • Work various teams to understand, document, and design database, ETL processes and reporting.
  • Contributes to quality assurance tasks and bug fixes.
  • Develop customer facing reporting, dashboards, SSRS reports, data visualizations, and analytics.
  • Coordinate with the Predictive Analytics team to prepare and preprocess data.
  • Provide knowledge, guidance, research, business process mapping and fact-finding expertise to define, design, and modify specifications and processes for complex information systems and business process.
  • Participates in establishing system documentation standards and QA methodologies.
  • Defines data standards and governance for the entire organization (including managing data catalogs).
    • Core technologies used in this position include: Azure (Data Bricks, Data Lake Storage 2.0, SQL Data Warehouse, Data Factory 2.0, Portal, Machine Learning), T-SQL and MDX queries, Power BI and M, SQL Stored Procedures, Synapse Analytics, Cloud based data warehouses, Master Data Management.
  • Other duties as assigned, full job description available upon request.

 

What we need from you:

  • Bachelor’s degree or equivalent in Computer Science or related field.
  • Master’s degree in Computer Science preferred.
  • MS Azure Data Warehouse certifications (Data Solution, Data Engineering).
  • 10 or more years of experience developing and maintaining cloud-based database and warehouse solutions; including performance optimizations and ETL processes (with focus on Azure).
  • 8+ years working on Business Analytics and Reporting using Power BI, SSRS and Tableau.
  • 5+ years of data governance (including Master Data Management, Data Architecture and data catalog).
  • Experience with monitoring, tuning, optimizing, profiling data warehouse and business intelligence environments.
  • Strong knowledge of data science and Azure based machine learning.
  • Working knowledge of Artificial Intelligence (AI) based technologies including Computer Vision and Natural Language Processing (NLP).
  • DBA skills related to data warehouse / business intelligence systems such as index design, aggregate design, partitioning, etc.
  • Solid understanding of Software Development Life Cycle.
  • Experience unit testing and validating data sets against tie out data sets and business requirements.
  • Experience in Commercial Real Estate domain and knowledge of ERP applications (i.e., Yardi), is a strong plus.

 

What You’ll get in Return:

For more than 50 years, Realty Income, The Monthly Dividend Company has been guided by our mission to invest in people and places, delivering dependable monthly dividends that increase over time. Our purpose is to build enduring relationships and brighter financial futures.

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

Who we are:

 

Realty Income, The Monthly Dividend Company®, is a member of the Artistocrat’s index within the S&P 500.

 

Our purpose is to build enduring relationships and brighter financial futures.  As the 6th largest REIT in the nation, our monthly dividends are supported by the cash flow from over 11,000 real estate properties owned under long-term lease agreements with global commercial tenants. To date, our company has declared over 600 consecutive common stock monthly dividends throughout its 53-year operating history and has continually increased the dividend since Realty Income's public listing in 1994 (NYSE: O). Our company attracts individuals who value integrity, perseverance, and teamwork. If you appreciate working in a professional environment that rewards employees based on merit and values a work-life balance, make sure to apply today! 

 

To all recruitment agencies, Realty Income does not accept unsolicited agency resumes. Please do not forward resumes to our job’s alias, Realty Income employees, or any company location. Realty Income is not responsible for any fees related to unsolicited resumes

 #REITJobs  #LI-HC1

Realty Income is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. For more information click here. If you require accessibility support to submit your application or other reasonable accommodations to participate in the recruitment process, please contact [email protected], or call 800-375-6700. An employee will respond to your message to begin the interactive process. Please note that this phone number and email address are only for individuals seeking a disability accommodation when applying for a job.