Job Title: Data Engineer

Company Name: Bitful Consulting

Job Url: https://www.simplyhired.com/job/jr5Uw9_D7EnYZNuFWoZiwcoT0o5RsZXd0l48yiITRvUSFJIkufq1XA

Job Description: Data Engineer
Bitful Consulting
Remote

Job Details
Full-time
Benefits
Internet reimbursement
Loan repayment program
Disability insurance
401(k) 4% Match
401(k) matching
Life insurance
Qualifications
Data model design
Cognos
Hyperion
Performance tuning
Data Integration (Data management)
Data lake
Cloud data warehouses
Azure Data Lake
Data migration
Mid-level
Data Architecture Design (Architecture design skills)
Azure Data Factory
Metadata
SSIS
Star schema
Informatica
PL/SQL
2 years
Metadata management
Dimensional modeling
T-SQL
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
Remote work allowance
Internet reimbursement
Bench pay
Profit share
Healthcare reimbursement
401k - 4% match
Short-Term disability
Long-Term disability
Life Insurance