Prometheus Sql Examples Jobs Salary 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.

Job Description:

Job Title: Data Analyst

Duration : 06+ months contract to hire

Location :Remote

Additional qualities to look for: Healthcare background is a plus

SQL, SSIS, SSRS, Active Batch, Control M, SQL Server

Strong Data Analysis, Data Validation, ETL

May include:

• Financial, pharmacy, claims, provider, and member data IRS, CMS, HHSC, HEDIS reporting
• Internal data cleansing and data reconciliation analysis
• Trend analysis in various functional areas of health care management
• Create and generate reports through MS-Excel, MS-Access, and SQL using Business Objects interface and direct links to core databases (ODS/EDW)
• Produce reports for and interface with senior management and internal and external stakeholders
• Gather and interpret business requirements and monitor data trends to proactively identify issues
• Execute data changes and update core systems as needed
• Handle multiple projects and timelines effectively and communicate risks and issues to manager regularly
• Assist with training lower level Data Analysts
• Performs other duties as assigned
• Complies with all policies and standards

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status

Role: Verint OM Developer

Location: Remote

Role Summary:

Seeking a Verint OM Developer with strong SQL and integration experience to support data extracts, batch processing, and system integrations within Verint Operations Manager. The role involves developing stored procedures, managing flat file/CSV extracts, troubleshooting job failures, and supporting Windows-based automation.

Key Skills:

Key Skills & Experience

• Intermediate SQL development experience, including designing, modifying, and optimizing stored procedures, views, and scheduled jobs to support data extracts and integrations.
• Strong understanding of data pipelines and batch processing, including flat file/CSV generation, scheduling, and delivery to downstream systems.
• Ability to translate operational and business requirements into technical extract logic in partnership with configuration analysts and stakeholders.
• Intermediate experience validating data extracts through testing, reconciliation, and troubleshooting data quality issues.
• Intermediate experience supporting integrations in Windows-based environments, including PowerShell scripting, configuration files, and job scheduling. Familiarity with AWS services is a plus
• Experience using logs and monitoring tools to debug file imports, job failures, and notification services in Verint or similar enterprise platforms.
• Healthcare operations experience is a plus; Verint OM or WFM platform experience is highly desirable.

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.

Company Description

Prometheus Materials develops innovative sustainable building materials to drive the transition toward a carbon-negative future. Using nature-inspired processes, the company utilizes microalgae to produce its ProZERO™ line of carbon-negative supplemental cement blends, designed for ready-mix concrete applications, manufactured products, and licensed material solutions. These cutting-edge materials address the environmental challenges of traditional construction while offering scalable solutions for concrete manufacturers.

Role Description

The Director of Business Development is responsible for identifying and developing the sales and marketing strategies leading to long-term, profitable growth. You will evaluate and execute new business opportunities which align with Prometheus Materials’ overall market growth strategies. This position will work closely with distributors, vendors, and customers. Additionally, close collaboration with internal business units (biotechnology, research and development, manufacturing, and product management) will be essential to the success of the Director of Business Development. 

Responsibilities:

This is a summary of activities and is not intended to be all-inclusive of all responsibilities.

·     Develop, own, and execute a formal business plan aligned with company objectives

·     Develop, maintain, and track product backlog and bid activity

·     Establish revenue goal KPIs and deliver results

·     Manage strategic relationships to maximize revenue performance

·     Create and manage key account plans, including defined goals, activities, and timelines

·     Communicating regular updates of key performance indicators, including volume, revenue, and strategic initiatives

·     Identify, secure, grow, and manage key licensing opportunities across multiple industries

·     Research, analyze, and implement key market trends within low-embodied carbon building materials

·     Monitor and maintain competitive intelligence, including competitor products, pricing strategies, and development activities

·     Regularly review the sales cycle and implement continuous improvement strategies

·     Travel up to 40% as required

Qualifications:

Use your existing network or develop a robust network of key stakeholders to increase market awareness, market share, and success of the formal business plan.

·     Bachelor’s degree in Business or a related field, or equivalent experience

·     Minimum of 5 years of experience in sales, marketing, or product management

·     Experience within the building materials industry preferred (e.g., sand and gravel, cement, ready mix, or admixtures)

·     Proven experience collaborating with industry experts (Architects and Engineers)

·     Working knowledge of key high-level industry standards relating to cement, concrete, and aggregates

·     Demonstrated experience developing, managing, and executing sales strategies to drive revenue growth

·     Strong understanding of business-to-business sales cycles, sales strategies, and key performance metrics

·     Experience building, leading, and managing multi-dimensional sales team

·     Proficiency with Customer Relationship Management (CRM) software and sales reporting

·     Solid financial and business acumen, including budgeting, forecasting, and pricing strategies

·     Strong negotiation, presentation, and facilitation skills

·     Knowledge or experience with sustainability initiatives, LEED certification, and carbon reduction targets

Please send resume and cover letter to

We're Hiring: Director of IT Architecture (Remote, with onsite meetings as needed)

We are seeking a Director of IT Architecture | Enterprise Architecture | Cloud & Systems Leader to lead and shape the IT architecture strategy for a growing healthcare organization. This is a unique opportunity to design and implement technology solutions that support business goals, regulatory compliance, and modern healthcare delivery.

Key Responsibilities:

• Define and execute a comprehensive IT architecture strategy aligned with clinical, operational, and business objectives.
• Lead and manage a team of network, cloud, and systems architects, fostering collaboration and high performance.
• Oversee network, cloud, and systems architecture initiatives, ensuring security, scalability, and interoperability.
• Evaluate, test, and implement modern platform visibility solutions (DataDog, Dynatrace, New Relic, Prometheus / Grafana).
• Collaborate with IT leadership, business stakeholders, vendors, and cloud providers to optimize technology investments.
• Establish IT governance, standards, and best practices to ensure compliance with industry regulations (HIPAA, HITECH, HITRUST).
• Monitor performance, risks, and cost optimization across all IT architecture initiatives.

Required Qualifications:

• Bachelor’s degree in Computer Science, IT, Healthcare Informatics, or related field.
• 10+ years of progressive experience in IT architecture, including at least 5 years in a leadership role managing network, cloud, and systems architecture teams, preferably in healthcare.
• Hands-on experience with cloud platforms (AWS, Azure) and hybrid environments.
• Demonstrated history of assessing, testing, and implementing modern platform visibility solutions (DataDog, Dynatrace, New Relic, Prometheus / Grafana).
• Strong expertise in network architecture (SD-WAN, VPNs, firewalls, healthcare data exchange networks).
• Deep knowledge of systems architecture, including server infrastructure, virtualization, storage, disaster recovery, and healthcare IT standards (HL7, FHIR, DICOM).
• Strong leadership, communication, and stakeholder management skills.
• Strategic thinker with strong problem-solving and analytical abilities.

Preferred Qualifications:

• Master’s degree in a related field.
• Relevant cloud certifications (AWS Solutions Architect Professional, AWS Security Specialty, Microsoft Azure Solutions Architect).
• Security and architecture certifications such as CISSP, CCNP, HITRUST, or FinOps.

This is a remote role with the flexibility to work from home, while requiring occasional onsite meetings for leadership collaboration and strategic planning.

If you are a visionary IT leader with a strong healthcare background, experience leading cloud, network, and systems architecture teams, and a passion for building scalable, secure IT platforms, we want to hear from you!

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.