Data Engineer
June 13
🏡 Remote – New York
Description
• 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 • Remote work allowance • Internet reimbursement • Bench pay • Profit share • Healthcare reimbursement • 401k - 4% match • Short-Term disability • Long-Term disability • Life Insurance
Apply Now
