Data Engineer/Data Scientist (Looker)

As a Data Engineer/Data Scientist at 3Pillar Global, your key responsibilities will include designing and maintaining data pipelines using dbt to transform and load data into BigQuery, collaborating with business teams to understand their data needs, and developing insightful visualizations in Looker. You'll also be responsible for creating and managing data models to ensure the data's accuracy and consistency for analysis.

To excel in the Data Engineer/Data Scientist role at 3Pillar Global, you should have extensive experience with Looker, proficiency in GCP cloud platforms, strong skills in Python and libraries like Pandas and NumPy, advanced SQL capabilities, and a deep understanding of data warehousing concepts. Experience with dbt for data modeling and transformation is also crucial for this position.

3Pillar Global offers an impressive benefits package for its Data Engineer/Data Scientist role, which includes comprehensive medical, dental, and vision insurance, life insurance, and short-term and long-term disability coverage. Furthermore, employees enjoy unlimited PTO, a supportive environment focusing on wellbeing, and a 401K retirement savings plan.

Collaboration is at the core of the Data Engineer/Data Scientist role at 3Pillar Global. You will work closely with various business stakeholders to gather data requirements and translate them into actionable insights through effective visualizations in Looker. This collaborative approach ensures that our solutions align perfectly with client goals.

The culture at 3Pillar Global emphasizes intrinsic dignity, outsized impact, and open collaboration. As a Data Engineer/Data Scientist, you will be part of a dynamic team that values continuous improvement and innovation. This environment fosters your growth and encourages you to contribute your best to our mission of delivering exceptional products and services.

In your response, consider highlighting specific projects where you developed dashboards and visualizations using Looker. Discuss your process for collaborating with stakeholders to ensure their data needs were met effectively, as well as any technical challenges you overcame in the process.

Provide an overview of your methodology for designing data pipelines, including the tools you use such as dbt and BigQuery. Mention how you ensure data accuracy and consistency and any practices you follow to optimize performance in the pipeline.

Discuss your experience with data modeling, particularly using dbt within GCP. Explain how you ensure that data models support efficient data analysis and how you address changes in business requirements while maintaining data integrity.

In your answer, talk about your experience in gathering requirements from diverse business stakeholders and how you balance competing priorities. Mention the importance of clear communication and regularly checking in with users to clarify their needs and expectations.

Emphasize your SQL skills by providing examples of how you've used SQL to query complex datasets, generate reports, or create insights. Discuss the relational and non-relational databases you've worked with and how you optimize queries for performance.

Talk about the principles you apply to create intuitive visualizations, such as understanding the target audience, focusing on key metrics, and using appropriate visualization techniques. Provide examples of dashboards you've developed and how they improved data accessibility for users.

Share a specific project that posed significant challenges, describing the obstacles you encountered, whether technical, organizational, or otherwise. Focus on your problem-solving skills and the collaboration strategies you used to address the challenge effectively.

Discuss your approach to ensuring data quality, such as implementing testing mechanisms in your data pipelines, maintaining proper documentation, and regularly reviewing models for accuracy. Mention any tools or methodologies you apply to uphold data integrity.

In your answer, mention your commitment to continuous learning. Talk about the resources you engage with, such as online courses, webinars, and industry conferences, that help you stay informed about new tools, methodologies, and best practices in the field.

Consider discussing qualities such as analytical thinking, attention to detail, or strong communication skills. Provide reasoned arguments for your choice and relate it back to how this quality would enable you to succeed at 3Pillar Global.