Query Optimization With Example Jobs Remote Jobs in Usa

Business Area:

Seniority Level:

Job Description:

At Cloudera, we empower people to transform complex data into clear and actionable insights. With as much data under management as the hyperscalers, we're the preferred data partner for the top companies in almost every industry. Powered by the relentless innovation of the open source community, Cloudera advances digital transformation for the world's largest enterprises.

The Data Platform Pillar is the bedrock of Cloudera's technology, where we design and build the core components that let our customers store, manage, and process data with unmatched scalability, security, and performance.

One of our products, Hue, is a mature open-source SQL Assistant for querying Databases & Data Warehouses and collaboration. Many companies and organizations use Hue to quickly answer questions via self-service querying.

The Data Warehouse Experience team is seeking passionate developers to join our distributed engineering team. Our mission is to make data warehousing simple and innovative for end users, working on software development, testing, user experience, distributed systems, and scalability.You will architect and implement applications within Hue, part of Cloudera Enterprise, which includes CDP Data Platform (CDPD), the world's leading open-source data platform for mission-critical environments, as well as CDP/Data Warehouse on the public cloud. We have already released the next generation of SQL experience using container-native Hadoop services to work in a Kubernetes cluster.

As a Sr. Staff Software Engineer, you will:

• Drive Hue's architecture and technical strategy to deliver a secure, scalable, and extensible data productivity interface for enterprise analytics.

• Lead core feature development across SQL editing, data catalog exploration, visualization, workflow orchestration, and practitioner productivity tooling.

• Define and execute the AI roadmap for Hue, incorporating Cloudera SQL AI, natural-language query experiences, contextual copilots, and retrieval-augmented analytics.

• Advance intelligent SQL assistance and automation by designing foundational capabilities for query generation, optimization suggestions, and semantic data understanding.

• Champion engineering excellence through robust testing, performance optimization, observability, and enterprise-grade reliability.

• Mentor engineers and lead cross-functional collaboration with product, UX, data platform, and other teams to influence long-term strategic direction.

We are excited about you if you have:

• Bachelor's degree in
  Computer Science or equivalent, and 7+ years of experience; OR Master's degree and 5+ years of experience; OR PhD and 3+ years of experience.

• Attention to details and ability to build reliable and scalable software systems.

• 4+ years of experience in development and test.

• Effective communication and collaboration skills.

• Strong development and system skills.

• Strong critical & analytical skills.

• Experience developing in Python.

• Web development framework experience (React, Vue, Angular etc.).

• Comfortable with HTML and CSS.

• Comfortable with security.

You may also have:

• Comfortable with the Web/RPC stacks in a Cloud world

• Working knowledge of Kubernetes and microservices-based application design

• Experience in developing continuous integration pipelines

Why this role matters:

You will tackle complex distributed systems challenges, crafting the foundational software for the control and data planes that powers CDP and keeps it running at massive scale. Working at the forefront of hybrid and multi-cloud technology, you will empower data scientists, engineers, and analysts with the tools and infrastructure they need for advanced analytics and modeling.

Collaboration is key, you will work alongside brilliant minds across product, data science, and engineering to drive innovation, standardize best practices, and shape the future of enterprise AI and data platforms. This is your chance to build the future of data and see your work make a global impact.

This role is not eligible for immigration sponsorship.

What you can expect from us:

• Generous PTO Policy

• Support work life balance with Unplugged Days

• Flexible WFH Policy

• Mental & Physical Wellness programs

• Phone and Internet Reimbursement program

• Access to Continued Career Development

• Comprehensive Benefits and Competitive Packages

• Paid Volunteer Time

• Employee Resource Groups

EEO/VEVRAA

#LI-SZ1

#LI-REMOTE

Job Summary:

We are seeking a detail-oriented SQL Analyst ideally with experience in SQL Server Management Studio (SSMS). This role will be responsible for designing, executing, and optimizing SQL queries, supporting data analysis initiatives.

The ideal candidate is highly analytical, skilled in relational databases, and capable of transforming raw data into meaningful reports that support data-driven decision making.

Key Responsibilities:

• Write, optimize, and maintain SQL queries and stored procedures to extract and analyze data from multiple sources.
• Perform data analysis to identify trends, anomalies, and business opportunities.
• Support business users by troubleshooting data issues, validating results, and ensuring accuracy of reporting.
• Collaborate with cross-functional teams to define requirements and translate them into technical solutions.
• Ensure data integrity, security, and performance of queries and reporting solutions.
• Create and maintain documentation for queries, dashboards, and data processes.

Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience).
• 2+ years of experience working as a SQL Analyst, Data Analyst, or BI Analyst.
• Strong proficiency in SQL and experience with SQL Server / SSMS.
• Solid understanding of relational databases, data structures, and ETL concepts.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to communicate technical concepts to non-technical stakeholders.

Job Title – Tech Lead, SFDC

Location – SFO- Bay Area, CA - Hybrid

Duration – Long Term Contract (C2C, W2)

We are looking for a Salesforce Technical Lead with strong Healthcare Cloud experience who is highly hands-on and comfortable with Apex coding, complex SOQL queries, and custom development.

Key Responsibilities:

- Lead end-to-end Salesforce implementations with a focus on Salesforce Health Cloud

- Design and develop custom Apex classes, triggers, batch/queueable jobs, and complex SOQL/SOSL queries

- Build and optimize Lightning Web Components (LWC) and Aura components

- Perform hands-on development while mentoring junior developers and reviewing code

- Design and implement integrations using REST/SOAP APIs, Platform Events, and middleware

- Ensure data security, compliance, and HIPAA standards in healthcare solutions

- Own technical architecture, troubleshooting, and performance optimization

- Collaborate closely with business stakeholders, product owners, and cross-functional teams

Required Skills & Experience:

- 13+ years of Salesforce experience with 5+ years as a Technical Lead

- Strong expertise in Salesforce Health Cloud

- Expert-level Apex development, including triggers, async Apex, and governor limit optimization

- Advanced experience writing SOQL queries and handling large data volumes

- Hands-on experience with LWC, Visualforce (as needed), and Salesforce flows

- Experience integrating healthcare systems (FHIR, HL7, EHR/EMR preferred)

- Solid understanding of Salesforce security model, data sharing, and compliance (HIPAA)

- Experience with CI/CD, DevOps tools, and source control (Git)

• 
  
  
• 
  
  Sign On Bonus Potential: Up To 10K
  
  
• 
  
  Randallstown, MD
  
  
• 
  
  NORTHWEST HOSPITAL
  
  
• 
  
  CAT SCAN
  
  
• 
  
  Full-time - Weekends - Day and Evening shifts - Hours Vary
  
  
• 
  
  ALLIED HEALTH
  
  
• 
  
  92660
  
  
• 
  
  $36.94-$58.17 Experience based
  
  
• 
  Posted:
  February 27, 2026
  
  

Summary

Summary

Performs Cat Scan procedures at a safe and experienced level without direct supervision. Unified by the core purpose of creating a healthier community one person at a time, the members of the Division of Patient Care Services commit themselves to sustaining a culture focused on achieving optimal patient outcomes.

Responsibilities

Provides excellent customer support by providing the best service possible. Demonstrates empathy and understanding of patient/customer concerns by listening carefully and responding appropriately. Displays a commitment to the value of teamwork by building strong relationships with patients, families, co-workers and the surrounding community by being cooperative and collaborative in the performance of duties, promoting a unified and spirited workplace.Performs CT scan procedures using prescribed techniques. Reviews requisitions to ensure completeness verifying patient name, diagnosis, description of requested exam. 

Experience: Required: * 1-3 years 

Education: Required: * Associate's Degree Graduate of a JRCERT accredited school in the field of Radiologic Technology. Licenses And Certification: Required: * Radiographer License - Current Maryland license or eligibility to obtain Maryland license * Basic Life Support * Registered Radiologic Technologist

Additional Information

• 
  
  
• 
  
  Baltimore, MD
  
  
• 
  
  SINAI HOSPITAL
  
  
• 
  
  FMF-CT SCAN
  
  
• 
  
  PRN - Night shift - 7:00pm-7:30am
  
  
• 
  
  ALLIED HEALTH
  
  
• 
  
  92346
  
  
• 
  
  $53.50-$53.50
  
  
• 
  Posted:
  January 28, 2026
  
  

Summary

Performs Cat Scan procedures at a safe and experienced level without direct supervision.  Unified by the core purpose of creating a healthier community one person at a time, the members of the Division of Patient Care Services commit themselves to sustaining a culture focused on achieving optimal patient outcomes.  Each employee is obligated to deliver highly reliable care while adhering to all National Patient Safety Goals.  This occurs within a learning environment that is supportive and just, where each employee is valued for their contribution to the collective safety of patient, staff, and visitors.  Of equal importance is each employee's commitment to the value of teamwork in order to promote a unified and spirited workplace. 

Provides excellent customer support by providing the best service possible.  Demonstrates empathy and understanding of patient/customer concerns by listening carefully and responding appropriately.  Displays a commitment to the value of teamwork by building strong relationships with patients, families, co-workers and the surrounding community by being cooperative and collaborative in the performance of duties, promoting a unified and spirited workplace.  Exceeds patient/customer needs by anticipating, identifying and responding to such needs promptly and in a caring and courteous manner. 

R.T.(R), NMTCB(CT), or equivalent required;

Graduate of JRCERT accredited program in Radiological Technology.

BLS required 

Additional Information

• 
  
  
• 
  
  Sign On Bonus Potential: Up to $10,000
  
  
• 
  
  Baltimore, MD
  
  
• 
  
  SINAI HOSPITAL
  
  
• 
  
  RIAO RADIOLOGY
  
  
• 
  
  Full-time - Day shift - 8:30am-5:00pm
  
  
• 
  
  ALLIED HEALTH
  
  
• 
  
  93309
  
  
• 
  
  $31.13-$47.87 Experience based
  
  
• 
  Posted:
  March 18, 2026
  
  

Summary

Now offering new, highly competitive rates and up to a $10,000 sign-on bonus!

At Sinai Hospital of Baltimore, we combine advanced imaging technology, compassionate care, and a collaborative team environment to deliver exceptional patient outcomes. We’re looking for an X-Ray Technologist who’s ready to grow, contribute, and be part of something bigger — a hospital that values your expertise as much as your empathy.

• 
  
• 
  

  Perform a variety of general diagnostic imaging procedures using state-of-the-art digital radiography equipment

  
  
  
• 
  

  Ensure every patient feels safe, comfortable, and respected during their exam

  
  
  
• 
  

  Collaborate closely with radiologists, nurses, and other providers to deliver accurate, timely diagnostic results

  
  
  
• 
  

  Maintain the highest standards of safety, quality, and compliance

  
  
  
• 
  

  Keep imaging workflows efficient and equipment ready for optimal performance

  
  
  

• 
  
• 
  

  Associate’s degree or completion of an AMA-approved School of Radiologic Technology

  
  
  
• 
  

  ARRT certification and Maryland State License (required)

  
  
  
• 
  

  AHA BLS/CPR certification (required)

  
  
  
• 
  

  1–3 years of radiology experience preferred — motivated new graduates are encouraged to apply

  
  
  
• 
  

  Strong communication, teamwork, and problem-solving skills

  
  
  

• 
  
• 
  

  Competitive Pay and up to a $10,000 Sign-On Bonus (prorated for part-time)

  
  
  
• 
  

  Generous Paid Time Off

  
  
  
• 
  

  403(b) Retirement Plan with Employer Match

  
  
  
• 
  

  Tuition Assistance and Continuing Education Support

  
  
  
• 
  

  Comprehensive Medical, Dental, and Vision Coverage

  
  
  
• 
  

  Employee Wellness and Assistance Programs, free parking, and fitness discounts

  
  
  

Bring your skills, compassion, and drive — and build a rewarding career where every image makes a difference.

Apply today and discover what’s possible at Sinai Hospital.

Additional Information

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.