Business Systems Analyst (SQL) (Hybrid)
Business Systems Analyst (SQL) (Hybrid)
Posted on :
04-10-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
04-10-2025
Job Description
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:
This 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.
Responsibilities:
Skill/Experience/Education
Mandatory:
Desired:
Highly Preferred:
Preferred Additional Experience:
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:
This 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.
Responsibilities:
- 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.
Skill/Experience/Education
Mandatory:
- 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.
- Expert SQL analysis and SQL development skills.
Preferred Additional Experience:
- Source-to-Target mapping
- Comfortable supporting testing production readiness verification and ensuring accuracy after deployments (including weekend and off-hours support)
Required Experience:
Senior IC
Employment Type
Contract
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
