Postgres Subject Matter Expert Job at Piper Companies (Mclean)

Data Architect

The Data Architect is responsible for designing and managing robust, scalable da...

Location

India , Chennai

Salary:

Not provided

OneMagnify

Expiration Date

Until further notice

Requirements

7+ years of experience in data engineering or data architecture roles, including 3+ years in a dedicated architecture capacity
Proven experience in cloud platforms—preferably GCP and/or Azure—with strong familiarity with native data services
Deep understanding of data storage paradigms including relational, NoSQL, and object storage
Hands-on experience with databases such as Oracle and Postgres
Python proficiency preferred
Familiarity with modern DevOps practices including infrastructure-as-code and CI/CD for data pipelines
Strong communication skills with the ability to lead through influence across technical and non-technical audiences
Self-starter with excellent organization and prioritization skills across multiple initiatives
Bachelor’s Degree or Equivalent Experience

Job Responsibility

Translate business and technical requirements into data models and architecture specifications
Design and document data architecture artifacts, including logical/physical data models, data flow diagrams, and integration patterns
Align data models with application architecture and system interaction patterns in partnership with Solution Architects
Establish and maintain design patterns for relational, NoSQL, and streaming-based data solutions
Serve as a hands-on architecture lead during project discovery, planning, and delivery phases
Support data engineers in implementing data architecture that aligns with platform and project requirements
Validate implementation through design reviews and provide guidance throughout the development lifecycle
Contribute to platform evolution by defining and enforcing scalable, reusable architecture practices
Define and uphold best practices for data modeling, data security, lineage tracking, and performance tuning
Promote consistency in metadata, naming conventions, and data access standards across environments

Fulltime

New

Staff Fullstack Software Engineer

We are looking for an exceptional Staff Fullstack Software Engineer to join our ...

Location

United States , Palo Alto

Salary:

175000.00 - 240000.00 USD / Year

Pebl

Expiration Date

Until further notice

Requirements

Bachelor's or Master's degree in Computer Science, Engineering, or a related field
8+ years of professional experience in software engineering, with a strong focus on backend development and distributed systems
Must have a lean mindset - Focus on delivering customer value by minimizing waste, optimizing workflows, fostering continuous improvement, and prioritizing in an iterative manner
Deep expertise in TypeScript, Postgres, and AWS (Lambda, DynamoDB, API Gateway, S3, etc.)
Strong understanding of system design, scalability, and performance optimization
Proven track record of successfully leading technical projects from inception to deployment
Excellent problem-solving and debugging skills, with a focus on delivering robust and reliable solutions

Job Responsibility

Lead the architecture, design, and implementation of complex, scalable systems and services
Collaborate closely with product managers, designers, and engineers to deliver impactful features aligned with business objectives
Drive technical decisions and set best practices for the team in areas such as coding standards, system design, and process improvements
Build, optimize, and maintain applications and services using React JS, TypeScript, Postgres, and AWS in a serverless environment
Mentor and guide engineers across the team, fostering a culture of technical excellence and continuous improvement
Conduct technical reviews, provide constructive feedback, and ensure high-quality deliverables
Act as a subject matter expert for the Growth Engineering team, staying up-to-date with emerging technologies and trends
Troubleshoot and resolve high-priority technical issues in production systems

What we offer

Offers Equity
Flexible Time Off
Parental Leave
Health and Dental Insurance
Retirement Savings + Employee Incentive Plan

Fulltime

Staff Software Engineer, Platform

At Scale, our products include the Generative AI Data Engine, SGP, Donovan, and ...

Location

United States , San Francisco; Seattle; New York

Salary:

248400.00 - 310500.00 USD / Year

Scale

Expiration Date

Until further notice

Requirements

8+ years of full-time engineering experience, post-graduation with specialities in back-end systems
Extensive experience in software development and a deep understanding of distributed systems and public cloud platforms (AWS preferred)
Demonstrated a track record of independent ownership and leadership across successful multi-team engineering projects
Possess excellent communication and collaboration skills, and the ability to translate complex technical concepts to non-technical stakeholders
Experience working fluently with standard containerization & deployment technologies like Kubernetes, Terraform, Docker, etc.
Experience with orchestration platforms, such as Temporal and AWS Step Functions
Experience with NoSQL document databases (MongoDB) and structured databases (Postgres)
Strong knowledge of software engineering best practices and CI/CD tooling (CircleCI, ArgoCD)

Job Responsibility

Architectural Vision: You will drive the design and implementation of foundational systems, acting as a bridge between high-level business goals and technical goals
Cross-Functional Leadership: You will collaborate with cross-functional teams to define and drive adoption of the next generation of features for our AI data infrastructure
Technical Ownership: You are responsible for proactively identifying and driving opportunities for organizational growth, driving improvements in programming practices, and upgrading the tools that define our development lifecycle
Technical Mentorship: You will serve as a subject matter expert, presenting technical information to stakeholders and providing the guidance to elevate the engineering culture across the company

What we offer

Comprehensive health, dental and vision coverage
retirement benefits
a learning and development stipend
generous PTO
additional benefits such as a commuter stipend
equity based compensation

Fulltime

Data Analytics Manager

Data and advanced analytics are central to how Amgen accelerates scientific disc...

Location

India , Hyderabad

Salary:

Not provided

Amgen

Expiration Date

Until further notice

Requirements

Any degree and 8-13 years of experience
Bachelor’s degree or higher in life science, data science, computer science, business administration, or a related field
8 - 13 years of experience delivering analytics platforms, advanced analytics, or data science solutions, preferably within Pharma, Biotech, or a regulated industry
Demonstrated experience independently leading and delivering analytics workstreams or complex analytical components end to end
Experience working effectively in globally distributed delivery models, partnering with onshore stakeholders from an offshore location
Strong analytical, problem-solving, and storytelling skills, with the ability to communicate complex concepts to non-technical audiences
Experience applying advanced analytics, AI/ML, GenAI, and statistical techniques to real-world business problems
Proficiency in analytics and visualization tools such as Tableau, Spotfire, or similar
Strong working knowledge of SQL and relational databases (Postgres, MySQL, MSSQL, Oracle, etc.)
Hands-on experience with Python, R, Spark, or similar analytics and data science tools

Job Responsibility

Apply an analytics-first mindset to R&D by designing and delivering advanced analytical solutions using modern statistical, data science, and AI/ML techniques
Independently design, build, implement, launch, and maintain analytical solutions aligned to business strategies, goals, and roadmaps
Serve as a hands-on subject matter expert for data, analytics, and metrics, providing practical, actionable insights to stakeholders
Partner with business stakeholders to understand strategic objectives and translate them into well-scoped analytical approaches
Implement cutting-edge analytics, AI/ML, and automation solutions across R&D use cases
Own delivery of key performance metrics, dashboards, and analytical products, continuously improving efficiency, quality, and scalability
Collaborate closely with onshore DDS leaders, business partners, and IS/DTI teams to deliver analytics solutions aligned to global DDS standards
Establish active communication with teams across functions and geographies to ensure global alignment and consistent delivery
Participate in regular working-hour overlap with global stakeholders to support effective collaboration, rapid issue resolution, and delivery transparency
Partner with Business Product Owners on requirements gathering, user stories, UAT, deployments, training, and end-user support

What we offer

Full support and career-development resources to expand your skills and maximize your potential
A diverse and inclusive community of belonging, where teammates are empowered to contribute and lead
Competitive total rewards supporting health, wealth, work/life balance, and career growth

Fulltime

Full Stack Developer

Design and development of new features on the Endpoint Security (ENS) Real Prote...

Location

United States , Frisco

Salary:

Not provided

Skyhigh Security

Expiration Date

Until further notice

Requirements

Bachelor's in Computer Science, Data Science and Machine Learning, Distributed Systems, Networking, Cybersecurity, or related field and 5 years of progressive experience as Full Stack Developer, Software Engineer, Software Engineering Intern, or related
OR Master's in Computer Science, Data Science and Machine Learning, Distributed Systems, Networking, Cybersecurity, or related field and 2 years of experience as Full Stack Developer, Software Engineer, Software Engineering Intern, or related
1 year must include experience with Node.js
1 year must include experience with Python
1 year must include experience with NodeJS Front-end / Backend Frameworks
1 year must include experience with Front-end JavaScript frameworks such as PolymerJS/VueJS/ReactJS
1 year must include experience with relational database systems such as Cassandra/ MySQL/ Postgres etc.
1 year must include experience with NoSQL database systems such as Aerospike, MongoDB, DynamoDB, Redis or similar
1 year must include experience with AWS technologies such as EC2, S3, ECR
1 year must include experience designing products with web technologies that support cybersecurity products

Job Responsibility

Design and development of new features on the Endpoint Security (ENS) Real Protect cloud solution space which drives growth and revenue to the company
Design and development of new security features on the cloud which includes but not limited to machine learning based solutions such as Real Protect and on-premise offerings such as ePO, Endpoint Security (HX)
Design, coding, testing, bug fixing, code refactoring, code review and automation of new features
Monitor and resolve product performance issues and memory footprint issues to improve the customer experience
Sustenance of released versions of the products by resolving field issues which includes root cause analysis, bug fixing, automation and participating in maintenance release cycle
Participate in product release roadmap, educating and training other teams like documentation, sustenance and product support teams
Lead research tasks and innovation by working with subject matter experts and product roadmap plans
Determine methods and procedures on new assignments and may coordinate activities of other personnel
Actively participate in the grooming the user stories for the future sprints
Interview candidates on technical skillset and provide recommendation to manager

What we offer

Retirement Plans
Medical, Dental and Vision Coverage
Paid Time Off
Paid Parental Leave
Support for Community Involvement

Fulltime

Software Engineer Manager-PDB Document Management

The Software Engineering Manager for the Document Management space is part of th...

Location

United States , Austin, Texas; Warren, Michigan

Salary:

Not provided

General Motors

Expiration Date

Until further notice

Requirements

Bachelor's degree in Computer Science, Electrical Engineering, or a related technical field
10+ years of experience in software development
3+ years leading technical projects
At least 3 years experience as a people leader
Strong technical background in JAVA, Relational and no SQL Databases (Postgres, Elastic, Oracle), Messaging systems (Kafka, pulsar, rabbit MQ), GitHub Actions
Demonstrated ability to lead and mentor software development teams in an agile environment
Excellent communication, interpersonal, and collaboration skills
Experience with cloud platform and services

Job Responsibility

Be an effective people manager, bringing out the best performance from your team, as well as be a highly technical hands on coder in the team
Developing enterprise-grade applications using Kubernetes/Docker, Quarkus, Java, Angular, and PostgreSQL, among other tools
Define and lead the software strategy for new technologies, highly complex features, and drive the next generation Global Inventory Platform
Capable of hosting technical discussions, being a subject matter expert, and having strategic influence
Leads comprehensive design analysis of design solution
Own and drive complex technical projects from the planning stage through execution
Create a team environment that encourages innovation and continuous learning
Provide career development opportunities, maintain an ongoing constructive feedback loop, and inspire innovation and technical growth through hands-on mentoring and encouragement for your team members
Balance the adoption of new technologies with practical, efficient solutions
Will run the day to day software development lifecycle, like running daily standup, eliminating roadblocks

What we offer

Company Vehicle : Upon successful completion of a motor vehicle report review, you will be eligible to participate in a company vehicle evaluation program, through which you will be assigned a General Motors vehicle to drive and evaluate
This job may be eligible for relocation benefits

Fulltime

GenAI Engineering Lead

We are seeking an exceptional and highly motivated GenAI Tech Lead to join our d...

Location

India , Pune

Salary:

Not provided

Citi

Expiration Date

Until further notice

Requirements

10-15 years of relevant experience in Apps Development or systems analysis role, with a significant portion dedicated to AI/ML and demonstrable hands-on experience in designing, building, and deploying real-world Generative AI solutions, with a specific focus on GenAI adoption and Agentic AI for business process automation
Proficiency in at least two programming languages. Strong preference for Python, with significant experience in Javascript/Typescript and Golang being highly valued
Demonstrated deep hands-on experience in engineering and deploying enterprise-grade solutions that are highly scalable, resilient, and performant
Strong theoretical and practical understanding of Large Language Models (LLMs), including experience with various open-source and proprietary models, fine-tuning techniques, and deployment strategies
Proficiency with transformers, agentic frameworks, vector stores, and advanced search algorithms
Hands-on experience with Retrieval Augmented Generation (RAG) implementations
Experience with relevant GenAI/ML frameworks such as LangChain, LangGraph, MLFlow, Spring AI, Spring Boot, and Flask
Extensive experience with data analysis and manipulation using tools like SQL and Pandas
Proficiency in database technologies including Oracle, Postgres, or MongoDB
Proven experience in designing and implementing robust REST and WebSocket APIs

Job Responsibility

Strategic Leadership & GenAI Adoption: Drive the identification, evaluation, and adoption of emerging Generative AI technologies and tools to develop innovative solutions and enhance existing platforms. Actively design, develop, and implement AI/ML solutions within financial applications, with a strong emphasis on practical GenAI adoption. This includes hands-on coding, prototyping, and deploying GenAI solutions
Agentic AI for Business Process Automation: Lead the end-to-end design, prototyping, and implementation of Agentic AI solutions focused on automating critical business processes, ensuring they address business needs and scale effectively across the enterprise. This includes designing and implementing Retrieval Augmented Generation (RAG) systems to enhance accuracy and contextuality, especially for financial data
Chatbot Development: Design, develop, and deploy intelligent chatbot solutions capable of interacting with users across both structured data sources and unstructured data, leveraging GenAI for natural language understanding and generation in complex conversational flows
Document Processing & OCR Integration: Implement solutions for processing and extracting information from documents, including integrating Optical Character Recognition (OCR) technologies to handle scanned documents and images, making their content available for GenAI models
Text-to-SQL Implementation: Develop and deploy solutions leveraging Large Language Models to facilitate Text-to-SQL capabilities, enabling users to generate SQL queries from natural language requests, thus simplifying data access and analysis from structured databases
Data Analysis & Feature Engineering: Analyze large, complex datasets, identify intricate patterns, and extract actionable insights, leveraging GenAI capabilities for data augmentation or synthetic data generation, particularly relevant for Agentic AI applications
Data Pipeline Development: Build and maintain robust, scalable data pipelines for data ingestion, processing, and transformation, specifically optimizing for the unique requirements of GenAI model training and inference
Cross-Functional Collaboration: Partner with multiple management teams and business stakeholders to deeply understand requirements and translate them into precise technical specifications and actionable roadmaps, incorporating GenAI and Agentic AI possibilities into discussions
System Enhancements & Architecture: Identify and define necessary system enhancements to deploy new GenAI products and process improvements. Ensure application design adheres to the overall architecture blueprint, integrating GenAI and Agentic AI components seamlessly
Problem Resolution: Resolve a variety of high-impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards, applying GenAI and Agentic AI where they can offer innovative solutions

Fulltime

Staff Software Engineer, Data

At Astronomer, we’re redefining how companies run Apache Airflow at scale. Our R...

Location

United States , New York City

Salary:

215000.00 - 250000.00 USD / Year

Astronomer

Expiration Date

Until further notice

Requirements

Hands-on experience designing, developing, and scaling production infrastructure
Extensive knowledge of Postgres and Postgres-like cloud offerings (AWS, GCP, Azure)
Extensive and recent experience with building low-level data systems and/or managed data platforms
In-depth knowledge and practical experience of the product and technology space in Database and related fields (Blob, NoSQL, Timeseries, Graph, Vector)
Experience defining requirements and making and justifying technology choices around the data space
Strong experience in Non-Abstract Systems design and implementation
Strong proficiency in Golang and in-depth experience with Kubernetes
Strong communication skills, both written and verbal, with experience in working with a globally distributed team in delivery

Job Responsibility

Be a subject-matter expert in how we treat Data at scale
Recommend, design and later lead building the data systems that will help us continue to scale
Own and develop our Database and overall data strategy and practice
Be directly involved in decision-making on what we work on, as well as how we work on it
Make build vs. buy assessments, and advocate for the right tools for the right job when it comes to data
Create and maintain comprehensive internal documentation and decision records for systems and processes, ensuring clarity and accessibility
Participate in Architectural forums and discussion and make principled, open decisions

What we offer

equity component
comprehensive benefits package

Fulltime

Postgres Subject Matter Expert

Piper Companies

Location:
United States , Mclean

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

Job Description:

Job Responsibility:

Requirements:

Additional Information:

Job Posted:
January 06, 2026

Looking for more opportunities? Search for other job offers that match your skills and interests.

Similar Jobs for Postgres Subject Matter Expert

Data Architect

Staff Fullstack Software Engineer

Staff Software Engineer, Platform

Data Analytics Manager

Full Stack Developer

Software Engineer Manager-PDB Document Management

GenAI Engineering Lead

Staff Software Engineer, Data

Postgres Subject Matter Expert

Piper Companies

Location:United States , Mclean

Category:IT - Software Development

Contract Type:Not provided

Salary:

Job Description:

Job Responsibility:

Requirements:

Additional Information:

Job Posted:January 06, 2026

Looking for more opportunities? Search for other job offers that match your skills and interests.

Similar Jobs for Postgres Subject Matter Expert

Data Architect

Staff Fullstack Software Engineer

Staff Software Engineer, Platform

Data Analytics Manager

Full Stack Developer

Software Engineer Manager-PDB Document Management

GenAI Engineering Lead

Staff Software Engineer, Data

Location:
United States , Mclean

Category:
IT - Software Development

Contract Type:
Not provided

Job Posted:
January 06, 2026