Production Support Data Analyst

3 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

  • Sr Data Analyst

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

  • Product Senior Manager

    3 weeks ago

    Purchase, New York, United States MAXIMUS Full time

    Job DescriptionThe Digital Products and Services team within PepsiCo's global Strategy and Transformation group is responsible for articulating the vision, executing, and implementing PEP's next-generation global digital products and data infrastructure.The Digital Product Management team is accountable for creating roadmaps, delivering data and software...

  • Business Analyst

    2 weeks ago

    Purchase, New York, United States MasterCard Full time

    Job SummaryWe are seeking a highly skilled Business Analyst to join our team in Account Management. The ideal candidate will have strong analytical skills and experience in financial services, cards, or payments. As a Business Analyst, you will be responsible for supporting sales strategies and analytical functions focused on optimizing and expanding our...

  • Product Senior Manager

    3 weeks ago

    Purchase, New York, United States MAXIMUS Full time

    Product Senior ManagerPepsiCo is seeking a Product Senior Manager to lead the development and execution of digital products and services. The ideal candidate will have 9+ years of product management experience, with a strong background in agile methodologies and experience working with cross-functional teams.The Product Senior Manager will be responsible for...

  • Financial Systems Analyst

    3 weeks ago

    Purchase, New York, United States Oakridge Staffing Full time

    Financial Systems Business AnalystOakridge Staffing is seeking a highly skilled Financial Systems Business Analyst to join our team. As a key member of our finance team, you will be responsible for analyzing, designing, and implementing financial systems that meet the needs of our organization.Key Responsibilities:Requirements Gathering: Collaborate with...

  • Technical Business Analyst

    3 weeks ago

    Purchase, United States Talent Groups Full time

    Duration: 12 months to startHybrid Details: need to go onsite occasionally or as neededJob Description:Looking looking for someone who is passionate about technical business analysis, has excellent analytical skills, and can demonstrate how they've used tools like Postman and SQL queries to drive business value. Must be detail-oriented, self-motivated...

  • Financial Systems Analyst

    4 weeks ago

    Purchase, United States Oakridge Staffing Full time

    While this is a contractor role, the intension is that is will be both long term and will likely turn into fulltime.This Financial Systems Business Analyst will be responsible for analyzing, designing, and implementing financial systems This role requires a strong understanding of financial and accounting, as well as the ability to translate business...

  • Financial Systems Business Analyst

    2 weeks ago

    Purchase, New York, United States Oakridge Staffing Full time

    As a Financial Systems Business Analyst at Oakridge Staffing, you will play a crucial role in analyzing, designing, and implementing financial systems that meet the needs of our clients. This is a contractor role with the intention of becoming long-term and potentially full-time.Key Responsibilities:Requirements Gathering: Collaborate with finance and...

  • Senior Business Analyst Mergers and Acquisitions

    3 weeks ago

    Purchase, New York, United States MasterCard Full time

    Job SummaryWe are seeking a highly skilled Senior Analyst, Mergers and Acquisitions Integration to join our team. This role will be responsible for supporting all phases of acquisition integration, including integration strategy development, planning, and execution. The successful candidate will be a key member of a highly visible team and will work closely...

  • Senior Business Analyst Mergers and Acquisitions

    3 weeks ago

    Purchase, New York, United States MasterCard Full time

    Job SummaryThe Senior Analyst, Mergers and Acquisitions Integration is a key member of the team responsible for supporting all phases of acquisition integration. This role involves working closely with business and functional teams to develop and execute integration strategies, plans, and performance management. The successful candidate will have strong...

  • Senior Business Analyst Mergers and Acquisitions

    3 weeks ago

    Purchase, New York, United States MasterCard Full time

    Job SummaryWe are seeking a highly skilled Senior Analyst, Mergers and Acquisitions Integration to join our team. This role will be responsible for supporting all phases of acquisition integration, including integration strategy development, planning, execution, and performance management.Key Responsibilities• Provide support for all phases of acquisition...

  • Senior Counsel

    2 weeks ago

    Purchase, New York, United States MasterCard Full time

    Job SummaryMastercard is seeking a highly skilled Senior Counsel to join our Privacy & Data Protection team. As a Senior Counsel, you will play a critical role in ensuring compliance with credit risk and privacy laws while enabling data-driven innovation. Key Responsibilities• Conduct privacy by design reviews for new products and services, including those...

  • Senior Technical Business Solutions Specialist

    1 week ago

    Purchase, New York, United States Talent Groups Full time

    Key Responsibilities:Analyze business problems to identify opportunities for technical solutionsDesign and implement test plans using tools such as PostmanDevelop and maintain SQL queries to extract insights from databasesBuild detailed requirements documentation from conversations with stakeholdersWork independently to complete tasks and deliver results in...

  • Logistics Systems Director

    2 weeks ago

    Purchase, New York, United States The Connors Group Full time

    Job SummaryWe are seeking a highly skilled Logistics Systems Director to lead the selection, architecture, and support of our logistics and transportation systems. This role 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...

  • Logistics Systems Director

    1 week ago

    Purchase, New York, United States The Connors Group Full time

    Job Summary: We are seeking a seasoned Director to lead our Transportation Systems team at The Connors Group.As the Director of Transportation Systems, you will oversee the selection, architecture, and support of our logistics and transportation systems. You will collaborate closely with the CIO, VP of Logistics, and other stakeholders to ensure seamless...

  • Director, Transportation Systems

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

  • Associate Director, Engagement Marketing Lead

    3 weeks ago

    Purchase, New York, United States Teladoc Health Full time

    About the RoleTeladoc Health is a global leader in whole-person virtual care, empowering people everywhere to live healthier lives. As an Associate Director, Engagement Marketing, you will play a critical role in driving our engagement and retention marketing strategies, working closely with cross-functional teams to deliver exceptional results.Key...

  • Director of Logistics and Transportation

    3 weeks ago

    Purchase, New York, United States MAXIMUS Full time

    Job Title: Director of Logistics and TransportationWe are PepsiCo, a leading global food and beverage company, and we are seeking a highly skilled and experienced Director of Logistics and Transportation to join our team.About the Role:The Director of Logistics and Transportation will be responsible for leading our logistics and transportation operations,...

  • Marketing Director, Engagement and Retention

    3 weeks ago

    Purchase, New York, United States Teladoc Health Full time

    Job SummaryTeladoc Health is a global leader in whole-person virtual care, empowering people everywhere to live healthier lives. As an Associate Director of Engagement Marketing, you will play a critical role in driving our ambitious engagement objectives, building strong relationships, and driving higher consumer satisfaction.Key ResponsibilitiesDevelop and...

  • SVP, CFO, Open Banking, Consumer Acquisitions

    1 week ago

    Purchase, United States MasterCard Full time

    Our Purpose We work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments and businesses realize their greatest potential. Our...