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)

System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.