We are seeking an experienced SQL Server Integrated Services (SSIS) Data Architect who will work with business users and members of the technical team on the architecture, design, and development of highly scalable ETL processes and Data Warehouse (EDW) utilizing tools such as Microsoft SQL Server and MicroStrategy. Candidate must have 5+ years experience with the Data Warehouse architecture, design, development and deployment of business intelligence systems.
Key Role & Responsibilities:
> 5+ years of business/technology work experience
> 6+ years of hands-on experience with ETL Processes
> Possess an understanding of modern data warehouse architectures and data warehouse modernization techniques
> Good knowledge of BI architecture, data warehousing concepts
> Data Integration Tools: MS SQL Server SSIS
> High level of SQL language proficiency with common database platforms such as SQL Server, Oracle, MySQL, and/or DB2 database management systems; Teradata experience is a plus
> Knowledge and experience with SSAS a plus
> Knowledge and experience with data modeling is a plus