Sr. Data Engineer Job at System One, Omaha, NE

b2NER09DVnY0SWt5anltazBuT25oSlJhREE9PQ==
  • System One
  • Omaha, NE

Job Description

Remote Sr. Data Engineer: 

Candidates must have a good amount of experience with: SQL, T-SQL, Data Warehousing, Azure Data Factory, data modeling, creating pipelines, mapping.

This work will consist of mapping data from source operational systems into the new enterprise data warehouse

Job Description/Objectives:
I. Data Extraction/Transformation Pipelines
- Landing Container (Data Flow/Pipeline)
- Conformance Container (Data Flow/Pipeline)
- Source to target map

II. Load Data to SQL Date Warehouse Staging Tables
- EDW Batch & BatchStep Metadata
- EDW External Table & Entity Table (Stage) Metadata
- EDW Initial Physical Creation (Production Tables)

III. Capture data from staging tables to destination production tables
- Stage to initial stored procedures
- EDW entity Table Metadata (initial)

IV. Create views to distribute the data in BI Tool
- EDW Operation Views Creation
- Add to Source Control (Repos)

Job Tags

Contract work,

Similar Jobs

1 Alpha Consulting

Human Resource/Recruitment Intern Job at 1 Alpha Consulting

 ...Only direct applicants will be considered. Staffing agencies and recruiter submissions will not be accepted. About 1 Alpha Consulting LLC: At 1 Alpha Consulting LLC, we deliver excellence across a broad range of consulting, staffing, and operation projects including... 

Seradata

Remote UX Researcher Job at Seradata

 ...collaborators. Were looking for a User Experience Researcher who shares our belief in user-centered...  ...What Youll Do Were looking for a UX Researcher who thrives in complex problem...  ...product outcomes. Depending on level and scope, UX Researchers may focus on:... 

National Automotive Training Academy

Express Lane Technician Matt Bowers Hyundai Gulfport Job at National Automotive Training Academy

Express Lane Technician Matt Bowers Hyundai Gulfport Join Our Winning Team Fast-Paced Growth Opportunity! Matt Bowers Hyundai in Gulfport, MS is looking for motivated Express Lane Technicians to join our expanding service team. If you're passionate about cars, thrive... 

Farm Credit Services of America

Insurance Officer - Business Development Job at Farm Credit Services of America

 ...resources, expertise, and talent to provide affordable credit, crop insurance, and financial services. Our associations are united by a...  ...Develop and maintain a working relationship with insurance company representatives to resolve policies issues, understand product... 

Vees Cafe

Cashier / Barista Job at Vees Cafe

 ...Vees Caf is looking for a reliable, dependable worker with exceptional customer service skills, seeking a position to work as a cashier. We want our staff members to deliver the same joy they're feeling not because they're at work, but because they feel at home....