# Data Engineer

> Bitful Consulting · United States (Remote) · Full-time · Posted 2024-06-12

**Workplace:** remote

## 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

## Apply

[Apply at Bitful Consulting](https://apply.workable.com/bitful-consulting/j/0C93AB84B4/apply)

---
Powered by [Workable](https://www.workable.com)