Description

You design and maintain the data architecture for business intelligence and analytics.

Responsibilities

• Develop conceptual, logical, and physical data models for BI, analytics, and reporting.
• Transform requirements into scalable and efficient data structures supporting advanced analytics.
• Collaborate with stakeholders to gather and interpret requirements for new data initiatives.
• Design and optimize database schemas using the medallion architecture (relational, star, denormalized).
• Serve as the technical bridge between engineering teams and business units.

Required Skills

• 10+ years of professional experience in data architecture.
• Expertise with PostgreSQL.
• Experience with Google Cloud Platform (GCP) and BigQuery.
• Experience with Power Builder.
• Ability to translate complex business questions into actionable data models.
• Experience establishing master data management and data governance structures.
• Proficiency in mapping data flows and documenting dataset relationships.
• Experience monitoring and optimizing data models for query performance.

Key Skills

Education

Bachelor's degree