job_description.job_card.job_descriptionWork in an Azure data warehouse environment, which includes developing database designs and architecture, data modeling and metadata repository creationWork with Architects, Technical Leads and Business Teams and contributes to the development of technical designsSecure data migrations & transformations to / from clients, customers, and vendorsProvides technical database consultation on application development, global infrastructure, and other database administration efforts related to specific DBMSConduct data profiling, cataloging, and mapping for technical design and construction of technical data flowsMigrate current ETL and SSIS packages to Synapse2-3+ Years of proven experience performing large data migration and transformation effortsStrong hands-on experience with Microsoft Azure Data & Analytics including Azure Synapse, Azure Data Factory, & Azure Data Lake StorageExperience in writing complex SQL queries and creating data modelsExperience or exposure to TSQL, SQL server, PL / SQLExperience or exposure to Informatica PowerCenter, Star Schema, Snowflake SchemaDatabase performance tuningData warehouse and data mart experienceStrong knowledge of various data structures and the ability to extract data from various data sources (such as Cognos, Informatica, Hyperion, etc.)Education Assistance / Student Loan Repayment - up to $2400 annuallyRemote work allowanceInternet reimbursementBench payProfit shareHealthcare reimbursement401k - 4% matchShort-Term disabilityLong-Term disabilityLife Insurance