Senior Data Engineer

Summary

Join 3Pillar Global as a Data Engineer and contribute to cutting-edge data analytics projects. You will design, develop, and maintain data pipelines using dbt, create data models, build Looker dashboards, and collaborate with stakeholders. Responsibilities include monitoring data quality, optimizing pipelines, troubleshooting issues, and implementing data governance practices. The ideal candidate possesses 5+ years of experience in a similar role, advanced SQL skills, and expertise in dbt and Looker. Strong Python skills and familiarity with cloud platforms are also required. 3Pillar offers a flexible work environment, global team collaboration, well-being initiatives, and career development opportunities.

Requirements

• Demonstrated expertise with a minimum of 5+ years of experience as data engineer or similar role
• Advanced SQL skills and experience with relational and non-relational databases
• Deep understanding of data warehousing concepts
• Extensive experience with dbt (data modeling and transformation)
• Expertise in Looker dashboard development and administration
• Familiarity with cloud platforms (AWS, GCP, Azure)
• Strong Python skills with hands-on experience on Panda, NumPy and other data-related libraries
• Strong exposure to write ETL
• Proven track record of designing and implementing data pipelines using dbt
• Experience building and maintaining Looker dashboards and explores
• Familiarity with data governance practices and data security protocols
• Experience in Data collection from multiple sources and integrating based on business needs
• Proficiency in the English language

Responsibilities

• Understanding the business requirements
• Design, develop, and maintain data pipelines using dbt to transform and load data into a data warehouse (e.g., Snowflake, BigQuery)
• Create and manage data models within dbt to ensure data consistency and accuracy for analysis
• Build and maintain Looker dashboards and explore, translating complex data into intuitive visualizations for business users
• Collaborate with business stakeholders to understand data requirements and translate them into effective data visualizations within Looker
• Monitor data quality and implement data quality checks to ensure data integrity
• Optimize data pipelines for performance and scalability
• Troubleshoot data issues and resolve data quality discrepancies
• Implement data governance practices to ensure data security and compliance

Preferred Qualifications

• Knowledge of BigQuery
• Exposure to Tableau, PowerBI

Benefits

• Imagine a flexible work environment – whether it's the office, your home, or a blend of both. From interviews to onboarding, we embody a remote-first approach
• You will be part of a global team, learning from top talent around the world and across cultures, speaking English everyday. Our global workforce enables our team to leverage global resources to accomplish our work in efficient and effective teams
• We’re big on your well-being – 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 generous time off, we want all of our team members operating at their best
• Our professional services model enables us to accelerate career growth and development opportunities - across projects, offerings, and industries