BigQuery Data Engineer

As a Data Engineer at DataNimbus, you will play a crucial role in designing, developing, and maintaining a highly scalable data warehouse solution in BigQuery. Your responsibilities will include: - Designing data models, schemas, and partitioning strategies to ensure efficient query performance. - Building and maintaining ETL/ELT pipelines using tools like Dataflow, Dataproc, Cloud Composer (Airflow), or dbt. - Optimizing query performance and managing cost-efficient BigQuery usage. - Implementing data governance, security, and compliance best practices such as IAM, data masking, and audit logging. - Collaborating with data analysts, data scientists, and business stakeholders to deliver reliable, high-quality datasets. - Ensuring data quality and consistency through monitoring, validation, and testing. - Mentoring junior engineers and contributing to best practices, coding standards, and documentation. Qualifications required for this role include: - 6+ years of experience in Data Engineering, with at least 3+ years working on BigQuery in a production environment. - Strong SQL expertise, including query optimization and advanced SQL features. - Proficiency in at least one programming language (Python, Java, or Scala). - Experience with the cloud data ecosystem, with a preference for Google Cloud Platform. - Strong understanding of data modeling, star/snowflake schemas, and OLAP concepts. - Hands-on experience with ETL/ELT frameworks and workflow orchestration tools like Airflow, Cloud Composer, and dbt. - Knowledge of data governance, lineage, and security practices. - Familiarity with streaming/batch data ingestion tools such as Pub/Sub, Kafka, or equivalent. - Exposure to machine learning workflows in BigQuery ML. - Experience with BI/visualization tools like Looker, Tableau, or Power BI. At DataNimbus, you will have the opportunity to work with cutting-edge technologies, contribute to solutions trusted by global businesses, and grow personally and professionally in a culture that values curiosity and continuous learning. If you are passionate about innovation, enjoy solving complex challenges with simplicity, and are eager to make a difference, DataNimbus is the place for you.,