Job description
👋 Greetings, future tech savant: Embark on an exciting journey into the realm of software development with 3Pillar! We extend an invitation for you to join our team and gear up for a thrilling adventure. At 3Pillar, our focus is on leveraging cutting-edge technologies that revolutionize industries by enabling data driven decision making. As a Data Engineer, you will hold a crucial position within our dynamic team, actively contributing to thrilling projects that reshape data analytics for our clients, providing them with a competitive advantage in their respective industries. If your passion for data analytics solutions that make a real-world impact, consider this your pass to the captivating world of Data Science and Engineering! 🚀💻
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.
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
- Core Python, PySpark, Hadoop, MariaDB, SQL - good hands-on for query preparation, Automation skillset, JavaScript & JQuery, Banking/Regulatory reporting domain knowledge would be advantage
- Familiarity with the AWS/GCP data engineering servicesKnowledge of AWS services viz., S3, Lambda,, GLUE ETL, Athena, RDS, Redshift, EC2
- Proficiency in the English language.
DESIRED
- Knowledge of BigQuery
- Exposure to Tableau, PowerBI
BENEFITS
- What is it like working for 3Pillar Global?
At 3Pillar, we offer a world of opportunity:
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.
We are an equal opportunity employer. It goes without saying that we live by values like Intrinsic Dignity and Open Collaboration to create cutting-edge technology AND reinforce our commitment to diversity - globally and locally.
Join us and be a part of a global tech community! 🌍💼 Check out our Linkedin site and Careers page to learn more about what it’s like to be part of our #oneteam!
#LI-Remote
