Ediscovery Query Examples Jobs in Usa

We're Hiring: Ivalua Techno-Functional Lead Consultant

Location: Sunnyvale, CA (Onsite – 3 days/week)

We are looking for an experienced Ivalua Techno-Functional Lead Consultant with strong expertise in procurement systems, SQL, and integrations. The ideal candidate will have deep hands-on experience working with the Ivalua platform, supporting procurement processes, and collaborating with cross-functional teams to deliver scalable solutions.

This role requires a strong understanding of sourcing and procurement workflows, technical integration capabilities, and the ability to work closely with stakeholders and third-party solution providers.

Key Responsibilities

• Lead and support Ivalua implementation, configuration, and enhancement projects.
• Write and optimize SQL queries to generate reports, retrieve data, and support integrations.
• Build and support API integrations and EAI connections with other enterprise applications.
• Configure Ivalua modules, including workflows, callbacks, and solution design.
• Provide production support, including troubleshooting priority bugs and fixes.
• Work with stakeholders to improve sourcing and procurement processes.
• Participate in project release processes and system improvements.
• Maintain strong collaboration with clients and third-party solution providers.

Required Skills & Experience

• 8+ years of hands-on experience with Ivalua in a project role within industry or consulting.
• L2 (preferred) or L3 certification in any of the following areas from Ivalua: P2P, INT, or SQL.
• Strong experience working with SQL queries to build reports, retrieve data, and support integrations.
• Deep understanding of Ivalua solutions and API development.
• Strong knowledge of sourcing and procurement processes and their business value drivers.
• Experience with configuration modules including design, workflows, and callback creation.
• Experience supporting production issues, priority bugs, and fixes.
• Knowledge of project release processes.
• Excellent analytical, problem-solving, and communication skills.
• Experience building strong client relationships and collaborating with third-party solution providers.

Job Description

Working on day-to-day Snowflake Admin activities like, Storage Integration (AWS & GCP buckets), Integration setup (Notification, API & Email)

Setup of Inbound & Outbound Data shares as per the project requirements.

IP Allow listing as per the Project requirements, after review/approval of Platform Manager.

New Application Onboarding guidance and provide in-depth knowledge around the costing & billing aspects as per the standards.

Analyzing the Snowflake Warehouse Usage and provide best recommendations as per the trend and cost optimization.

Providing guidance around the usage of Cloud Toolkit API's and reading the secrets and manage the passwords in Keeper Vault Services.

Configure and optimize Snowflake accounts, virtual warehouses, databases, schemas, and user roles.

Monitor platform performance and ensure optimal configuration and scaling of compute resources.

Implement and manage data security measures including role-based access control, data encryption, and user authentication.

Monitor query performance and optimize SQL queries for better efficiency, Analyze and resolve performance bottlenecks and resource contention issues, Utilize Snowflake's advanced features such as clustering keys, materialized views, and result caching to enhance performance.

Implement backup and recovery strategies to ensure data durability and availability, Manage data archiving, replication, and failover processes.

Develop and maintain scripts for automating administrative tasks and workflows, Utilize tools and frameworks for continuous integration and deployment (CI/CD).

Provide technical support and troubleshooting for Snowflake-related issues, collaborate with Snowflake support to resolve platform-specific issues

Knowledge in any RDBMS database like Teradata or Oracle

Knowledge of programming languages such as Python or JavaScript.

Experience with data visualization tools (e.g., Tableau, Power BI).

24*7 support model experience

Salary Range: $64,000 - $125,000 a year

#LI-CM2

Role: AWS Cloud Engineer

Location: San Antonio, TX (On-Site)

• Identify and select the data sources, Tables, Relationships between different entities in Snowflake.

• Establish a secure connection between Snowflake and AWS Neptune via AWS service stack by securing extracted data storing in S3 for transformation before loading into AWS Neptune.

• Collaborate with current platform team to understanding data structure to implement data extraction processes from Snowflake.

• Load the extracted data into AWS S3 for graph model transformation.

• Analyze the data, relationships, entities mappings to determine the necessary graph schema.

• Design nodes, edges, and properties for the graph schema using entities definitions.

• Implement the graph schema in AWS Neptune.

• Creating indexes to improve query performance

• Review and refine schema based on query patterns and performance based on mutually agreed design

• Define the transformation logic using DBT.

• Develop DBT models for data transformation.

• Schedule and automate the ELT pipeline using DBT and Snowflake.

Sr. Data Engineer (PySpark & Python + AI Tools Exp.) - (Only W2 or 1099)

Charlotte, NC (Hybrid)

12+ Months Contract

Job Description:

We are currently seeking a Senior Data Engineer with hands-on coding experience and a strong background in Python, PySpark, and Object-oriented programming.

The ideal candidate will be responsible for designing, developing, and implementing new features to our existing framework using PySpark and Python.

This position requires a deep understanding of data transformation and the ability to create standalone scripts based on given business logic. Also, exposure to AI Tools and building any AI applications will be advantage.

Key Responsibilities:

• Design, develop, and optimize large-scale data pipelines using PySpark and Python.
• Implement and adhere to best practices in object-oriented programming to build reusable, maintainable code.
• Write advanced SQL queries for data extraction, transformation, and loading (ETL).
• Collaborate closely with data scientists, analysts, and stakeholders to gather requirements and translate them into technical solutions.
• Troubleshoot data-related issues and resolve them in a timely and accurate manner.
• Leverage AWS cloud services (e.g., S3, EMR, Lambda, Glue) to build and manage cloud-native data workflows (preferred).
• Participate in code reviews, data quality checks, and performance tuning of data jobs.

Required Skills & Qualifications:

• 6+ years of relevant experience in a data engineering or backend development role.
• Strong hands-on experience with PySpark and Python, especially in designing and implementing scalable data transformations.
• Solid understanding of Object-Oriented Programming (OOP) principles and design patterns.
• Proficient in SQL, with the ability to write complex queries and optimize performance.
• Strong problem-solving skills and the ability to troubleshoot complex data issues independently.
• Excellent communication and collaboration skills.
• Hands-on experience with AI Tools.

Preferred Qualifications (Nice to Have):

• Experience working with AWS cloud ecosystem (S3, Glue, EMR, Redshift, Lambda, etc.).
• Exposure to data warehousing concepts, distributed computing, and performance tuning.
• Familiarity with version control systems (e.g., Git), CI/CD pipelines, and Agile methodologies.
• Exposure to AI Tools and hands-on experience of building any AI applications.

Must have

Teradata platform expertise

• Deep knowledge of Teradata architecture: parsing, BYNET, AMP, vproc, fallback, hashing, PDCR, fallback, and spool management.

• Data distribution and primary index design; collecting statistics and understanding optimizer behavior.

• Experience with recent Teradata versions and releases migration/upgrade planning: TD 16.XX, TD 17.XX and preferably TD 20.XX.

System administration

• Provisioning and managing Teradata nodes and clusters (physical and virtual).

• OS-level skills: Linux administration (SLES/RHEL/CentOS/Oracle Linux) for Teradata on Linux, including kernel tuning, package management, user and permissions management.

• Storage subsystem knowledge: SAN, NAS, Fibre Channel, LUNs, RAID, and how storage impacts Teradata I/O and spool.

Performance tuning and troubleshooting

• SQL query and plan analysis; collecting and interpreting Explain plans.

• Workload management (WLM) and resource allocation: query prioritization, throttling, and KRI/SLAs.

• Monitoring and diagnostics: using Teradata tools and logs to analyze spool, CPU, memory, disk I/O, network, BYNET contention.

Backup, recovery & high availability

• Best practices for backups restore procedures, and disaster recovery (DR) planning and testing.

• Knowledge of fallback, AMP resilience, replication methods and physical vs logical protection.

Security & compliance

• DB and platform-level security: roles, privileges, LDAP/Kerberos integration, encryption (at rest/in transit), auditing and compliance (SOx and Others as applicable).

• Secure configuration and hardening practices.

Networking & infrastructure

• Network architecture for Teradata clusters, VLANs, link aggregation, low-latency requirements, and BYNET tuning.

• Integration with enterprise infrastructure: DNS, NTP, monitoring stacks, and identity providers.

Automation, scripting & tools

• Scripting languages: Bash, Python, Perl for automation, maintenance, and custom monitoring. – one of them

• Configuration management and automation tools: Ansible, Terraform, Chef, or Puppet (as used in the enterprise). – one of them

• Familiarity with Teradata utilities and tools: BTEQ, FastLoad, MultiLoad, TPT (Teradata Parallel Transporter), DBSControl, Viewpoint, Teradata Studio/SQL Assistant. – one of them

Observability & tooling

• Use of monitoring/alerting tools (Viewpoint, Prometheus, Grafana, Splunk, Nagios, etc.) and designing dashboards and alerts. One of them, View point is mandatory

• Capacity planning, trending, and forecasting for CPU, disk, spool, and concurrency.

Soft skills & organizational capabilities

• Incident management and on-call experience

• Leading postmortems, RCA (root-cause analysis), implementing corrective actions.

• Communication and stakeholder management: vendors, management and applications

• Translate technical impacts to business stakeholders; coordinate with DBAs, developers, network/storage teams, and vendors.

Role and Responsibilities

Installs, configures and upgrades Teradata software and related products.

• Backup, restore, migrate Teradata data and objects

• Establish and maintain backup and recovery policies and procedures.

• Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum downtime

• Implements and maintains database security.

• Sets up and maintains documentation and standards.

• Supports multiple Teradata Systems including independent marts/ enterprise warehouse.

• Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance.

• Responsible for improvement and maintenance of the databases to include rollout and upgrades.

• Responsible for implementation and release of database changes as submitted by the development team, Working with end customer

• Teradata, customer, datacenter, vendor co-ordinations

• Forecast data, security audits

• User account and access management

• Teradata active system management and customer requests and system allocation

• Backup and recovery

• SOX compliance and audits

• DB support from 3rd party vendors

• Product evaluations

• On call support and major incidents

• Backup restore, frequency and retention

• Disaster recovery

• Create long r

Position Title: Manual Tester [API / SQL]

Location: Mountain View, CA (Hybrid 3 days)

Duration: 6 Months contract to hire

Interview - 2 rounds [1st Video and 2nd In-Person]

Please find complete job description below:

• 8+ hands-on years of manual testing and test automation experience (nice to have).
• Need Manual and Automation exp, candidates should be willing to start with manual testing and gradually move to automation.
• Good experience in API Testing.
• Need selenium or web driver exp.
• Solid exp is SQL queries (Advance to expert level).
• Good expertise in complex SQL queries.
• Oracle and Postgres databases.
• Nice to have experience in AWS/Azure/GCP.
• Demonstrated experience with WebDriverIO or any Selenium test frameworks or similar open-source automation framework.
• Solid understanding and experience of writing locators in selenium.
• Cucumber, Mocha, or similar BDD test scripts development experience.

Additional Preferred Skills:

• Experience with Mobile testing tools in Appium, XCUI Test, Espresso
• Experience with Docker, Kubernetes, Tomcat, Weblogic

Job Title: Store Manager

Reporting to: Head of Retail

Location: Buckhead Avenue, Atlanta, Georgia, 30305

Contract Type: Full time, 40 hours per week

About the Company:

ME+EM London is one of the UK's fastest-growing modern luxury fashion labels. As well as a successful global digital business, we have stores in London and Edinburgh, concessions in Harrods and Selfridges, and recently opened US stores in Manhattan, SoHo, East Hampton, Dallas, Greenwich & LA

At ME+EM we are an entrepreneurial, creative, and passionate group of people. We work hard, are enthusiastic to learn and are not afraid to take risks. Everyone contributes to our success at all levels, and that precisely what makes being a member of the team so rewarding.

Our office and stores are always busy and fast paced, but we work just as hard to make sure it's fun, with social activities and biannual parties. We pride ourselves on being approachable, supportive, and welcoming and ensure that everyone's hard work is rewarded. It takes all these things to build a strong, successful business and our door is always open to new talent ready to contribute to our growth and evolution.

About the Role:

The ME+EM Store Manager is an entrepreneurial lover of clothes, who is dedicated to customer service, team morale and driving results. Responsible for overseeing the overall operations of the store, managing team performance and leading by example. Your focus is that all store aspects, from inventory management to visual merchandising, from store reporting to finance management, are running smoothly. You have a keen understanding of the brand vision and stay up to date on industry trends. You understand the role of retail in our omnichannel business while representing the brand ethos.

Responsibilities:

Leadership

• Understand the store target and relay this to the team. Explain how company bonus works.
• Work toward set objectives and feedback regularly to the Head of Retail and MT to ensure their store always has the best chance to achieve optimum results.
• Manage staff uniform and dress code policy.
• Encourage dress code compliance following the policy.
• Display and ensure high level of telephone etiquette when using the store phone and able to train others to the same standard.
• Ensure a professional tone is used when using company email addresses.
• Coordinate and monitor the activities of the team.
• Lead by example, creating a professional, fair and inclusive working environment.
• Ensure the protection of confidential information to build trust.
• Create a culture of coaching and feedback.

People Management

• Be the first point of call for all people related issues within your store and loop in the Senior People Advisor and Head of Retail for regular support.
• Carry out the first stage interviews with the support of the Talent Acquisition Specialist, and ensure the candidate meet with the Head of Retail for the final stage of the recruitment process.
• Carryout instore onboarding sessions, setting expectations for the first 3 months and welcoming your new starter to the store.
• Ensure the new starter attends the HR onboarding session.
• Carryout regular feedback meetings: 3-month probation reviews, annual appraisals and performance meetings, seeking support from the Senior People Advisor if there is performance issues.
• Create monthly rota effectively to cover both logistics, VM and trading hours.
• Manage staff admin including hours worked against what is recorded in Humanity, ensure regular breaks are taken and casual contractor invoices are correct and submitted in time for payroll.
• Manage staff admin in regard to sickness monitoring, return to work interviews and providing additional and individual support and guidance.
• Keep up to date with company policies and ensure the team are trained in all areas of compliance with the support of the Compliance and Training Coordinator.
• Identify training needs and arrange store training sessions to fill the gaps with the Compliance and Training Coordinator, Senior People Advisor and Head of Retail or any external resources.
• Delegate tasks in an appropriate manner and follow up their execution.
• Follow company procedures to report any maintenance issues in store promptly.

Customer

• Be confident in building organic and long-lasting relationships with customers.
• Carryout personal styling sessions with confidence.
• Be aware of the importance of CRM and explain this to the team.
• Promote where possible the omni channel experience.
• Confidently offer solutions to customer queries and complaints following the standards set by the Company. Escalate serious complaints and queries to the Head of Retail and the Customer Care Team.

Product

• Ensure high level of product knowledge which can inform merchandising actions, stock movement and replenishment for their location.
• Ensure the store display represents the design intent for each garment with the support of the VM Manager.
• Daily stock accuracy and stock room management. Ensure the protection and use of stock is in the best interests of the business.
• Some locations will have the additional support of a stockroom controller.
• Lead the store recall process and monitor, question and be accountable for the accuracy of stock.

System

• Adapts easily to system changes and leads these in a positive manner to the store teams.
• Work alongside the Customer Care team and other operational functions to ensure policies and procedures are aligned to ensure the best customer experience is achieved.
• Understand Elucid and continually strive to develop the system and suggest improvements to IT and operations.

Benefits:

• 401(k)
• Dental insurance
• Employee discount
• Flexible schedule
• Health insurance
• Paid time off
• Vision insurance

ME+EM is an equal opportunities employer committed to fostering and preserving a culture of diversity, equality, and inclusion in our workforce. As an equal opportunities' employer, we do not discriminate against applicants based on race, colour, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. We believe that diversity enriches our workforce and strengthens our organisation. Therefore, we encourage minorities, LGBTQ+ candidates, and individuals with disabilities to apply for opportunities within our company.

Please note, due to the large number of applications we receive, we can only reply to those that are successful to the next stage.

Junior Account Manager

We are looking for a Junior Account Manager to act as the first point of contact with new customers, answer their queries and increase client satisfaction.

If you enjoy coming up with effective solutions and working toward achieving goals, this job is right for you. You will use your communication skills to identify and address clients’ needs while representing our company in a positive way. Previous customer service experience will be an advantage.

Ultimately, you will contribute to building profitable, long-term relationships with our clients to reach our business objectives.

Responsibilities

• Gather information on assigned clients
• Contact clients to understand their needs
• Provide after-sales support to retain customers
• Ensure prompt and accurate answers to clients’ queries
• Build strong client relationships, through regular communication
• Report on the status of accounts
• Suggest company products/services that maximize client satisfaction
• Communicate product and pricing details clearly
• Promote new products/services to existing customers

Requirements and skills

• Proven work experience as a Junior Account Manager or relevant sales role
• Understanding of sales principles and ability to deliver excellent customer experience
• Strong (verbal and written) communication skills with an ability to build relationships
• Effective presentation and negotiation skills
• High degree of professionalism
• Good time-management skills with a problem-solving attitude

Job title: QAD Techno functional Consultant

Pre-Screening Questionnaire:

QAD EE Implementation experience?

Experience in PROGRESS 4GL/Open Edge?

Experience in QAD EE with distribution, shipping, manufacturing, costing and finance

Experience in integration with multiple ERP

Must Have Technical/Functional Skills:

Should have strong domain knowledge in distribution, manufacturing, shipping and finance area with QAD EE

Required have strong experience in manufacturing and shipping.

Shall have strong knowledge on discrete orders, schedule orders, EDI, MRP, RSS, MSW/PSW and Costing, including Requirement gathering, Solution Design and Configurations, integration, end to end functional testing.

Should have hands on experience in Qxtend and QAD cloud, 3PL

Proven experience conducting analysis sessions to understand the functional and technical needs of project requirements and document.

Interact with remote/offshore developer to pass on the requirement, make them understand the functional flow, assist with any queries and ensure development is done within time and quality

Understanding of how QAD customization works

Must have strong knowledge on PROGRESS 4GL/Open Edge

Shall be able to write queries to resolve issues

Experience in integration through Mulesoft would be added advantage

Experience in integration with multiple ERP

• Gather, analyze, and translate business requirements into detailed technical specifications
  
  
• Conduct stakeholder interviews to define scope, timelines, and deliverables
  
  
• Ensure solutions align with budgets, project deadlines, and business objectives
  
  

• Assist with system design, development, deployment, and ongoing support
  
  
• Collaborate with programmers and developers throughout the SDLC
  
  
• Support infrastructure improvements to enhance scalability and integration
  
  

• Manage projects from concept through implementation
  
  
• Interface with internal clients to define scope and deliver results
  
  
• Mentor and review work of other Business Systems Analysts
  
  

• Develop and execute detailed test plans
  
  
• Create and maintain process documentation and workflows
  
  
• Review and edit technical documentation across IT teams
  
  
• Track product updates to ensure documentation stays current
  
  

• Establish standards for IT documentation, forms, and workflows
  
  
• Create scalable processes that ensure operational consistency
  
  

• High school diploma or GED
  
  
• 10+ years of related experience OR equivalent combination of education and experience
  
  
• Strong analytical and problem-solving skills
  
  
• Ability to communicate complex technical concepts to non-technical audiences
  
  
• Experience supporting application development and system implementation
  
  

• Bachelor’s degree in Computer Science, Business Information Systems, or related field
  
  
• Experience with billing, collections, or revenue cycle systems
  
  
• Healthcare industry experience
  
  
• Working knowledge of SQL and ability to write basic queries
  
  
• Experience with legacy systems or Query tools
  
  

• Microsoft Office (Outlook, Word, Excel)
  
  
• Email and internet-based research tools
  
  
• General office and remote work technology
  
  

• Strong written and verbal communication
  
  
• High attention to detail
  
  
• Ability to manage multiple priorities
  
  
• Self-starter with excellent organizational skills
  
  
• Ability to work independently and collaboratively
  
  
• Discretion when handling confidential information
  
  

• Remote flexibility
  
  
• Competitive salary + bonus potential
  
  
• Growth-oriented IT environment
  
  
• Collaborative, supportive culture
  
  
• Meaningful work supporting essential services nationwide