Senior Consultant

Senior Consultant (CREQ
46763) Responsibilities

• The candidate will manage and enhance the data warehousing environment and to take it through the future iterations
• Establish the longterm strategy and technical architecture for the data warehouse
• Define and implement technical requirements, technical and data architectures for the data warehouse
• Design and manage the ETL process, including data quality and testing
• Design and manage the information access and delivery effort for the data warehouse
• Define and implement production release requirements and sustainment architecture
• Demonstrated ability to produce high quality technical documentation
• Write maintain scripts to extract, clean, organize and load data across platforms
• Manage the data architecture and infrastructure for processing large quantities of data sets
• Manage documentation for their data models across multiple sets SQL and No
  
  SQL databases

• Proficiency in Data Warehouse/ETL industry leading tools (Snowflake, Redshift, Informatica, Talend, Matellica, Pentaho, Snaplogic etc.)
• Experience w/ one or more of the following relational databases:
  MySQL, Postgres, Oracle, Sybase, SQL Server
• Comprehensive knowledge of relational and dimensional data modeling practices and implementation techniques and where they are best utilized.
• Exposure and experience working with AWS
• Experience with Data Performance and Optimization techniques
• Strong organization skills with excellent written and oral communication