Business Systems Analyst
📋 Role Overview & Responsibilities
Role: Business AnalystLocation: Hybrid Job - 3 Days in Office in Philadelphia DowntownClient: Insurance Company
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 DetailsExtensive 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
Frequently Asked Questions
How do I apply for the Business Systems Analyst position at SP Software Solutions? ▼
Click the “Apply for this Position” button on this page to submit your application directly to SP Software Solutions without recruitment intermediary fees.
Is this position eligible for remote work or visa sponsorship? ▼
This position is located in Philadelphia, PA with potential relocation and sponsorship assistance depending on candidate qualifications.
Are there any candidate fees on Hirely? ▼
No. Hirely is completely free for candidates. We never charge registration fees or placement fees.
Legitimate employers will never ask you to transfer funds, purchase equipment from unauthorized vendors, or pay application/visa fees. Hirely rigorously monitors listings, but always verify communication is from official corporate email domains.
Learn how to protect yourself against employment fraud →