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
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 more
Title : Business System Analyst.Explain the system architecture, experienced with APIs design, documentation and data analysis.
Explaining the system architecture at least at high level is a differen...Show more
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 more
Inter-Plan Business Systems Analyst.Philadelphia, PA (Hybrid – 3 days / week from office).Claims Operations is hiring a Sr.
Inter-Plan Business Systems Analyst to join our Shared Services BlueCard and...Show more
If you are a current Jazz employee please apply via the Internal Career site.Jazz Pharmaceuticals is a global biopharma company whose purpose is to innovate to transform the lives of patients and ...Show more
Earn at least $2310 driving with Uber when you complete your first 192 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...Show more Earn at least $2310 driving with Uber when you complete your first 192 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...Show more 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 more 
Since 1952, Kiely Family of Companies has been building lasting relationships and delivering innovative design-build solutions that put our customers’ success first.Recognized on the ENR 400,...Show more
Time Away and Life Solutions Senior Consultant.Are you interested in a dynamic position that provides consultative support for Life and Disability Benefits to the Professional Employer Organization...Show more 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 more 
Earn big and work on your own time and terms as a Grubhub delivery partner! Grubhub is looking for drivers and bikers like you to hit the road quick and start delivering from restaurants, liquor st...Show more
VP, Business Solutions Manager.Old Republic Specialty Insurance Underwriters (ORSIU).Yardley, PA / Hybrid, 3 days in-office or Remote.
Old Republic is a leading specialty insurer that operates diverse...Show more
Senior Business Analyst – Oracle FLEXCUBE (Corporate Banking).EST Hours) | Contract | $100 / hour.This role will support major financial technology initiatives focused on Trade Finance, Treasury, and...Show more
For over 16 years, Trilyon, Inc.Cloud Technology, AI / ML, Software Development, Technical Writing, and Digital Transformation.
We partner with top companies to deliver high-quality talent in...Show more Earn at least $2310 driving with Uber when you complete your first 192 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...Show more 
Quality / Compliance Professional will effectively help leadership team by refining, streamlining, and organizing executive-level programs and initiatives.
Leveraging management and administrative ski...Show more Earn at least $2310 driving with Uber when you complete your first 192 trips in 30 days.Driving is an easy way to boost your income while maintaining the flexibility your schedule requires (gig, pa...Show more
Business Systems Analyst
Techstra Solutions • Philadelphia, PA, US
Full-time
Quick Apply
Last updated: 30+ days ago
Business System Analyst
TWO95 International • Trenton, NJ, United States
Temporary
Last updated: 30+ days ago • Promoted
Hybrid Hiring : Business Systems Analyst || Princeton Pike or Summit, NJ
Sunrise Systems • Princeton, New Jersey, United States
Temporary
Quick Apply
Last updated: 30+ days ago
Sr. Inter-Plan Business Systems Analyst
iSoftTek Solutions Inc • Philadelphia, PA, US
Full-time
Quick Apply
Last updated: 30+ days ago
Business & Technology Capabilities Sr. Analyst
Jazz Pharmaceuticals • Philadelphia, PA, United States
Full-time
Last updated: 30+ days ago • Promoted
Earn At Least $2310 For Your First 192 Trips, Guaranteed.
Uber • Newtown, PA, US
Full-time +1
Last updated: 17 days ago • Promoted
Side gig : Earn at least $2310 in your first 192 trips driving, guaranteed.
Uber • Marcus Hook, PA, US
Full-time +1
Last updated: 17 days ago • Promoted
Business Analyst - Enterprise
Sunrise Systems • Trenton, New Jersey, United States
Full-time
Quick Apply
Last updated: 30+ days ago
Project Engineer
The Kiely Family of Companies • Hammonton, NJ, US
Full-time
Last updated: 30+ days ago • Promoted
Time Away & Life Solutions - Senior Consultant
Aon • Hammonton, NJ, United States
Full-time +1
Last updated: 30+ days ago • Promoted
DOE Sr. Business Analyst
Sunrise Systems • Trenton, New Jersey, United States
Full-time
Quick Apply
Last updated: 30+ days ago
Grubhub Driver - Wilmington, DE - Fast Cash, Flexible Work!
Grubhub • Claymont, DE, United States
Full-time
Last updated: 30+ days ago • Promoted
Business Systems Analyst
Old Republic Specialty Insurance Group • Yardley, PA, US
Full-time
Last updated: 30+ days ago • Promoted
Senior Business Analyst – Oracle FLEXCUBE (Remote)
Together We Talent • Ewing, NJ, us
Remote
Full-time
Quick Apply
Last updated: 16 days ago
Business Analyst
Trilyon, Inc. • Ewing, NJ, United States
Full-time
Quick Apply
Last updated: 8 days ago
Drive with Uber - Earn at least $2310 in your first 192 trips with Uber.
Uber • Lansdale, PA, US
Full-time +1
Last updated: 17 days ago • Promoted
Analyst 2 - Business Solutions
eTeam Inc • Horsham, Pennsylvania, United States
Full-time
Quick Apply
Last updated: 30+ days ago
Drive With Uber : Earn At Least $2310 For Your First 192 Trips, Guaranteed.
Uber • Richboro, PA, US
Full-time +1
Last updated: 17 days ago • Promoted