Impact Consulting Solutions inc is hiring: Data Analyst in Pittsburgh

Responsibilities

Data Analysts:

·         Gather requirements and analysis for new development, enhancements, and defects

·         Data Validation and QA

·         Transformation Documents

·         Test Case Creation

Data Engineer:

• Translating technical requirements to solutions using code

·         New development of ETL/ELT from any system to any other system

·         Unit testing

Data Engineer - Lead:

• Lead a team on the research and implementation of a larger project, which may consist of multiple data models, maps, and workflows.
• Be the contact for the team and participate in prioritization and execution of work.
• Serve as SME, understand the data, its usage and meaning.
• Deliver robust end-to-end integration solutions that follow Data Engineering best practices and leverage test driven development. 
• Translating technical requirements to solutions using code

·         New development of ETL/ELT from any system to any other system

·         Unit testing

·         Data Modeling

Skillsets

Data Analyst - Senior

• Data Warehousing experience
  • Source to target transformation documents
  • ETL/ELT analysis
  • Understanding of types of data stores/data warehouse components
• SDLC experience - Agile Software Development
• Expert communication
• Advanced SQL skills - mandatory
  • DDL vs DML
  • Understanding of data normalization
  • Multiple table joins
  • Subqueries and nested SQL statements
• Analyzing business needs and decomposing them into tasks based on User Story Acceptance Criteria
• Test Case creation
  • Writing manual test cases that trace requirements to implementation
• Self Starter