Previous Job
Previous
Database Architect
Ref No.: 17-00020
Location: Chicago, Illinois
Position Type:Contract
Start Date: 01/23/2017
Role: Database Architect
Location: Chicago, IL
Tenure: 3-6+ months and ongoing based on project progress and report work sizing
ØHigh level Responsibilities:
  • Database Architect to elaborate, estimate, design and prioritize data preparation and database / SQL queries for analytical insights reporting
  • Analyze analytical reporting requirements & current data warehouse design to elaborate corresponding data preparation and reporting needs
  • Recommend design for data preparation and DB / SQL queries to address the analytical reporting requirements
  • Evaluate if Tableau will address their reporting needs or if alternatives to be suggested
  • Identify pre-requisites and dependencies to be fulfilled for successful data design
  • Estimate efforts and recommend project plan to accomplish the data preparation and reports delivery
  • Work with customer stakeholders to validate / fine-tune the requirements, design approaches and project plan
  • Deliver the data preparation / DB design / SQL queries as designed on top of SQL Server DWH
  • Work with Tableau / reporting developers to deliver the set of reports
  • work with customer stakeholders to manage and mitigate ongoing project risks and dependencies to align / accommodate / adjust project timelines or task priorities and keep fulfillment of overall goals on track
ØTechnical skills:
  • Critical - Database design from functional, administrative, security, performance point of view
  • Important - SQL Server data warehouse design
  • Critical - BI reporting off DWH
  • Important - Tableau or equivalent tool for report development
  • Important - Effort estimation, risk management, professional communication, project tracking & reporting.