Business System Analyst (SQL/DW)

Open Systems Technologies
Philadelphia, PA, US
$65-$75 an hour
Full-time

Our client is looking for a Business System Analyst to join their team in Philadelphia, PA.

Pay : $65-75 / hr

The Business System Analyst role on the Data Warehouse team requires experience in creating Business Requirement Documents, Functional 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.

The ideal candidate should have all of the above skills at expert level along with strong verbal and written communication skills to work with various stakeholders, gather and formulate business requirements and translate the same to the technical team.

Other preferred experience includes Source-to-Target mapping, health insurance knowledge and general data warehousing. The candidate will also be comfortable enough to support testing, production readiness verification and ensuring accuracy after the deployments.

This might include weekend and off hours support (Candidates should be local to the office).

Mandatory Skills :

1. Strong Data Profiling and Analysis skills

2. Strong SQL knowledge

3. Strong Data Mapping and Functional requirements documentation skills

4. Strong verbal, writing and active listening skills

Desired Skills :

1. Data warehousing knowledge

2. Healthcare experience

24- #LI-JB1

24 days ago
Related jobs
Promoted
SP Software Solutions
Philadelphia, Pennsylvania

Business analysis background, and ability to use SQL as far as writing queries. Mandatory Skills: Data warehouse Background, SQL, SSIS & Tableau for reporting. Requires experience creating Business Requirement Documents and Mapping documents for the development of ETL applications. This role require...

Promoted
Dale WorkForce Solutions
Philadelphia, Pennsylvania

Understands the value of process-centric approach to business analysis Tackles complex business/systems problems and conveys this information to stakeholders (includes technical teams for translation into solution design). Formulates and defines scope (requirements) and objective based on user needs...

FirstPRO
Bala Cynwyd, Pennsylvania

Hiring for a Business Analyst specializing in A&F Systems. This position will upgrade and enhance existing platforms, and has the freedom to customize or build solutions to impact the usability of the business systems. Provide ad-hoc analysis, systemic support and development/implementation of new f...

Two95 International
Philadelphia, Pennsylvania

Title: Business Systems Analyst. Collaborate with various teams to gather and analyze business requirements for data migration. Take initiative and work with key stakeholders while continuously improving new Knowledge Management system. Provide training and support to business users on how to use ma...

Community College of Philadelphia
Philadelphia, Pennsylvania

Under the guidance of the Associate Vice President of Enrollment Management, the Enrollment Business Systems Analyst has overall responsibility for working with units within and outside the Division of Enrollment Management to identify, review, prioritize, develop and implement effective business pr...

Beacon Hill Staffing Group
Philadelphia, Pennsylvania

Advanced knowledge of SQL, with ability to write complex SQL queries across multiple tables. Create documentation for Business, Functional and Mapping requirement documents for ETL application development. Create mapping documentation using SQL, data analysis and profiling skills. Advanced documenta...

Sunrise Systems
Wayne, Pennsylvania

Job Title: Business Systems Analyst III. Responsible for business analysis activities in accordance with Cencroa's systems development methodology and supporting projects within a specific portfolio area (sales and marketing, supply chain, finance, etc. Works in close collaboration with business par...

IQVIA
Wayne, Pennsylvania
Remote

To effectively navigate this increased scope the Finance and Procurement Group within the Enterprise Technology Services (ETS) team is looking to replace a Senior Business Systems Analyst with a focus on PeopleSoft Financial applications; General Ledger (GL), Order to Cash (OTC) and Record to Report...

Highmark Health
PA, Working at Home, Pennsylvania

Uses regular judgement and discretion to collaborate with customers in order to: Understand capability needs; Gather project specifications; Create business cases and cost sheet analysis; Translate high-level business needs into detailed requirements for new capabilities (and change request/enhancem...

Ohm Systems
Philadelphia, Pennsylvania

Position Info:</b></p> <ul> <li>Title: Business Analyst</li> <li>Client: Office of Innovation and Technology</li> <li>Duration: 5 Months</li> <li>Location: 1234 Market Street, 18th Fl, Philadelphia, PA 19107</li> </ul> <p>...