Current jobs related to Data Integration Specialist - West Chester, Pennsylvania - Pierce Technology Corp


  • West Chester, Pennsylvania, United States Smart IMS Full time

    Job Title: Data Analyst Excel SpecialistWe are seeking a skilled Data Analyst or Excel Power User with strong proficiency in Advanced Excel, specifically with VLOOKUP, Pivot Tables, and formula use. The ideal candidate should have the ability to compare and manipulate data, sort, analyze, and transform it to match specified formats. This role involves...


  • West Chester, Pennsylvania, United States Apex Systems Full time

    We are seeking a highly skilled Data Entry Specialist to join our team for a short-term project. The primary responsibility will be to accurately enter information from various documents into our database. This project will require approximately 2000 forms to be entered into our system.This role requires a high level of accuracy and confidentiality, as the...


  • West Chester, Pennsylvania, United States Educational Data Systems Inc Full time

    Job Summary:We are seeking a highly skilled Workforce Career Specialist to join our team at Educational Data Systems Inc. As a Workforce Career Specialist, you will play a critical role in providing career development assistance to our clients.Key Responsibilities:Build strong relationships with clients to understand their career goals and provide...


  • West Chester, Pennsylvania, United States Aloden, Inc. Full time

    Data Warehouse ArchitectAloden, Inc. is seeking a highly skilled Data Warehouse Architect to join our team. As a key member of our data engineering team, you will be responsible for designing, developing, and maintaining data pipelines using Azure Data Factory and SSIS.Key Responsibilities:Design and develop data pipelines using Azure Data Factory and...


  • West Chester, Pennsylvania, United States Aloden, Inc. Full time

    Job Title: Data Warehouse ArchitectAbout the Role:Aloden, Inc. is seeking a highly skilled Data Warehouse Architect to design, develop, and maintain data pipelines using Azure Data Factory and SSIS. The ideal candidate will have proven experience in Azure Data Factory pipeline development for both Azure and on-premises SQL Server environments.Key...


  • West Chester, Pennsylvania, United States Diverse Lynx Full time

    Job Title:CAD - PLM Integration EngineerLocation:West Chester, PA (Remote)Duration:FulltimeJob DescriptionThe CAD - PLM Integration Engineer is responsible for leading the deployment, administration, and maintenance of integrated engineering systems.This role involves providing technical leadership, troubleshooting complex issues, and implementing process...

  • Data Analyst

    7 days ago


    West Chester, Pennsylvania, United States Smart Ims Full time

    Job DescriptionSmart Ims is seeking a skilled Data Analyst to work with data from 401k, 403b, and other retirement plans. The ideal candidate should have strong proficiency in Advanced Excel, specifically with VLOOKUP, Pivot Tables, and formula use.Responsibilities:* Use Excel formulas to scrub, manipulate, and analyze data from prior record keepers (PRK) to...


  • West Chester, Pennsylvania, United States InterSources Full time

    Job Title :Data Warehouse Architect Location: HybridRate : Best competitive rate*Local candidates or those willing to relocate to the Richmond area during this engagement due to onsite work requirement *ONSITE interviews only *Candidates must be willing and able to work onsite 3 days/week, NO ExceptionsCandidate will be expected to create and modify...


  • West Chester, Pennsylvania, United States Serigor Inc Full time

    Job Title: Data Warehouse Architect 2Location: RemoteDuration: 12+ MonthsJob Description:We are seeking a highly skilled Data Warehouse Architect to join our team at Serigor Inc. The successful candidate will be responsible for developing data mapping from one system to another, managing data mapping from legacy systems to new systems, and ensuring seamless...


  • West Chester, Pennsylvania, United States Serigor Inc Full time

    Job Title:Data Warehouse Architect 4 (Hybrid)Location:Chester, VADuration:12+ MonthsJob Description:Candidate will be expected to create and modify interfaces between Workday and other systems. To manage these interfaces the candidate will need experience with Sql Server (SSIS), Azure Data Factory pipelines, and should be experienced, or familiar, with...

  • Data Architect

    1 week ago


    West Chester, Pennsylvania, United States Diverse Lynx Full time

    Job Summary:We are seeking a highly skilled and experienced Data Modeler to join our team as a Business Associate. The ideal candidate will have 10 to 14 years of experience in data modeling and will play a crucial role in designing and implementing data structures that support our business objectives.The successful candidate will have a deep understanding...


  • West Chester, Pennsylvania, United States Diverse Lynx Full time

    Diverse Lynx LLC is seeking a highly skilled CAD - PLM Integration Engineer to join our team. The ideal candidate will have 3-5 years of experience in administering SolidWorks, Creo, NX, and PTC Windchill PLM or related software administration. They will also possess advanced proficiency in software packaging and deployment, scripting (e.g., AutoIT,...


  • West Chester, Pennsylvania, United States Lorven Technologies Full time

    Job Description:Candidate will be responsible for designing and implementing data pipelines using Azure Data Factory and SSIS. The ideal candidate will have experience with Workday Studio and XSLT, as well as expertise in SQL Server and Azure environments. The role requires strong communication skills, self-motivation, and the ability to work independently....


  • West Chester, Pennsylvania, United States Serigor Inc Full time

    Job Title: Data Warehouse Architect 2Location: RemoteDuration: 12 monthsJob Description:We are seeking a highly skilled Data Warehouse Architect to join our team at Serigor Inc. The successful candidate will be responsible for designing and implementing data mapping solutions from legacy systems to new systems.The ideal candidate will have a solid attention...


  • West Chester, Pennsylvania, United States GE Aerospace Full time

    Job DescriptionAs a CFM56 HPC Module Integration Leader at GE Aerospace, you will be responsible for providing technical direction in the design, product support, and repair development for HPC components. Your key objectives will include establishing priorities and making commitments for fleet responsiveness and support, as well as ensuring the successful...

  • Data Entry Clerk

    2 weeks ago


    West Chester, Pennsylvania, United States A. Duie Pyle Full time

    A. Duie Pyle: A Family-Owned Business with a Rich HistoryA. Duie Pyle is a family-owned business with a rich history dating back to 1924. We provide a range of integrated transportation and distribution solutions throughout the Northeast.Job Summary:We are seeking a Part-Time Data Entry Clerk to join our team. As a Data Entry Clerk, you will work directly...

  • Data Entry Clerk

    3 weeks ago


    West Chester, Pennsylvania, United States A. Duie Pyle Full time

    A. Duie Pyle: A Family-Owned Business with a Commitment to ExcellenceWe are seeking a highly skilled and detail-oriented Part Time Data Entry Clerk to join our team at A. Duie Pyle. As a family-owned business since 1924, we pride ourselves on providing integrated transportation and distribution solutions throughout the Northeast.Job Summary:This is a unique...


  • West Chester, Pennsylvania, United States Power Home Remodeling Full time

    Data Center Technician Job DescriptionAt Power Home Remodeling, we are seeking a highly skilled Data Center Technician to join our team. As a Data Center Technician, you will be responsible for the design, implementation, and maintenance of the electrical and cooling infrastructure within our data center. This role requires a deep understanding of electrical...


  • West Chester, Pennsylvania, United States PrideStaff Full time

    PrideStaff Warehouse Specialist Job DescriptionWe are seeking a highly organized and detail-oriented Warehouse Specialist to join our team at PrideStaff. As a key member of our warehouse team, you will be responsible for maintaining a safe and efficient work environment, ensuring accurate inventory levels, and providing exceptional customer service.Key...


  • West Chester, Pennsylvania, United States Aequor Technologies Full time

    Job Title: Sr. Medical Coding Specialist Job Summary: We are seeking a highly skilled Sr. Medical Coding Specialist to join our team at Aequor Technologies. As a key member of our medical coding team, you will be responsible for delivering accurate and consistent medical coding for all assigned company protocols within established timelines and in compliance...

Data Integration Specialist

2 months ago


West Chester, Pennsylvania, United States Pierce Technology Corp Full time
Job Description

Job Summary

Pierce Technology Corp is seeking a highly skilled Data Integration Specialist to join our team. As an ETL Process Developer, you will be responsible for designing, developing, and documenting complex ETL processes to ensure seamless data integration across our systems.

Key Responsibilities

  • Design and develop ETL processes to extract, transform, and load data from various sources into our data warehouse.
  • Collaborate with cross-functional teams to identify data integration requirements and develop solutions to meet those needs.
  • Develop and maintain technical specifications, diagrams, and documentation for ETL processes.
  • Participate in ETL design sessions with the team to ensure alignment with business requirements.
  • Provide production support for new or changing mappings and workflows, and produce technical specifications.
  • Responsible for the analysis, data profiling, development, and integration of disparate systems throughout all phases of the project life cycle.
  • Work as part of a team delivering high-quality and efficient integration solutions.
  • Assist in ongoing development of technical best practices for data movement, data quality, data cleansing, and other ETL-related activities.
  • Implement best practices and tune for optimization.
  • Complete assignments in a timely manner.

Requirements

  • Bachelor's degree in Computer Science or related field.
  • At least 2-3 years of experience in technical development.
  • At least 2-3 years of experience with Informatica PowerCenter – Additional experience with SSIS or Talend is a plus.
  • At least 2-3 years of experience with Oracle Database.
  • Possess great diligence while also being flexible to adapt to a dynamic environment and changing priorities.
  • Excellent SQL, PL/SQL, and Database Skills – Python/R are a plus.
  • Some prior use of Toad for Oracle or any similar tools a plus.
  • Explicit understanding of SQL and some experience in a database environment.
  • Familiarity with data modeling – Star/Snow-flake schemas.
  • Experience with erwin Data Modeler software a plus.
  • Experience working in a corporate IT or similar environment.
  • Persuasive communication skills.
  • Dependability and adaptability.
  • Ability to work in a team/collaborative setting.
  • Technical proficiency.