Remote Data Engineer

Description:

• Work in an Azure data warehouse environment, which includes developing database designs and architecture, data modeling, and metadata repository creation.
• Collaborate with Architects, Technical Leads, and Business Teams to contribute to the development of technical designs.
• Secure data migrations & transformations to/from clients, customers, and vendors.
• Provide 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.