Business System Analyst

Overview

On Site
Contract - W2
Contract - Longterm

Skills

SQL
Datawarehouse
ETL
SSIS
DWH
data warehousing

Job Details

DWH Business Systems Analyst
Hybrid Job - 3 Days in Office in Philadelphia Downtown
Only W2


JD:
This BSA sits on the Data Warehousing team. Requires experience creating Business Requirement Documents and Mapping documents for the development of ETL applications. This role requires extensive SQL experience in writing complex queries across multiple tables, data analysis and profiling skills for the creation of the mapping documents, and further discussion with data modelers for the necessary table designs.

Top Skills Details
  • Extensive SQL experience in writing complex queries across multiple tables from scratch.
  • Source to target mapping within a Data Warehousing/ETL environment.
  • Data Profiling experience - Understanding the relationships of data sources and producing business requirements from that data.
  • Business analysis background, and ability to use SQL as far as writing queries.
  • For analysis background- they deal with text files and making that data and landing it into the warehouse.
  • Working with data coming from multiple sources. When they bring the data in they have a standard model. They have to conform data from various sources into this one data model.
  • Additional Skills & Qualifications: Strong communication skills. Needs to have a strong understand of business requirements. Ability to write business samples/rules and transformation documents. Ability to take on more than one project at once. Good understanding and knowledge of the healthcare industry is preferred, but not required.

Environment:
  • Teradata & SQL Server Database
  • -Data Stage ETL w/ Homegrown SQL/ETL tools
  • -SSIS & Tableau for reporting.