One To Many Database Example Jobs in Usa

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

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.

Powerwell is a leading recruitment firm helping our clients discover top talent. We are recruiting for an Intellectual Property (IP) Patent Paralegal. Candidates must have at least five years of IP Patent Paralegal experience and be able to work a hybrid work schedule.

Job Description:

Our client is a premier business law firm, based in Michigan with an international practice and recently recognized in Michigan as one of the 101 Best and Brightest Places to Work. We are seeking an Intellectual Property Patent Paralegal/Specialist to provide legal support on a variety of tasks focused on patent matters, including gathering of preliminary technical information for patent assessment, monitoring deadlines for various domestic and foreign patent activities, and handling routine activities in connection with the maintenance and protection of domestic and foreign patents. The person will also assist with the docketing of U.S. and foreign patent matters, including patents, license agreements, and related contested matters.

Additional Information:

• Looking to fill this role in Kalamazoo, MI; Ann Arbor, MI; Bloomfield Hills, MI; Lansing, MI; Grand Rapids, MI; Chicago, IL; Washington, D.C. offices.
• Hybrid/4 days in office for the first 6 months. 3 days in the office, 2 days at home is standard firm policy.

Responsibilities:

• Coordinates domestic and international filings with the USPTO and foreign law offices and/or other foreign entities.
• Maintains docket system of due dates for actions including responses, renewals, oppositions, Patent Cooperation Treaty (PCT) requirements and payment of patent annuities in foreign countries.
• Prepares and files various documents with the USPTO or foreign counsel.
• Prepares and records assignments.
• Prepares correspondence to clients.
• Prepares status summary reports for attorneys and clients.
• Reviews and takes action on correspondence received from foreign associates.
• Obtains legalizations and certifications.
• Research and compile information pertaining to national and international patent rights including searches of USPTO records, industry databases and general legal research.

Qualifications:

• Bachelor's Degree required and Paralegal Certification preferred.
• At least five years of IP Patent experience required.
• Knowledge of and familiarity with U.S. and foreign patent work (prosecution, maintenance and renewals).
• Strong computer literacy, including proficiency in Word, Excel, and the ability to work with Innovation, PATTSY, Lexis/Nexis, and other research databases.
• Must be a problem solver, willing to work and think with independence, handle confidential information with discretion, and accept responsibility for producing work that is consistently complete and accurate.
• Exceptional organizational skills, highly versatile and adaptable and able to multi-task in a pressured environment.
• Ability to handle a high volume of work and work through projects with minimal supervision.
• Strong attention to detail and follow-up skills.
• Strong interpersonal and teamwork skills.
• Excellent work ethic and a commitment to professionalism.
• Willingness to learn and use new research materials and practice tools.

Our Client's Benefits:

• Medical coverage:
• Comprehensive medical plan options are available: HDHP, HMO, or PPO.
• Option to receive a monthly stipend for waiving medical coverage.
• Health savings account option available to those who enroll in HDHP.
• Dental coverage:
• Firm-paid monthly premium for comprehensive dental coverage for employee and eligible family members.
• No age limit on orthodontic coverage.
• Optical coverage:
• Firm-paid monthly premium for comprehensive optical coverage for employee and eligible family members.
• Wellbeing:
• Student loan debt refinancing through Sofi and CommonBond.
• Mortgage loans and refinancing through Rocket Mortgage, LLC.
• CPR/AED training.
• Employee Assistance Program (including free Travel Assistance).
• Homethrive Caregiving Assistance Program
• TOOTRiS Childcare Sourcing Program
• 401(k):
• Firm-paid matching contribution of 25% on the first 5% of compensation contributed; immediate 100% vesting in matching contributions.
• Employee may contribute up to 50% of annual compensation, subject to the IRS limits and participation may start as early as 3 months after hire.
• Plan permits Roth contributions, after-tax contributions, and hardship distributions.
• Profit Sharing:
• Firm-paid annual contribution of 5% of compensation into your retirement account; immediate 100% vesting in profit sharing contributions.
• 1 year waiting period waived for business professionals with 10 years' legal industry experience.
• Life Insurance and Accidental Death and Dismemberment (AD&D):
• Firm-paid premium for Basic Life and Accidental Death and Dismemberment insurance coverage.
• Supplemental life insurance, supplemental AD&D insurance, and dependent life insurance available at an additional cost.
• Disability Income Protection:
• Firm-paid premium for disability coverage.
• Advantageous option to pay tax on the Firm-paid premium for a tax-free benefit.
• Disability benefit is 60% of base earnings.
• Reimbursement Programs:
• Fitness reimbursement for fitness improvement programs or the purchase of fitness equipment.
• Transportation allowance offered to employees who work in offices where they must pay to park.
• Tuition Reimbursement of up to $2,500 annually for eligible tuition costs.
• Voluntary Benefits:
• Flexible spending accounts for both health care and dependent care
• Long-Term Care Insurance
• Critical Illness Insurance
• Accident Plan Insurance
• Pet Insurance
• Discounts:
• A wide variety of discounts are offered through Firm clients and vendors, such as:
• Travel and entertainment
• Computer purchases
• Mobile device services
• Vehicle purchases (GM, Ford, and Volkswagen)
• Paid Time Off:
• Generous paid time off All Purpose Leave (APL) program
• Paid holidays
• Paid parental, bereavement, and jury duty leave.
• Flexible scheduling
• Paid time off for Firm sponsored community service event(s).
• Rewards & Recognition:
• Competitive compensation program
• Performance-based bonus opportunity
• Anniversary gift program, S.T.A.R. awards, annual business professional appreciation celebration, new baby, marriage, and employee birthday recognition, on-site celebrations of milestone events, holidays, and more!
• Community Involvement:
• The Firm supports and sponsors many community involvement events, e.g., Chapter One Volunteer Tutoring program and the Client Annual Day of Service.

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.