Job Description

The  Data Warehouse  Lead  is  responsible  for  designing  data  solutions  and  leading  a  team  during  the writing of scripts and ETLs required to extract, transform, clean, and move data and metadata so theycan be loaded into or extracted from databases, data warehouses, data marts, or text files.

Responsibilities

• Planning, design, development and optimization of relational and multi-dimensional data models and ETL/ELT Jobs and processes.
• Definition and maintenance of the data warehouse metadata (Data Dictionary)
• Participate in defining data modeling standards, strategies, and approaches in accordance with industry best practices and procedures
• Responsible for testing, monitoring and validating data integration activity, including data extraction, cleansing, transformation, movement, loading and updating processes
• Ensures data integration processes meets service level requirements
• Designs and  writes  the  scripts  required  to  extract,  transform,  clean  and  move  data  and metadata so it can be loaded into a data warehouse, data mart or operational data store
• Supporting the technical design process by participating in the analysis of technical application requirements
• Assisting in implementing analyses that will identify requirements related to people, processes and technology
• Participating in implementing the technical infrastructure
• Assisting in the integration of technical and application components
• Maintaining, tuning and repairing applications; providing user support
• Participating in execution and documentation of tests
• Executing conversion plans and documenting possible improvements; identifying disruptions inthe processes
• Responsible for providing leadership to a team of developers
• Prioritizes requirements, schedules tasks and communicates progress
• Design of Test Scripts and Process

Skills

• Good communication and leadership skills
• Understanding of source and target data structures
• Understanding of ETL processes and products
• Knowledge of Unix shell scripting
• Strong problem-solving and metadata skills
• ETL Tools, RDBMS, SQL writing experience
• End-to-end implementation of ETL projects
• Data Warehouse design and data modeling experience

Education and Experience Level

• Experience with data performance and data warehousing concepts
• Minimum of  8  years  data  architecture  experience,  demonstrated  accomplishment  of  data architecture and data modeling assignments
• BS Degree in Computer Science/Information Technology, Computer Engineering or any 4-year IT related degree
• Hands-on experience in implementation and deployment of SAS Data Integration Solution.
• Hands-on experience in implementation and deployment of any of the following Data Integration Technologies/Solutions: SAP, Oracle, IBM, Informatica, Microsoft SQL Server and on SAS Data Quality Solution is a plus