Overview
Remote
On Site
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12
Skills
Snowflake
REDSHIFT
BigQuery
Data model
Semantic
BI/ Data Engineer
LookML
Looker
Job Details
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.
PSRTEK is a reputed technology recruitment and IT staffing brand with a global footprint and an admired client base. As an ideas and innovation powerhouse with a culture of excellence, we bring remarkable expertise and deliver powerfully transformative results.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.