Production Support Data Analyst

4 months ago

Purchase, United States Ampcus Full time
Data Warehouse Support Analyst - Long Term Contract

Must have Strong SQL

Hybrid Role on site Tues, Wed and Thurs in any of the following locations

Conshohocken, PA; Florham Park, NJ; New York, NY; Purchase, NY

The DataWarehosue Support Data Analyst is a hands-on position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse. The position will work within IT to help our client maintain the enterprise data warehouse architecture. Furthermore, the data warehouse architecture will measure performance in all aspects of the organization's operations.

ROLE RESPONSIBILITIES
  • Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
  • Create source-to-target mapping documents to capture additional application data elements.
  • Load the source-to-target mapping documents from source systems into the enterprise data warehouse.
  • Collaborate with the ETL team to ensure the source-to-target mapping documents are in correct ETL code.
  • Ensure the ETL code align with STM requirements.
  • Perform data validation, to insure correct data movement into the enterprise data warehouse architecture.
  • Consult with reporting teams to develop a general understanding for any identified variances - between the enterprise data warehouse and source system applications.
TECHNICAL QUALIFICATIONS
  • Proven 5+ years' experience of data analysis within an enterprise data warehouse.
  • Possess 2 years of Policy & Claims Insurance subject-matter expertise.
  • Candidate has advanced level SQL knowledge.
  • Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
  • Candidate is capable of creating and tuning Semantic layer Reporting Views.
  • Able to facilitate data discovery sessions, which will include an audience of business subject-matter experts.
  • Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
  • Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus.
GENERAL QUALIFICATIONS
  • Candidate has strong interpersonal skills, including both written and verbal communication skills.
  • Possess the ability to work as part of a team.
  • Candidate has strong organizational skills and analysis skills.
EDUCATION REQUIREMENTS
  • B.S. Degree in Computer Information Science, Information Management, or Statistics.

please send your resume to janice.dicicco@ampcus.com

  • Production Support Data Analyst

    2 weeks ago

    Purchase, United States Vimerse Infotech, Inc. Full time

    Production Support Data Analyst Onshore - SI Office Preferred Locations: Purchase, NY; Morristown, NJ Acceptable Offices: Charlotte, NC; Chicago, IL; Colorado Springs, CO; Dallas, TX; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New York, NY; Topeka, KSThe Production Support Data Analyst is a hands-on...

  • Sr Data Analyst

    4 months ago

    Purchase, United States Damco Solutions Full time

    Title : Sr Data Analyst (Data Warehouse) Location : Purchase, NY or Florham Park, NJ; (Day 1 onsite with Hybrid model)Required skills: Guidewire Policy center Datawarehouse Informatica TECHNICAL QUALIFICATIONS 10 + years of data analysis experience extracting OLTP data specifically for a data warehouse 5 + years P&C Insurance subject matter experience...

  • Senior Supply Chain Optimization Analyst

    1 week ago

    Purchase, New York, United States JS Consulting Full time

    Job DescriptionLocation: Purchase, NY (Hybrid 3 Days Onsite In A Week)Duration: FulltimeInterviews: VideoVisa Requirements: USC/GCLinkedIn Profile: RequiredHiring Priority: Local CandidatesAbout the RoleWe are seeking a highly experienced Logistics Business Systems Expert to join our team at JS Consulting. As a Senior Supply Chain Optimization Analyst, you...

  • Commercialization Analyst Senior

    1 week ago

    Purchase, New York, United States PepsiCo Full time

    We are seeking a highly skilled Senior Procurement Analyst to join our team at PepsiCo. The ideal candidate will have experience in project management, supply chain, and procurement, as well as excellent communication and interpersonal skills.The successful candidate will be responsible for managing multiple projects simultaneously, leading cross-functional...

  • Real Estate Investment Analyst

    4 days ago

    Purchase, United States Keller Augusta Full time

    THE OPPORTUNITYOur client is currently seeking an Analyst who will assist in supporting the Acquisitions team in the following areas across all regions: evaluating potential transactions, producing internal and external investment memorandums, assisting in the due diligence process, evaluating targeted markets to identify changes and trends on investment...

  • Supply Chain Graphic Specialist

    5 days ago

    Purchase, New York, United States PepsiCo Full time

    We are looking for a talented Senior Procurement Analyst to join our team at PepsiCo. As a key member of our commercialization team, you will play a critical role in supporting the launch of new products and initiatives across Gatorade.The successful candidate will have 1-3 years of experience in the CPG industry or comparable field, with a strong background...

  • Administrative Support Specialist

    1 week ago

    Purchase, New York, United States Mastercard Full time

    About MastercardMastercard is a leading global payments and technology company that connects consumers, businesses, merchants, issuers and governments around the world.We power economies by making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and...

  • Procurement Innovation Lead

    1 week ago

    Purchase, New York, United States PepsiCo Full time

    At PepsiCo, we are seeking a talented Senior Procurement Analyst to join our team. This exciting role will be responsible for supporting the commercialization of graphics, packaging, and ingredients across all of Gatorade.The ideal candidate will have 1-3 years of experience in the CPG industry or comparable supply chain/procurement/graphics/project...

  • Manager, Partnerships and Support Services

    3 weeks ago

    Purchase, United States ANC Full time

    About ANCANC is a leader in the digital signage and video display industry, specializing in the design, installation, and maintenance of complex technology systems for high-profile sports arenas, iconic transit hubs, commercial destinations, and major entertainment venues nationwide. Since 1997, ANC has delivered breakthrough multimedia advertising...

  • Manager, Partnerships and Support Services

    4 weeks ago

    Purchase, United States ANC Full time

    About ANCANC is a leader in the digital signage and video display industry, specializing in the design, installation, and maintenance of complex technology systems for high-profile sports arenas, iconic transit hubs, commercial destinations, and major entertainment venues nationwide. Since 1997, ANC has delivered breakthrough multimedia advertising...

  • Informatica Developer

    4 weeks ago

    Purchase, United States Ampcus Full time

    Informatica DeveloperHybrid Schedule/Partial Remote: Candidate must be willing to work in the office three days per week (Tuesday, Wednesday, Thursday) in one of the following locations: Alpharetta, GA; Boston, MA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Florham Park, NJ; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt...

  • Director, Transportation Systems

    2 months ago

    Purchase, United States The Connors Group Full time

    Overview:As the Director of Transportation Systems, you will lead the selection, architecture, and support of our logistics and transportation systems. You will report to the CIO and collaborate closely with the VP of Logistics, the IT Leadership Team, software vendors, and third-party contractors to ensure seamless operations and system enhancements that...

  • Guidewire Claims Center, Technical Lead

    2 weeks ago

    Purchase, United States HexaQuEST Global, Inc. Full time

    ROLE SUMMARY AND RESPONSIBILITIES This role will be a hands-on senior Claims Center Technical Lead who has grown through the ranks with experience managing 10-20 integration and configuration engineers across project and maintenance portfolios with substantial experience in owning, running, and supporting Guidewire Claims Center platform and integrations...

  • Guidewire Claims Center, Technical Lead

    2 weeks ago

    Purchase, United States HexaQuEST Global, Inc. Full time

    ROLE SUMMARY AND RESPONSIBILITIES This role will be a hands-on senior Claims Center Technical Lead who has grown through the ranks with experience managing 10-20 integration and configuration engineers across project and maintenance portfolios with substantial experience in owning, running, and supporting Guidewire Claims Center platform and integrations...

  • Physical Therapist

    2 weeks ago

    Purchase, United States JAG Physical Therapy Full time

    Physical TherapistThe Physical Therapist is forward-thinking who excels at assessing patients' strengths and weaknesses and devising creative and effective treatment plans. Therapists must practice discretion & maintain patient confidentiality. Must operate a high-energy, positive-thinking environment and offer patients positive encouragement to achieve...

  • Physical Therapist

    3 weeks ago

    Purchase, United States JAG Physical Therapy Full time

    Physical TherapistThe Physical Therapist is forward-thinking who excels at assessing patients' strengths and weaknesses and devising creative and effective treatment plans. Therapists must practice discretion & maintain patient confidentiality. Must operate a high-energy, positive-thinking environment and offer patients positive encouragement to achieve...

  • Physical Therapist

    7 days ago

    Purchase, United States JAG Physical Therapy Full time

    Physical Therapist at JAG Physical Therapy summary: A Physical Therapist at JAG Physical Therapy assesses patients' strengths and weaknesses to create effective treatment plans aimed at healing and maximizing functional independence. The role requires maintaining patient confidentiality, excellent decision-making skills, and collaboration with an...

  • Trading Operations

    1 month ago

    Purchase, United States Arena Investors I Quaestor Advisors Full time

    Arena is looking to expand the global Operations Team through the addition of an Assistant Vice President of Trading Operations to provide unparalleled support to the firm’s Corporate Securities business lines. In this role, this individual will oversee all aspects of the life cycle of tradeable securities across global markets. The individual will also...

  • JAG Physical Therapy | Physical Therapist- Full-Time

    2 weeks ago

    purchase, United States JAG Physical Therapy Full time

    Physical TherapistThe Physical Therapist is forward-thinking who excels at assessing patients' strengths and weaknesses and devising creative and effective treatment plans. Therapists must practice discretion & maintain patient confidentiality. Must operate a high-energy, positive-thinking environment and offer patients positive encouragement to achieve...

  • Physical Therapist

    2 weeks ago

    Purchase, United States JAG Physical Therapy Full time

    Physical TherapistThe Physical Therapist is forward-thinking who excels at assessing patients' strengths and weaknesses and devising creative and effective treatment plans. Therapists must practice discretion & maintain patient confidentiality. Must operate a high-energy, positive-thinking environment and offer patients positive encouragement to achieve...