Data Engineer

This Data Engineer role involves developing database designs and architecture within an Azure data warehouse. The role involves data modeling, metadata creation, data migration, and consultation with application development and infrastructure teams. The engineer will also perform data profiling, cataloging, and mapping, and migrate existing 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 (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
• Ability to extract data from various data sources (e.g., Cognos, Informatica, Hyperion, etc.)

Benefits

• Education Assistance/Student Loan Repayment
• Remote work allowance
• Internet reimbursement
• Bench pay
• Profit share
• Healthcare reimbursement
• 401k - 4%
• Short-Term disability
• Long-Term disability
• Life Insurance