Ceic Database Jobs in Usa

Hybrid: Applicants must be a California resident as of their first day of employment.

PRINCIPAL RESPONSIBILITIES:

Member Services Representatives (MSR) are the first point of contact for our members' primary contact with the Alliance for both routine and complex member issues with the goal of delivering excellent customer service to our customers. The position is responsible for answering a high volume of inbound and outbound calls in a timely manner. Respond to all communications coming into Member Services in the form of email, fax, letters, chat and phone calls. Timely responses to all member communication are essential. Must effectively prioritize and flex the workload as new communication and tasks are submitted. Identify the caller's needs, clarify information, research issues, and provide solutions and/or alternatives whenever possible. Accurately and consistently document all conversations in the electronic database. This position is a liaison between the plan, the provider network, and other community agencies. The MSR positions are flexibly staffed classification and work is expected to be performed minimally at the MRS II level. However, the initial selection will be made at the entry level MSR I. Our more advanced level position of the series is the MSR III who will be required to perform a variety of complex matters.

Member Services Representatives are under the direction of a Member Services Supervisor, Manager and Director, and service our members through our call center as well assisting other departments with responses to member issues by initiating communication between departments to ensure action, cooperation, and compliance of managed care operations.

Member Services Representative I

This position which requires the ability to work as a team player within the Alliance and with external contacts, make sound judgments based on analysis of information, be an effective communicator, active listener and balance advocacy for the member with the policy provisions such as plan policies, EOC, regulatory guidelines, and DMHC/DHCS rules and regulations. The MSR provides courteous, professional, and accurate responses to incoming inquiries regarding network, plan benefits, eligibility, authorizations, plan services and guidelines, as well make decisions with the goal of ensuring member satisfaction and retention. The MSR performs a variety of complex functions and is also responsible for maintaining accurate and complete inquiry/grievance records in the electronic database. Maintains compliance with DMHC regulatory requirements and DHCS contractual obligations. MSR I staff who demonstrate proficiency in meeting, maintaining and exceeding principal performance objectives and metrics may be eligible to be promoted to a Member Services II or III role. Member Services Representative I staff may be eligible for promotion to Member Services Representative II or III positions once they have worked as a MSR I for a minimum of 12 months to be proficient with program and system knowledge in addition to meeting performance matrix requirements.

Principle duties and responsibilities

* Serve as the primary contact for members, providers and others for questions related to claims, benefits, authorizations, pharmacy, member eligibility and other questions related to Alameda Alliance and provide accurate, satisfactory answers to their inquiries or concerns.

* Respond to and resolve member service inquiries and issues by identifying the topic and type of assistance the caller needs such as benefits, eligibility, claims, behavioral health, and care coordination.

* Answer incoming calls, emails, chats, and other requests for assistance in a timely manner in accordance with departmental performance targets and provide excellent customer service while doing so. May include assisting members in person.

* Recognize and understand the difference between calls that require quick resolutions and calls which will require follow-up and handle each appropriately.

* De-escalate situations involving dissatisfied customers, offering patient assistance and support.

* Accurately document all contacts per department standards/guidelines in the Customer Relationship Management (CRM) system.

* Accurately and consistently document (electronic database) and resolve Exempt Grievances (any expression of dissatisfaction that are not coverage disputes, disputed health care services involving medical necessity, or experimental or investigational treatment and that are resolved by the next business day following receipt).

* Interface with Grievance and Appeals, Claims, Enrollment, IT, Network Management, Pharmacy, Authorizations, and other internal departments to provide Service Excellence to our members.

* Help guide and educate members about the fundamentals and benefits of managed health care topics, to include managing their health and well-being by selecting the best benefit plan service options, maximizing the value of their health plan benefits, and choosing a quality care provider.

* Intercede with care providers (doctor's offices) on behalf of the member, assisting with appointment scheduling; connect members with internal Case Management Department for assistance as needed.

* Assist members in navigating , the Member Portal, and other health care partner online resources and websites to encourage/reassure them to use self- service tools that are available.

* Manage any issues through to resolution on behalf of the member, either on a single call or through comprehensive and timely follow-up.

* Research complex issues across multiple databases and work with support resources to resolve member issues and/or partner with others to resolve escalated issues.

* Provide education and status on previously submitted pre-authorizations or pre- determination requests for both medical and pharmaceutical benefits.

* Meet the performance goals established for the position in the areas of compliance, efficiency, call quality, member satisfaction, first call resolution, punctuality, and attendance.

* Always maintain a professional level of service to members.

* Always maintain confidentiality of information.

* Consistently support the Alliance's approach to Service Excellence by adhering to established department and company standards for all work-related functions.

* Interact positively with all Alliance Departments.

* Accurately and consistently document (electronic database) and resolve Exempt Grievances (any expression of dissatisfaction that are not coverage disputes, disputed health care services involving medical necessity, or experimental or investigational treatment and that are resolved by the next business day following receipt).

* Process MS Dept projects

* Serve as a back-up to manage the escalated calls.

* Perform other duties as assigned.

ESSENTIAL FUNCTIONS OF THE JOB

* Contacts: Receive, manage, and document telephone calls, emails, and other sources of contacts from members, potential members, and providers, and explain health plan benefits and plan rules. Describe the types of services the Alliance offers to the Member within the managed care system. Provide clarification about issues regarding patient and physician rights and how the plan operates.

* Conflict resolution: Resolve member problems/conflicts by convening with other departmental staff as needed.

* Member communications: Create and/or mail appropriate member materials and communications as needed.

* Computer: Perform ongoing data entry which assists in the maintenance of the Member Services department database to ensure data integrity.

* Comply with the organization's Code of Conduct, all regulatory and contractual requirements, organizational policies, procedures, and internal controls.

PHYSICAL REQUIREMENTS

* Constant and close visual work at desk or computer.

* Constant sitting and working at desk.

* Constant data entry using keyboard and/or mouse.

* Constant use of multi-monitor setup

* Frequent use of telephone and headset.

* Frequent verbal and written communication with staff and other business associates by telephone, correspondence, or in person.

* Frequent lifting of folders, files, binders, and other objects weighing between 0 and 30 lbs.

* Frequent walking and Standing

Number of Employees Supervised: 0

MINIMUM QUALIFICATIONS:

* Bachelor's degree or equivalent experience preferred.

* High school diploma, GED required.

* The ability to speak and understand-bilingual: Spanish/English, Cantonese/English, Vietnamese/English, Tagalog/English are required as designated.

* A bilingual proficiency exam will be administered to ensure the candidate possesses the appropriate skill level to meet requirements. The successful candidate must score 90% or higher.

MINIMUM YEARS OF ADDITIONAL RELATED EXPERIENCE:

* Minimum one year of direct customer service experience. Call center experience and managed care experience a plus

* Experience determining eligibility for financial assistance, insurance benefits, unemployment and/or other social services programs.

* Demonstrated knowledge expert of AAH Member Services policies and procedures

* Consistent record of meeting, maintaining, or exceeding monthly Departmental performance metrics.

* Consistent track record of documenting Service Requests accurately and clearly and monitoring open Service Requests to ensure responses and closure.

* Consistent record of high quality of work as demonstrated through call and documentation auditing, appropriate Call Disposition coding, as well as an overall acceptable monthly Member Satisfaction Survey result as assessed by Member Services Quality Specialist, MS Trainer and Member Services Supervisor.

* Demonstrated proficiency in current Customer Relationship Management (CRM) tool, phone system software Quality Management Solution, Pharmacy Benefits Management applications (PBM), Interpreter vendor scheduling software, delegate portal solutions and the Alliance's Member portal.

* Demonstrated ability to effectively handle the department's key special projects: Member Portal Request Processing, Kaiser PTE Requests, PCP retroactive and same month requests.

* Demonstrated ability to help members face-to-face in the field and/or at the Alliance offices (walk-ins). Also highly skilled at handling issues related to member bills, transportation set-up and benefit coordination with providers and pharmacy needs.

SPECIAL QUALIFICATIONS (SKILLS, ABILITIES, LICENSE):

* Ability to prioritize and adapt to changing situations in a calm and professional manner.

* Ability to maintain composure in stressful situations.

* Excellent problem-solving skills

* Ability to exhibit cooperation, flexibility, and provide assistance when talking to members, providers, and staff.

* Skill in basic data entry

* Ability to type 40 net words per minute: multi-task

* Manual dexterity to operate telephone, computer keyboard equipment.

* Speak English proficiently, clearly, and audibly.

* Memorize and retain information quickly; meet physical requirements

* Spell correctly

* Learn the policies, regulations, and rules applicable to business operations.

* Follow instructions, reason clearly, analyze solutions accurately, act quickly and effectively in emergency situations; operate office equipment including computers and supporting word processing, spreadsheet, and database applications.

* Excellent phone etiquette and ability to communicate clearly and concisely, both orally and in writing.

* Excellent interpersonal skills with the ability to interact with diverse individuals and flexibility to customize approach to meet all types of member communication styles and personalities.

* Strong verbal and written communication skills.

* Demonstrated ability to quickly build rapport and respond to members in a compassionate manner by identifying and exceeding member expectations (responding in respectful, timely manner, consistently meeting commitments).

* Demonstrated ability to listen skillfully, collect relevant information, determine immediate requests, and identify the current and future needs of the member.

* Must be self-motivated and able to work with minimal supervision

* Must be team-oriented and focused on achieving organizational goals.

* Proficient problem-solving approach to quickly assess current state and formulate recommendations.

* Proficient in translating healthcare-related jargon and complex processes into simple, step-by-step instructions which members can understand and act upon.

* Proficient conflict management skills to include ability to resolve issues during stressful situations and demonstrating personal resilience.

* Ability to work regularly scheduled shifts within the Alliance's hours of operation including the training period, with scheduled lunches and breaks, flexibility to adjust daily schedules; and to work over-time and/or weekends as needed.

* Medical terminology knowledge preferred

* Ability to work within a broad systems perspective

* Experience in use of various computer systems software as well as Microsoft Windows, and Microsoft Suite, especially Outlook, Word, Excel.

* Must have reliable and stable internet connection for remote work (50-100 Mbps download speeds).

Employees who interact with members of the public may be required to be tested for Tuberculosis and fully vaccinated against COVID-19 and influenza. Successful candidates for those positions/ classifications may be required to submit proof of vaccination against influenza and/or COVID-19, a negative Tuberculosis test, or request an exemption for qualifying medical or religious reasons during the onboarding process. Candidates should not present proof of vaccination until instructed to do so by the Human Resources department.

SALARY RANGE $22.88-$34.33 HOURLY

The Alliance is an equal opportunity employer and makes all employment decisions on the basis of merit and business necessity. We strive to have the best-qualified person in every job. The Alliance prohibits unlawful discrimination against any employee or applicant for employment based on race, color, religious creed, sex, gender, transgender status, age, sexual orientation, national origin, ethnicity, citizenship, ancestry, religion, marital status, familial status, status as a victim of domestic violence, assault or stalking, military service/veteran status, physical or mental disability, genetic information, medical condition, employees requesting accommodation of a disability or religious belief, political affiliation or activities, or any other status protected by federal, state, or local laws.

About Wakefern

Wakefern Food Corp. is the largest retailer-owned cooperative in the United States and supports its co-operative members' retail operations, trading under the ShopRite®, Price Rite®, The Fresh Grocer®, Dearborn Markets®, and Gourmet Garage® banners.

Employing an innovative approach to wholesale business services, Wakefern focuses on helping the independent retailer compete in a big business world. Providing the tools entrepreneurs need to stay a step ahead of the competition, Wakefern’s co-operative members benefit from the company’s extensive portfolio of services, including innovative technology, private label development, and best-in-class procurement practices.

The ideal candidate will have a strong background in designing, developing, and implementing complex projects, with focus on automating data processes and driving efficiency within the organization. This role requires a close collaboration with application developers, data engineers, data analysts, data scientists to ensure seamless data integration and automation across various platforms. The Data Integration & AI Engineer is responsible for identifying opportunities to automate repetitive data processes, reduce manual intervention, and improve overall data accessibility.

Essential Functions

• Participate in the development life cycle (requirements definition, project approval, design, development, and implementation) and maintenance of the systems.
• Implement and enforce data quality and governance standards to ensure the accuracy and consistency.
• Provide input for project plans and timelines to align with business objectives.
• Monitor project progress, identify risks, and implement mitigation strategies.
• Work with cross-functional teams and ensure effective communication and collaboration.
• Provide regular updates to the management team.
• Follow the standards and procedures according to Architecture Review Board best practices, revising standards and procedures as requirements change and technological advancements are incorporated into the >tech_ structure.
• Communicates and promotes the code of ethics and business conduct.
• Ensures completion of required company compliance training programs.
• Is trained – either through formal education or through experience – in software / hardware technologies and development methodologies.
• Stays current through personal development and professional and industry organizations.

Responsibilities

• Design, build, and maintain automated data pipelines and ETL processes to ensure scalability, efficiency, and reliability across data operations.
• Develop and implement robust data integration solutions to streamline data flow between diverse systems and databases.
• Continuously optimize data workflows and automation processes to enhance performance, scalability, and maintainability.
• Design and develop end-to-end data solutions utilizing modern technologies, including scripting languages, databases, APIs, and cloud platforms.
• Ensure data solutions and data sources meet quality, security, and compliance standards.
• Monitor and troubleshoot automation workflows, proactively identifying and resolving issues to minimize downtime.
• Provide technical training, documentation, and ongoing support to end users of data automation systems.
• Prepare and maintain comprehensive technical documentation, including solution designs, specifications, and operational procedures.

Qualifications

• A bachelor's degree or higher in computer science, information systems, or a related field.
• Hands-on experience with cloud data platforms (e.g., GCP, Azure, etc.)
• Strong knowledge and skills in data automation technologies, such as Python, SQL, ETL/ELT tools, Kafka, APIs, cloud data pipelines, etc.
• Experience in GCP BigQuery, Dataflow, Pub/Sub, and Cloud storage.
• Experience with workflow orchestration tools such as Cloud Composer or Airflow
• Proficiency in iPaaS (Integration Platform as a Service) platforms, such as Boomi, SAP BTP, etc.
• Develop and manage data integrations for AI agents, connecting them to internal and external APIs, databases, and knowledge sources to expand their capabilities.
• Build and maintain scalable Retrieval-Augmented Generation (RAG) pipelines, including the curation and indexing of knowledge bases in vector databases (e.g., Pinecone, Vertex AI Vector Search).
• Leverage cloud-based AI/ML platforms (e.g., Vertex AI, Azure ML) to build, train, and deploy machine learning models on a scale.
• Establish and enforce data quality and governance standards for AI/ML datasets, ensuring the accuracy, completeness, and integrity of data used for model training and validation.
• Collaborate closely with data scientists and machine learning engineers to understand data requirements and deliver optimized data solutions that support the entire machine learning lifecycle.
• Hands-on experience with IBM DataStage and Alteryx is a plus.
• Strong understanding of database design principles, including normalization, indexing, partitioning, and query optimization.
• Ability to design and maintain efficient, scalable, and well-structured database schemas to support both analytical and transactional workloads,
• Familiarity with BI visualization tools such as MicroStrategy, Power BI, Looker, or similar.
• Familiarity with data modeling tools.
• Familiarity with DevOps practices for data (CI/CD pipelines)
• Proficiency in project management software (e.g., JIRA, Clarizen, etc.)
• Familiarity with DevOps practices for data (CI/CD pipelines)
• Strong knowledge and skills in data management, data quality, and data governance.
• Strong communication, collaboration, and problem-solving skills.
• Ability to work on multiple projects and prioritize tasks effectively.
• Ability to work independently and in a team environment.
• Ability to learn new technologies and tools quickly.
• The ability to handle stressful situations.
• Highly developed business acuity and acumen.
• Strong critical thinking and decision-making skills.

Working Conditions & Physical Demands

This position requires in-person office presence at least 4x a week.

Compensation and Benefits

The salary range for this position is $75,868 - $150,644. Placement in the range depends on several factors, including experience, skills, education, geography, and budget considerations.

Wakefern is proud to offer a comprehensive benefits package designed to support the health, well-being, and professional development of our Associates. Benefits include medical, dental, and vision coverage, life and disability insurance, a 401(k) retirement plan with company match & annual company contribution, paid time off, holidays, and parental leave.

Associates also enjoy access to wellness and family support programs, fitness reimbursement, educational and training opportunities through our corporate university, and a collaborative, team-oriented work environment. Many of these benefits are fully or partially funded by the company, with some subject to eligibility requirements

• 
  
• Responsible for providing assistance in the acquisition, negotiation and renewal functions related to IT vendor contracts. Register vendors for IT contracts and manages databases for IT vendor contracts.
  
• 35% Assists in the acquisition, negotiation, and renewal functions related to IT vendor contracts. Reviews, analyzes and creates hierarchy for IT vendor agreements. Maintains and updates various IT vendor databases in support of area workflow and department projects.
  
• 35% Perform quality reviews of databases to ensure agreements are entered correctly. Works with staff to correct and advise of proper protocols.
  
• 10% Trains and assists new employees with processes and procedures of the databases. Creates work instructions, procedures and standards for databases.
  
• 10% Request vendor registrations from new and established vendors and assists IT Payables with finalizing the required documentation.
  
• 10% Creates, reviews, maintains, and completes various reports for management.
  

• 
  
• This position manages key vendor and contract activities, including requesting vendor registrations and assisting IT Payables with required documentation.
  
• Responsibilities include supporting renewal functions for critical IT vendor contracts, reviewing and analyzing reports for senior leadership, and collaborating closely with the Chief Negotiator, IS Negotiation team, and key vendors.
  
• The position also involves maintaining and updating IT vendor databases to ensure accurate workflow and support department projects.
  

• 
  
• Fast paced, multi-platformed environment which may require action and response 24X7 to support the technical business needs of the customer.
  

• 
  
• This department operates in a fast-paced environment, supporting a wide range of customers across BCBSSC and most of various lines of business. Our work often involves tight deadlines, with busy end of quarters, a very busy end of year for renewals, and at times it may require overtime to meet critical deliverables.
  
• We're a close-knit team that values collaboration and support. While we work in a high-functioning environment and pride ourselves on being hardworking, we also make space for fun and positivity.
  
• We partner closely with other teams across the AIMS organization. Our culture is a safe, inclusive space where everyone feels accepted and respected, and we welcome diverse perspectives.
  

• 
  
• 4 years project coordination or other related work experience.
  

• 
  
• Bachelor's Degree
  
• Degree Equivalency: 4 years job related work experience or Associate's and 2 years job related work experience
  

• 
  
• Excellent organizational skills and quality research skills.
  
• Excellent verbal and written communication skills.
  
• Demonstrated skills to work with and assist others.
  
• Ability to acquire in-depth knowledge of department functions, procedures and workflow.
  
• Analytical or critical thinking skills.
  
• Good judgment skills.
  
• Ability to handle confidential or sensitive information with discretion.
  
• Ability to work in a team environment and prioritize work effectively.
  
• Ability to assist in the preparation, documentation, and presentation of recommendations to management.
  

• 
  
• Microsoft Office.
  
• Vendor Management experience
  
• Experience communicating with executive level management
  
• Service Now Experience
  

• 
  
• Smart Cloud Control Desktop
  

Performs a variety of technical work in the day-to-day operation of the Public Works Asset Management and Computerized Maintenance Management System (CMMS) Programs. Provide support and training to end users as assigned. These tasks are illustrative only and may include other related duties.

To be considered in the first review, applications must be submitted by Tuesday February 17th, 2026 at 8:00am.

Full-time 40 hours per week

AFSCME-represented position

12-month probationary period

Modifies and maintains CMMS data to support asset data analysis. Works independently with vendors, and Public Works supervisors to assist in program development by gathering information for assets and other new and old data and information needed to allow the asset data system to function effectively; creates new codes for the above areas mentioned and when necessary modifies asset characteristics and descriptions.

Provides daily user support including routine troubleshooting and system and data maintenance for asset data analysis, working closely with Information Technology and GIS to evaluate responsibility for addressing specific requests. Ensures the integration of CMMS with other systems and relevant databases.

Assists with the establishment and maintenance of user profiles within the CMMS, e.g. security settings and access controls for each program user.

Assists with establishing equipment records; associates the manufacturer's maintenance recommendations with the equipment records. Defines, compiles, and incorporates maintenance activities in the CMMS system. Provides guidance and support to end users in the operation, use and capabilities of the CMMS.

Coordinates with Public Works program supervisors to efficiently and accurately enter data into the system. Collects and enters asset data into the CMMS and related databases from various sources including direct field investigation; documents such as as-built drawings, invoices, and O&M manuals.

Generates standard and ad-hoc reports using the standard report structure of the asset data system, and other end user reporting tools. Fulfills requests for reports and information; works with end users to understand business processes and report requirements for assigned projects.

Performs quality control checks of asset data to ensure the accuracy of all data within the system.

Provides input to the division supervisor on system needs, the performance of asset data software and hardware, and improvements to the asset data analysis system.

Provides in-house training programs and manuals for asset management, CMMS, GIS, and other relevant software applications.

Maintains professional networks and attends training sessions and conferences as necessary to advance skills and keep abreast of issues and practices in all areas of responsibility.

Researches and makes recommendations on Asset Management and CMMS needs; monitors the performance of asset data software and hardware and recommends improvements. Assists with CMMS hardware and software upgrades for the asset data analysis system. Ensures the implementation of processes and practices are in support of asset management best practices and are synchronized with GIS. Assists with hardware and software upgrades for the asset data analysis system.

Serves as a member of various City committees as assigned. Assists other staff in the performance of their duties as assigned.

Conforms to all safety rules and performs work in a safe manner.

Performs as a member of a team, assisting with development of work group goals and objectives and contributing to the achievement of goals and objectives.

Complies with all Administrative Policies. Performs work in accordance with Council Policies and Municipal Code sections applicable to the position.

Delivers excellent customer service to diverse audiences. Responds to customer service requests, questions and complaints. Maintains a positive customer service demeanor and delivers service in a respectful and patient manner.

Acts ethically and honestly; applies ethical standards of behavior to daily work activities and interactions. Builds confidence in the City through own actions.

Maintains effective work relationships.

Arrives to work, meetings and other work-related functions on time and maintains regular job attendance.

Operates and drives vehicles and/or equipment safely and legally.

Education and Experience

High School diploma or equivalent required. Four years of related experience, training and/or education in Information Technology, Asset Management or GIS with three of those years in database development and project management in an increasingly responsible capacity.

-OR-

Associates degree in Computer Science, Information Technology or related field, including major coursework in computer science and engineering and significant coursework in database system management. Two years of increasingly responsible related experience in database development and project management.

Related experience includes significant responsibility collecting, entering and verifying data, supporting users, analyzing workflows and data, and reporting.

Prior experience and/or education in the maintenance and use of Asset Management/CMMS/GIS systems preferred.

Knowledge, Skills and Abilities

General knowledge of the principles, theories and methods of database concepts, structures, and programming logic; and the various types, classes, uses, and interrelationships of assets. Knowledge of asset management within a typical municipal Public Works department preferred.

CMMS and GIS software skills are preferred, including creating, editing and reporting on assets, using built-in functions or query languages (e.g. SQL).

Ability to develop procedures and to provide end user training.

Effective communication, analytical, customer service, interpersonal and problem solving skills.

Ability to get along well with co-workers and maintain working relationships; ability to promote a culture of teamwork and communication.

Ability to use a computer to perform essential functions of the position. High level of proficiency using an office productivity software suite and related applications.

Thorough knowledge of traffic laws and defensive driving.

Special Requirements

Ability to pass a pre-employment background and/or criminal history check.

Possession of and the ability to maintain a valid Oregon Driver's License.

Travel among City worksites and to training/conferences is required.

Demonstrable commitment to sustainability.

Demonstrable commitment to promoting and enhancing equity, diversity, and inclusion.

This individual shall not pose a direct threat to the health or safety of the individual or others in the workplace.

Qualified applicants must submit an online application located on theCity of Corvallis website(click on "Apply" above).

Position is open until filled.

First review of applications will occur after 8:00 AM on Tuesday February 17, 2026.

Applicants are required to include a cover letter and resume with the online application;

Resumes will not be accepted in lieu of a completed online application.

Late or incomplete applications will not be accepted/considered.

*Please do not include personal or protected information in attached resumes or cover letters, this includes your birth date, age, dates of education, and graduation dates.*

Loloi Rugs is a leading textile brand that designs and crafts rugs, pillows, and throws for the thoughtfully layered home. Family-owned and led since 2004, Loloi is growing more quickly than ever. To date, we’ve expanded our diverse team to hundreds of employees, invested in multiple distribution facilities, introduced thousands of products, and earned the respect and business of retailers and designers worldwide. A testament to our products and our team, Loloi has earned the ARTS Award for “Best Rug Manufacturer” in 2010, 2011, 2015, 2016, 2018, 2023, and 2025.

Security Advisory: Beware of Frauds

Protect yourself from potential fraud and verify the authenticity of any job offer you receive from Loloi. Rest assured that we never request payment or demand any sensitive personal information, such as bank details or social security numbers, at any stage of the recruiting process. To ensure genuine communication, our recruiters will solely reach out to applicants using an @ email address. Your security is of paramount importance to us at Loloi, and we are committed to maintaining a safe and trustworthy hiring experience for all candidates.

We are building a Business Operations Center of Excellence, and we need a Product Data Analyst to serve as the "Guardian of the Golden Record." In this role, you are the absolute owner of product data integrity as it relates to the digital customer experience. You ensure that every item we sell is accurately represented across every touchpoint—from our ERP and PIM to our website storefront and marketing feeds. This is not a data entry role; it is a high-impact technical logic and investigation role. You will work directly with our Data Platform and Software Engineering teams to define business rules, audit data health via complex SQL, and troubleshoot data transmission errors before they impact the customer.

Responsibilities

• Storefront Governance: Serve as the absolute owner of product data integrity within the PIM. Ensure that all storefront-critical attributes (pricing, dimensions, weights, image links) are accurate and standardized for a seamless customer experience.
• Technical Data Auditing: Write and run complex SQL queries against our centralized database to identify anomalies, "orphan" records, and data hygiene issues that need resolution. You will be expected to query across multiple schemas to validate data consistency between systems.
• Feed Logic & Mapping: You will manage the logic of how data translates from our PIM to external endpoints. You will ensure that our products appear correctly on Google Shopping, Meta, Amazon, and other marketplaces by managing feed rules and mapping definitions.
• API Payload Analysis: You will act as the first line of defense for data transmission errors. If a product isn't showing up on the site, you will review the JSON/XML response bodies to determine if it is a data payload error or a software code bug.
• Cross-Functional Impact Analysis: You will act as the gatekeeper for data changes, predicting downstream impacts (e.g., "If Merchandising changes this Category Name, it will break the Finance reporting filter").
• Hygiene Logic Definition: You will partner with our IT/Database team to define automated health checks. You identify the "rot" (bad data patterns), and they implement the database constraints to stop it.

What You Will NOT Do (The Boundaries)

• No Web Development: You are not a Front-End Developer. You do not write HTML, CSS, or React code. You ensure the data powering those components is 100% accurate.
• No Manual Data Entry: Your job is not to copy-paste descriptions. You build the systems, bulk processes, and logic that ensure data quality at scale.
• No Database Administration: You do not manage server uptime or schema changes (IT owns this). You own the quality of the records inside the database.

Intersection with Technical Teams

• With IT (Database Mgmt): IT owns the infrastructure and schema; you own the quality of the data within it. When you identify a systemic issue (e.g., "5,000 orphan records"), you partner with IT to implement the technical fix (scripts/constraints).
• With Software Engineering (Commerce): If a product is missing from the site, you check the data payload. If the data is correct, you hand off to Engineering, confirming it is a code/caching bug rather than a data error.

Experience, Skills, & Ability Requirements

• 5-8 years of experience in Data Management, PIM Administration, or technical eCommerce Operations.
• SQL Proficiency: You are comfortable writing queries beyond simple SELECT *. You should be proficient with CTEs (Common Table Expressions), Window Functions (e.g., Rank, Lead/Lag), Subqueries, and complex Joins to act as a forensic data investigator.
• API Fluency: You can read and understand JSON and XML. You know what a valid payload looks like and can spot formatting errors or missing keys.
• Data Manipulation: You are an expert at handling large datasets (CSVs, Excel) and understand data types, formatting standards, and normalization concepts.
• You love hunting down the root cause of an error. You don't just fix the wrong price; you find out why the price was wrong and build a rule to stop it from happening again.
• You have high standards for accuracy. You understand that a wrong weight in the system means a financial loss on shipping for the business.

Bonus Points (Nice-to-Haves)

• Familiarity with Visio/Lucidchart to visualize data flows.
• Ability to build simple dashboards in Tableau to track data health scores.
• Basic familiarity with Python or R for data manipulation.

What We Offer

• Health, dental, and vision benefits
• Paid parental leave
• 401(k) with employer match
• A culture of meritocracy that fosters ongoing growth opportunities
• A stable, growing family-owned company that looks after its employees

Loloi Rugs does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits. We seek a diverse pool of applicants and consider all qualified candidates regardless of race, ancestry, color, gender identity or expression, sexual orientation, religion, national origin, citizenship, disability, Veteran status, marital status, or any other protected status. If you have a special need or disability that requires accommodation, please let us know.

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

Job summary:

We are seeking highly skilled full stack developers with strong expertise in backend development using Java Spring Boot, frontend development using Angular and Drupal. The ideal candidate will have deep database design and optimization skills, experience building scalable web applications and ability to work across the full software development cycle.

Key responsibilities:

Database & Data Management:

• Strong Oracle Database skills.
• Design and maintain relational database schemas (Oracle, MySQL)
• Write complex SQL queries, Stored procedures, triggers, and performance tuned indexes.
• Handle data migration . normalization and optimization for high volume systems.
• Experience with NOSQL database is a plus.

Frontend Development:

• Develop responsive, user-friendly web interfaces using Angular(latest version), HTML, CSS, TypeScript, React etc.
• Work on UI/UX designs and prototypes and translate the designs into functional UI components.
• Optimize frontend performance and ensure cross-browser compatibility.

Web Platform Development:

• Develop, customize, and maintain Drupal-based websites and applications.
• Build and manage custom Drupal modules, themes, content types, and views.
• Integrate Drupal with backend services and third-party systems via APIs.

Backend Development:

• Design, develop and maintain REST APIs and microservices using Java, Spring Boot, Spring MVC and Spring Security.
• Implement business logic, integrations, backend services with high performance and reliability.
• Ensure application security , scalability, and performance best practices.

Other Preferred Skills:

• Participate in CI/CD pipelines, build automation and deployment processes.
• Write unit, integration, and end to end tests.
• Troubleshoot and resolve issues
• Conduct code reviews and ensure adherence to coding standards.
• Additionally, experience with version control (Git/Bitbucket) and DevOps practices (CI/CD, Docker) is crucial.
• Familiarity with Docker and Kubernetes.
• Knowledge of cloud platforms (AWS, Azure)
• Experience working in Agile/Scrum teams.
• Healthcare industry experience.
• Soft skills like communication, teamwork, accountability, ownership, self-driven, analytical thinking and problem-solving are also essential.
• Ability to work independently and collaboratively in cross-functional teams.
• Excellent communication and documentation skills.
• Proactive mindset with attention to detail.

Company Description

Press Ganey is the leading experience measurement, data analytics, and insights provider for complex industries-a status we earned over decades of deep partnership with clients to help them understand and meet the needs of their key stakeholders. Our earliest roots are in U.S. healthcare -perhaps the most complex of all industries. Today we serve clients around the globe in every industry to help them improve the Human Experiences at the heart of their business. We serve our clients through an unparalleled offering that combines technology, data, and expertise to enable them to pinpoint and prioritize opportunities, accelerate improvement efforts and build lifetime loyalty among their customers and employees.

Like all great companies, our success is a function of our people and our culture. Our employees have world-class talent, a collaborative work ethic, and a passion for the work that have earned us trusted advisor status among the world's most recognized brands. As a member of the team, you will help us create value for our clients, you will make us better through your contribution to the work and your voice in the process. Ours is a path of learning and continuous improvement; team efforts chart the course for corporate success.

Our Mission:

We empower organizations to deliver the best experiences. With industry expertise and technology, we turn data into insights that drive innovation and action.

Our Values:

To put Human Experience at the heart of organizations so every person can be seen and understood.

• Energize the customer relationship:Our clients are our partners. We make their goals our own, working side by side to turn challenges into solutions.

• Success starts with me:Personal ownership fuels collective success. We each play our part and empower our teammates to do the same.

• Commit to learning:Every win is a springboard. Every hurdle is a lesson. We use each experience as an opportunity to grow.

• Dare to innovate:We challenge the status quo with creativity and innovation as our true north.

• Better together:We check our egos at the door. We work together, so we win together.

This position is responsible for the successful ingress of client data into Press Ganey databases. Client data is used to generate surveys (mail, phone and email) and to capture patient, employee and demographics for.

Job Duties:

• Creating new and updating existing InfoTurn import templates: Working in the TESTINFO & INFOTURN databases to create templates that will capture records from client uploads. Writing logical expressions to pull data from the files as necessary. Working with Account Managers and client IT contacts to verify upload settings such as languages, sampling, precodes, etc... Using tools to test and validate data. Submits for quality inspection by Senior/Lead EDI. Create FTP account and train client on the transmission process. Monitor uploads after implementation to ensure data imports are successful.
• EDI Cases: works independently to address open EDI cases. Writes advanced SQL statements to troubleshoot and define error causes. Reviews and deciphers FTP Server logs to troubleshoot and resolve advanced connection issues. Removes/alters data residing in the InfoTurn database and coordinates approval from appropriate departments (i.e. InfoTurn, Public Reporting, DAR, Client Experience). Upon request from Client Experience, Patient Advisory Services, Public Reporting or the client, the Senior EDI researches uploaded data concerning records processed, duplicates, errors, mailed, undeliverable, data integrity, FTP connection issues, etc... via V-Train (SQL), Intranet reports, Modify demograph, File Import Explorer, Ppatdemo, File Parser, Ultra-Edit, WS_FTP and/or visual inspection of the imported files.
• Communication: Work with both client and PG staff to coordinate the receipt of test data, data-mapping, and live updates. Explain upload methods and required changes to data. Document and communicate account status to client contacts, Client Experience, Public Reporting and Sales.
• Serve as the assigned EDI resource for large enterprise clients. Manage onboarding of new enterprise clients. Manage and implement newly purchased services and changes to existing client file layout(s). Attend scheduled, recurring and impromptu meetings regarding implementation and service issues. Provide ongoing support for all transmission, configuration and data integrity issues.
• Complete SRF update requests: Update import templates according to custom SRF changes not performed by SRF automation. Including add/remove languages, exclusions, custom expressions, custom lookups, etc... Test and validate data by importing data into the test info database and review stored data to assure accuracy.
• Provide phone support: Answer incoming client phone calls. Address issues relating to imported data, upload file errors, FTP transmission and connection errors. Provide second level support for issues escalated from Associate EDI Specialists and EDI Specialists. Provide direction, correct configuration issues or escalate to Lead EDI, EDI Manager or development teams. Attend scheduled client conference calls.
• Training and mentoring: Assist with training EDI new hires on various subject matters including PG developed applications, off the shelf applications, database structure and PG/EDI policies and procedures. Assist with training new hire Account Managers on Import Maintenance/SRF, CRM and Sales Force. Mentor Associate EDI Specialists, EDI Specialists and Account Managers as needed. Address questions from other departments.
• Participates in planning, user acceptance testing and testing of deployed bug fixes/feature enhancements. Works with developer teams to test and troubleshoot new software/hardware technology products.

Don't meet every single requirement?Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At Press Ganey we are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyways. You may be just the right candidate for this or other roles.

Additional Information for US based jobs:

Press Ganey Associates LLC is an Equal Employment Opportunity/Affirmative Action employer and well committed to a diverse workforce. We do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, veteran status, and basis of disability or any other federal, state, or local protected class.

Pay Transparency Non-Discrimination Notice - Press Ganey will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.

The expected base salary for this position ranges from $54,000to $70,000. It is not typical for offers to be made at or near the top of the range. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, licensure or certifications obtained. Market and organizational factors are also considered. In addition to base salary and a competitive benefits package, successful candidates are eligible to receive a discretionary bonus tied to achieved results.

All your information will be kept confidential according to EEO guidelines.

Our privacy policy can be found here:legal-privacy/