Apply Now

Data Warehouse Architect

Oakbrook Terrace, IL, USA Req #190
Wednesday, October 2, 2019

 SIRVA is a leading partner for corporations to outsource their mobility needs, relocating and moving their executives and staff globally. SIRVA offers an extensive portfolio of mobility services across approximately 170 countries providing an end-to-end solution to deliver an enhanced mobility experience and program control and security for customers. SIRVA has a portfolio of well-known and recognizable brands including Allied Van Lines, northAmerican Van Lines, SMARTBOX, and Allied Pickfords. For more information please visit

SIRVA brings together strong, collaborative people in a dynamic culture of mutual respect, support, and passion for the brand and product. We believe innovation drives winning performance, and we constantly challenge ourselves to be the very best we can in every aspect of our business. You will be surrounded by some of the brightest and most driven people in the industry. At SIRVA, you will be in great company!           

The Data Warehouse Architect is an expert well-versed in Data Warehousing and Business Intelligence technologies who demonstrates extensive abilities interacting with end-users to understand and document business and functional requirements, data sources, metadata, and conceptual data models for complex analytics application across a global enterprise.


• Design and develop data warehouse solution architecture
• Gather requirement and translate business requirement into technical design
• Design, develop, and implement ETL codes
• Support production ETL bug fixes
• Coordinate, lead, and mentor offshore ETL developers


  • At least 7 years of Data Warehouse ETL design, development and maintenance with successful implementation of large Enterprise BI solutions

  • Min. 5 years of experience with RDBMS platforms (ie. Oracle, Teradata, DB2, MS SQL Server), SQL, ETL tools (Talend, Informatica PC, Business Objects Data Integrator, SSIS and others), big data architecture and related technologies (ie Spark)

  • Developing solution architecture using business stakeholders' requirement and transforming into conceptual data models, including socializing and implementing logical and physical DW/data mart data models; identifying data sources and metadata (including business rules, definitions, attributes, etc.) to deliver analytic requirements

  • At least two full lifecycle implementations, BI/SQL, DW/SQL/ETL/Modeling tools and other related technologies involving: 

    • BI and enterprise DW data management, modeling, integration and/or synchronization, quality, security, conversion and analysis, star schema and relational reporting models, enterprise data management policies, procedures, compliance and risk management and/or database administration,

    • Design and development of data models, extraction code and cleansing routines utilizing typical data quality functions, i.e. standardization, transformation, rationalization, linking and matching that leverages data standards, processes and technology management for data, master data, and metadata; and, data security (including data masking and related data protection techniques)

  • Experienced with java, python and OOP concept

  • Hands on experience working on Windows and Linux environments and UNIX scripting

  • Identifiable leadership skills on generating a vision, establishing direction and motivating developers and other team members, creating an atmosphere of trust, leveraging diverse views, coaching staff, and encouraging improvement and innovation

  • Must be self-starter and able to demonstrate experience working in an agile environment to deliver robust & well tested solutions

  • Strong interest in learning new technologies

  • Able to stay on mission some nights/weekends during Team Sprints and production support

  • Demonstrated experience in various phases of the Systems Development Life Cycle

  • DBA or database development experience (a plus)

  • Bachelor’s degree (B.S.) in computer science or related field plus required experience

SIRVA is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, military status, genetic information or any other consideration made unlawful by applicable federal, state, or local laws. SIRVA also prohibits harassment of applicants and employees based on any of these protected categories. It is also SIRVA's policy to comply with all applicable state and federal laws respecting consideration of unemployment status in making hiring decisions. The Federal EEO Law Poster may be found at  If you need a reasonable accommodation because of a disability of any part of the employment process, please send an email to Human Resources at and let us know the nature of your request and your contact information.

Other details

  • Pay Type Salary
  • Oakbrook Terrace, IL, USA