Data Integration & Engineering: Develop ETL/ELT pipelines to ingest, transform, and move data from Google BigQuery to Microsoft Fabric (OneLake).
Performance Optimization: Monitor and tune Data Factory pipelines and SQL queries for large-scale, high-performance data processing.
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.
