Jobs
>
Philadelphia

    ETL Analyst - Philadelphia, United States - iO Associates - US

    Default job background
    Technology / Internet
    Description

    We are hiring an ETL Analyst who can expand our customer's capacity to ingest 3rd party or internal data and implement enhancements to the systems that the team owns. The role will also contribute to the creation and delivery of analytics to various functions of the organization.

    Applicants local to Philadelphia, who can work on a hybrid basis, will be preferred. We can also consider hybrid applicants in: Boston, NYC, D.C., or Hartford CT.

    Key responsibilities include:

    • Performs ETL (Extract, Transform, Load) tasks to prepare both internal and 3rd party data sources for both text and quantitative analysis using a combination of various Informatica modules and SQL Server or SSIS.
    • Develops financial and business analyses using Qlik, MS Excel, and/or other financial software.
    • Partners with business and technical teams on data integration projects to establish procedures and approaches for structured and unstructured data.
    • Directs the development of data management and advanced analytics using the firm's business intelligence tools for client engagements, practice management and other firm initiatives.
    • Effectively communicates complicated methods to fellow teammates to share knowledge and enhance the team's capabilities.
    • Creates and maintains documentation pertaining to the ETL processes, analysis, or system specifications as required by standards and policies.
    • Develops deliverables and solutions, leveraging both statistical analysis and qualitative data review, to disclose data trends, key findings and observations that aid in decision-making for client engagements and firm initiatives.
    • Maintains practice management business intelligence applications and dashboards; identifies new reporting and analytics needs and enhancement needs.

    Experience and qualifications:

    • Bachelor's degree (B.A.) from four-year college or university, Master's degree and other advance certification is preferred, and minimum of five (5) years of experience in an analytical role.
    • Technical skills (Informatica, MS SQL Server, Qlik, Tableau, MS Excel).
    • Demonstrated analytical and problem-solving skills.
    • Strong ability to manage multiple initiatives simultaneously and be responsive to changing priorities.


  • RIT Solutions Inc Philadelphia, United States

    **Role: Billing Analyst/Product Owner** · **Location: 1901 Market St Philadelphia PA 19103** · **Type: W2 Contract** · - Work experience supporting and configuring Oracle Revenue Management and Billing (ORMB) or similar billing systems. · - Preferably development experience with ...


  • ProIT Inc. Philadelphia, United States Full time

    **Servicenow Business Analyst** · **FULL TIME** · **Philadelphia, PA - Onsite** · Overview: · **Duties**: · - Collaborate with stakeholders to understand their business needs and objectives · - Conduct requirements gathering and analysis · - Create detailed documentation includin ...

  • Comcast Corporation

    Data Solutions Analyst

    18 hours ago


    Comcast Corporation Philadelphia, United States

    Comcast brings together the best in media and technology. We drive innovation to create the world's best entertainment and online experiences. As a Fortune 50 leader, we set the pace in a variety of innovative and fascinating businesses and create career opportunities across a wi ...

  • Allspire Health Partners LLC

    Data Analyst

    1 week ago


    Allspire Health Partners LLC West Conshohocken, United States

    **Data Analyst** · **Position Overview**: · The Data Analyst reports to the Finance & Operations Department and supports AllSpire Health Partners ("AHP"), AllSpire Health GPO ("AHGPO"), their clinical and value analysis committees, supply chain leadership and sourcing staff throu ...


  • Vsolutions Technologies Philadelphia, United States

    5+ year Business Systems Analysts · Strong SQL · ETL · Data warehouse experience · Healthcare industry is a plus but not a must · Experience: Strong SQL, data warehouse, ETL, data mapping/transformation, business analyst skill set with strong communication. · ...


  • Lincoln Financial Radnor, United States

    **Date**:Apr 10, 2024 · **Primary Location**: Radnor, PA, US · **Company**:Lincoln Financial · **Alternate Locations**: Work from Home · **Work Arrangement**: · Hybrid/Flexible : Work at home and use the office as appropriate for in-person collaboration. · **Relocation assistance ...

  • FXI Inc

    BI Developer

    2 days ago


    FXI Inc Radnor, United States

    Overview: · **Responsibilities**: · **Responsibilities**: · - Design, implement and maintain data warehouse solutions including data migration tools, data modeling, data integration, data warehousing and database design. · - Design and shape the business intelligence architecture ...

  • SP Software Solutions

    Business Analyst

    1 day ago


    SP Software Solutions Philadelphia, United States

    DWH Business Systems Analyst · Hybrid Job - 3 Days in Office in Philadelphia Downtown · Open for W2, 1099 · JD: · This BSA sits on the Data Warehousing team. Requires experience creating Business Requirement Documents and Mapping documents for the development of ETL applications. ...


  • SP Software Solutions Philadelphia, United States

    DWH Business Systems Analyst · Hybrid Job - 3 Days in Office in Philadelphia Downtown · Only W2 · JD: · This BSA sits on the Data Warehousing team. Requires experience creating Business Requirement Documents and Mapping documents for the development of ETL applications. This rol ...

  • Brooksource

    Junior Data Analyst

    3 days ago


    Brooksource Philadelphia, United States

    Junior Data Analyst · Philadelphia, PA · Hybrid (3 days onsite) · Long term Contract · We are seeking a motivated Junior Analyst with a passion for learning and a keen interest in the healthcare industry. The ideal candidate will possess strong analytical skills, proficiency in ...

  • Brooksource

    Junior Analyst

    1 week ago


    Brooksource Philadelphia, United States

    Junior ORMB Analyst (Oracle Revenue Management & Billing System) · Philadelphia, PA · Hybrid (3 days onsite) · Long term Contract · We are seeking a motivated Junior Analyst with a passion for learning and a keen interest in the healthcare industry. The ideal candidate will p ...


  • Ztek Consulting Philadelphia, United States

    Job Role : Technical Business Analyst · Location : Philadelphia, PA (On-site/hybrid) · Mode of interview : Video Interview · Job Roles/Responsibilities: · Primary Skill · Requirements gathering and analysis, Data analysis and interpretation. Business process modeling, data mode ...


  • A2C Philadelphia, United States

    Overview · Exciting opportunity to become a contributing team member with a nj based ecommerce provider. Ground floor "Greenfield" opportunity building a best of breed Saas Based Informatics Platform · The Opportunity · Chief data architect is looking for lead data analysts to he ...


  • Open Systems Technologies Philadelphia, United States

    A direct client of our located in Philadelphia, PA has multiple openings for Business Systems Analysts with Datawarehouse experience. This is a hybrid role onsite 2-3 days a week. · The client's Data Warehouse team requires experience in creating Business Requirement Documents, F ...


  • SP Software Solutions Philadelphia, United States

    DWH Business Systems Analyst · Hybrid Job - 3 Days in Office in Philadelphia Downtown · Only W2 · A high number of candidates may make applications for this position, so make sure to send your CV and application through as soon as possible. · JD: · This BSA sits on the Data ...

  • SP Software Solutions

    Business Analyst

    8 hours ago


    SP Software Solutions Philadelphia, United States

    DWH Business Systems Analyst · Hybrid Job - 3 Days in Office in Philadelphia Downtown · Open for W2, 1099 · Please ensure you read the below overview and requirements for this employment opportunity completely. · JD: · This BSA sits on the Data Warehousing team. Requires exp ...


  • Lorven Technologies Inc. Philadelphia, United States

    Our client is looking Business System Analyst for long term project in Philadelphia, PA (Onsite) Below is the detail requirement. · Role: Business System Analyst (Only for W2) · Location: Philadelphia, PA (Onsite) · Candidate must be local and available for a face-face interview. ...


  • Serigor Inc Philadelphia, United States

    Job Title: Business Systems Analyst (SQL) · Location: Philadelphia, PA · Duration: 6 Months · Overview: · Our Client a national health care insurance company is looking for a SQL Business System Analyst. The Business System Analyst role on the EIM Data Warehouse team requires ex ...

  • Brooksource

    Junior Analyst

    4 days ago


    Brooksource Philadelphia, United States

    Junior ORMB Analyst (Oracle Revenue Management & Billing System) · Philadelphia, PA · Hybrid (3 days onsite) · Long term Contract · Be one of the first applicants, read the complete overview of the role below, then send your application for consideration. · We are seeking a ...


  • Damco Solutions Inc Philadelphia, PA, United States

    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 ...