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

    2 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

    2 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

    2 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

    2 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

    2 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/product Owner

    4 days 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

    3 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

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

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

  • Technical Business Data Analyst

    4 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 Systems Analyst

    2 weeks ago

    Philadelphia, United States Expedite Technology Solutions LLC Full time

    Title: Business Systems Analyst Location: Philadelphia, PA 19103 Duration: Long Term Contract to HireJob Description: This position requires 6-8 years' 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...

  • Business System Analyst

    2 weeks ago

    Philadelphia, United States Open Systems Technologies Full time

    Our client is looking for a Business System Analyst to join their team in Philadelphia, PA. Pay: $65-75/hr The Business System Analyst role on the 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...

  • Technical Business Data Analyst

    2 weeks 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,...

  • Technical Business Analyst

    1 week ago

    Philadelphia, United States RIT Solutions Inc Full time

    **Role: Warehouse Management consultant** **Location: 1901 Market St Philadelphia, PA 19103 ( 3 days in office)** **Type: W2 contract** **Skills and qualifications**: - Work experience supporting and configuring Oracle Revenue Management and Billing (ORMB) or similar billing systems. - Preferably development experience with Java based programming. Groovy...

  • BSA with DW and Healthcare exp

    2 weeks ago

    Philadelphia, United States Damco Solutions Inc Full time

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

  • Data Solutions Analyst

    1 day 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

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

  • DBT / QlikSense / ETL / remote / contract

    1 month ago

    Philadelphia, United States Motion Recruitment Full time

    A leading children's hospital dedicated to pediatric research, where you will play a pivotal role as a DBT Data Engineer. Leveraging your expertise in dbt (Data Build Tool), data modeling, Snowflake, and QlikSense, you will collaborate with a multidisciplinary team to design and implement efficient data transformation pipelines. Your work will directly...

  • Entry-Level/Junior Senior Data Engineer

    3 weeks ago

    Philadelphia, United States augmentjobs Full time

    Job DescriptionJob DescriptionJob Description:Responsibilities:Data Collection and Ingestion: Assist in the collection and ingestion of data from various sources, including databases, APIs, and external systems. Develop basic ETL (Extract, Transform, Load) processes to clean, transform, and prepare data for analysis.Data Modeling and Schema Design: Support...