Data Integration Specialist

2 months ago


philadelphia, United States Seneca Resources Full time

A government agency located in Philadelphia, PA is looking for a Data Integration Specialist for a 6 month role. This is a hybrid position with some onsite work required in Philadelphia.


Position overview / Statement of Work

We are seeking a skilled and experienced Data Integration Specialist for a temporary assignment to join our dynamic team. This position will be responsible for the migration, integration, and maintenance of data within Amazon S3 and Amazon Redshift environments. This position will also be responsible for ensuring data integrity and security throughout the entire process, from initial migration to continuous data operations. This position requires 3 or more years of experience working as a Data Integration Specialist.


The pay rate range for this role is $65 - $75.85/hr

Work Mode: Hybrid, minimum 3 days onsite per week


Work activities:

• Design and implement data pipelines to extract, transform and load data (ETL and/or ELT) data into Amazon S3 using Azure Data Factory and other tools

• Set up automated workflows to ensure continuous data migration

• Configure Amazon S3 buckets for data storage

• Set up data schemas and tables in Amazon Redshift

• Migrate cleaned and preprocessed data into Amazon S3 and Redshift

• Ensure data integrity and security during migration

• Monitor data pipelines for performance and reliability

• Perform regular maintenance to address any issues

• Improve data integration processes for increased efficiency and scalability

• Document data integration processes and procedures


Skills/experience of the assigned staff:

Required

• Experience with various cloud platforms

• Proficient with Azure Data Factory

• Strong knowledge of Amazon AWS S3, AWS Redshift and AWS Lambda

• Proficient in SQL and ETL tools

• Effective communication and documentation abilities

• Expertise in data security and integrity measures

• Excellent problem-solving and analytical skills

• 3 years of experience creating, documenting, implementing, and maintaining data pipelines


Highly Desired/Preferred

• Experience using AWS Glue

• Proficient with Python, C# and sparkSQL



  • philadelphia, United States Seneca Resources Full time

    A government agency located in Philadelphia, PA is looking for a Data Integration Specialist for a 6 month role. This is a hybrid position with some onsite work required in Philadelphia.Position overview / Statement of WorkWe are seeking a skilled and experienced Data Integration Specialist for a temporary assignment to join our dynamic team. This position...


  • Philadelphia, United States Seneca Resources Full time

    A government agency located in Philadelphia, PA is looking for a Data Integration Specialist for a 6 month role. This is a hybrid position with some onsite work required in Philadelphia.Position overview / Statement of WorkWe are seeking a skilled and experienced Data Integration Specialist for a temporary assignment to join our dynamic team. This position...


  • Philadelphia, United States Ohm Systems, Inc Remote Work Freelance Full time $44 - $46

    Summary: A Data Integration Specialist is needed for a temporary role to support data migration, integration, and maintenance in Amazon S3 and Amazon Redshift environments. This role will involve designing, implementing, and securing data pipelines while ensuring data integrity and optimizing processes.Position Info:Title: Data Integration SpecialistClient:...


  • Philadelphia, Pennsylvania, United States NantHealth Full time

    Job Description:We are seeking a highly skilled Data Integration Specialist to join our team at NantHealth. In this role, you will be responsible for gathering functional requirements, including workflows, use cases, and business rules, and documenting them in a structured manner.The estimated salary for this position is $90,000 - $110,000 per year,...


  • Philadelphia, Pennsylvania, United States Penn Medicine Full time

    Penn Medicine seeks a skilled Data Integrity and Coding Specialist to join our team. This critical role plays a vital part in ensuring the accuracy and integrity of our coding data, driving informed decision-making across the organization.As a key member of our Central Fee Abstraction (CFA) team, you will be responsible for validating data, identifying...


  • Philadelphia, Pennsylvania, United States Seneca Resources Full time

    Seneca Resources is looking for a highly skilled Data Integration Architect to join their team for a 6-month role. This hybrid position requires some onsite work in Philadelphia, PA.About the Role:We are seeking an experienced professional to lead our data integration efforts, ensuring seamless migration, integration, and maintenance of data within Amazon S3...


  • Philadelphia, Pennsylvania, United States American College of Physicians Full time

    About the RoleAs a Data Integration Strategist at American College of Physicians, you will drive business outcomes by orchestrating data across marketing and IT, designing robust data systems, and enhancing business growth by aligning business needs with data-rich technology solutions.Main ResponsibilitiesPartner with IT, Marketing, and other stakeholder...


  • Philadelphia, Pennsylvania, United States Eateam Full time

    Key ResponsibilitiesAs a Salesforce Data Cloud Developer, you will be responsible for:Designing, implementing, and maintaining data cloud solutions using Salesforce technologies.Developing Apex classes, triggers, and controllers to support complex business logic.Creating Lightning Web Components (LWC) to enhance user experiences.Integrating external systems...


  • Philadelphia, Pennsylvania, United States Diverse Lynx Full time

    Key ResponsibilitiesWe are seeking a highly skilled Enterprise Integration Specialist to join our team at Diverse Lynx LLC. The ideal candidate will have extensive experience in delivering solutions related to enterprise integration, APIs, and technology modernizations using Boomi, as well as excellent analytical and problem-solving skills.The successful...


  • Philadelphia, Pennsylvania, United States University of Pennsylvania Full time

    Data Analyst Specialist**Overview**The University of Pennsylvania, a world-renowned leader in education and research, is seeking a highly skilled Data Analyst Specialist to join our team. As a Data Analyst Specialist, you will play a critical role in ensuring the accuracy and integrity of data within iPenn and SEVIS, overseeing SEVIS registration, managing...


  • Philadelphia, Pennsylvania, United States AVEVA Full time

    About the OpportunityWe are seeking a highly skilled Data Integration and Automation Professional to join our team at AVEVA. As a key member of our data integration team, you will be responsible for establishing seamless data flows between the MDM system and various enterprise applications.You will collaborate with ETL developers and integration teams to...


  • Philadelphia, Pennsylvania, United States SoftPathTechnologies Full time

    About the RoleSoftPath Technologies is hiring a Senior Data Integration Consultant to lead our data engineering efforts. As a key member of our team, you will be responsible for designing and implementing complex data integration projects, working with clients to understand their requirements, and providing expert advice on data architecture and...

  • Data Engineering

    2 days ago


    Philadelphia, United States Sagax Team Full time

    Data Engineering & Integration ConsultantWe are currently seeking a Data Engineering & Integration Consultant for a client in the Philadelphia Area. Duration: 2-3 months initial termLocation: Hybrid (2 days in Philadelphia is a MUST). Long-distance expense reimbursement not offered. Start Date: ImmediatePossibility of extension based on project performance...

  • Data Engineering

    2 weeks ago


    Philadelphia, United States Sagax Team Full time

    Data Engineering & Integration ConsultantWe are currently seeking a Data Engineering & Integration Consultant for a client in the Philadelphia Area. Duration: 2-3 months initial termLocation: Hybrid (2 days in Philadelphia is a MUST). Long-distance expense reimbursement not offered. Start Date: ImmediatePossibility of extension based on project performance...


  • Philadelphia, Pennsylvania, United States Salesforce Full time

    OverviewSalesforce, the Customer Company, is seeking a skilled Cloud Data Integration Strategist to lead clients through app development and deployment on Heroku for mission-critical systems.About SalesforceWe're a vibrant ecosystem that inspires business with AI+ Data +CRM. Our core values drive us to help companies blaze new trails and connect with...


  • Philadelphia, Pennsylvania, United States System One Full time

    Data Insights SpecialistSystem One is a premier provider of workforce solutions and integrated services across North America. Our mission is to deliver high-quality results while fostering a collaborative work environment.We are currently seeking a highly skilled Data Insights Specialist to support our clients. As a key member of our team, you will be...


  • Philadelphia, Pennsylvania, United States Comcast Corporation Full time

    Job SummaryWe are looking for a talented Integration Specialist to join our team at Comcast Corporation. In this role, you will be responsible for integrating new technologies and systems into our existing infrastructure to improve efficiency and reduce costs. Main ResponsibilitiesCollaborating with cross-functional teams to identify integration...


  • Philadelphia, Pennsylvania, United States AVEVA Full time

    About the RoleWe are seeking a highly skilled Master Data Management Specialist to join our team at AVEVA. As a key member of our data management team, you will be responsible for leading the configuration, deployment, and management of Informatica MDM SaaS solutions.With a strong background in data governance and integration, you will define and enforce...


  • Philadelphia, Pennsylvania, United States Community Behavioral Health. Full time

    Community Behavioral Health (CBH) is seeking a skilled Data Architecture Specialist to join our team. This role is responsible for designing, creating, and managing the data architecture within CBH's IT division.Job DescriptionThis Data Architecture Specialist will be a crucial part of establishing and continuously refining our data architecture frameworks....


  • philadelphia, United States Integration International Inc. Full time

    Job Details: Title: - Industrial EngineerFulltime with benefits Monday-Friday 8-5PM with one hour lunchJob DescriptionResponsibilities:Demonstrate technical expertise in all areas of Heat Treat: Furnace Designs and Components, Heat Delivery, Electronic Controls, Process Gases, Blowers and Ventilation, Water Cooling, Data Logging, Run Chart Interpretation,...