ETL Analyst

4 weeks ago

Philadelphia, United States iO Associates - US Full time


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.

  • Business System Analyst with ETL

    7 hours ago

    Philadelphia, United States Lorven Technologies Full time

    Job Title: Business System Analyst with ETL Job Location: Philadelphia, PA Job Type: Contract 12+ Months (C2C/W2) Primary Skill 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,...

  • Business System Analyst

    5 days ago

    Philadelphia, United States Vsolutions Technologies Full time

    5+ year Business Systems AnalystsStrong SQLETLData warehouse experienceHealthcare industry is a plus but not a must! Experience: Strong SQL, data warehouse, ETL, data mapping/transformation, business analyst skill set with strong communication.

  • Business System Analyst

    5 days ago

    Philadelphia, United States Vsolutions Technologies Full time

    5+ year Business Systems AnalystsStrong SQLETLData warehouse experienceHealthcare industry is a plus but not a must! Experience: Strong SQL, data warehouse, ETL, data mapping/transformation, business analyst skill set with strong communication.

  • Business Analyst

    5 days ago

    Philadelphia, United States SP Software Solutions Full time

    DWH Business Systems AnalystHybrid Job - 3 Days in Office in Philadelphia DowntownOpen for W2, 1099JD:This BSA sits on the Data Warehousing team. Requires experience creating Business Requirement Documents and Mapping documents for the development of ETL applications. This role requires extensive SQL experience in writing complex queries across multiple...

  • Business Analyst

    5 days ago

    Philadelphia, United States SP Software Solutions Full time

    DWH Business Systems AnalystHybrid Job - 3 Days in Office in Philadelphia DowntownOpen for W2, 1099JD:This BSA sits on the Data Warehousing team. Requires experience creating Business Requirement Documents and Mapping documents for the development of ETL applications. This role requires extensive SQL experience in writing complex queries across multiple...

  • Business Analyst

    5 days ago

    Philadelphia, United States SP Software Solutions Full time

    DWH Business Systems AnalystHybrid Job - 3 Days in Office in Philadelphia DowntownOpen for W2, 1099JD:This BSA sits on the Data Warehousing team. Requires experience creating Business Requirement Documents and Mapping documents for the development of ETL applications. This role requires extensive SQL experience in writing complex queries across multiple...

  • Data Warehouse Business Analyst

    3 days ago

    Philadelphia, United States IntePros Full time

    Business System Analyst OverviewThe Senior Business Systems Analyst determines business requirements by working with business clients and recommends appropriate business system applicationsRecommends systems criteria and project scopeIdentifies potential problems, performs analysis and implements system enhancements, modifications and upgradesPlans and...

  • Data Warehouse Business Analyst

    3 days ago

    Philadelphia, United States IntePros Full time

    Business System Analyst OverviewThe Senior Business Systems Analyst determines business requirements by working with business clients and recommends appropriate business system applicationsRecommends systems criteria and project scopeIdentifies potential problems, performs analysis and implements system enhancements, modifications and upgradesPlans and...

  • Business Analyst/product Owner

    1 week ago

    Philadelphia, United States RIT Solutions Inc Full time

    **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 Java based programming. Groovy script preferred. - Ability to parse through many...

  • Business Systems Analyst

    1 month ago

    Philadelphia, United States Serigor Inc Full time

    Job Title: Business Systems Analyst (SQL)Location: Philadelphia, PADuration: 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 experience in creating Business Requirement Documents, Functional Requirement Documents and...

  • Business Systems Analyst

    4 weeks ago

    Philadelphia, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Business Systems Analyst (SQL)Location: Philadelphia, PADuration: 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 experience in creating Business Requirement Documents,...

  • Business Systems Analyst

    19 hours ago

    Philadelphia, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Business Systems Analyst (SQL)Location: Philadelphia, PADuration: 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 experience in creating Business Requirement Documents,...

  • Business Systems Analyst

    1 month ago

    Philadelphia, United States Open Systems Technologies Full time

    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, Functional Requirement Documents and Mapping documents for the development of ETL...

  • Business Systems Analyst

    4 weeks ago

    Philadelphia, United States Open Systems Technologies Full time

    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, Functional Requirement Documents and Mapping documents for the development of ETL...

  • Technical Business Data Analyst

    7 days ago

    Philadelphia, United States HexaQuEST Global, Inc. Full time

    Looking for a Business Data Analyst who is proficient with SQL Scripting along with good experience of SSIS, SSRS, Tableau along with Data Warehousing tools. The Candidate must have a prior Health-Care Experience.Skill Set•Business process modeling, data modeling and database design, Documentation and report writing•Microsoft Office Suite, SQL, Visio,...

  • Business System Analyst

    2 days ago

    Philadelphia, United States Lorven Technologies Inc. Full time

    Our client is looking Business System Analyst for long term project in Philadelphia, PA (Onsite) Below is the detail requirement. Role: Business System AnalystLocation: Philadelphia, PA (Onsite)Candidate must be local and available for a face-face interview. JOB DESCRIPTION:Primary SkillRequirements gathering and analysis, Data analysis and interpretation....

  • Business System Analyst

    1 day ago

    Philadelphia, United States Lorven Technologies Inc. Full time

    Our client is looking Business System Analyst for long term project in Philadelphia, PA (Onsite) Below is the detail requirement. Role: Business System AnalystLocation: Philadelphia, PA (Onsite)Candidate must be local and available for a face-face interview. JOB DESCRIPTION:Primary SkillRequirements gathering and analysis, Data analysis and interpretation....

  • Business System Analyst

    2 days ago

    Philadelphia, United States Lorven Technologies Inc. Full time

    Our client is looking Business System Analyst for long term project in Philadelphia, PA (Onsite) Below is the detail requirement. Role: Business System AnalystLocation: Philadelphia, PA (Onsite)Candidate must be local and available for a face-face interview. JOB DESCRIPTION:Primary SkillRequirements gathering and analysis, Data analysis and interpretation....

  • Data Solutions Analyst

    5 days ago

    Philadelphia, United States Comcast Corporation Full time

    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 wide range of locations and disciplines. We are at the forefront of change and...

  • Analytics Consultant

    2 weeks ago

    Philadelphia, Pennsylvania, United States Klick Full time

    As part of our Analytics team, you'll be at the forefront of the big data revolution, guiding marketing strategies for our diverse range of clients. If you're ready to unleash your creativity and expertise in a fast-paced environment, we invite you to embark on your career journey with us at Klick.As an integral part of our forward-thinking team, you'll...