[Remote] Data Architect (with Postgres)

Note: The job is a remote job and is open to candidates in USA. Perficient is a global AI-first consultancy that partners with innovative enterprises to deliver business results through AI. The Data Architect will provide architectural solutions for projects, assist with client engagements, and collaborate with industry talent to create innovative data solutions while focusing on performance and scalability. Responsibilities • 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/PostgreSQL • 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 • 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 shared repositories • Lead code review and knowledge-sharing sessions with development teams • Implement reproducible deployment and rollback processes for database objects • Evaluate logical and physical data models for performance, normalization/denormalization strategy, partitions, distribution keys, and storage efficiency • Define guidelines for schema design, distribution, and partitioning strategies • Collaborate with data governance teams to ensure model consistency and naming standards • Participate in production support for SQL job failures; help with root-cause analysis and guide optimization • Develop monitoring metrics and dashboards for long-running or error-prone jobs • Create and maintain documentation and runbooks for database performance management • Lead (POC) and planning for migration from Greenplum to AWS (Snowflake), including performance benchmarking • Evaluate workload translation, data partitioning, and performance scaling strategies in target platforms • Provide architectural input on hybrid data environments and ETL orchestration Skills • 8+ years of experience in data engineering or database development (PostgreSQL / Greenplum or similar MPP systems) • Expert SQL skills with proven experience in performance tuning of DW, MPP optimization, and execution plan analysis, and performance diagnostics • Strong hands-on experience with DW, like Greenplum in addition to PostgreSQL in enterprise-scale, multi-tenant environments • Experience/Exposure to Snowflake (including concurrency and parallelization challenges) • Deep understanding of data warehouse architecture, design patterns, and optimization techniques • Experience with ETL/ELT pipelines and AWS native integrations (Informatica, Glue, Lambda, Kafka, S3) • Python for automation, scripting, and ETL/ELT support, Working knowledge of Linux environment • Exposure to data governance, security, and compliance practices • Experience using Git for SQL loads with version control and peer-review workflows • Strong problem-solving skills for complex ETL and query performance issues • Knowledge of database monitoring, governance, and compliance best practices • Excellent communication and ability to guide and mentor engineers • Design and architecture experience supporting both batched and streaming workloads for Big Data Pipelines • At least 3 years of experience in a professional services company, consulting firm, or agency • Have a solid understanding of delivery methodology and lead teams in implementing the solution according to the designed architecture • Experience in project and solution estimation and team structure definition • Fluent and current on architecture trends with an eye on market/technical conditions and future direction • Experience in defining new architectures and the ability to drive an independent project from an architectural standpoint • Demonstrated ability to leverage AI tools to enhance productivity, streamline workflows, and support data-informed task execution • A solid understanding of AI capabilities and limitations, including ethical considerations, is expected • Demonstrated success in performing work and managing complex and/or large consulting projects • Ability to elicit requirements and communicate clearly with non-technical individuals, development teams, and other ancillary project members • Track record of leadership roles delivering solutions within defined timeframes • Experience working with a globally distributed team and managing off-shore teams • Desire to mentor younger team members and develop their skills • Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field • Experience leading data modernization or cloud migration to DW like AWS, Snowflake, or Redshift • Familiarity with Informatica, Glue, modern ETL tools and Batch orchestration • Scripting and programming skills (bash, Python, Java) for automation • Familiarity with Data modeling and implementation Company Overview • Perficient is an IT consulting firm that helps companies adapt their systems to third party software products that use internet. It was founded in 1998, and is headquartered in St Louis, Missouri, USA, with a workforce of 5001-10000 employees. Its website is Company H1B Sponsorship • Perficient has a track record of offering H1B sponsorships, with 125 in 2025, 147 in 2024, 156 in 2023, 196 in 2022, 175 in 2021, 223 in 2020. Please note that this does not guarantee sponsorship for this specific role. Apply tot his job