Overview

We are looking for a highly experienced Senior Data Modeler with 12+ years of overall experience in designing and implementing enterprise-scale data models. The ideal candidate will have deep expertise in BigQuery and modern Big Data modeling techniques, including denormalization and star schema design for analytical workloads. This role requires strong technical skills, business analysis capabilities, and the ability to work in a fast-paced, cloud-first environment.

Responsibilities

• Design and develop conceptual, logical, and physical data models for large-scale data platforms and analytical systems.
• Implement Big Data modeling techniques such as denormalization, star schema, and optimized partitioning for performance and scalability.
• Collaborate with business stakeholders to analyze requirements, understand data flows, and translate them into robust data models.
• Develop and maintain data models in Google BigQuery and other cloud-based environments.
• Ensure data governance, quality checks, and compliance from a data modeling perspective.
• Create and maintain metadata documentation and technical specifications using tools like Jira, Confluence, and SharePoint.
• Work closely with engineering teams to support ETL/ELT processes and optimize query performance.
• Provide mentorship and guidance to junior data modelers and analysts.
• Participate in Agile development processes, including sprint planning and retrospectives.

Qualifications

• 12+ years of experience in data modeling and database design.
• Strong expertise in BigQuery and Big Data modeling techniques (denormalization, star schema, dimensional modeling).
• Proficiency in SQL and ability to write complex queries for data analysis and validation.
• Experience with data warehouse design methodologies (Kimball, Inmon).
• Familiarity with cloud-based data platforms and modern data architecture principles.
• Strong understanding of data governance, metadata management, and data quality frameworks.
• Excellent communication, analytical, and problem-solving skills.

Preferred Qualifications

• Experience with large-scale data platforms and high-volume datasets.
• Knowledge of ETL/ELT tools, data pipelines, and performance optimization techniques.
• Exposure to Big Data technologies (e.g., Hadoop, Spark, Kafka) and streaming architectures.
• Certifications in Google Cloud Platform (GCP) or related technologies.

Technical Skills

• Data Modeling: Denormalization, Star Schema, Dimensional Modeling
• Tools: BigQuery, Erwin, ER Studio, SQLdbm
• Cloud: Google Cloud Platform (BigQuery, Dataflow, Cloud Storage)
• Databases: Oracle, SQL Server, MySQL, Snowflake
• Languages: SQL, PL/SQL
• Methodologies: Agile Scrum, Waterfall