Senior Data Architect with PostgreSQL

Overview

Remote
$70 - $80
Contract - W2
Contract - Independent
Contract - 12 Month(s)
50% Travel

Skills

Senior Data Architect
PostgreSQL
Data Governance
Data Quality
Data Modeling
databases

Job Details

Position: Senior Data Architect with PostgreSQL

Location: Remote

Type: Contract (C2C, W2, 1099)

We are seeking an experienced Senior Data Architect who possesses a comprehensive skill set encompassing Data Architecture, Data Engineering, and Data Modeling to join our team. This is a hands-on role where you will be responsible for overseeing the design, implementation, and governance of our Enterprise Data Model within a Data Lake at an enterprise scale. You will also serve as the primary guardian of the Enterprise Data Model, ensuring adherence to best practices in data governance, quality, and architecture.

As a key member of the data team, you will collaborate closely with business stakeholders, cross functional data teams, and subject matter experts (SMEs) to implement data solutions that support data-driven decision-making at scale.

Qualifications:

  • Minimum of 10+ years of experience in data, digital, technology or analytical roles.
  • Expertise in installing, configuring, securing and maintaining PostgreSQL databases.
  • Deep understanding of networking concepts, including setting up PostgreSQL replication (master-slave, master-master), failover and clustering.
  • Expertise in query performance tuning, using tools like pg_stat_statements, EXPLAIN ANALYZE and server settings to optimize database performance.
  • Experience with PostgreSQL-specific tools such as pgAdmin, pgBouncer, pgBadger, pg_repack etc.
  • Extensive experience in Data Architecture Design, Data Modeling, including Star Schema, Data Vault and Analytical/Semantic Models With Peformance Tuning
  • Expertise in industry-standard data modeling tools such as Erwin.
  • Solid understanding of Data Platform and Data Warehouse frameworks, including data integration patterns and architecture.
  • Collaborate with DevOps and application teams to optimize query performance and database architecture
  • Conduct regular security assessments, patching, and vulnerability remediation
  • Automate monitoring, backups, and failover strategies using industry best practices
  • Provide expert-level troubleshooting and root cause analysis for databaserelated incidents
  • Experience in Cloud Architecture (AWS, Azure, Google Cloud Platform) and modern data platforms such as Snowflake.
  • Experience working with metadata management, including business and technical metadata, data cataloging, quality, governance, taxonomy, and ontology.

Technical Skills:

  • Strong knowledge of Data Governance, Data Quality, and Data Modeling best practices.
  • Hands-on expertise in Cloud-based Architecture (AWS, Azure, Google Cloud Platform).
  • Experience in integrating AI/ML frameworks into data platforms.
  • Ability to write clear design specifications and technical documentation.
  • Proven ability to mentor and guide teams on Data Architecture Principles.

Certifications:

  • Relevant certifications in Cloud-based Architecture (AWS, Azure, or Google Cloud Platform) are a plus.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Infodyne Solutions