Senior Data Engineer

Summary

Join 3Pillar Global's data team as a Senior Data Engineer and leverage your expertise in Looker, LookML, BigQuery, and SQL to transform data into actionable insights. You will design, develop, and maintain Looker dashboards and visualizations, write and optimize complex SQL queries, and develop LookML models. Collaborate with stakeholders to gather BI requirements, suggest cost optimization solutions, and ensure data accuracy and performance. Monitor Looker performance, work with data engineers and analysts, and provide training and documentation for end-users. Follow best practices for data governance, security, and compliance. 3Pillar Global offers a remote-first culture with flexible work arrangements and a commitment to employee well-being.

Requirements

• 5+ years of experience as a BI Developer or in a similar role
• Strong hands-on experience with Looker and LookML development
• Proficient in SQL with a deep understanding of data transformation and analysis
• Hands-on experience with Google BigQuery or similar cloud data warehouse solutions
• Solid understanding of data modeling concepts (star/snowflake schemas, dimensional modeling)
• Experience working with large datasets and performance tuning for BI tools
• Excellent communication skills and the ability to translate business needs into technical solutions

Responsibilities

• Design, develop, and maintain Looker dashboards and visualizations to meet business needs
• Write and optimize complex SQL queries to extract, transform, and analyze data from large datasets in BigQuery
• Develop and maintain LookML models, explores, views, and dashboards
• Collaborate with stakeholders to gather BI requirements and translate them into technical specifications
• Suggest Cost optimization solutions
• Understanding current Data Architecture structure and suggesting the required changes
• Ensure data accuracy, consistency, and performance in reporting and analytics solutions
• Monitor Looker performance and optimize LookML models and SQL for efficiency
• Work closely with data engineers and analysts to align on data pipelines and definitions
• Provide training and documentation for end-users on Looker dashboards and data sources
• Follow best practices for data governance, security, and compliance

Benefits

• Career growth and development
• Physical and mental wellbeing: as a company, we spend a whole trimester in our annual cycle focused on wellbeing. Whether it is taking advantage of fitness offerings, mental health plans (country-dependent), or simply leveraging unlimited PTO to take some needed time off, we want all of our team members operating at their best
• Living our value for Intrinsic Dignity as an equal opportunity employer