Prometheus Query Examples Jobs in Usa

We put the unity in "opportunity."

Opportunity Snapshot:

• Compensation: $72.00/hour
• Location: Denver, CO
• Work Schedule: M-F / 40 hours+
• Duration: 12 months +
• Benefits: Comprehensive benefits with 401(k), PTO and Holidays

Qualifications:

• Bachelor's Degree in Engineering, Computer Science, Data Science, Finance, or related field
• 3+ years of professional experience as a Data Analyst, Business Intelligence Analyst, or similar role
• 2+ years writing complex SQL queries in production environments, including creating new queries from scratch and optimizing existing ones
• 2+ years hands-on experience building and managing Power BI and/or Spotfire dashboards. Experience supporting operations, engineering, or field teams in a data-intensive environment
• Drilling & Completions knowledge and/or upstream oil & gas experience strongly preferred
• Experience with OpenWells or similar well data management systems (Landmark, PPDM-based applications)
• Knowledge of oil & gas operational metrics including well-level data (API numbers, pads, formations, lateral lengths), drilling metrics (spud dates, drill days, directional surveys), and completion metrics (stages, proppant, pump schedules, frac timelines)
• Programming skills in Python or R for advanced analytics and automation
• Experience with Microsoft Power Platform (Power Automate, Power Apps) for workflow automation
• Experience with cloud data platforms (Azure, AWS).

Responsibilities:

• Directly support Drilling & Completions teams driving upstream operations in the Rockies region
• Work with cutting-edge data systems supporting major oil & gas operations
• Contribute to high-impact business decisions affecting well delivery and capital efficiency
• Drive automation and innovation that improves operational efficiency
• Gain exposure to enterprise-scale data environments and cross-functional collaboration
• Extract, analyze, and interpret complex datasets to derive insights that drive strategic business decisions. Develop and maintain SQL queries against enterprise data systems to support D&C reporting and analysis
• Perform detailed analysis of drilling and completions performance, timelines, costs, and operational KPIs. Translate technical findings into actionable business insights and recommendations
• Build, enhance, and manage Power BI and/or Spotfire dashboards for D&C and Operations teams. Create insightful visualizations that communicate complex data clearly to technical and non-technical stakeholders
• Maintain dashboard integrity by troubleshooting issues, reconnecting data sources, and optimizing refresh performance. Ensure reporting solutions align with enterprise BI standards
• Utilize automation tools to streamline data analysis and business processes. Identify manual, repetitive processes and implement automated solutions
• Develop reusable SQL templates, stored procedures, and data pipelines for recurring analysis. Continuously identify optimization opportunities in data workflows and reporting
• Work closely with D&C engineers, operations leads, and business stakeholders to understand data requirements and provide analytical support. Collaborate effectively with data engineers, data scientists, and IT teams. Respond swiftly to ad-hoc data requests while maintaining quality standards. Document data lineage, business logic, and reporting methodologies
• Develop data validation queries and perform continuous QC across source systems. Monitor data freshness and proactively flag anomalies. Support master data management for wells, pads, assets, and operational hierarchies

The Bergaila Way:

The Bergaila Companies is a nationally recognized leader in providing staffing services to all sectors of the energy industry. We continually focus on partnering with talented professionals, engineering the perfect fit between our clients and employees. Choosing a career path with Bergaila grants you immediate access to nationally recognized organizations we partner with. Bergaila consistently attracts and retains its Employees with our dedicated internal service team, top tier benefits programs for contractors and their families, and commitment to place you in the desired career of your choice.

Client Overview:

Our Client is a global international energy exploration and production company and one of the largest oil producers in the United States. Founded in 1920, our client’s technical expertise and proven ability to deliver lasting results are the hallmark of their international success. While manufacturing the building blocks for life-enhancing products, our client utilizes leading edge technologies that grow their business and simultaneously help to advance a lower-carbon world.

Title: Enterprise Agile Coach -JIRA/JQL

Terms: Long Term Contract

Location: Atlanta area

Hybrid Role

Must live in Atlanta, GA

3 days a week on site is a requirement

Are you looking for a career opportunity that allows you to grow your career? If so, this opportunity will genuinely excite you! Our client is transforming how their organization services their customers while aligning best in breed technology solutions. We are looking for an Enterprise Agile Coach that has hands-on experience working with JIRA and JQL.This individual will help build out & develop best in class work and work on innovative projects for the business.

Job Title: Enterprise Agile Coach (Jira & JQL Specialist)

Position Overview

We are seeking an experienced Agile Coach with deep expertise in Jira and Jira Query Language (JQL) to drive enterprise Agile maturity, optimize delivery performance, and enhance visibility across portfolios. This role partners with Product, Engineering, PMO, and executive leadership to embed Agile best practices, implement data-driven performance metrics, and leverage Jira as a strategic delivery intelligence platform.

The ideal candidate combines hands-on Agile coaching experience with strong technical fluency in Jira configuration, reporting, workflow design, and advanced JQL querying to enable transparent, scalable delivery operations.

Key Responsibilities

Agile Coaching & Transformation

• Coach Scrum Masters, Product Owners, Release Train Engineers (RTEs), and leadership teams on Agile principles and frameworks (Scrum, Kanban, SAFe, Scrumban).
• Lead Agile maturity assessments and develop improvement roadmaps.
• Facilitate Agile ceremonies at team and program levels.
• Drive continuous improvement through inspect-and-adapt practices.
• Support enterprise Agile transformation initiatives.

Jira Administration & Optimization

• Configure and optimize Jira projects, workflows, issue types, permissions, and boards.
• Design scalable Jira frameworks aligned to SDLC governance and compliance requirements.
• Develop standardized templates for epics, features, stories, and acceptance criteria.
• Implement automation rules to streamline workflows and reduce manual effort.
• Maintain alignment between Jira configurations and Agile best practices.

Advanced JQL & Reporting

• Develop complex JQL queries to extract actionable insights across multiple teams and portfolios.
• Create dashboards and executive-level reporting for:
• Velocity trends
• Sprint predictability
• Burn-up / burn-down
• Cycle time & lead time
• Throughput
• Capacity planning
• Dependency tracking
• Partner with leadership to define KPIs and delivery health metrics.
• Train teams on using JQL for self-service reporting and transparency.

Portfolio & Scaling Support

• Enable cross-team coordination (Scrum of Scrums, dependency mapping).
• Support PI planning and scaled Agile events (if SAFe environment).
• Provide portfolio-level analytics using Jira data.
• Align tooling strategy with enterprise governance and compliance standards.

Required Qualifications

• 5+ years of experience as an Agile Coach, Senior Scrum Master, or Agile Transformation Lead.
• Deep expertise in Jira configuration and administration.
• Advanced proficiency in Jira Query Language (JQL).
• Experience designing dashboards and delivery metrics for executive audiences.
• Strong understanding of Agile frameworks (Scrum, Kanban; SAFe preferred).
• Experience coaching multiple teams in complex, enterprise environments.
• Excellent facilitation and stakeholder engagement skills.

Preferred Qualifications

• Jira Administrator certification.
• SAFe Program Consultant (SPC), SAFe Agilist, or equivalent certification.
• Certified Scrum Professional (CSP), PSM II/III, or CSM.
• Experience integrating Jira with BI tools (Power BI, Tableau, etc.).
• Familiarity with DevOps metrics and CI/CD tooling integrations.

Key Competencies

• Servant leadership
• Data-driven decision making
• Enterprise systems thinking
• Conflict resolution and facilitation
• Organizational change management
• Strong communication and executive presence

What Success Looks Like in This Role

• Increased Agile maturity and delivery predictability across teams.
• Standardized, scalable Jira frameworks adopted enterprise wide.
• Clear, executive-level visibility into portfolio health and performance.
• Reduced workflow inefficiencies through automation and governance.
• Empowered teams using Jira and JQL for transparent, data-driven delivery.

About GSquared Group:

Shouldn’t your recruiting partner put as much effort and value into your career as you do? With GSquared Group, we take the time to understand where you would like to take your career and what is important to you.

GSquared Group is a woman-owned boutique technology services company in the Atlanta area. Founded in 2010, we are a premier provider of IT talent search, management consulting, and software development services. We support a diverse client base that spans all industries and includes Fortune 100 to mid-market companies. We offer direct hire placement, contract, and contract-to-hire positions. We are proud to be known by our community for putting relationships at the core of everything we do.

GSquared Benefits:

• Competitive & Comprehensive Healthcare Package (available only for W2 hourly consultants)
• Simple IRA with company match (available only for W2 hourly consultants)
• Professional development & networking opportunities
• A family-friendly environment
• Nice bonuses for referrals
• A culture that supports you and your career

Hear what others are saying on Glassdoor:

About Wondercide

Wondercide was founded 15 years ago by Stephanie Boone when her dog Luna became ill from what her vet suspected was conventional flea and tick treatments and monthly pest control services.  Stephanie knew there had to be a better way and set out on a mission to invent a plant-powered alternative. Today, Wondercide offers a comprehensive line of plant-powered pest control solutions for your pets, yard, home, and family with +50,000 5-star reviews on Amazon.  

Wondercide, based in Austin, TX, is a privately held, high-growth, and digitally native consumer packaged goods company that has an omnichannel presence and is expanding into specialty brick-and-mortar and beyond. The company is a vertically integrated organization where sales, marketing, creative content, customer service, innovation, procurement, mixing, production, fulfillment, and more are all done in-house.  This allows the team to control their own destiny from a multi-year roadmap down to quality of execution via operational excellence.

We are a close-knit, highly collaborative team of ‘doers’ who operate in an entrepreneurial and KPI-driven environment.  Grit, Action, Curiosity, Ownership, and Insight are the five operating values we embody in our day-to-day work.

At Wondercide, we’re driven by a Fierce Love® for families. We wake up every day inspired by our mission to protect families of every kind, everywhere, from pests with safe, effective pest control solutions. We work with Mother Nature to deliver plant-powered products that promote well-being. We do this so families can live long, happy, and healthy lives together. We believe in doing whatever it takes to protect those we love…and that when you know better, you can do better. Our promise to customers: they’ll never have to go it alone. We’re in this together, and we’ll be there to support each step of the way.

About the Role

This role reports to the Chief Growth Officer and plays a critical part in commercial data visibility, performance reporting, and insight generation across Sales, Finance, Operations, Brand, and Growth.

You will build scalable reporting systems, automate workflows, and create dashboards that provide clear performance visibility across B2B, D2C, retail, and POS channels.

This is a hands-on analytics role focused on delivering accurate reporting, identifying key drivers, and supporting better business decisions.

What You’ll Do

Analytics & Reporting

• Write and maintain complex SQL queries and scripts to extract, transform, and analyze data from multiple systems.
• Build scalable, automated reporting models using advanced Excel/Google Sheets formulas.
• Develop and maintain dashboards in Hex (or similar BI tools), leveraging some SQL and Python as necessary.
• Create executive-ready visualizations and performance reporting frameworks.
• Ensure data accuracy, consistency, and integrity across systems.

S&OP and Forecast Visibility

• Maintain forecasting dashboards and reporting frameworks that support sales, financial, and operational planning.
• Analyze forecast variance, accuracy, and bias to surface key drivers and risks.
• Support S&OP by ensuring inputs are consolidated, validated, and clearly visualized.
• Analyze performance across omnichannel business (Retail, B2B, D2C, POS).

Syndicated Data & Category Support

• Support analysis of syndicated data sources (e.g., Nielsen or similar) to provide category performance visibility and competitive benchmarking.
• Maintain category scorecards, including distribution, velocity, pricing, and promotional metrics.
• Surface key trends and competitive movements to support retail sales strategy.
• Provide analytical support for buyer meetings and line reviews.

Data Systems & Process Optimization

• Partner with IT and data engineering resources to improve data pipelines and system integrations.
• Define data acquisition and integration logic to ensure scalability and reliability.
• Improve workflows through automation, documentation, and streamlined reporting structures.
• Document models, queries, and reporting logic for long-term scalability.

Cross-Functional Leadership

• Partner with Sales, Finance, Operations, Brand, and Product teams to answer strategic business questions.
• Translate complex data into clear insights that influence decision-making.
• Provide data-driven recommendations with clearly stated assumptions and confidence levels.
• Manage multiple priorities in a fast-paced, growth-focused environment.

What We’re Looking For

• 3+ years of experience in data analysis, business analytics, or a related field.
• Strong SQL skills and experience writing complex queries.
• Advanced Excel or Google Sheets skills.
• Experience with BI/dashboarding tools (Hex, Tableau, Power BI, Looker, or similar).
• Experience supporting commercial forecasting processes (variance analysis, accuracy tracking).
• Experience working with syndicated retail data (Nielsen, IRI, SPINS, etc.).
• Python experience (NumPy, Pandas) preferred.
• Strong analytical mindset with the ability to identify meaningful performance drivers.
• Excellent communication skills and ability to influence cross-functional stakeholders.
• Ability to work independently while collaborating effectively across teams.

Preferred Experience

• Omnichannel CPG, retail, manufacturing, or consumer goods environment.
• Experience supporting S&OP or demand planning processes.
• Pet industry or pest control experience is a plus.

Why This Role Matters

This role directly impacts how Wondercide plans, prioritizes, and grows. Your work will shape forecasting accuracy, inventory strategy, channel performance, and leadership decision-making.

If you’re excited about building scalable analytics systems that drive real business outcomes, we’d love to meet you.

What’s in it for you? 

• We mentioned changing the world, right? Need more? You got it! 
• Work with a dream team that will support you and help you succeed
• Good pay and benefits, including low healthcare premiums, 100% of vision and dental covered, paid volunteer time off, and extended maternity and paternity leave 
• Bonus program that is based on business performance
• Performance-based review process, giving you direct influence on your performance/merit increase
• Company-wide Thankful Thursdays and Thrilling Thursdays. 
• Fun swag and free Wondercide gear/products 

This position is based in Round Rock, TX, at the new Wondercide headquarters, with a hybrid option available.  This is not a remote position.

Here at Wondercide, we celebrate, support, and thrive on diversity and inclusion. We’re a proud Equal Opportunity/Affirmative Action Employer.  If you’re interested in joining the Wondercide Pack, apply today!

Overview

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

Responsibilities

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

Performance Expectations

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

Qualifications (Knowledge, Skill and Ability)

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

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

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

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

About the role:

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

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

What you’ll do:

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

What we’re looking for:

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

What we offer:

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

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

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

Title: Senior Technical Support Engineer (Care Delivery)

Employment Type: 6-Month Contract-to-Hire

Start Date: ASAP

Work Model: Hybrid – 3 days onsite required

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

Compensation: 65-68/hr

About the Role

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

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

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

What You’ll Do

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

Required Qualifications

Technical

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

Preferred Qualifications

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

Ideal Candidate Profile

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

Additional Details

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

Job Summary

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

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

Key Responsibilities

Electronic Health Records (EHR) and Health Information Systems Management

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

Clinical Workflow, Data, Forms, and Reporting

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

Project Management and System Support

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

Additional Responsibilities

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

Qualifications

Education & Experience

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

Technical Knowledge

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

Preferred Experience

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

Skills

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

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)

Company Description

At Titl, we simplify the real estate process by eliminating paperwork, legal obstacles, and delays associated with buying, owning, or selling a home. Our advanced technology ensures transparency and peace of mind throughout every transaction. We provide a modern and user-friendly way to handle property—designed for today and prepared for future needs.

Role Description

We're seeking an experienced Full-Stack Engineer to join our team working on a sophisticated property data research and report generation platform. This role involves building and maintaining enterprise-grade systems that automate property data extraction from government sources, generate comprehensive property reports, and manage complex business workflows including payments, authentication, and blockchain integration.

What You'll Work On

• Backend Services: Develop and maintain NestJS microservices handling property data scraping, PDF generation, report aggregation, and enterprise account management
• Frontend Applications: Build responsive Next.js applications with complex state management and real-time updates
• Data Pipeline: Work with automated scraping systems using Puppeteer and AI-powered document processing (Google Document AI, OpenAI)
• Integration Development: Implement OAuth flows, Stripe payment processing, webhook handling, and third-party API integrations
• Queue Management: Design and maintain Bull queue systems for background job processing and async workflows
• Blockchain Integration: Work with Polymesh blockchain for property ownership verification and asset tokenization
• Database Design: Create efficient Prisma schemas and optimize PostgreSQL queries for complex property data relationships

Required Technical Skills

Core Stack (Must Have)

• Backend: Advanced proficiency in NestJS with deep understanding of dependency injection, decorators, guards, and service patterns
• Frontend: Expert-level Next.js 14 (App Router) and React with TypeScript
• Database: Strong Prisma ORM experience and PostgreSQL optimization skills
• TypeScript: Production-level TypeScript across full stack
• API Design: RESTful API design, DTOs, validation, and Swagger documentation Infrastructure & DevOps
• Docker: Container orchestration and development environments
• Cloud Platforms: Google Cloud Platform (Cloud Storage, Cloud Run)
• Queue Systems: Bull or similar job queue systems (Redis-backed)
• Monorepo: Experience with pnpm workspaces or similar monorepo tooling Authentication & Payments
• OAuth 2.0: Multi-provider authentication (Google, Facebook, LinkedIn)
• JWT: Token-based authentication and authorization patterns
• Stripe: Payment processing, webhooks, subscription management, and usage-based billing Specialized Skills
• Web Scraping: Puppeteer or similar browser automation tools
• PDF Processing: PDF generation, manipulation, and data extraction
• AI/ML Integration: Experience with AI APIs (OpenAI, Google AI, etc.)
• Background Jobs: Async processing, retry logic, and error handling

Highly Desired Skills

• Blockchain: Polymesh or Ethereum blockchain integration experience
• Document Processing: OCR, document AI, or legal document processing
• Property/Real Estate Domain: Understanding of property records, deeds, liens, title commitments
• Legal Tech: Experience with legal document workflows or compliance systems
• Testing: Jest, testing-library, E2E testing frameworks
• Performance Optimization: Query optimization, caching strategies, lazy loading
• Security: OWASP best practices, rate limiting, encryption

Architecture & Design Requirements

You should be comfortable with:

• Design Patterns: Service-oriented architecture, repository pattern, factory pattern
• Dependency Injection: Understanding NestJS DI container and module system
• Database Relations: Complex multi-tenant data models with proper isolation
• State Management: React Context, server/client component patterns
• Error Handling: Comprehensive error handling, retry logic, fallback mechanisms, API Security: Rate limiting, API key management, webhook signature verification

Experience Requirements

• 5+ years of full-stack development experience
• 3+ years with TypeScript in production environments
• 2+ years with NestJS or similar enterprise Node.js frameworks
• 2+ years with modern React and Next.js
• Experience building production SaaS applications with multi-tenant architecture
• Track record of shipping complex features end-to-end
• Experience with third-party integrations and webhook systems
• Domain Knowledge (Preferred)
• Understanding of property data and real estate records
• Familiarity with government data systems and public records
• Knowledge of legal document structures (deeds, liens, mortgages, title commitments)
• Experience with regulated industries and compliance requirements
• Understanding of Miami-Dade County or similar municipal systems (bonus)

Development Practices

You should have experience with:

• Git workflows: Feature branches, pull requests, code review
• Documentation: Writing clear technical documentation and API specs
• Testing: Unit tests, integration tests, E2E tests
• CI/CD: Automated testing and deployment pipelines
• Agile: Working in iterative development cycles
• Code Quality: ESLint, Prettier, TypeScript strict mode

Problem-Solving Skills

We're looking for someone who can:

• Debug complex distributed systems across multiple services
• Optimize database queries and reduce API response times
• Design scalable architectures for high-volume data processing
• Handle edge cases in automated scraping and data extraction
• Troubleshoot integration issues with third-party services
• Implement robust error handling and monitoring
• Communication & Collaboration
• Clear written communication for documentation and code reviews
• Ability to explain technical concepts to non-technical stakeholders
• Collaborative approach to problem-solving
• Proactive in identifying and addressing technical debt
• Experience mentoring junior developers (preferred)
• Package Manager Note
• This project uses pnpm exclusively for monorepo management. Experience with pnpm workspaces is preferred, but npm/yarn monorepo experience transfers well.

What Makes You Stand Out

• Contributions to open-source projects
• Experience with LangChain or LangGraph for AI orchestration
• FastAPI or Python experience (for AI service integration)
• Understanding of title insurance or property ownership verification
• Experience with Puppeteer clusters and browser farm optimization
• Background in fintech or regulated industries
• Experience with multi-environment deployments (local, staging, production)

Working Style

This role requires:

• Attention to detail when working with legal and financial data
• Systematic approach to debugging complex systems
• Ability to work independently on ambiguous problems
• Comfort with reading and understanding existing codebases
• Pragmatic decision-making balancing speed and quality
• Tech Stack Summary: NestJS • Next.js • TypeScript • Prisma • PostgreSQL • Puppeteer • Bull • OAuth • Stripe • Google Document AI • OpenAI • Docker • GCP • Polymesh • pnpm
• This role offers the opportunity to work on challenging technical problems at the intersection of PropTech, LegalTech, and AI, building systems that handle real-world property data at scale.