This role is for a Data Engineer working in an Azure data warehouse environment, responsible for database design and architecture, data modeling, and metadata repositories, as well as secure data migrations and transformations, and migrating ETL/SSIS packages to Synapse.
Responsibilities
- ▹Design databases and architecture in an Azure data warehouse environment, including data modeling and metadata repository creation
- ▹Work with architects, technical leads, and business teams on technical designs
- ▹Perform secure data migrations and transformations to/from clients, customers, and vendors
- ▹Provide technical database consultation for application development, global infrastructure, and DBA efforts
- ▹Conduct data profiling, cataloging, and mapping for technical data flow design
- ▹Migrate current ETL and SSIS packages to Synapse
Requirements
- ▹2-3+ years of experience with large-scale data migration and transformation
- ▹Strong hands-on experience with Azure Synapse, Azure Data Factory, and Azure Data Lake Storage
- ▹Experience writing complex SQL queries and building data models
- ▹Experience or exposure to T-SQL, 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 data structures and extracting data from sources such as Cognos, Informatica, Hyperion
What we offer
- ▹Education assistance / student loan repayment up to $2,400/year
- ▹Remote work allowance and internet reimbursement
- ▹Bench pay, profit share
- ▹Healthcare reimbursement
- ▹401k with 4% match
- ▹Short-term and long-term disability, life insurance
Similar jobs
Job
Data Architect | US
Cuesta Partners
💰 Salary: not specified
🌍 Remote
🇺🇸 Chicago
🗣️ EN
Job
Revenue Data Analyst
DoorDash
💰 Salary: not specified
🌍 Remote
🇺🇸 United States - Remote
🗣️ EN
Job
Software Engineer, Data Infrastructure & Acquisition - West Palm Beach, FL, USA
Speechify
💰 Salary: not specified
🏢 On-site
🇺🇸 West Palm Beach
🗣️ EN
Job
Software Engineer, Data Infrastructure & Acquisition - St. Louis, MO, USA
Speechify
💰 Salary: not specified
🏢 On-site
🇺🇸 St. Louis
🗣️ EN
Job
Software Engineer, Data Infrastructure & Acquisition - Spokane, WA, USA
Speechify
💰 Salary: not specified
🏢 On-site
🇺🇸 Spokane
🗣️ EN
Job
Software Engineer, Data Infrastructure & Acquisition - Santa Cruz, CA, USA
Speechify
💰 Salary: not specified
🏢 On-site
🇺🇸 Santa Cruz
🗣️ EN