Data Architect

Title:                                    Data Architect
Location:                            Schaumburg, IL or Eden Prairie, MN
Duration:                            6 Months Contract
 
Job Description:
Project/Projects
To start in 2019, CPR+ Platform Stability
 
What are the top 5-10 responsibilities for this position? (Please be detailed as to what the candidate is expected to do or complete on a daily basis)
  • Looking for someone to help us stabilize these environments - blueprint a better data architecture, data movement, help us separate our reporting from transactional data.
  • Need ETL improved, reporting data models, better reporting warehouse/DataMart/etc. Need to be able to mentor/train younger data folks
 
What skills/attributes that are desired?
  • Data architecture - setting up transaction systems vs reporting systems
  • Query & Function Optimization [Functions, Stored Procedures] - Creation, optimization, and exporting of these key data functions
  • ETL - optimize data pulls, processes, tools – SQL server
  • Capacity Planning - Help Design system for scalability and growth
  • Structuring Data- Help untangle bad correlations to create a usable data product
  • General Administration & Security
  • Experience setting up & optimizing a data warehouse/store/mart for reporting and analysis purposes in SQL Server
  • Design Data warehouse, lake, operational reporting data model
  • Improve ETL process
  • Data Visualization and Analytics
  • SQL Architecture Knowledge - Work within the SQL Data Architecture & understand it
  • High Availability [Always On] Experience - Know how to setup High Availability Data Systems
  • Transactional Data Analysis - be able to understand data as it flows within an application or system
 
What skills/attributes are a must have?
  • Data Warehouse/ Reporting Experience - have knowledge on designing and structuring data warehouses for use by reporting
  • Structured Data Solutions - have experience creating permanent data solutions for use by Data Lakes/Warehouses
  • Relational Database Design - Be able to design relational data solutions
  • SQL Architecture Knowledge - Work within the SQL Data Architecture & understand it
  • Capacity Planning - Help Design system for scalability and growth
 
What skills/attributes are nice to have?
  • Agile knowledge
  • High Availability [Always On] Experience - Know how to setup High Availability Data Systems

Want to apply later?

Type your email address below to receive a reminder

Apply to Job

ErrorRequired field
ErrorRequired field
ErrorRequired field
Error
Error
insert_drive_file
insert_drive_file