Work in an Azure data warehouse environment, which includes developing database designs and architecture, data modeling and metadata repository creation
Work with Architects, Technical Leads and Business Teams and contributes to the development of technical designs
Secure data migrations & transformations to/from clients, customers, and vendors
Provides technical database consultation on application development, global infrastructure, and other database administration efforts related to specific DBMS
Conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows
Migrate current ETL and SSIS packages to Synapse
Requirements
2-3+ Years of proven experience performing large data migration and transformation efforts
Strong hands-on experience with Microsoft Azure Data & Analytics including Azure Synapse, Azure Data Factory, & Azure Data Lake Storage
Experience in writing complex SQL queries and creating data models
Experience or exposure to TSQL, SQL server, PL/SQL
Experience or exposure to Informatica PowerCenter, Star Schema, Snowflake Schema
Database performance tuning
Data warehouse and data mart experience
Strong knowledge of various data structures and the ability to extract data from various data sources (such as Cognos, Informatica, Hyperion, etc.)
Benefits
Education Assistance/Student Loan Repayment - up to $2400 annually