Data Engineer

- 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

Originally posted on Himalayas