Business Systems Analyst with ETL Expertise

6 days ago


Philadelphia, Pennsylvania, United States Lorven Technologies Full time

Job Title: Business Systems Analyst with ETL Expertise

Job Summary:

Lorven Technologies is seeking a highly skilled Business Systems Analyst with expertise in ETL (Extract, Transform, Load) to join our team. As a key member of our Data Warehouse team, you will be responsible for creating Business Requirement Documents, Functional Requirement Documents, and Mapping documents for the development of ETL applications.

Key Responsibilities:

  • Requirements gathering and analysis, data analysis and interpretation.
  • Business process modeling, data modeling and database design, documentation and report writing.
  • Microsoft Office Suite, SQL, Visio, Power BI, Python, JIRA, Sharepoint.

Secondary Skills:

  • SSiS, SSRS, Tableau.
  • Data Warehouse team requires experience in creating Business Requirement Documents, Functional Requirement Documents and Mapping documents for the development of ETL applications.
  • 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.
  • Strong verbal and written communication skills to work with various stakeholders, gather and formulate business requirements and translate the same to the technical team.
  • Candidate with prior healthcare and data warehousing experience are preferred.
  • Support testing and production releases, including weekend and off hours support.

About Us:

Lorven Technologies is a leading provider of technology solutions. We are committed to delivering high-quality services and solutions to our clients. Our team is passionate about innovation and excellence, and we are seeking like-minded individuals to join us.



  • Philadelphia, Pennsylvania, United States Lorven Technologies Full time

    Job Title: Business Systems Analyst with ETLJob Summary:We are seeking a highly skilled Business Systems Analyst with expertise in ETL (Extract, Transform, Load) to join our team at Lorven Technologies. As a Business Systems Analyst, you will be responsible for gathering and analyzing business requirements, designing and implementing data models, and...


  • Philadelphia, Pennsylvania, United States Open Systems Technologies Full time

    Job Opportunity for Business Systems Analyst at Open Systems TechnologiesAbout the Role:The Data Warehouse team at Open Systems Technologies is seeking a highly skilled Business Systems Analyst with expertise in data warehousing and SQL. As a Business Systems Analyst, you will play a crucial role in creating Business Requirement Documents, Functional...


  • Philadelphia, Pennsylvania, United States Open Systems Technologies Full time

    Business Systems Analyst - Data Warehouse ExpertWe are seeking a highly skilled Business Systems Analyst with expertise in Data Warehouse to join our team at Open Systems Technologies.The ideal candidate will have extensive experience in creating Business Requirement Documents, Functional Requirement Documents, and Mapping documents for the development of...


  • Philadelphia, Pennsylvania, United States Twenty Bridge Staffing Full time

    Job Description**Job Title:** Business System Analyst**Job Summary:** We are seeking a highly skilled Business System Analyst to join our team at Twenty Bridge Staffing. The ideal candidate will have extensive experience in creating Business Requirement Documents, Functional Requirement Documents, and Mapping documents for the development of ETL...


  • Philadelphia, Pennsylvania, United States IntePros Full time

    **Job Summary**IntePros is seeking a highly skilled Business Systems Analyst to join our team. This role is crucial to ensuring the effective delivery of data warehouse solutions, where you will serve as the bridge between business needs and technical implementation.**Key Responsibilities:****Requirements Gathering & Analysis**: Work closely with business...


  • Philadelphia, Pennsylvania, United States A2C Full time

    Position Overview:We are seeking a skilled Senior Business Analyst to join our team at A2C. This role is a contract-to-hire opportunity that involves collaboration in a dynamic environment.Key Responsibilities:Engage with various stakeholders, including executive-level audiences, to ensure effective communication and understanding of project goals.Utilize...


  • Philadelphia, Pennsylvania, United States Partner's Consulting Inc Full time

    Business Systems Analyst - EIM Data Warehouse Specialist **Job Summary** Partner's Consulting Inc is seeking a skilled Business Systems Analyst - EIM Data Warehouse Specialist to create Business Requirement Documents, Functional Requirement Documents, and Mapping documents for the development of ETL applications. The ideal candidate will have extensive SQL...


  • Philadelphia, Pennsylvania, United States AmeriHealth Caritas Family of Companies Full time

    Job SummaryWe are seeking a highly skilled Business Systems Analyst Lead with expertise in ERP systems to join our team at AmeriHealth Caritas Family of Companies.Key ResponsibilitiesProvide ongoing support for assigned systems and technologies, including data mapping, configuration, and queries.Serve as a Subject Matter Expert (SME) for Oracle-PeopleSoft,...


  • Philadelphia, Pennsylvania, United States Della Infotech Full time

    About the RoleWe are seeking a highly skilled Business Analyst to join our team at Della Infotech. As a Business Analyst, you will play a critical role in driving business requirements and ensuring that our software solutions meet the needs of our clients.Key ResponsibilitiesAct as a liaison between executive sponsors and project teams to drive requirement...


  • Philadelphia, Pennsylvania, United States IntePros Full time

    Job Overview:IntePros is looking for a dedicated and detail-oriented Billing Systems Support Analyst to enhance our team. In this pivotal role, you will work closely with various stakeholders to ensure the effective functioning of our billing systems. The ideal candidate will possess experience in ETL processes and analytical tools to bolster our billing...


  • Philadelphia, Pennsylvania, United States A2C Full time

    Position Overview:We are seeking a Senior Business Systems Analyst to join our team at A2C. This role is a contract-to-hire opportunity that requires a strong presence in the office.Key Responsibilities:Support and enhance billing systems to ensure efficiency and accuracy.Analyze complex issues by diving deep into details to identify root causes.Prioritize...


  • Philadelphia, Pennsylvania, United States AmeriHealth Administrators Full time

    About AmeriHealth CaritasAmeriHealth Caritas is a mission-driven organization with over 30 years of experience delivering comprehensive, outcomes-driven care to those who need it most. We offer integrated managed care products, pharmaceutical benefit management, and specialty pharmacy services, behavioral health services, and other administrative...


  • Philadelphia, Pennsylvania, United States IntePros Full time

    Business Systems Analyst OpportunityWe are seeking a seasoned Business Systems Analyst to join our team at IntePros. As a key member of our Healthcare client's project team, you will work closely with executive stakeholders to lead critical projects using your expertise in Waterfall methodology.Key Responsibilities:Develop and execute project plans using...

  • Oracle ETL Developer

    5 hours ago


    Philadelphia, Pennsylvania, United States Graphite GTC Full time

    Job Title: Oracle ETL DeveloperAt Graphite GTC, we are seeking a highly skilled Oracle ETL Developer to join our team of innovative professionals. As a key member of our analytics and business intelligence team, you will be responsible for designing, developing, and managing ETL processes and models in Oracle environments.Key Responsibilities:Design and...


  • Philadelphia, Pennsylvania, United States The Dignify Solutions LLC Full time

    The Dignify Solutions LLC is seeking a seasoned Business Analyst with expertise in P&C Insurance to join our team. The ideal candidate will have a strong background in business analysis, requirement analysis, and documentation of functional requirements. A minimum of 2+ years' experience in the P & C insurance domain is required. The successful candidate...


  • Philadelphia, Pennsylvania, United States Goddard Systems, Inc. Full time

    About the RoleWe are seeking a highly skilled Senior Business Systems Analyst to join our corporate team at Goddard Systems, LLC (GSL). As a key member of our team, you will play a critical role in providing strategic business analysis services to our business partners.Key ResponsibilitiesReview and analyze business processes to identify operational,...


  • Philadelphia, Pennsylvania, United States CyberTec Full time

    CyberTec is seeking a skilled Business Analyst to join our team. As a Business Analyst, you will play a critical role in bridging the gap between business and technology. Your expertise in insurance industry knowledge, SQL, and data analysis will be essential in driving business growth and process improvement. You will work closely with stakeholders to...


  • Philadelphia, Pennsylvania, United States Partner's Consulting, Inc. Full time

    ONSITE REQUIREMENT: 3 Days a week. LOCAL CANDIDATES OR THOSE WITH COMMUTABLE DISTANCE ONLY. MUST BE ON OUR W2. NO SPONSORSHIP AVAILABLE.ESSENTIAL SKILLS:ETL, BUSINESS ANALYSIS, HEALTHCARE EXPERIENCE PREFERRED.Partner's Consulting, Inc. is looking for a highly skilled Technical Business Analyst III who is confident and capable of engaging with executive-level...


  • Philadelphia, Pennsylvania, United States Partner's Consulting, Inc. Full time

    ONSITE REQUIREMENT: 3 Days a week. LOCAL CANDIDATES ONLY OR THOSE WITH COMMUTABLE DISTANCE. MUST BE ON OUR W2. NO SPONSORSHIP AVAILABLE.ESSENTIAL SKILLS:ETL, BUSINESS ANALYSIS, HEALTHCARE EXPERIENCE PREFERRED.Partner's Consulting, Inc. is in search of a Technical Business Analyst III who possesses strong confidence and is adept at engaging with...


  • Philadelphia, Pennsylvania, United States Beacon Hill Full time

    Job Title: Technical Business AnalystWe are seeking a detail-oriented Technical Business Analyst with a strong background in Agile methodologies, SQL query writing, and data migration. This role involves working closely with stakeholders to understand business needs, analyze technical requirements, and support data migration projects.Key...