Senior Data Warehouse / BI Architect Location:Chicago, IL

Senior Data Warehouse / BI Architect Location:Chicago, IL

  • Posted on : 09-08-2023
  • Job Type : Full Time only
  • Salary : 100,000 - 200,000

Job Description:

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
Strong research skills:

  • 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.


  • Latest Jobs
    Featured Jobs
    Trending Jobs
    Share Job: