Share this Job

Lead Architect, Database Architecture

Requisition Id:  334600
Business Unit:  Brokerage

Chicago, IL, US, 60601


Solutions driven success.


XPO is a top ten global provider of transportation services, with a highly integrated network of people, technology and physical assets. At XPO Logistics, we look for employees who like a challenge and can communicate effectively in all situations. We want to leverage your skills and years of experience to drive positive results while ensuring a bright future for yourself and XPO. If you’re looking for a growth opportunity, join us at XPO. 


As the Lead Architect of Database Architecture, you’ll assist in the architecture work of a highly integrated, high performance, real-time reporting data warehouse. We will equip you with the best tools in the industry to grow and develop to a level that will exceed your expectations.


Pay, benefits and more.

We are eager to attract the best, so we offer competitive compensation and a generous benefits package, including full health insurance (medical, dental and vision), 401(k), life insurance, disability and the opportunity to participate in a company incentive plan.


What you’ll do on a typical day:

  • Build industry-changing applications for the third-party logistics industry
  • Collaborate with and provide guidance to Application Developers and Enterprise Architects to design, document and implement database strategies
  • Proactively manage database support issues and effectively take corrective actions
  • Oversee the scaling and availability of SQL Server databases On Perm and On Cloud
  • Review database procedural and structural change requests, ensuring that all new database code meets company standards for readability, reliability, and performance
  • Rewrite and tune poorly performing SQL code to improve system performance by studying execution plans and optimizing the capabilities of the DBMS
  • Develop stored procedures and scripting to automate databases tasks
  • Develop interfaces and integrations with other applications
  • Build reporting and BI tools in a Microsoft SQL Server environment (including SQL Server Integration Services and SQL Server Analysis Services)

What you need to succeed at XPO:

At a minimum, you’ll need:

  • Bachelor's degree or equivalent related work or military experience
  • 4 years of related experience
  • Strong SQL Server (preferably 2016 or later) administration with experience in a clustered environment
  • Experience in SQL Server performance tuning and query monitoring
  • Strong T-SQL skills
  • Strong understanding of relational data modeling

It’d be great if you also have:

  • Bachelor’s or master’s degree in computer science or electrical engineering
  • Experienced in SQL Server performance tuning and query monitoring and SQL Server Always on Availability Groups
  • Build robust database solutions from business requirements
  • Experience with Project-oriented offline database development (SSDT)
  • Experience with no-SQL document based database like Couchbase or MongoDB
  • Experience with Cloud SQL databases for GCP or Azure
  • Fluent in source control, esp. Github
  • Experience with TeamCity and continuous integration
  • Experience with SSIS
  • Excellent verbal and written communication skills; able to present clean, organized and thorough information and data appropriate for intended audience
  • Microsoft SSAS and data warehouse design
  • OLAP cubes and MDX development

Be part of something big.


We are proud to be an Equal Opportunity/Affirmative Action employer. Qualified applicants will receive consideration for employment without regard to race, sex, disability, veteran or other protected status.


All applicants who receive a conditional offer of employment may be required to take and pass a pre-employment drug test. 

The above statements are not an exhaustive list of all required responsibilities, duties and skills for this job classification.  

Review XPO's candidate privacy statement here. 

Nearest Major Market: Chicago

Job Segment: Architecture, Database, Data Warehouse, SQL, Developer, Engineering, Technology