Business Analyst - Philadelphia, United States - SP Software Solutions

SP Software Solutions Philadelphia, United States

2 weeks ago

Description

DWH Business Systems Analyst

Hybrid Job - 3 Days in Office in Philadelphia Downtown

Open for W2, 1099

Please ensure you read the below overview and requirements for this employment opportunity completely.

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 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 healthcare industry is preferred, but not required.

Environment:

Teradata & SQL Server Database

-Data Stage ETL w/ Homegrown SQL/ETL tools

-SSIS & Tableau for reporting

Business Analyst

3 weeks ago

City of Philadelphia Philadelphia, United States

**Company Description** · A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. ...
Business Analyst

3 weeks ago

Medtrics Lab Philadelphia, United States

Medtrics Lab is a healthcare education SaaS company dedicated to improving the operational efficiency of healthcare organizations. We are on a mission to create an engaged healthcare workforce that saves lives. Our platform empowers healthcare providers and administrators with to ...
Business Analyst

1 week ago

US Defense Logistics Agency Philadelphia, United States

**Duties**: · - If selected at the GS-09 level, duties will be performed in a developmental capacity. · - Responsible for budget formulation, execution, allocation, and monitoring the use of resources to support the goals and objectives of the Strategic and Business Plans of the ...
Business Analyst

2 weeks ago

City of Philadelphia Philadelphia, United States

**Company Description** · A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. ...
Business Analyst

2 weeks ago

Elegant Enterprise Wide Solutions, Inc Philadelphia, United States

**Skills/experience of the assigned staff**: · - Adhere to all required activities needed in each phase of the project including Discovery, Requirements, Design, Development, Deployment and Operations. · - Understand and follow steps of various SDLC methodologies. · - Meet deadli ...
Business Analyst

1 day ago

Independence Blue Cross Philadelphia, United States

Our organization is looking for dynamic individuals who love to learn, thrive on innovation, and are open to exploring new ways to achieve our goals. If this describes you, we want to speak with you. You can help us achieve our vision to lead nationally in innovating equitable wh ...
Business Analyst

2 weeks ago

Tri-Force Consulting Services, Inc. Philadelphia, United States

Title: Business Analyst · Duration: 07 Months · Client: City of Philadelphia · Location: Philadelphia, PA · Note: This position is onsite and the candidate must be available for onsite interview. · "The applicant is the center of our universe." · Job Description:The person in th ...
Business Analyst

2 weeks ago

Tri-Force Consulting Services, Inc. Philadelphia, United States

Title: Business Analyst · Duration: 07 Months · Client: City of Philadelphia · Location: Philadelphia, PA · Note: This position is onsite. · "The applicant is the center of our universe." · Job Description:The person in this position will work closely with the CIO for the Office ...
Business Analyst

2 days ago

City of Philadelphia Philadelphia, United States

**Company Description** · A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. ...
New Business Analyst

3 weeks ago

Morgan Lewis Philadelphia, United States

Morgan, Lewis & Bockius LLP, one of the world's leading global law firms with offices in strategic hubs of commerce, law, and government across North America, Asia, Europe, and the Middle East, is seeking to hire a New Business Analyst in the Client/Matter Administration Departme ...
Business Operations Analyst

1 week ago

Morgan Lewis Philadelphia, United States

Morgan, Lewis & Bockius LLP, one of the world's leading global law firms with offices in strategic hubs of commerce, law, and government across North America, Asia, Europe, and the Middle East, is seeking to hire a Business Operations Analyst to support the daily business operati ...
Business System Analyst

2 weeks ago

Everest Global Solutions Inc Philadelphia, United States

**Benefits**: · - Employee Recognition and Rewards · - Bonus based on performance · - Opportunity for advancement · **Role: Business System Analyst** · **Required Exp: 12 Years** · **Location: Philadelphia, PA / hybrid** · **Duration: 12 months** · **Contract: C2C** · - Healthcar ...
Servicenow Business Analyst

3 weeks ago

RM Dream Homes Pvt. Ltd. Philadelphia, United States

**Job Title: Service Now Business Analyst** · **Location: Philadelphia, PA** · **Duration: Full-Time** · **Technical/Functional Skills** · Service Now - ITSM(Incident, Problem & Change Mgmt),CMDB module · **Experience Required** · 8 + years · **Roles & Responsibilities** · Active ...
Business Data Analyst

3 weeks ago

Panacea Direct, Inc Philadelphia, United States

**Required**: · - **SQL + DWH + Healthcare + BA + DA knowledge are must.** · - Strong logical & analytical SQL query writing skill. · - Deep understanding in Healthcare Insurance domain. · - Understanding in designing & building Data warehousing rule engine. · - Knowledge in prep ...
Business Process Analyst

2 weeks ago

City of Philadelphia Philadelphia, United States

**Company Description** · A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. ...
Technical Business Analyst

3 weeks ago

RIT Solutions Inc Philadelphia, United States

**Role: Warehouse Management consultant** · **Location: 1901 Market St Philadelphia, PA days in office)** · **Type: W2 contract** · **Skills and qualifications**: · - Work experience supporting and configuring Oracle Revenue Management and Billing (ORMB) or similar billing system ...
Business Continuity Analyst

3 days ago

Children's Hospital of Philadelphia Philadelphia, United States

SHIFT: · Day (United States of America) · **Seeking Breakthrough Makers** · Children's Hospital of Philadelphia (CHOP) offers countless ways to change lives. Our diverse community of more than 20,000 Breakthrough Makers will inspire you to pursue passions, develop expertise, and ...
Business Intelligence Analyst

1 week ago

Cisco Systems Philadelphia, United States

**What You'll Do** · **Who You'll Work With** · This role requires engagement with various roles, from Engineers, Product Managers, Project Managers, peer business analysts, and Operations Managers. You'll also work in close partnership with an Agile development team to analyze p ...
Jr. Business Analyst

3 days ago

TechPoint LLC Philadelphia, United States

**Eligibility · - Authorized to work in US** · **Education/Certification - Qualifications**: · - Great communication skills, ability to collaborate with developers and Product Management · - Bachelor's / Master's Degree from an accredited college or university with a concentratio ...
Urbn: Business Systems Analyst

2 weeks ago

URBN Philadelphia, United States

Urban Outfitters, Inc. ("URBN"), is a leading lifestyle products and services company which operates a portfolio of global consumer brands comprised of Anthropologie, BHLDN, Free People, Terrain, Urban Outfitters and Nuuly brands and the Food and Beverage division. Urban Outfitte ...