About the job
Work in an Azure data warehouse environment, which includes developing database designs and architecture, data modeling and metadata repository creation.
Responsibilities
- 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.).
Conditions
- 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.