Data Warehouse Architect

3 weeks ago


West Chester, Pennsylvania, United States InterSources Full time

Job Title :

Data Warehouse Architect Location:
Hybrid

Rate :
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 Exceptions

Candidate will be expected to create and modify pipelines with a cloud-based Enterprise Resource Planning (ERP) system. To manage these pipelines the candidate will need experience with Azure Data Factory (ADF) and Sql Server (SSIS) pipelines.

Candidate will be creating data pipelines that support data marts and will be expected to code processes according to our standards.

Candidate will be well-versed in current methodologies for synchronizing data mart datasets from source systems via file-based extracts.

Working with our business partners to develop data mapping from one system to another is desirable but not strictly required.

Key Responsibilities:

  • Develop and maintain Azure Data Factory pipelines for data integration and processing.
  • Design and implement SSIS packages for data extraction, transformation, and loading.
  • Collaborate with business stakeholders to identify data requirements and develop data mapping solutions.
  • Ensure data quality and integrity through data validation and testing.
  • Stay up-to-date with industry trends and best practices in data warehousing and business intelligence.

Requirements:

  • 5+ years of experience in data warehousing and business intelligence.
  • Proficiency in Azure Data Factory and SSIS.
  • Strong understanding of data modeling and data architecture.
  • Excellent communication and collaboration skills.
  • Ability to work in a fast-paced environment and prioritize multiple tasks.

Preferred Qualifications:

  • Experience with Azure file storage data sources (data lake, blob, hadoop).
  • Knowledge of HIP and PII regulations.
  • Experience with Workday reports and outbound integrations.

About Us:

InterSources Inc , a Certified Diverse Supplier, was founded in 2007 and offers innovative solutions to help clients with Digital Transformations across various domains and industries.

We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enable us to grow as a global platform and they are causally linked with our success.



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

  • Senior Data Architect

    4 weeks ago


    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

    3 weeks ago


    West Chester, Pennsylvania, United States Insight Global Full time

    Job Title: Data ArchitectWe are seeking a skilled Data Architect to join our team at Insight Global. As a Data Architect, you will be responsible for building and optimizing data architectures and visualizations that drive strategic decision-making within the Trauma BU.Key Responsibilities:Design and implement data architectures using SQLCollaborate with...

  • Data Architect

    4 weeks ago


    West Chester, Pennsylvania, United States Insight Global Full time

    Job SummaryWe are seeking a highly skilled Data Architect to join our team at Insight Global. As a key member of our team, you will be responsible for designing and implementing data architectures that drive strategic decision-making within our Trauma BU.Key Responsibilities:Design and implement data architectures using SQLCollaborate with end-users to...


  • West Chester, Pennsylvania, United States Insight Global Full time

    Job Summary: We are seeking a highly skilled Data Architect to join our rapidly growing team at Insight Global. This individual will take full ownership of building and optimizing data architectures and visualizations that drive strategic decision-making within the Trauma BU.Key Responsibilities:Lead custom database creation and own data refreshes to ensure...


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

  • Data Architect

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

  • Data Architect

    4 weeks ago


    West Chester, Pennsylvania, United States Insight Global Full time

    Job Title: AnalystA leading Medical Device company is seeking an Analyst to join their rapidly growing team. This individual will take full ownership of building and optimizing data architectures and visualizations that drive strategic decision-making within the Trauma Business Unit.Key Responsibilities:Design and maintain data architecture using SQL to...

  • Network Architect

    4 weeks ago


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

    Job SummaryPierce Technology Corp is seeking a highly skilled Network Architect to design and implement Ethernet and IP networks. The ideal candidate will have a strong background in network architecture and technology planning, with experience in carrier and enterprise service provider environments.Key ResponsibilitiesArchitect and design Ethernet and IP...

  • Warehouse Worker

    4 weeks ago


    West Chester, Pennsylvania, United States PeopleShare Full time

    Assembler Job DetailsOur client in Chester is seeking Assemblers/Warehouse workers to join their team.Key Highlights:Monday-Friday schedule, 7am-3:30pm$15.50/hour pay rateNo weekendsHealthcare benefits after 30 daysAssembler Job DescriptionFabricate or assemble electronic equipment according to written work instructions.Flex to multiple work areas daily...

  • Warehouse Worker

    4 weeks ago


    West Chester, Pennsylvania, United States PeopleShare Full time

    Assembler Job DetailsOur client in Chester is seeking Assemblers/Warehouse workers to join their team.Schedule: Monday- Friday, 7am-330pmPay Rate: $15.50/hr.No WeekendsHealthcare Benefits after 30 DaysAssembler Job DescriptionFabricate or assemble electronic equipment according to written work instructions. Flex to multiple work areas daily based on...

  • Logistics Coordinator

    3 weeks ago


    West Chester, Pennsylvania, United States Candidate Source Ltd Full time

    Job Summary: We are seeking a highly organized and detail-oriented individual to join our team as a Shipping and Receiving Clerk. The successful candidate will be responsible for processing inbound and outbound paperwork for truck drivers, distributing workload to forklift operators, and working closely with other shipping clerks and forklift operators.Key...

  • Warehouse Specialist

    4 weeks ago


    West Point, Pennsylvania, United States Vallen Full time

    Job Title: Storeroom AttendantVallen is seeking a highly organized and detail-oriented Storeroom Attendant to join our team. As a Storeroom Attendant, you will be responsible for receiving, stocking, and issuing inventory in a fast-paced warehouse environment.Key Responsibilities:Unload and receive incoming products, goods, tools, and equipment, and...

  • Sanitation Associate

    4 weeks ago


    West Chester, Pennsylvania, United States Verano Full time

    Job Summary:The Sanitation Associate is responsible for maintaining a clean and safe environment in our warehouse facility.Key Responsibilities:Clean and supply designated building areas, including dusting, sweeping, vacuuming, mopping, and cleaning ceiling vents and restrooms.Perform routine inspection activities and document findings.Carry out heavy...


  • West Mifflin, Pennsylvania, United States Fluor Marine Propulsion, LLC Full time

    Job Description:Fluor Marine Propulsion, LLC is seeking an experienced Enterprise Architect to lead the Enterprise Architect team within the Information Technology (IT) Department.You will improve current IT infrastructure, optimize business operations for efficiency, and set the direction for integrating information technology throughout the Naval Nuclear...

  • Civil Project Manager

    4 weeks ago


    West Chester, Pennsylvania, United States The Kleingers Group Full time

    Civil Project Engineer Job DescriptionThe Civil Project Engineer will provide technical leadership to project teams working on planning, evaluation, design, and implementation of civil engineering projects.Key Responsibilities:Lead the study-phase and/or design-phase of projects related to civil, environmental, construction, and industrial fields.Manage...

  • Warehouse Associate

    4 weeks ago


    West Mifflin, Pennsylvania, United States Core-Mark Full time

    Job SummaryWe are seeking a highly motivated and detail-oriented Warehouse Associate to join our team at Core-Mark. As a key member of our distribution center, you will play a critical role in ensuring the efficient flow of products through our system.Key ResponsibilitiesOperate material handling equipment, such as forklifts and pallet jacks, to transport...


  • West Chester, Pennsylvania, United States IDR Healthcare Full time

    Job Title: Senior IT Systems AnalystAbout the Role:IDR Healthcare is seeking a skilled Senior IT Systems Analyst to join our team. As a Senior IT Systems Analyst, you will be responsible for coordinating project efforts and managing backlog grooming in an Agile environment.Key Responsibilities:* Regularly meet with clients to coordinate project efforts and...

  • Fullstack Developer

    3 weeks ago


    West Chester, Pennsylvania, United States Profound Technologies Full time

    Job Title: Fullstack DeveloperJob Description:Profound Technologies is a leading Audio/Video solution provider driven by its core value to reduce technology friction and drive human experiences. We are seeking an experienced full-stack web developer to join our team and contribute to the development of our web applications.Responsibilities:* Inheritance and...


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

    Patient Solutions Customer Service Representative Job SummaryWe are seeking a highly skilled Patient Solutions Customer Service Representative to join our team at PeopleShare Inc. As a Patient Solutions Customer Service Representative, you will be responsible for making outbound calls to collect patient payments, resolving outstanding account balances, and...