Data Warehouse Architect

Company Name:
ATSI Group
Our client, a high profile local financial institution, needs a Data Warehouse Architect to join the team.
They're starting a ground up build of a new DW/BI system and need a seasoned expert to assist in all aspects of construction. They have just completed an enterprise wide business interview process. You'll be assisting with analyzing the interview data and distilling out the business processes to be considered in the business process prioritization session.
The ideal candidate would provide mentoring in addition to completing hands-on tasks, working closely with our database developer. You will be expected to complete environment setup, and one or two business process iterations through the lifecycle resulting in completed SSAS cubes for use in SSRS and PowerPivot for Excel.
Required Experience:
- SQL SERVER 2008,2012 (SSMS, SSIS, SSAS, SSRS)
- Dimensional modeling tools
- Data profiling tools
- Database design tools
- Source repositories
- Windows server 2008/2012 (physical and virtual on VMWare)
- NetApp SAN
- Microsoft Fast Track reference architectures
- Data Warehouse appliances
- Kimball Data Warehouse Lifecycle
- Agile development
- SQL Server Enterprise administration and database development expertise, including the following:
- System sizing for a new warehouse.
- Determining the best infrastructure configuration for a new warehouse (physical vs. virtual, local storage vs. SAN).
- Selecting the best compromise of safety vs. performance for backup/DR needs of a new warehouse.
- Full data warehouse lifecycle experience, specifically Kimball approach
- Multi-dimensional design and implementation, specifically SSAS MDX
- Powerpivot design and implementation (non-sharepoint)
- Powerview design and implementation (non-sharepoint)
- SSRS design and implementation (non-sharepoint)
- Source control for database objects
- Documentation of data warehouse design, processes, and data


Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.