Senior Data Engineer in Pittsburgh

Job DescriptionJob Description

Data Engineer Senior 

• Data Warehousing experience
• • Applying Kimball and Inmon techniques such as DDS (dimensional data stores), ODS, slowly changing dimensions, etc.
  • Data flow from source to target to dimension to BI tool
• Advanced SQL skills - mandatory
• • DDL vs DML
  • how to decompose data to 3NF,
  • how to model relational data
  • ACID transactions
  • Basic performance and security knowledge
  • CAP theorem
• Java Script - senior level
• Experience with non-relational/NoSQL data stores
• Translating technical requirements to solutions using code
• Snowflake exposure
• Intermediate experience and skills around Azure Cloud Technologies (Azure Data Factory)
• Source Control using Git/Git hub 
• Pipelines - creating branches and merges
• Data Modeling experience a plus
• • Data Modeling techniques
  • • Slowly changing dimensions
    • Star schemas
    • Data vault
• Comfortable in a scrum team environment - (4 analysts, 4 engineers)
• Self Starter

Company DescriptionImpact Consulting Solutions, Inc. is an Information Technology consulting and full time Placement Company located in the Pittsburgh area. Our clients range from small local businesses to Fortune 500 Corporations.

We work with a selected number of clients and service their entire business staffing requirements including:

consulting and project work
full-time placements
from Consultant level all the way to Director and Partner level.

Exciting opportunities currently exist for Information Systems professionals. If you are looking for career advancement, new technologies, and the money you deserve, we are the firm for you. We take pride in our ability to match the individual with the right job. Our promise is to provide you with the best financial and career opportunities availableCompany DescriptionImpact Consulting Solutions, Inc. is an Information Technology consulting and full time Placement Company located in the Pittsburgh area. Our clients range from small local businesses to Fortune 500 Corporations.\r\n\r\n\r\nWe work with a selected number of clients and service their entire business staffing requirements including:\r\n\r\nconsulting and project work\r\nfull-time placements\r\nfrom Consultant level all the way to Director and Partner level.\r\n\r\nExciting opportunities currently exist for Information Systems professionals. If you are looking for career advancement, new technologies, and the money you deserve, we are the firm for you. We take pride in our ability to match the individual with the right job. Our promise is to provide you with the best financial and career opportunities available