Strong experience with Azure Data & Analytics tools
Proficient in complex SQL queries and data modeling
Familiarity with TSQL, SQL Server, PL/SQL
Knowledge of ETL processes, specifically in Informatica
Experience in database performance tuning
Understanding of data warehouse concepts
Responsibilities
Develop database designs and architecture in Azure environment
Collaborate with architects and business teams on technical designs
Ensure secure data migrations and transformations
Provide technical consultation on database-related application development
Conduct data profiling, cataloging, and technical data flow mapping
Migrate existing ETL and SSIS packages to Azure Synapse
Benefits
Education Assistance/Student Loan Repayment up to $2400 annually
Remote work allowance
Internet reimbursement
Bench pay
Profit share
Healthcare reimbursement
401k with 4% match
Short-Term and Long-Term disability
Life Insurance
Full 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
