Business Systems Analyst (SQL) (Hybrid)Serigor Inc. • Philadelphia, PA, US
Business Systems Analyst (SQL) (Hybrid)
Serigor Inc. • Philadelphia, PA, US
30+ days ago
Job type
- Full-time
- Quick Apply
Job descriptionThis position is ideal for a SQL Business Systems Analyst with strong SQL skills and a deep understanding of data warehousing concepts. The SQL Business Systems Analyst role on the Enterprise Integration Management (EIM) – 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 mapping documents, and further discussion with data modelers for the necessary table designs. The ideal candidate should have all of the above skills at an 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 supporting testing, production readiness verification, and ensuring accuracy after deployments. This might include weekend and off-hours support. Candidates should be local to the office or willing to relocate to Philadelphia or the surrounding area prior to starting. Work with external vendors and internal business stakeholders in a variety of interactions including but not limited to issue resolution, requirements gathering, and ensuring efficient communication workflows. Regularly create Business Requirement Documents (BRD), Functional Requirement Documents, User Test Documents, and training / reference documentation. Confidently work with users and stakeholders to conduct interviews and gather thorough requirements. Recurrently execute the following SQL functions at an expert level including SQL joins, writing complex SQL queries, and SQL clauses including WHERE and GROUP BY. Create SQL rankings and partitions. Perform SQL data filtering and data aggregation. Use SQL to retrieve, manipulate, or analyze data from databases. Frequently perform data profiling activities including column analysis, data quality assessments, relationship discovery, and data distribution analysis to gain insights into the data in order to make informed decisions about how to manage, clean, transform, and use the data effectively. Execute data gap analysis to identify disparities or discrepancies in data quality, completeness, consistency, or relevance between the current state of data and the desired state. Collaborate on activities associated with User Acceptance Testing (UAT) and Data Validation. Perform data management functions including Change Data Capture (CDC) to capture and track changes made to data in a database or data warehouse. Execute standard Data Quality activities including data deduplication and Data Referential Integrity. Strong Data Profiling and Analysis skills Strong SQL knowledge Strong Data Mapping and Functional Requirements Documentation skills Strong verbal, writing, and active listening skills Desired : Data warehousing knowledge Healthcare experience Highly Preferred : Knowledge of Healthcare Claims, Client Setup, and Premium Billing Deep understanding of Business Analysis concepts and successful application of standard methodologies. Source-to-Target mapping Comfortable supporting testing, production readiness verification, and ensuring accuracy after deployments (including weekend and off-hours support) Powered by JazzHR
Job Title :
- Business Systems Analyst (SQL) (Hybrid) Location : Philadelphia, PA Duration : 12 Months Overview : This is a BSA position - onsite 3x / week required.
- Candidate must be in the tri-state area (PA, NJ, DE) prior to assignment start.
- The Business System Analyst role on the EIM - 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.
Job Summary :
Responsibilities :
Skill / Experience / Education Mandatory :
Expert SQL analysis and SQL development skills. Preferred Additional Experience :
Create a job alert for this search
System Analyst • Philadelphia, PA, US
Related jobs
Title : Business Systems Analyst.Location : Philadelphia, PA / Hybrid (3 days per week onsite) .Collaborate with various teams to gather and analyze business requirements for data migration.Ensure...Show more
At least 3 years with Data Warehouse, 5 years with SQL and 8 years on a BSA / Technical role.Solid Healthcare Domain Knowledge.
BSA Experience in Data Warehouse projects (Preferably in Sourcing or O...Show more
Role name : Business Systems Analyst with Automotive or connected vehicles telematics.Work Location : Camden, NJ US (Onsite).
Developing user stories form business requirements and working with the cl...Show more
The main function of a business systems analyst is to analyze science, engineering, business and all other data processing problems for application to electronic data processing systems.A typical b...Show more
Required Skills & Qualifications.Proven technology application solution analysis for business requirements with a minimum of 8 years of experience.
Vizio flowcharting and system process data flow di...Show more
We're looking for a Business Systems Analyst to join our North America Accident & Health (A&H) division primarily supporting the Leisure Travel Business.
In this role, you'll play a critical part in...Show more
Business Systems Analyst (SQL) (Hybrid).This is a BSA position - onsite 3x / week required.Candidate must be in the tri-state area (PA, NJ, DE) prior to assignment start.
The Business System Analyst r...Show more
We are seeking a Senior Business Systems Analyst to join our team.The ideal candidate will have 7+ years of experience in business systems analysis, strong knowledge of the Software Development Lif...Show more
Title : Business System Analyst.BSA experience in data analytics / data warehouse / data integration through agile environment with AML background and experience.
Strong communication, interpersonal, col...Show more
NewLane Finance is a commercial equipment finance company, serving small and mid-size businesses nationwide.Our mantra is "business lending done right", and our strategy is to revolutionize small b...Show more
Mount Laurel, NJ; Detroit, Michigan; New York, NY ( 4 days office).Collaborate with Product Owner, business stakeholders, and technology teams to gather, analyze, and document business and system r...Show more
Location : Philadelphia, PA (Hybrid).Candidate with prior healthcare and data warehousing experience are preferred.Documentation and report writing.
SQL experience in writing complex queries across m...Show more
The Senior Business Systems Analyst (BSA) will be responsible for supporting data warehouse initiatives with a strong focus on healthcare domain projects.
The ideal candidate will have extensive exp...Show more
THIS ROLE IS HYBRID IN MOUNT LAUREL, NJ •.Hybrid in Mount Laurel NJ (2 days a week in office is mandatory).Should be good in data mapping,.
SQL queries to do data analysis,.ETL tool how to track line...Show more
We are looking for a senior Business Systems Analyst Specialist (BSA) to join our client's Wholesale Liquidity Technology team.
The ideal candidate has a solid understanding of Liquidity reporting r...Show more
Philadelphia, PA (Onsite / Hybrid).We are seeking a highly skilled Business Systems Analyst (BSA) with proven experience in the health insurance domain and strong technical proficiency across BigQu...Show more
Location : Philadelphia, PA 19103 (Hybrid).Duration : 06 Months (C2H Role).The Business System Analyst role on the EIM - Data Warehouse team requires experience in creating Business Requirement Docum...Show more
Location : MOUNT LAUREL, NJ (Only Local).Role Description : BSA 8yrs - emphasis on technology application solution analysis for business requirements not just business requirements2.Vizio flowchartin...Show more
Business System Analyst
TWO95 International • Philadelphia, PA, United States
Full-time
Last updated: 30+ days ago • Promoted
Business System Analyst
HCL Global Systems • Philadelphia, PA, United States
Full-time
Last updated: 13 days ago • Promoted
Business Systems Analyst
United Software Group • Camden, NJ, United States
Full-time
Last updated: 14 days ago • Promoted
Business Systems Analyst
Techstra Solutions • Philadelphia, PA, United States
Full-time
Last updated: 17 days ago • Promoted
Business Systems Analyst
Artech • Mt Laurel, NJ, United States
Full-time
Last updated: 13 days ago • Promoted
Business System Analyst (Partnerships & Implementation)
Chubb • Philadelphia, PA, United States
Full-time
Last updated: 13 days ago • Promoted
Business Systems Analyst (SQL) (Hybrid)
Serigor Inc • Philadelphia, PA, United States
Full-time
Last updated: 17 days ago • Promoted
Business Systems Analyst
Connexus Technology,LLC • Philadelphia, PA, United States
Full-time
Last updated: 30+ days ago • Promoted
Business System Analyst
Diverse Lynx • Mt Laurel, NJ, United States
Full-time
Last updated: 17 days ago • Promoted
Sales Enablement Business Systems Analyst
WSFS Bank • Philadelphia, PA, United States
Full-time
Last updated: 17 days ago • Promoted
Business Systems Analyst
Apolis • Mt Laurel, NJ, United States
Full-time
Last updated: 17 days ago • Promoted
Business Systems Analyst-Philadelphia, PA (Hybrid)
Georgia IT Inc • Philadelphia, PA, United States
Full-time
Last updated: 30+ days ago • Promoted
Senior (Business / Systems Analysts)
Cynet Systems • Philadelphia, PA, United States
Full-time
Last updated: 13 days ago • Promoted
Sr.Business System Analyst
Keylent Inc • Mt Laurel, NJ, United States
Full-time
Last updated: 30+ days ago • Promoted
Business Systems Analyst (BSA)
Omni Inclusive • Cherry Hill, NJ, United States
Full-time
Last updated: 30+ days ago • Promoted
Business System Analyst (Philadelphia)
IntePros • Philadelphia, PA, US
Part-time
Last updated: 2 days ago • Promoted
Business System Analyst
Apex Informatics • Philadelphia, PA, United States
Full-time
Last updated: 14 days ago • Promoted
Business System Analyst
Purple Drive • Mt Laurel, NJ, United States
Full-time
Last updated: 16 days ago • Promoted