5 Smollan Group Jobs

Role & responsibilities

Summary:

We are seeking a highly skilled and experienced Looker Developer to join our team. The ideal candidate will have a strong understanding of data engineering principles and practices, as well as experience in Big Query optimization, ETL pipeline design, data modeling with SQL and Python, data quality monitoring, schema design, and automated validation checks. The candidate will play a critical role in designing, building, and maintaining our data infrastructure, ensuring that our data is accurate, reliable, and accessible.

• Big Query Optimization: Optimize Big Query performance through query tuning, partitioning, and clustering strategies.
• ETL Pipeline Design: Design and implement efficient and scalable ETL pipelines to extract, transform, and load data from various sources into our data warehouse.
• Data Modeling: Develop and maintain data models using SQL and Python to support business intelligence and analytics.
• Data Quality Monitoring: Implement data quality monitoring processes and automated validation checks to ensure data accuracy and integrity.
• Schema Design: Design and implement database schemas that are optimized for performance and scalability.
• Data Ingestion: Develop and maintain data ingestion processes to efficiently load data from various sources into our data warehouse.

Preferred candidate profile

Must-Haves (Absolutely Required):

• SQL: Expert-level SQL for BigQuery, including query optimization.
• Python: Proficient Python scripting for data manipulation and automation (pandas, etc.).
• BigQuery: Deep, hands-on BigQuery experience (architecture, optimization, loading, security).
• ETL: Proven experience designing and building ETL pipelines (Dataflow, Airflow, or custom).
• Data Modeling: Strong understanding of data warehousing modeling concepts (star schema, etc.).
• Schema Design: Can create and implement optimized, scalable database schemas.
• Problem-Solving Ability: Ability to analyze and solve complex data engineering problems.
• Communication Skills: Excellent written and verbal communication skills.

Perks and benefits

• Competitive salary and benefits package
• Opportunities for professional growth and development
• Work on challenging and impactful projects
• A collaborative and supportive work environment