Job Description
- 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
Key skill Required
- SQL
- Architecture
- SQL Server
- Azure
- Construction
- Data Lake
- Analytics
- Application Development
- Azure Data Factory
- Cataloging
- Data Mart
- Data Migration
- Data Modeling
- Data Profiling
- Data Warehouse
- Database
- Database Performance
- Design
- Development
- Healthcare
- Healthcare Reimbursement
- Informatica PowerCenter
- Infrastructure
- Insurance
- Internet
- Life Insurance
- Metadata
- Microsoft Azure
- Performance Tuning
- PL/SQL
- Profiling
- Reimbursement
- Short-Term Disability
- Snowflake Schema
- Star Schema
- Writing
