Career

Data Modeler / Data Analyst

Exciting Opportunity:

We’re looking for a seasoned Data Modeler / Data Analyst to design and deliver intelligent, scalable, and high-performance data solutions on Google Cloud Platform (GCP), with a strong focus on BigQuery.

Experience: Data Modeler / Data Analyst (6–8 Years)

Location: Pune

Responsibilities:

· Collaborate with cross-functional teams to understand business needs and translate them into conceptual, logical, and physical data models.

· Design scalable data architectures using star/snowflake schemas, data vaults, and modern best practices.

· Optimize BigQuery datasets using partitioning, clustering, sharding, and materialized views for performance and cost-efficiency.

· Define and enforce data modeling standards, naming conventions, and maintain metadata documentation.

· Work closely with data engineers on ETL/ELT strategy, pipeline design (Dataflow, dbt, Composer), and model alignment.

· Conduct data profiling, validation, and troubleshoot data issues across environments.

· Perform schema change impact assessments and lead version-control of models.

· Mentor junior team members and contribute to architecture and design reviews.

· Recommend cost-optimization strategies for BigQuery and other GCP data services.

What You Bring

· 6–8 years of experience in data modeling, data warehousing, or database design, including 2+ years on GCP BigQuery.

· Expertise in SQL, dimensional modeling, 3NF, data vault, and cloud-native modeling principles.

· Deep knowledge of query optimization techniques, BigQuery partitioning/clustering, and materialized views.

· Hands-on experience with ETL/ELT tools: Dataflow, Cloud Composer, dbt, or similar.

· Familiarity with BI/reporting tools such as Looker, Tableau, Power BI.

· Understanding of data governance, metadata management, and lineage tracking using tools like GCP Data Catalog.

· Excellent verbal and written communication skills; able to bridge business and technical discussions.

Academic Qualifications: Bachelor’s or Master’s degree in computer science, Information Systems, Engineering, Statistics, or a related field.

Why Join Us

At Smart Analytica, we're at the forefront of cloud innovation, leveraging Azure's cutting-edge technologies to drive transformative data solutions. As an Azure Cloud Data Solutions Architect, you'll play a pivotal role in shaping enterprise-scale platforms that harness the full potential of Azure's ecosystem. We offer a collaborative work environment, opportunities for professional growth, and the chance to work on impactful projects that drive real-world results

How to Apply

Send your resume and a statement of interest to hiring@smart-analytica.com

Team Smart Analytica

Newsletter Sign up

Sign up for our newsletter to discover winning trends before your competition!