With Query Example Sql Jobs in Usa

Associate Director of Communications Systems

Arlington, VA (On-Site)

About Us

Ennoble Care is a mobile primary care, palliative care, and hospice service provider with patients in New York, New Jersey, Maryland, DC, Virginia, Oklahoma, Kansas, Pennsylvania, and Georgia. Ennoble Care's clinicians go to the home of the patient, providing continuum of care for those with chronic conditions and limited mobility. Ennoble Care offers a variety of programs including remote patient monitoring, behavioral health management, and chronic care management, to ensure that our patients receive the highest quality of care by a team they know and trust. We seek individuals who are driven to make a difference and embody our motto, "To Care is an Honor." Join Ennoble Care today!

Overview

Ennoble Care is seeking an Associate Director of Communications Systems to own our Dialpad and Zoho CRM platforms end to end—from day-to-day administration to the analytics that drive operational decisions for clinical leadership and the C-suite.

This is not just a systems administration role. You'll inherit active automation projects in Zoho (workflow rules, field permissions, validation logic, cross-module integrations) and a growing analytics practice around Dialpad call data (transfer acceptance rates, queue performance, agent productivity). You'll be expected to build on both—and you'll have AI tools at your disposal to do it. We're actively using AI to automate workflows, analyze call data, and eliminate manual processes across both platforms. You'll be expected to leverage these tools to move faster than a traditional admin ever could.

You'll report directly to the CIO and have regular visibility with the COO and executive leadership. This position is on-site at our Arlington, VA corporate headquarters.

Key Responsibilities

Dialpad Administration & Analytics (~610 users across 15+ offices and 11 states)

• Manage user provisioning/deprovisioning, license management (Connect vs Contact Center), number assignment, and extensions

• Configure and optimize call routing, IVR structures, queues, and office/department setup

• Build and maintain performance dashboards for clinical operations leadership—transfer acceptance rates (warm vs cold), queue performance, agent productivity, ring timeout analysis, voicemail detection

• Leverage AI tools to automate call data analysis, anomaly detection, and recurring reporting

• Track and report on KPIs weekly: call answer rate, abandon rate, average speed to answer, queue wait time

• Conduct root cause analysis when performance dips—whether it's a routing issue, a training gap, or a staffing constraint

• Serve as primary technical contact with Dialpad support and account team

• Troubleshoot call quality issues, agent status problems, and routing errors

Zoho CRM Administration & Automation (~50+ liaisons, scaling to 100+)

• Manage user creation, role/profile management, field-level permissions, module configuration, and layout customization

• Own and extend existing workflow automations—bonus point calculations, pathway expiration enforcement, focused pathway caps, cross-module lookups (house call / hospice), referral-to-liaison mapping

• Drive data integrity: account deduplication, referral source accuracy, sync monitoring between Zoho, OA (OperationsAccel), and MatrixCare

• Build liaison performance dashboards and automate the pulse report

• Reduce bonus reconciliation from ~16 hours/month of manual work to near-zero through automation

• Use AI-assisted development to build and iterate on Zoho workflow rules, validation logic, and cross-module integrations faster

Integrations & Cross-Platform

• Coordinate user lifecycle (provisioning/deprovisioning) across Dialpad and Zoho as part of onboarding/offboarding workflows

• Maintain integrations between Dialpad, Zoho, CallRail, and other systems

• Monitor sync reliability between Zoho, OA, and the Dialpad data warehouse (Azure SQL)

• Support other no-code/low-code tools (Scribe, Keragon, Emitrr) as needed

Performance Monitoring & Reporting

• Track and report on Dialpad and Zoho KPIs weekly to leadership

• Identify trends and proactively address issues before they impact metrics

• Support Operations Analyst with data extraction for deeper analysis

Documentation & Training

• Create and maintain system documentation, runbooks, and SOPs

• Develop training resources to improve adoption and reduce errors

• Conduct end-user training for new hires and existing staff

What Success Looks Like

• You own Dialpad and Zoho administration completely—user provisioning, routing changes, and system configuration no longer route through the helpdesk or the CIO

• Leadership gets recurring, self-service visibility into call center performance and liaison productivity without asking for it

• Manual reconciliation work that currently takes 16+ hours/month is automated or eliminated

• When something breaks or trends in the wrong direction, you catch it before anyone else does

Qualifications

Required

• 3+ years of experience administering a cloud communications platform (Dialpad, RingCentral, 8x8, Five9, or similar)

• 2+ years of experience administering a CRM (Zoho CRM strongly preferred; Salesforce acceptable)

• Hands-on experience building CRM automations—workflow rules, validation rules, field-level security, cross-module lookups

• Comfortable writing SQL queries for analytics (you'll query an Azure SQL data warehouse—and use AI tools to accelerate query development and analysis)

• Experience building dashboards or reports in Power BI, Looker, or similar

• Strong analytical skills—able to interpret data and identify root causes

• Excellent communication skills with ability to present metrics to leadership

• Strong attention to detail—you'll reconcile bonus payments where errors directly impact employee compensation

• Ability to work on-site in Arlington, VA

Preferred

• Zoho CRM administration certification

• Experience with Zoho-to-external-system integrations (webhooks, APIs, middleware like Zoho Flow)

• Healthcare industry experience (home health, hospice, or multi-site provider groups)

• Experience with Dialpad specifically (API, webhooks, admin console, contact center configuration)

• Familiarity with data warehousing concepts and ETL pipelines

• Experience using AI/LLM tools (Claude, ChatGPT, Copilot) to accelerate technical work—writing automations, analyzing data, building integrations

• Background in contact center operations (not just IT administration)

What We Offer

• Ownership of two mission-critical platforms with direct impact on business performance

• Direct visibility with CIO, COO, and executive leadership

• AI-forward team—you'll have enterprise AI tools and an automation backlog with clear ROI from day one

• Growing organization—the systems you build now will scale with 2x liaison headcount and continued M&A expansion

• Competitive compensation and benefits package

• Career growth opportunities within IT and operations

Compensation

Salary Range: $90,000 - $110,000 with 10% Bonus based on Annual KPIs

Benefits

Full-time employees qualify for the following benefits:

• Medical, Dental, Vision and supplementary benefits such as Life Insurance, Short Term and Long Term Disability, Flexible Spending Accounts for Medical and Dependent Care, Accident, Critical Illness, and Hospital Indemnity

• Paid Time Off

• Paid Office Holidays

All employees qualify for these benefits:

• Paid Sick Time

• 401(k) with up to 3% company match

• Referral Program

• Payactiv: pay-on-demand — cash out earned money when and where you need it!

Candidates must disclose any current or future need for employment-based immigration sponsorship (including, but not limited to, OPT, STEM OPT, or visa sponsorship) before an offer of employment is extended.

Ennoble Care is an Equal Opportunity Employer, committed to hiring the best team possible, and does not discriminate against protected characteristics including but not limited to race, age, sexual orientation, gender identity and expression, national origin, religion, disability, and veteran status.

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.

Key Responsibilities

• Design and implement RESTful APIs and microservices with Go and Gin.

• Write clean, well-tested, maintainable backend code and optimize for performance, scalability and reliability.

• Implement authentication, authorization and other security best practices.

• Integrate third-party APIs and services as needed.

• Build responsive, high-performance user interfaces in React and TypeScript.

• Develop reusable components, maintain component libraries and manage state with Redux, Zustand or React Query.

• Ensure cross-browser compatibility and responsive design in collaboration with UX/UI designers.

• Design and maintain PostgreSQL schemas, write efficient SQL queries, create indexes and migrations, and optimize database performance.

• Design scalable system architectures, participate in code reviews and technical discussions, and implement CI/CD pipelines and automated testing.

• Monitor and debug production issues, mentor junior developers, and contribute to engineering best practices.

Essential Skills

• Go (Golang) with the Gin framework

• React and TypeScript

• PostgreSQL 17 and SQL query optimization

• RESTful API and microservices architecture

• State management tools such as Redux, Zustand or React Query

• CI/CD pipeline creation and automated testing

• Performance tuning and troubleshooting across the stack

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.

Summary

As a member of Wakefern Tech’s HR/Legal Systems team, this role will support and enhance Wakefern's HCM platform, including configuration, troubleshooting, and developing SQL-based reporting. This role involves working closely with various areas across the enterprise (including corporate, warehouse, retail, and member locations) to understand their needs and architect the appropriate HCM related solutions.

Essential Functions

• Participate in the project development lifecycle for HCM related systems including, but not limited to:
• System design, configuration, and integration
• System testing and validation
• System implementation
• Provide ongoing system support including, but not limited to:
• Ongoing work related to system upgrades, enhancements, production fixes, etc., including the testing and rollout of new features and functionality
• Provide day-to-day HCM related system support including application configuration changes, incident troubleshooting and resolution, and ongoing system maintenance activities
• Develop and optimize SQL queries for data extraction, audits, and analysis
• Build and maintain custom reporting and dashboards using SQL and/or other appropriate tools
• Build and maintain integrations with both external vendors/systems and internal systems
• Support data integrity, auditing, and audit reconciliation efforts
• Partner with stakeholder teams around the enterprise to identify opportunities for platform enhancement/improvement and work with the project team to translate these requirements into system solutions
• On call support after hours and on weekends as needed

Qualifications

• Bachelor’s degree in Information Systems, HR Technology, or related field preferred
• 5+ years supporting an enterprise HCM system
• Proficiency with modern cloud-based HCM platforms such as Dayforce, Workday, UKG, Oracle Fusion, or comparable system
• Strong SQL skills for queries, troubleshooting, and reporting
• Experience developing custom HCM reports
• Strong analytical and communication skills

Working Conditions & Physical Demands

• Standard office environment; ability to work on a computer for extended periods.
• This position requires in-person office presence four days per week

Competencies

• Problem Solving
• Communication
• Technical Expertise
• Collaboration

Compensation and Benefits

The salary range for this position is $81,224 - $175,396. 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.

• Location: Boston, MA
• Hybrid: 3 days on site
• Potential Convert: Yes, USC/GC ONLY no exceptions. WILL NOT SPONSOR

• ETL/ELT
• ODI
• PL/SQL coding
• 7 years’ experience
• Knowledge on how to be an admin side of things (not day to day but is able to do that)
• Scripting – Python & Unix Scripting

• Build ODI mappings/interfaces, packages, procedures, scenarios, topology configuration, ODI Agent and load plans to integrate data from multiple enterprise systems.
• Expertise in building Pl/SQL queries, procedures, data loading process, ensuring high-performance and scalability to meet the evolving data needs of the various applications.
• Design, develop, and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI).
• Collaborate effectively with cross-functional teams, including other data engineers, DBA group, analysts, and business stakeholders, to understand data requirements and deliver solutions.
• Monitor and troubleshoot RMJ jobs, ODI workflows, sessions, agents, and data pipelines on Linux environments.
• Perform root cause analysis for failures related to ODI workflows, RMJ jobs, network connectivity, API integrations, and file transfers.
• Optimize ETL workflows to improve reliability, performance, and scalability.
• Use scripting and automation tools to support data processing and operational workflows.
• Work in Linux/Unix environments, using command-line tools and shell scripts for job automation and troubleshooting.
• Maintain comprehensive documentation of data processes, configurations, and best practices.
• Participate in walk-throughs which review program specifications, source code, and all technical supporting documentation, including screens/reports. Provide feedback in accordance with team standards and guidelines.
• Participate in implementation of changes, enhancements, and newly developed programs.
• Conduct technical research and provide recommendations, develop proofs of concept or prototypes, contributing to technical design of applications.
• Helping to identify coding patterns and anti-patterns and enforce implementation of the patterns through code reviews.
• Quickly resolving issues encountered by business lines in the production environment, maintaining a helpful, "high touch" approach to working with business users, performing root cause analysis, technology evaluation, and performance tuning.

Desired Qualifications:

• Degree in Computer Science, Engineering or related technical area
• 7+ years of extensive hands-on experience in ODI, Oracle Datawarehouse, Oracle PL/SQL, Linux, Python scripting, and ODI admin module (ODI Agent setup, logs configuration, certificate installation).
• Must have experience in building Pl/SQL queries for Oracle Server (incl. stored procedures, functions…) and must understand basic principles of data modeling
• Excellent collaborative and communication skills, particularly in high-stress situations
• Experience with scripting Python and Linux scripting, CLE, networking fundamentals (API, IP/ports, SFTP/FTP connectivity)
• High proficiency in development practices: unit testing, Continuous Integration (CI/CD), refactoring, clean code
• Experience with Bitbucket/GIT source control management
• Problem solving skills, able to determine upcoming risks & issues and address them accordingly.
• Ability to interpret and troubleshoot applications using logs.
• Pro-active approach and good communication skills.
• Experience with agile methodologies (Scrum, Kanban) and tools (Jira)

• Private Banking domain experience.
• Working experience in a financial service industry
• Financial application knowledge like FIS AddVantage, CRD, CRM Pivotal.
• Experience with Apache Airflow for workflow orchestration.
• Knowledge of dbt (Data Build Tool) for modern data transformations.
• Exposure to cloud data platforms or hybrid data architectures.

Key Competencies:

• Strong analytical and problem-solving skills
• Ability to work with large-scale enterprise data environments
• Excellent collaboration and communication skills
• Ability to manage multiple priorities in a fast-paced environment
• Commitment to continuous learning and technology innovation

Estimated Min Rate: $55.00

Estimated Max Rate: $72.00

What’s In It for You?
We welcome you to be a part of the largest and legendary global staffing companies to meet your career aspirations. Yoh’s network of client companies has been employing professionals like you for over 65 years in the U.S., UK and Canada. Join Yoh’s extensive talent community that will provide you with access to Yoh’s vast network of opportunities and gain access to this exclusive opportunity available to you. Benefit eligibility is in accordance with applicable laws and client requirements. Benefits include:

• Medical, Prescription, Dental & Vision Benefits (for employees working 20+ hours per week)
• Health Savings Account (HSA) (for employees working 20+ hours per week)
• Life & Disability Insurance (for employees working 20+ hours per week)
• MetLife Voluntary Benefits
• Employee Assistance Program (EAP)
• 401K Retirement Savings Plan
• Direct Deposit & weekly epayroll
• Referral Bonus Programs
• Certification and training opportunities

Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Visit to contact us if you are an individual with a disability and require accommodation in the application process.

For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

By applying and submitting your resume, you authorize Yoh to review and reformat your resume to meet Yoh’s hiring clients’ preferences. To learn more about Yoh’s privacy practices, please see our Candidate Privacy Notice:  working/work at home options are available for this role.