Strong experience in Snowflake DWH and its components
Advanced SQL (CTEs, window functions, tuning)
Python for data pipelines and processing
Requirements:
Lead data engineering projects leveraging Snowflake and Python to deliver scalable data solutions
Design, develop, and optimize ETL/ELT pipelines with a focus on data integrity and root-cause analysis
Architect data lake/warehouse solutions and collaborate with cross-functional teams to meet business goals
Mentor and lead a team of engineers while driving innovation and establishing global standards
Job description
🌟 Distinguished Tech Innovator:3Pillar warmly extends an invitation for you to join an elite team of visionaries. Beyond software development, we are dedicated to engineering solutions that challenge conventional norms. Envision you: steering projects that redefine urban living, establish new media channels for enterprise companies, or drive innovation in healthcare. Your invaluable expertise will serve as the cornerstone in shaping the future direction of our endeavors.This role transcends the ordinary realms of coding; it's about orchestrating technological marvels that disrupt industries. Seize this extraordinary opportunity to lead a team that is actively shaping the tech landscape for our clients, and sets global standards along the way. 🌍🔥
Minimum Qualification
Experience: 5-10 years of experience in data engineering,
Strong exp in Snowflake DWH and its components
SQL — advanced (CTEs, window fns, tuning)
Amazon QuickSight (BI visualizations)
Python (pipelines, data processing)
Data integrity & root cause analysis
ETL / ELT pipeline development
dbt (data build tool)
AWS Glue / Lambda / S3
Rockset (analytical engine)
SQL-heavy role.
Snowflake critically important.
Amazon QuickSight used to render visualizations for clinical stakeholders.
Additional experience
Data Architecture: Experience designing or optimizing data lake solutions.
Security Practices: Understanding of data security practices, data governance, and compliance for secure data processing.
Automation & CI/CD: Familiarity with CI/CD tools to support automation of deployment and testing.
Big Data Technologies: Knowledge of big data processing tools like Spark, Hive, or related AWS services.
Advanced Analytics: Background in analytics or data science to contribute to more data-driven decision-making.
Cross-Functional Collaboration: Experience collaborating with non-technical teams on business goals and technical solutions.