Ediscovery Query Examples Jobs in Usa

Overview

Responsible for database maintenance and direct mail operations including mailing list preparation and deadlines. Responsible for performing analysis on direct mail campaigns, recommend campaign changes and maintaining accurate records. Generate reports and perform audits on direct mail to insure accuracy. Responsible for supervision of Database and Promotional Teams.

Responsibilities

• Responsible for database integrity (security, data cleansing, NCOA, etc.).
• Utilize knowledge of Structured Query Language (SQL), data warehouses, relational databases, and multi-dimensional databases in analyzing various data sources (in-house databases, data warehouse, other third-party data sources, etc.) to develop the queries and procedures for extracting and communicating required information
• Maintain Player Tracking Database
• Responsible for ensuring data integrity for all data sources used. Work closely with all areas of marketing and Information Technology staff to identify, troubleshoot, and resolve data-related issues of concern.
• Capture and perform data analysis within player tracking to monitor performance.
• Will review and monitor results from promotions to determine effectiveness and revenue-generating impact.
• Assists in the planning and implementation of direct mail programs designed to attract and retain new and existing customers to the casino.
• Gather data, organize it into reports, and provide conclusions.
• Coordinates reports and audits on direct mail to ensure accuracy. Perform analysis on direct mail efforts and maintain accurate records.
• Provide pre- and post-campaign analysis
• Provide insightful suggestions for campaigns, promotions, and Marketing activities
• Responsible for the strict adherence to Compliance policies, internal control procedures, and the Casino’s policies and procedures.
• Supervises the Database and Promotional Teams
• Organize the theme selection, planning, ordering items for, and execution of, casino gift promotions.
• Design, coordinate, execute, and evaluate all events on and off-site
• Promote business growth and loyalty program goals, design promotions and events, execute and evaluate those events.
• Disseminates marketing information to the entire casino on a timely basis.
• Work with the Marketing Manager to complete the art of Direct Mail and Email
• Finalize targets for email campaigns

Performance Expectations

• Applies the All-Star Service Principles to all internal and external guest situations
• Acquires the appropriate job knowledge in a timely fashion and consistently updates that knowledge
• Consistently produces above-average work
• Produces results in work by meeting all deadlines
• Works well in a team environment
• Is a property leader
• Consistently reliable
• Not only locates problems, but also provides suggestions for a solution
• Adheres to all appearance standards
• Practices productive communication
• Always is prepared for the day's business
• Can adapt to a changing environment
• Executes projects from planning to completion

Qualifications (Knowledge, Skill and Ability)

• In-depth knowledge of direct mail including players tracking database.
• Knowledge and experience with Slot Player Tracking, Casino Management and Casino marketing systems.
• Proficient in Structured Query Language (SQL) and developing and maintaining SQL standard compliant databases (Microsoft SQL Server and other relational database products), multi-dimensional databases, and data mining models
• Comprehensive knowledge of all Microsoft Office Professional software applications, including but not limited to Microsoft SQL Server, Access, and Excel
• Practical knowledge in accumulating and integrating data for use in report software, spreadsheets, graphs and flow charts.
• Proven experience in the use of computer systems including database systems, software, data retrieval methodologies and quantitative analysis.
• Ability to maintain strict confidentiality of classified information.
• Must be competent with various PC based software programs, especially in database and spreadsheet programs
• Proven analytical and problem-solving abilities.
• Experience at working both independently and in a team-oriented, collaborative environment is essential.
• Strong written and oral communication skills and interpersonal skills.
• Enthusiasm and positive attitude

Profitmind is building the intelligence behind how retailers make pricing and merchandising decisions. Today, many of these decisions are still driven by spreadsheets, rigid rules, and manual judgment, even at the largest brands.

Our platform turns complex data such as sales, inventory, and competitive signals into clear, explainable recommendations merchants can trust. Our platform focuses on impact, helping retailers improve margin, inventory health, and decision quality at scale. 

Based in Pittsburgh, we’re a fast-growing startup with real customers. Profitmind is backed by a recent strategic investment from Accenture, and is scaling its agentic AI platform to power decision-making for some of the world’s largest retailers.

About the role:

Profitmind is looking for a Full-Stack Software Engineer to help build and evolve the core product experience across both the frontend and backend. This role is frontend-heavy, but requires comfort working across the stack, including writing SQL queries and supporting backend data access in a JavaScript/TypeScript environment. 

You’ll work closely with product, design, and engineering to turn complex data, workflows, and AI-driven functionality into experiences that feel simple, fast, and purposeful. This is a hands-on role for a mid-level engineer who can operate independently and work with the team to deliver features end-to-end.

What you’ll do:

• Build and maintain modern, responsive user interfaces across our web applications
• Develop and maintain reusable UI components within the core Profitmind product
• Work in a full-stack JavaScript/TypeScript environment, supporting both frontend features and backend data needs
• Write and maintain SQL queries to support product functionality and analytics use cases
• Support front-end and back-end integration for AI-powered tools and workflows
• Build dashboards and agent-style interfaces that make complex outputs easy to understand
• Write automated tests for frontend and full-stack functionality as part of a high-quality development process
• Ensure strong performance, accessibility, and cross-browser compatibility
• Iterate quickly based on user feedback and evolving product direction

What we’re looking for:

• 4–5 years of professional software development experience preferred
• Strong, hands-on experience building frontend applications using modern frameworks such as React, TypeScript, Next.js, or similar
• Comfort working across the stack in a JavaScript/TypeScript codebase
• Ability to write SQL queries independently and work with relational data on the backend
• Experience building data-driven user interfaces, dashboards, or analytics-heavy applications
• A pragmatic approach to automated testing and code quality
• High attention to detail and pride in delivering polished, usable software
• Ability to work independently in a fast-moving, product-driven environment
• Experience with enterprise, data-heavy, or analytics-focused products is a plus

What we offer:

• Competitive compensation and equity
• Comprehensive benefits including medical, dental, vision, etc.
• Unlimited and flexible PTO

This is a full-time position based in Pittsburgh, PA, though remote candidates will be considered on a case-by-case basis.

Apply today to join a small, senior team working on problems that sit at the core of how global retailers operate.

Title: Senior Technical Support Engineer (Care Delivery)

Employment Type: 6-Month Contract-to-Hire

Start Date: ASAP

Work Model: Hybrid – 3 days onsite required

Eligible Locations: Boston, MA | Raleigh, NC | Dallas, TX | Waterloo, Ontario (Canada)

Compensation: 65-68/hr

About the Role

We are hiring a Senior Technical Support Engineer to support a complex production application environment focused on care delivery workflows. This is a hands-on troubleshooting role for someone who enjoys diagnosing real system problems — not a developer stop-gap role.

You will investigate live production issues, analyze application behavior, read backend code, execute SQL queries, and either resolve problems directly or partner with engineering teams to drive fixes.

The ideal candidate is a career technical support professional who takes ownership of issues and thrives in a high-impact operational environment.

What You’ll Do

• Reproduce and diagnose complex production issues
• Read and interpret object-oriented backend code
• Execute advanced SQL queries to validate system behavior
• Identify root cause and resolve issues when possible
• Escalate bugs to engineering with clear technical documentation
• Support ongoing operational stability of the platform
• Work within ticketing systems to manage incidents
• Improve support tooling and workflows
• Collaborate cross-functionally with engineering and operations teams

Required Qualifications

Technical

• Strong object-oriented programming background in Java, Go, or Python (must be strong in at least one)
• Advanced SQL querying skills
• Application-level troubleshooting experience
• Ability to read and debug code (not just run scripts)
• Experience working within ticketing/incident systems

Preferred Qualifications

• Experience as a Senior/Staff/Principal Technical Support Engineer
• Python scripting or automation experience
• Exposure to AI workflow optimization
• Healthcare or life sciences industry experience (nice to have)

Ideal Candidate Profile

• Senior application support engineer (career support track)
• Comfortable reading production code daily
• Strong ownership mindset — drives problems to resolution
• Not a developer seeking a temporary role
• Enjoys deep troubleshooting and operational stability work

Additional Details

• 6-month contract to hire
• Hybrid (3 days onsite required)
• Candidates must reside in Boston, Raleigh, Dallas, or Waterloo
• Immediate start preferred

Job Summary

The Health Information Systems Manager is responsible for designing, implementing, and maintaining systems that support data-driven decision-making across enterprise applications. This role analyzes business requirements, develops reporting solutions, and ensures the accuracy and integrity of data used for strategic and operational decisions.

The position also oversees system administration functions such as user access management, system performance monitoring, and troubleshooting while ensuring compliance with security policies and regulatory standards. This role plays a critical part in safeguarding sensitive data, enforcing security protocols, and supporting audits to maintain system integrity and compliance.

Key Responsibilities

Electronic Health Records (EHR) and Health Information Systems Management

• Serve as the functional owner and administrator for the organization’s electronic health record (EHR) system and other related applications.
• Configure, maintain, and optimize system functionality to support operational and program workflows.
• Manage system security, user access, roles, permissions, and data retention in accordance with privacy and compliance requirements.
• Coordinate system upgrades, patches, testing, and system deployment activities.
• Ensure reporting and data processes comply with applicable regulations and standards, including privacy and healthcare data regulations (e.g., HIPAA, HITECH), internal policies, and accreditation requirements.
• Act as the primary liaison between the organization and system vendors, ensuring effective communication and issue resolution.
• Complete and maintain relevant system certifications and technical training as required.

Clinical Workflow, Data, Forms, and Reporting

• Design and maintain system configurations and documentation workflows aligned with quality standards and reporting requirements.
• Utilize available system functionality to support efficiency and data accuracy, including form building, data exports, dashboard creation, and reporting tools.
• Develop and maintain custom queries and reports using Structured Query Language (SQL) and other reporting tools.
• Support business intelligence reporting and dashboard development using modern data visualization platforms.
• Collaborate with internal teams to ensure data is accurate, complete, and usable for reporting and operational needs.
• Observe operational workflows when necessary to better understand reporting requirements and system usage.
• Monitor and audit operational workflows and data quality.
• Design and conduct validation testing to ensure system deliverables meet defined requirements.
• Maintain and support legacy systems while assisting with transitions to modern platforms when necessary.

Project Management and System Support

• Lead and manage EHR and information system projects, including implementations, optimizations, and regulatory initiatives.
• Develop project plans, timelines, and deliverables.
• Track risks, issues, and project outcomes to ensure successful completion.
• Develop and deliver training related to system workflows, documentation standards, and system updates.
• Provide advanced technical support and issue escalation for system-related challenges.
• Create and maintain documentation, system workflows, and user guides.
• Coordinate internal and external stakeholders during system migrations or major upgrades.

Additional Responsibilities

• Promote a culture of continuous quality improvement and operational excellence.
• Perform other duties as assigned.

Qualifications

Education & Experience

• Bachelor’s degree or equivalent experience required.
• Minimum of four (4) years of relevant experience in health information systems, data management, or related fields.

Technical Knowledge

• Experience working with electronic health record (EHR) systems or similar enterprise applications strongly preferred.
• Proficiency with relational databases and data structures.
• Ability to write SQL queries and develop reports using database reporting or business intelligence tools.
• Understanding of systems engineering concepts, testing methodologies, and data modeling techniques.
• Proficiency with Microsoft Office applications.

Preferred Experience

• Experience supporting healthcare, behavioral health, or social service program operations.
• Experience working with data reporting, dashboards, and analytics platforms.

Skills

• Ability to work independently with minimal supervision.
• Strong collaboration and communication skills across technical and operational teams.
• Strong analytical thinking and problem-solving abilities.
• Excellent organization and attention to detail.
• Ability to learn new workflows, processes, and technologies quickly.
• Strategic thinking and creative problem-solving skills.

Summary:

The Clinical Documentation Registered Nurse collaborates extensively with physicians, nursing staff, other patient caregivers and coding staff to improve the quality and completeness of documentation of care provided and coded for coordination, abstraction and submission of accurate data required by CMS. Facilitates concurrent modifications to clinical documentation to insure commensurate reimbursement of clinical severity and services rendered to patients with a DRG based payer (Medicare, Medicaid). Supports timely, accurate and complete documentation of clinical information used for measuring and reporting physician and facility outcomes. Communicates with and educates all clinical staff concerning accurate and effective clinical documentation.

Responsibilities:

• Reviews inpatient medical records for identified payer populations as within one business day of admission and throughout hospitalization to identify opportunities for physician documentation.
• Analyzes clinical status of patient, current treatment plan, and past medical history and identifies potential gaps in MD documentation and leaves physician query to obtain complete, accurate clinical documentation.
• Works closely with HIM coding staff to assure documentation of discharge diagnosis and any co-existing co-morbidities is a complete reflection of the patient’s clinical status and care
• Maintain a DRG worksheet to assist coders on identifying all documented POA/HAC, diagnosis and procedures
• Updates DRG worksheet to reflect any changes to inpatient status/procedure/treatment and confers with the physician to finalize diagnosis.
• Demonstrates basic knowledge about HIM coding standards and applies to ongoing evaluation of medical record documentation for accuracy of physician documentation to support the acuity of illness.
• Performs chart review on expired patients to identify severity of illness and risk of mortality for performance improvement activities.
• Develops and implements plans for both formal and informal education of physician, nursing, and other clinical staff on clinical documentation opportunities, coding and reimbursement as well as performance improvement methodologies.
• Collaborate with case manager regarding cases with length of stay outside of the expected GMLOS, to ensure documentation identifies severity of illness and maximizes reimbursement potential.
• Coordinates and assures complete and accurate data collection and validation for public reporting data initiatives for Premier, CMS and JCAHO.
• Maintains good rapport and cooperative relationships. Approaches conflict in a constructive manner. Helps identify problems, offers solutions, and participates in their resolution.
• Coordinates with quality department by: providing concurrent review for core measures documentation, providing retrospective chart audits as needed, and educating nursing and medical staff of improvement and current status of quality initiates.
• Performs follow-up to document physician response to queries. Tracks and trends patterns of physician responses and reports monthly to director.
• Designs and implements collaboration with physician leadership specific tools to support medical record physician documentation.
• Review clinical issues with coding staff to assign working DRG’s.
• Work collaboratively with the coding staff to ensure that documentation of discharge diagnoses and co-morbidities are a complete reflection of the patient’s clinical status and care.
• Review final DRG and compare with clinical data gathered to ensure the DRG assigned is appropriated and that all co-morbidities are captured.
• Communicates with Case Management Director and/or Vice President of Medical Affairs regarding program barriers/success/outcomes of CDI program.
• Assists in collection and organization of data for analysis by appropriate medical and hospital committees.
• Consistently meets established productivity targets for record review.
• Maintain strict confidentiality at all time.
• Performs other duties as assigned. 

Requirements:

• Associate's Degree in Nursing
• RN License in state of employment or compact

Work Schedule:

PRN

Work Type:

Per Diem As Needed