Data Warehouse ETL Developer

Posted on Jan 22, 2019 by Revantage Corporate Services

Chicago, IL 60606
Senior Appointments
Immediate Start
Annual Salary


Job ID 2
Category Information Technology

Revantage Technology comprises a team of data professionals focused on delivering business intelligence tools that improve decision-making, optimize internal business processes, increase operational efficiency, and transform data to insights.

The Data Warehouse ETL Developer will be responsible for designing and implementing efficient data transformations that will empower our high-impact Business Intelligence and Data Governance initiatives. The ETL Developer must ensure strategy aligns with the enterprise data management and analytics architecture assets (including master data management, data quality, data warehousing, data integration, metadata management, enterprise data model, and analytics).

As the Data Warehouse ETL Developer, one is held accountable to, however not limited to, the following job functions:
  • Develop complex ETL mappings and workflows utilizing various forms of data (relational, xml, json, csv) and data sources (APIs, server logs, external data, etc.)
  • Business requirements analysis, coding, testing, integration, maintenance and support
  • Write advanced SQL including query tuning
  • Implement testing techniques and scripts to QA ETL processes
  • Identify needs and formalize recommendations
  • Document system design and technical specifications
  • Create data migration plans
  • Contribute to daily stand-up meetings, planning meetings, and code review sessions (using Scrum / Agile methodology)
  • Collaborate with cross-functional groups to fulfill business requirements and change management

  • Bachelor's degree in Computer Science, Technology, Engineering
  • 3+ years of experience designing and building complete ETL/SSIS processes moving and transforming data for Staging and Data Warehousing
  • ETL/Data Integration tools (SSIS)
  • Experience in system optimization
  • Strong oral and written communication skills

  • Proficient with MS SQL Server / Azure Cloud Environment
  • Demonstrated experience with Kimball / dimensional data architecture techniques
  • 5-7 years of experience

Revantage Corporate Services ("Revantage") is a newly-formed organization providing key business services to real estate portfolio companies of the alternative investment firm, The Blackstone Group. Headquartered in Chicago, Illinois, Revantage is a fully-integrated corporate services platform set up to deliver best-in-class services which include accounting, tax, treasury, legal, risk management, technology and human resource capabilities, to a diverse real estate portfolio comprised of multi-family (LivCor), commercial office (EQ Office), hospitality (BRE Hotels and Resorts), industrial (Gateway Industrial Properties) , manufactured housing, retail (ShopCore) and senior living assets (Longview).

Revantage is a forward-thinking company with a highly skilled employee base and a strong commitment to sustainability. Culturally, its professionals are innovative, focused on future trends and requirements, and committed to providing the highest level of service and value. Revantage's primary objective is to provide efficient, scalable, best-in-class corporate services to Blackstone Real Estate, as well as support the operating business of each portfolio company. Revantage's vision is "Partnering in possibilities to unlock our greatest potential, together." Integral to the vision are several values or practices, such as lead with needs, better every day, innovation is a mindset, feedback loop, one team and co-ownership.

Blackstone is a global leader in real estate investing. Founded in 1991, the company manages approximately $420 billion in assets, including $120 billion in real estate investments with properties located across the U.S., Europe, Asia and Latin America. Major holdings include Willis Tower, The Cosmopolitan Hotel, Invitation Homes (single family homes), Stuytown (New York City), Thompson Reuters Corp., and prime retail and office buildings in the world's major cities. Blackstone real estate also operates one of the leading real estate finance platforms, including management of the publicly traded Blackstone Mortgage Trust.

Reference: 614988630

Similar Jobs

Senior Manager of Warehouse Operations

Chicago, IL

Alliance Search Solutions

Data Architect

Chicago, IL


Data Analyst

Chicago, IL

Revantage Corporate Services

Data Governance Lead

Chicago, IL

Revantage Corporate Services