You haven't searched anything yet.
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 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
Full Time
$88k-107k (estimate)
04/27/2024
05/14/2024
The following is the career advancement route for Business System Analyst positions, which can be used as a reference in future career path planning. As a Business System Analyst, it can be promoted into senior positions as a Business Systems Analyst IV that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Business System Analyst. You can explore the career advancement for a Business System Analyst below and select your interested title to get hiring information.
If you are interested in becoming a Business System Analyst, you need to understand the job requirements and the detailed related responsibilities. Of course, a good educational background and an applicable major will also help in job hunting. Below are some tips on how to become a Business System Analyst for your reference.
Step 1: Understand the job description and responsibilities of an Accountant.
Quotes from people on Business System Analyst job description and responsibilities
Also known as Systems Analysts, these highly-analytical specialists have both business and technical expertise.
03/29/2022: Bakersfield, CA
Solves organizational information problems and requirements by analyzing requirements; designing computer programs; recommending system controls and protocols.
04/09/2022: Washington, DC
Designs new computer programs by analyzing requirements; constructing workflow charts and diagrams; studying system capabilities; writing specifications.
03/12/2022: Florence, SC
Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats.
03/22/2022: Charleston, SC
Improves systems by studying current practices; designing modifications.
04/24/2022: Reno, NV
Step 2: Knowing the best tips for becoming an Accountant can help you explore the needs of the position and prepare for the job-related knowledge well ahead of time.
Career tips from people on Business System Analyst jobs
Ability to Understand Delegated Objectives.
02/21/2022: Jacksonville, FL
Being able to Run Meetings with Stakeholders.
03/18/2022: Omaha, NE
Being Diligent with Time Management.
03/24/2022: Chattanooga, TN
Documenting and Writing Reports.
04/01/2022: Raleigh, NC
Understand the key things a Business Analyst does.
03/07/2022: Rock Island, IL
Step 3: View the best colleges and universities for Business System Analyst.