数据工程师

• 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