Business Systems Analyst (SQL) (Hybrid)
Serigor Inc.Philadelphia, PA, US3 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
Summary : 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 syst...Show moreLast updated: 23 days ago
We are seeking a motivated and detail-oriented.The ideal candidate will have a strong foundation in troubleshooting, system monitoring, and customer service.
Provide technical support to end users f...Show moreLast updated: 1 day ago
Superprof is the leading tutoring platform in the USA, connecting passionate individuals with eager learners.We operate in over 41 countries, making education accessible to everyone, everywhere.Sup...Show moreLast updated: 30+ days ago
Job Title : Business Systems Analyst.Duration : 12 Month Contract (Possible extension based on work performance).Location : Princeton Pike or Summit, NJ.
SAP analyst with some IT Background.Experience ...Show moreLast updated: 30+ days ago
BSA experience in data analytics / data warehouse / data integration through agile environment with AML background and experience.
Strong communication, interpersonal, collaboration, and negotiation ski...Show moreLast updated: 3 days ago
Be the exclusive Publisher for your neighborhood, enjoying complete autonomy and schedule flexibility.Be in business for yourself, but not by yourself!.
Sell print and digital ad products & solu...Show moreLast updated: 8 days ago
Business Systems Analyst (BSA) • •Hybrid (3 Days onsite) • •Philadelphia, PA • As a Business Systems Analyst (BSA), you will be the liaison between different teams such as developers, testers, pro...Show moreLast updated: 30+ days ago Business Analyst • •Philadelphia, PA • •Hybrid • •Contract-to-hire • We are seeking a Mid-level Business Systems Analyst to play a key role in the implementation of the Advanced Distribution Manage...Show moreLast updated: 30+ days ago 
Summary Pega Lead Business Architect will act as a liaison between the business users, stakeholders and technologists.This individual will be responsible to work with Lead System ...Show moreLast updated: 1 day ago
Join thousands of members already earning with top-paying surveys and offers.Get started today and enjoy competitive rewards, fast payouts with no waiting periods, and the flexibility to participat...Show moreLast updated: 6 hours ago Job Title : Business Analyst - Enterprise.Duration : 06 months of Contract.Very Seneior BA experienced withProject development work and / or function / business process analysis.Develop workflows, requir...Show moreLast updated: 30+ days ago 
Driving with Uber is an alternative to a part-time or full-time job and can get you earning cash on the road quickly.Driving with Uber allows you to earn quick cash while maintaining the flexibilit...Show moreLast updated: 30+ days ago Driving with Uber is an alternative to a part-time or full-time job and can get you earning cash on the road quickly.Driving with Uber allows you to earn quick cash while maintaining the flexibilit...Show moreLast updated: 30+ days ago 
Title : Business Systems Analyst.Location : Philadelphia, PA / Hybrid (3 days per week onsite) .Rate : $Open / hour .Collaborate with various teams to gather and a...Show moreLast updated: 30+ days ago Business Analyst Job ID : 24-04848 Location : Trenton, NJ (Hybrid) Duration : 12 months of Contract Demonstrated experience in the standard concepts, practices and deliverables related to Business Ana...Show moreLast updated: 30+ days ago 
L3Harris is dedicated to recruiting and developing high-performing talent who are passionate about what they do.Our employees are unified in a shared dedication to our customers’ mission and quest ...Show moreLast updated: 4 days ago
Summary Pega Lead Business Architect will act as a liaison between the business users, stakeholders and technologists.This individual will be responsible to work with Lead System ...Show moreLast updated: 1 day ago Driving with Uber is an alternative to a part-time or full-time job and can get you earning cash on the road quickly.Driving with Uber allows you to earn quick cash while maintaining the flexibilit...Show moreLast updated: 30+ days ago
Business Systems Analyst
Techstra SolutionsPhiladelphia, PA, USFull-time
Quick Apply
- Promoted
IT Junior System Administrator
MYCO Mechanical, Inc.Telford, PA, USFull-time
- Promoted
Physics Private Tutoring Jobs Levittown
SuperprofLevittown, PA, United StatesFull-time +1
Hybrid Hiring : Business Systems Analyst || Princeton Pike or Summit, NJ
Sunrise SystemsPrinceton, New Jersey, United StatesTemporary
Quick Apply
- Promoted
Business Analysis
Diverse LynxMt Laurel, NJ, United StatesFull-time
- Promoted
Sales Representative
BVMHammonton, NJ, USFull-time
- Promoted
Business Systems Analyst
BrooksourcePhiladelphia, Pennsylvania, USFull-time
- Promoted
Business Analyst
BrooksourcePhiladelphia, Pennsylvania, USFull-time +1
Business Analyst
Vinsys Information Technology IncTrenton, NJ, United StatesFull-time
Quick Apply
- Promoted
- New!
Fully Remote Survey Participant
Prime InsightsHammonton, NJ, United StatesRemote
Full-time
Business Analyst - Enterprise
Sunrise SystemsTrenton, New Jersey, United StatesFull-time
Quick Apply
- Promoted
Flexible Gig - Drive with Uber
UberTrainer, PA, United StatesFull-time +1
- Promoted
Alternatives To Cash Jobs - Drive with Uber
UberClaymont, PA, United StatesFull-time +1
Business System Analyst
Two95 International Inc.Philadelphia, PA, USFull-time
Quick Apply
DOE Sr. Business Analyst
Sunrise SystemsTrenton, New Jersey, United StatesFull-time
Quick Apply
- Promoted
Software Engineering
L3Harris TechnologiesMedford Lakes, NJ, United StatesFull-time
Business Analyst
Black Rock GroupsTrenton, NJ, United StatesFull-time
Quick Apply
- Promoted
Flexible Hours - Drive with Uber
UberMarcus Hook, PA, United StatesFull-time +1