Job Details

Role:Senior Data Warehouse / BI Architect

Location:Chicago, IL

In short: you are hungry to grow a base of power-users but you don\'t shy away from daunting integration & legacy/tech-debt tasks.

A few other things:

• Business Analyst role: lead and assist in research & requirements gathering to formulate and plan delivery planning & data model requirements.
  
• Participating in the full lifecycle of DW / BI implementations, taking on roles beyond that of a developer when necessary.
  
• Candidate must be comfortable being involved in business analysis and testing tasks in addition to architecture and development.
  
• Build, optimize, and stress-test ETL packages and SQL Agent Jobs
  
• Build, optimize, and stress-test Operational Data Stores and the Enterprise Data Warehouse.
  
• Leading and supervising EDW and reporting build, test, and deployment
  
• Leading, directing, and mentoring other staff involved in building and supporting DW and BI initiatives.
  
• Flexible work environment but occasional odd hours in the event of infrastructure changes, downtime, or upgrades
  

What you'll bring to the table:

• Mostly using SSRS & Tableau in-house now: tell us why you like these tools or prefer others!
  
• Do you have experience with Power BI, Amazon Redshift, Qlik View, Qlik Sense, or Spotfire? Tell us how you\'ll make them work for us!
  
• Experience deploying DW and BI solutions in on-premise and cloud-based infrastructures
  
• Familiarity with Agile methodologies (we\'re on Scrum!)
  
• Familiarity with EDW methodologies and best practices. Kimball / Inmon / Data Vault
  

• Demonstrated problem-solving and quantitative skills, combined with excellent written and verbal communication skills are required.
  
• Bonus if you have mortgage industry and/or other lending or financial business experience.
  
• Double bonus if you've built prior Data Warehouse(s) for a lender or FinTech company.