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