Previous Job
Previous
Sys Architect
Ref No.: 18-21031
Location: Des Moines, Iowa
Title: Sys Architect (571190) 
Location:Des Moines, IA 50315
Duration: 10+ Months


Job Descprtion:
This position will be working full-time on the Enterprise Data Warehouse ETL team and will require advanced Data Architect and DBA skillsets.The existing data warehouse is built upon the Microsoft SQL Server platform.   Extensive experience in data warehouse design, dimensional modeling, and new database development is required. Part of the role will be to contribute to the team develop the best tool bases to use on the project. 
                 
This will involve reviewing the current ETL strategy, database design and verification, data integrity validation, and interactions with external stakeholders and customers.  The candidate will have experience working in a fast-paced environment, working on multiple tasks simultaneously. 
 
Responsibilities
  •  Analyze data stored in a disparate set of systems (mainframe and client server) to produce data  requirements and provide architectural and decision support direction.
  • Use dimensional modeling to designing a robust data warehouse design (MS SQL)
  • Use industry standards and/or best practices  to create an efficient ETL strategy
  • Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, logical, and physical data models based on those needs
  • Be accountable for integrity and quality of data, ensuring the information meets customer needs
  • Understand how the data interacts with the application code
  • Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision
  •  Ability to read, understand and create design documents
  • Experience working in a team-oriented, collaborative environment
  • Exceptional analytical, conceptual and problem-solving abilities
  • Strong written, technical documentation and oral communication skills
Skills Required:
  • Experience in enterprise data warehouse design and dimensional modeling
  • Extensive background in relational database systems, preferably with MS SQL Server
  • Proficient use of Transact SQL (T-SQL) to query, analyze and manage relational databases
  • Experience in analyzing client operations, evaluating current systems and reviewing objectives with clients
  • Experience with ETL scripting, preferably using SQL Server Integration Services (SSIS)
  • Proficient configuration of database security, backup and recovery options