Data Architect; Postgres

Position: Data Architect (with Postgres)
Perficient is a global AI-first consultancy. Our team of strategists, designers, technologists, and engineers partners with the world's most innovative enterprises and admired brands to deliver real business results through the transformative power of AI. As part of our AI-First strategy, we empower every employee to build AI fluency and actively engage with AI tools to drive innovation and efficiency.

We break boundaries, obsess over outcomes, and shape the future for our clients. Join a company where bold ideas and brilliant minds converge to redefine what's possible - while building a career filled with growth, balance, and purpose.

Perficient currently has a career opportunity for a Data Architect to join our team located in the United States. This role is primarily office-based at a local Perficient location, with travel and on-site client engagements expected as needed.

Job Overview

The Data Architect is expected to be knowledgeable in two or more technologies within the Data & Analytics domain. The Solutions Architect may or may not have a programming background, but will have expert infrastructure architecture, client presales / presentation, team management, and thought leadership skills.

You will provide best-fit architectural solutions for one or more projects; you will assist in defining the scope and sizing of work; and anchor Proof of Concept developments. You will provide solution architecture for business problems, perform platform integration with third-party services, and design and develop complex features for clients' business needs.

You will collaborate with some of the best talent in the industry to create and implement innovative high quality solutions, participate in Sales, and various pursuits focused on our clients' business needs. You will also contribute in a variety of roles in thought leadership, mentorship, systems analysis, architecture, design, configuration, testing, debugging, and documentation. You will challenge your leading-edge solutions, consultative, and business skills through the diversity of work in multiple industry domains.

About Us

The Perficient Data & Analytics Solutions organization supports a wide variety of clients, technologies, and applications. Our Team members drive innovation in the arena of data and analytics solutions. We work on innovative digital transformation deployment for various clients across the globe. We had explosive growth in the last few years to meet the demands of a massive transition to digital with an AI-first approach.

Our practice groups include Artificial Intelligence, Analytics, Content Management, Data Governance, Data Management, Data Strategy, and Search.

Perficient is always looking for the best and brightest talent, and we need you! We're a quickly growing, global digital consulting leader, and we're transforming the world's largest enterprises and biggest brands.

You'll work with the latest technologies, expand your skills, and become a part of our global community of talented, diverse, and knowledgeable colleagues.

RESPONSIBILITIES

SQL & Database Optimization

• Review SQL functions, queries, and ETL pipelines for performance and best practices.
• Develop and enforce SQL coding standards and query tuning guidelines for developers using Greenplum/Postgre
  
  SQL.
• Partner with DBAs to monitor database health, throughput, and segment usage; identify and remediate performance bottlenecks.
• Provide mentoring and training on Greenplum query execution plans, partitioning, and workload management.
• Assess database schemas and DDL for gaps and improvements.
• Analyze and optimize long-running queries and workloads.
• Lead database capacity planning and scalability strategy.

Engineering Practices & Governance

• Establish and maintain version control best practices (Git branching, code review workflow, CI/CD for SQL).
• Define conventions for SQL function documentation, deployment, and testing in hared repositories.
• Lead code review and knowledge-sharing sessions with development teams.
• Implement reproducible deployment and rollback processes for database objects.

Data Modeling & Architecture

• Evaluate logical and physical data models for performance,…