Prometheus Sql Examples Jobs Hiring Now Jobs in Usa

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.

About the Role

This is an implementation and product support role — not a sales position.

You’ll onboard new SMB and Enterprise customers, migrate data from legacy systems, train operators through go-live, and provide ongoing system support. You’ll also work closely with our development team on bug tracking, testing, and software upgrades.

What You’ll Do

• Lead customer onboarding and software migration
• Perform data cleansing, validation, and reconciliation
• Build Excel reports (lookups, cross-sheet comparisons)
• Train customers and support go-live execution
• Test software releases and coordinate upgrades
• Act as liaison between customers and developers

What We’re Looking For

• 3–8 years in SaaS implementation, ERP support, application support, or operational software
• Strong Excel and SQL proficiency- Write queries (not just read them)
• Validate data during implementations
• Troubleshoot mismatches/issues
• Work with engineering using data
• Comfortable working with structured, data-driven systems
• Excellent communication and training skills
• Technically curious and detail-oriented
• Able to work onsite in Newton, MA five days per week

Ideal for someone who enjoys hands-on problem solving, working within complex systems, and becoming deeply knowledgeable in a mission-critical operational platform.

Job Title: Client Advisory Analyst

Position Summary:

Pareto Intelligence™ is a bold and innovative healthcare analytics organization redefining how health plans approach data, insights, and performance improvement. We are a team of passionate professionals driven to challenge conventional thinking and deliver transformative analytic solutions that others say are not possible.

Our Client Advisory Analysts are key members of this mission—immersing themselves in advanced data analytics, modeling, and problem-solving to drive measurable client outcomes. This role bridges data and decision-making, helping clients interpret analytical insights while contributing to the enhancement of Pareto’s proprietary tools and methodologies.

Essential Duties and Responsibilities:

• Serve as a trusted partner to clients, interpreting outcomes from Pareto’s suite of data analytic tools.
• Manage multiple client engagements and relationships concurrently.
• Apply critical thinking to develop customized analytic interpretations and solutions for client needs.
• Provide live demonstrations and user instruction for Pareto’s data analytic tools to current and prospective clients.
• Collaborate extensively with technical and non-technical team members to ensure seamless delivery and insight translation.
• Uphold the security, confidentiality, and integrity of client information across all engagements.
• Innovate by translating client feedback into enhancements for Pareto’s analytic and visualization tools.
• Contribute to process improvements and product evolution through active participation and solution-oriented thinking.

Education and Experience Requirements:

• Bachelor’s degree in data Analytics; Economics; Management Information Systems; Finance; Accounting; or a related field.
• Up to 2 years of consulting or data analytics experience.
• Strong quantitative and analytical skills with the ability to apply statistical analysis to unstructured problems.
• Proficiency in interpreting data outputs and translating findings into actionable insights.
• Demonstrated experience presenting analytics and system functionality to client stakeholders.

Skills and Attributes:

• Complex Problem Solving: Ability to identify and address challenges by evaluating information, assessing options, and implementing effective solutions.
• Critical Thinking: Ability to use logic and reasoning to evaluate alternative approaches and determine optimal strategies.
• Deductive Reasoning: Ability to apply general rules to specific problems to derive accurate conclusions.
• Inductive Reasoning: Ability to identify patterns and relationships across diverse data and scenarios.
• Communication Skills: Strong oral and written communication skills with the ability to convey complex ideas clearly.
• Quality Assurance: Commitment to accuracy, precision, and thorough self-review of analytical outputs.
• Adaptability: Ability to thrive in an entrepreneurial environment where learning and innovation are continuous.

Travel Requirements:

The successful candidate must be willing and able to travel as needed; estimated travel is less than 25% of the time.

Compensation and Benefits:

The expected base salary for this position ranges from $75,000 - $85,000 USD with a bonus target of up to 5% of the base salary. We do consider a wide range of factors when making offer decisions, including (but not limited to) the scope and responsibilities of the position, a candidate’s relevant skills, training, experience, education and where applicable, licensure and certifications obtained. We also consider organizational and market factors when making offer decisions.

Equal Employment Opportunity Statement:

Convey Health Solutions is an Equal Opportunity Employer committed to fostering an inclusive and diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other characteristic protected by applicable federal, state, or local laws.

Convey Health Solutions also provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable laws. Applicants requiring accommodation during the application or interview process should contact the Human Resources department.

The Convey Health Solutions family of companies, including Pareto Intelligence™, delivers a powerful combination of purpose-built technology, advanced analytics, and expert services to help health plans thrive in a complex, post, Affordable Care Act environment.

As a trusted partner to Medicare and commercial payers, we provide scalable, compliant solutions that span the entire member lifecycle, from enrollment and billing to risk adjustment, Stars performance, and member engagement. Pareto’s deep analytics and financial intelligence complement Conveys’ operational expertise, enabling our clients to improve performance, reduce costs, and create better healthcare experiences for millions of Americans, especially seniors and vulnerable populations.

Together, we help health plans scale smarter, grow stronger, and make healthcare work better for the people who need it most.

Learn more at

About Prometheus Group

Prometheus Group is a team of self-starters centered on being resourceful, accountable, and results-focused. Career progress is based on merit and not years of service or attaining certifications. Our drive and dedication to creating great products for our global customers are at the heart of all we do! In joining Prometheus, you will become a part of the largest global provider of comprehensive enterprise asset management (EAM) software solutions that support the management life cycle for equipment maintenance and operations.

Job Summary

The Junior Account Manager is responsible for selling Prometheus Group products and services to new and existing Prometheus Group customers as well as developing pipeline to drive revenue growth.

Responsibilities

• Sales and Territory Development
• Achieve or exceed quota targets.
• Develop effective and specific opportunity/account plans to ensure revenue target delivery and sustainable growth
• Establish and maintain key relationships at multiple levels within the assigned accounts
• Develop and deliver overviews, presentations, and coordinate high level functional product demonstrations to new and existing accounts.
• Participate in the development of the assigned region, including accounts, account relationships, prospect profiling and sales cycles.
• Participate in the development and delivery of a comprehensive business case to address customer and prospect priorities and pain points.
• Follow a disciplined approach to maintaining a rolling pipeline. Keep pipeline current and moving up the pipeline curve.
• Support all Prometheus promotions and events in the assigned region.
• Maintain SalesForce system with accurate customer and pipeline information.
• Territory Development
• Find and nurture opportunities for company’s solutions by cold calling into targeted companies and following up with leads
• Work in coordination with Account Executives to target high value prospects in assigned territory Generate a sufficient number of new opportunities per month
• Articulate business value to prospects
• Gather prospects needs and understand their initiatives as they relate to the solution
• Occasionally travel for trade shows and travel to customers
• Document all activity related to accounts using
• Keep current with industry knowledge and best practices to effectively communicate with prospects

Skills and Experience

• B.S/B.A. in Business, Communication or related field
• 2-4 years’ sales experience within software
• Customer-focused, results-driven, excellent communicator
• High energy, self-starter who can learn quickly and easily engage clients
• Able to work effectively as an individual contributor as well as within a team
• Foreign language skills a plus

Benefits Overview

We offer an attractive benefits program to meet the diverse needs of our teammates:

• Employee base HSA plan, dental, life and short-term disability coverage 100% paid for by Prometheus Group
• HSA & FSA plan options
• Retirement Savings with Generous Company Match & Immediate Vesting
• Gym membership to O2 Fitness
• Casual dress attire
• Half-Day Fridays
• Generous Paid Time Off
• Company Outings, Trips & Activities
• Paid Parental Leave

Prometheus Group is proud to be an Equal Employment Opportunity and Affirmative Action employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

Description

The Scientific Computing & Data group at the Icahn School of Medicine at Mount Sinai (ISMMS) accelerates scientific discovery by supporting a high-performance computing and research data ecosystem. This includes a data commons and two clinical research data warehouses: one for ISMMS and one for the Kidney Precision Medicine Project (KPMP), a multi-institutional research consortium ( ) funded by the National Institute of Diabetes and Digestive and Kidney Diseases (NIDDK). Both warehouses use Microsoft SQL Server and the OMOP Common Data Model.

The Lead Data Warehouse Engineer is a senior technical specialist responsible for leading development, maintenance, and operations of these research data warehouses. The role collaborates with warehouse team members and research stakeholders to expand functionality and integrate new data sources. Data transformations are built in Transact-SQL stored procedures, with SSIS used for orchestration.

Responsibilities

• Design databases and pipelines that balance functionality, performance, cost, and development time; evaluate technical options with the product manager.
• Design, build, test, and maintain ETL/ELT processes using T-SQL stored procedures, SSIS, and SQL Agent; apply metadata-driven design for extensibility.
• Serve as a team leader; contribute to project planning, work breakdown, dependency sequencing, and release management.
• Develop and promote standards, conventions, design patterns, DevOps/SDLC best practices, and operational procedures for pipelines and warehouse maintenance.
• Mentor junior engineers in data warehousing, data engineering skills, and operational support.
• Design, build, and maintain data management processes, including loading flat files (csv, tsv, pipe-delimited, JSON).
• Lead design sessions, code walkthroughs, peer reviews, and produce technical documentation.
• Tune database objects, stored procedures, and pipelines to optimize performance and minimize compute and storage costs.
• Monitor database and pipeline operations; lead troubleshooting and remediation of failures; provide occasional after-hours on-call support.
• Collaborate with DBAs and system administrators on backups, performance tuning, statistics/index maintenance, and patching.
• Provide high-quality customer service to researchers, clinicians, and internal partners; maintain a science‑driven, customer-focused approach.
• Ensure patient privacy and data security in compliance with IRB & cybersecurity policies, HIPAA, 42 CFR Part 2, NYS Article 27-F, and other regulations.
• Stay current with emerging technologies to improve capabilities, efficiency, quality, or cost.
• Identify improvements in procedures, technology, compliance, and data privacy/security.
• Periodically assist DBAs with user provisioning, backups, restorations, capacity planning, and performance monitoring.
• Perform related duties as assigned.

Qualifications

• Bachelor’s degree in a technical field; Master’s preferred.
• 12–15 years of related experience, including 7+ years designing, developing, and maintaining relational databases, data pipelines, and dimensional/OLAP warehouses.

Preferred

• Expert knowledge of data warehousing: 3NF & dimensional modeling (fact table types, SCDs), change data capture, incremental loads, data lineage, source-to-target mappings, pattern-based & parameter-driven development.
• Expert-level experience with Microsoft SQL Server technologies: T-SQL, indexing, stored procedures, UDFs, sequences, dynamic SQL, Linked Servers, SSIS, Visual Studio, SSDT, and SQL Agent.
• Experience with DevOps/SDLC best practices; Agile (Scrum, Kanban) with JIRA and Confluence; version control with git.
• Strong communication and customer service skills for working with researchers, clinicians, administrators, and IT staff.
• Excellent critical thinking, problem-solving, multitasking, and collaboration skills; ability to work independently in a fast-paced environment.
• Preferred experience with healthcare data (EHR, billing/claims, cost accounting), Epic Clarity/Caboodle, data models (OMOP, i2b2, PCORnet).
• Preferred experience with Azure Synapse, Azure Data Factory, Oracle PL/SQL, PostgreSQL PL/pgSQL.
• Experience with SQL Server administration: configuration, performance tuning, partitioning, materialized views, permissions, backups & restorations.
• Preferred experience with scripting in Windows & Linux (PowerShell, Python, or similar); HL7; web services/REST APIs; reporting tools like SSRS, Power BI, Tableau.

Strength through Unity and Inclusion

The Mount Sinai Health System is committed to fostering an environment where everyone can contribute to excellence. We share a common dedication to delivering outstanding patient care. When you join us, you become part of Mount Sinai’s unparalleled legacy of achievement, education, and innovation as we work together to transform healthcare. We encourage all team members to actively participate in creating a culture that ensures fair access to opportunities, promotes inclusive practices, and supports the success of every individual.

At Mount Sinai, our leaders are committed to fostering a workplace where all employees feel valued, respected, and empowered to grow. We strive to create an environment where collaboration, fairness, and continuous learning drive positive change, improving the well-being of our staff, patients, and organization. Our leaders are expected to challenge outdated practices, promote a culture of respect, and work toward meaningful improvements that enhance patient care and workplace experiences. We are dedicated to building a supportive and welcoming environment where everyone has the opportunity to thrive and advance professionally. Explore this opportunity and be part of the next chapter in our history.

About the Mount Sinai Health System:

Mount Sinai Health System is one of the largest academic medical systems in the New York metro area, with more than 48,000 employees working across eight hospitals, more than 400 outpatient practices, more than 300 labs, a school of nursing, and a leading school of medicine and graduate education. Mount Sinai advances health for all people, everywhere, by taking on the most complex health care challenges of our time — discovering and applying new scientific learning and knowledge; developing safer, more effective treatments; educating the next generation of medical leaders and innovators; and supporting local communities by delivering high-quality care to all who need it. Through the integration of its hospitals, labs, and schools, Mount Sinai offers comprehensive health care solutions from birth through geriatrics, leveraging innovative approaches such as artificial intelligence and informatics while keeping patients’ medical and emotional needs at the center of all treatment. The Health System includes more than 9,000 primary and specialty care physicians; 13 joint-venture outpatient surgery centers throughout the five boroughs of New York City, Westchester, Long Island, and Florida; and more than 30 affiliated community health centers. We are consistently ranked by U.S. News & World Report's Best Hospitals, receiving high "Honor Roll" status, and are highly ranked: No. 1 in Geriatrics, top 5 in Cardiology/Heart Surgery, and top 20 in Diabetes/Endocrinology, Gastroenterology/GI Surgery, Neurology/Neurosurgery, Orthopedics, Pulmonology/Lung Surgery, Rehabilitation, and Urology. New York Eye and Ear Infirmary of Mount Sinai is ranked No. 12 in Ophthalmology. U.S. News & World Report’s “Best Children’s Hospitals” ranks Mount Sinai Kravis Children's Hospital among the country’s best in several pediatric specialties. The Icahn School of Medicine at Mount Sinai is ranked No. 11 nationwide in National Institutes of Health funding and in the 99th percentile in research dollars per investigator according to the Association of American Medical Colleges. Newsweek’s “The World’s Best Smart Hospitals” ranks The Mount Sinai Hospital as No. 1 in New York and in the top five globally, and Mount Sinai Morningside in the top 20 globally.

Equal Opportunity Employer

The Mount Sinai Health System is an equal opportunity employer, complying with all applicable federal civil rights laws. We do not discriminate, exclude, or treat individuals differently based on race, color, national origin, age, religion, disability, sex, sexual orientation, gender, veteran status, or any other characteristic protected by law. We are deeply committed to fostering an environment where all faculty, staff, students, trainees, patients, visitors, and the communities we serve feel respected and supported. Our goal is to create a healthcare and learning institution that actively works to remove barriers, address challenges, and promote fairness in all aspects of our organization.

Compensation

The Mount Sinai Health System (MSHS) provides salary ranges that comply with the New York City Law on Salary Transparency in Job Advertisements. The salary range for the role is $145200 - $217875 annually. Actual salaries depend on a variety of factors, including experience, education, and operational need. The salary range or contractual rate listed does not include bonuses/incentive, differential pay or other forms of compensation or benefits.

Purpose

The IT Database Engineer is responsible for designing, implementing, and supporting relational database platforms in both traditional data centers and Azure cloud environments. The role covers installation, configuration, performance tuning, high availability, backup and recovery, monitoring, and incident response for Microsoft SQL Server, MySQL, and PostgreSQL, with participation in an on-call rotation to support mission-critical workloads.

Key Responsibilities

• Install, configure, and upgrade MSSQL, MySQL, and PostgreSQL in data center and Azure environments (IaaS and/or PaaS as applicable).
• Perform day-to-day database administration, including user and role management, permissions, schema changes, and maintenance tasks.
• Monitor database health, performance, and capacity using native and third-party tools; define meaningful alerts and dashboards for proactive issue detection.
• Troubleshoot database incidents (performance issues, blocking/deadlocks, failed jobs, connectivity problems, resource constraints) and drive root-cause analysis and permanent fixes.
• Design, implement, and maintain backup and recovery strategies (full/diff/log, PITR, snapshots, Azure backup options) and regularly test restore procedures.
• Implement and support high availability and disaster recovery configurations (e.g., SQL Server Always On, failover clustering, log shipping, MySQL/Postgres replication, Azure availability sets/zones).
• Optimize database performance through indexing strategies, query tuning, statistics management, and configuration tuning at both OS and database levels.
• Implement and enforce security controls (authentication, authorization, encryption at rest/in transit, auditing) aligned with organizational and regulatory requirements.
• Support application and development teams with database design, query optimization, and controlled deployment of schema changes across environments.
• Maintain detailed documentation including runbooks, standards, topology diagrams, data flows, and operational procedures for both on-prem and Azure deployments.
• Participate in an on-call rotation, responding to after-hours incidents, and perform planned maintenance during maintenance windows.
• Automate routine tasks (provisioning, checks, patching, reporting) using scripts and tooling (e.g., T-SQL, PowerShell, Bash, Python, Azure CLI).

Required Qualifications

• Proven experience as a Database Engineer/DBA supporting MSSQL, MySQL, and PostgreSQL in production environments.
• Hands-on experience managing databases in traditional data centers (physical/virtual servers) and Azure (e.g., SQL Server on Azure VMs, Azure SQL Database, Azure Database for MySQL/PostgreSQL or similar).
• Strong understanding of database internals: storage structures, indexing, transactions, isolation levels, and locking.
• Demonstrated skills in performance troubleshooting and tuning using execution plans, wait statistics, and monitoring metrics.
• Practical experience with HA/DR solutions and backup/restore strategies, including testing and documentation of failover/recovery procedures.
• Proficiency with scripting/automation for database operations and integration with operational tooling.
• Familiarity with networking, OS, and virtualization concepts relevant to database performance and connectivity (subnets, firewalls, load balancers, storage latency).
• Solid understanding of security best practices for databases.

Preferred Qualifications

• Experience with Azure-native monitoring and management tools (e.g., Azure Monitor, Log Analytics, Alerts, Managed Identities, Key Vault).
• Experience with CI/CD and database change automation, including schema versioning and deployment pipelines.
• Exposure to large-scale or high-volume databases, partitioning, and scaling strategies (vertical/horizontal).
• Knowledge of regulatory and compliance requirements related to data (e.g., PCI, HIPAA, GDPR) and data protection techniques (masking, tokenization).
• Relevant certifications (e.g., Microsoft Azure, SQL Server, MySQL, PostgreSQL).

Soft Skills

• Strong analytical and problem-solving skills, especially under time pressure during incidents and on-call situations.
• Clear communication skills to work effectively with developers, infrastructure teams, security, and business stakeholders.
• High sense of ownership for data integrity, availability, and reliability, with a structured approach to documentation and process.

Working Conditions (travel, hours, environment)

• Limited travel required including air and car travel
• While performing the duties of this job, the employee is occasionally exposed to a warehouse environment and moving vehicles. The noise level in the work environment is typically quiet to moderate.

Physical/Sensory Requirements

Sedentary Work – Ability to exert 10 - 20 pounds of force occasionally, and/or negligible amount of force frequently to lift, carry, push, pull or otherwise move objects. Sedentary work involves sitting most of the time but may involve walking or standing for brief periods of time.

Benefits & Rewards

• Bonus opportunities at every level
• Non-traditional retail hours (we close at 7p!)
• Career advancement opportunities
• Relocation opportunities across the country
• 401k with discretionary company match
• Employee Stock Purchase Plan
• Referral Bonus Program
• 80 hrs. annualized paid vacation (full-time associates)
• 4 paid holidays per year (full-time hourly store associates only)
• 1 paid personal holiday of associate’s choice and Volunteer Time Off program
• Medical, Dental, Vision, Life and other Insurance Plans (subject to eligibility criteria)

Equal Employment Opportunity

Floor & Decor provides equal employment opportunities to all associates and applicants without regard to age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, disability, veteran status, genetic information, ethnicity, citizenship, or any other category protected by law.

This policy applies to all areas of employment, including recruitment, testing, screening, hiring, selection for training, upgrading, transfer, demotion, layoff, discipline, termination, compensation, benefits and all other privileges, terms and conditions of employment. This policy and the law prohibit employment discrimination against any associate or applicant on the basis of any legally protected status outlined above.

About the Company:

Our client is a well-established capital equipment provider with operations across the western United States. With a large multi-state footprint and a long history of growth through acquisitions, the company supports customers through equipment sales, rentals, parts, and service. Their IT systems are mission-critical and continue to evolve through modernization and data integration initiatives.

Job Summary:

We are seeking a Senior Lead Programmer Analyst (COBOL) to serve as a hands-on technical leader supporting core business systems. This role is ideal for an experienced COBOL developer who enjoys deep technical work while also guiding design decisions, mentoring peers, and supporting system modernization efforts.

This is a player-coach role, not a formal management position. You will remain actively involved in development while providing technical leadership across the COBOL team, particularly as legacy systems transition to SQL-based architectures.

Key Responsibilities:

• Act as a senior, hands-on developer supporting and enhancing COBOL applications (online and batch)
• Design and develop new COBOL programs, processes, and system enhancements
• Embed SQL within COBOL programs as legacy files are migrated to relational databases
• Develop new functionality leveraging SQL-based data structures
• Provide technical leadership for core systems including parts inventory, customer data, invoicing, and tax modules
• Partner with business stakeholders to translate requirements into effective technical solutions
• Participate in application design, planning, and technical reviews
• Lead or contribute to data conversions related to acquisitions and system integrations
• Create and maintain technical documentation, design artifacts, and test plans
• Identify and recommend improvements to development practices and system efficiency
• Mentor peer developers through code reviews and technical guidance

Required Qualifications:

• Strong hands-on experience with COBOL on HP NonStop (Tandem) platforms
• Experience developing and supporting online and batch COBOL applications
• Proficiency with SQL, including embedding SQL within COBOL programs
• Experience with SQLXpress and HTML
• Solid understanding of the software development lifecycle (SDLC)
• Strong skills in system analysis, debugging, testing, and troubleshooting
• Excellent technical documentation and communication skills
• Proven ability to work independently while collaborating within a team
• Strong analytical, organizational, and time-management skills

Preferred Qualifications:

• Experience leading or mentoring developers in a technical (non-managerial) capacity
• Experience with legacy-to-SQL modernization efforts
• Background in acquisition-driven or integration-heavy environments
• Exposure to inventory, parts, invoicing, or financial systems
• Experience in heavy equipment, manufacturing, distribution, or similar industries

Why This Role?

• Fully remote, full-time position
• High-impact role supporting mission-critical systems
• Opportunity to shape technical direction and modernization efforts
• Hands-on leadership without people-management responsibilities
• Stable organization with long-term investment in core technology