BI Data Engineer REMOTE at PSRTEK

Job Title: BI/ Data Engineer Location: Remote Job Description: Responsible for designing developing and optimizing a semantic data model using Looker Modeling Language (LookML) to transform raw data into a reliable consistent and user-friendly source of truth. Design and Implement LookML Models: Translate complex business requirements and raw data warehouse schemas (e.g. in BigQuery Snowflake Redshift) into robust scalable and highly performant LookML models Views and Explores. Define Metrics and Business Logic: Enforce a single source of truth by defining and centralizing all core business metrics dimensions and calculations (measures) within LookML. Develop Derived Tables: Create Persistent Derived Tables (PDTs) and Native Derived Tables (NDTs) to pre-calculate complex or common logic significantly improving query performance and user experience Experience: 3 years of professional experience in Business Intelligence development with at least 2 years of hands-on deep expertise with Looker and LookML. SQL Mastery: Advanced proficiency in writing and optimizing complex SQL queries across cloud data warehouses (e.g. BigQuery Snowflake etc.). Data Modeling: Solid understanding of data warehousing concepts including star/snowflake schemas and normalization/denormalization techniques. Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Full Time Experience: years Vacancy: 1