Senior Data Engineer( Snowflake , Azure)
3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin America, and Asia, we work with the most ambitious companies in financial services, healthcare, media, and technology - helping them move faster, modernize boldly, and compete on their own terms. Our HelixAI platform and Helix Pods delivery model put our engineers at the center of real agentic transformation - doing work that is open, portable, and built to last. We are building the future of enterprise AI
Key Responisiobilities
Understanding the business requirements
Writing code and implementing the proposed solutions
Creating data pipelines, versioning and change management
Manage the complexity inherent in versioned data pipelines
Develop ETL/ELT processes to help extract and manipulate data from multiple sources.
Design, build and maintain batch or real-time data pipelines in production.
Automate data workflows such as data ingestion, aggregation, and ETL processing.
Logging and instrumentation of pipelines and services.
Ensure data accuracy, integrity, privacy, security, and compliance through quality control procedures.
Train and mentor junior engineers.
Minimum Qualifications
Demonstrated expertise with a minimum of 5+ years of experience as data engineer or similar role
Advanced SQL skills and experience with relational databases and database design.
Experience working with cloud Data Warehouse solutions (e.g., Snowflake, Redshift, BigQuery, Azure Synapse, etc.).
Strong Python skills with hands-on experience on Pandas, NumPy and other data related libraries
Experience with Big Data technologies like Spark, Map Reduce, Hadoop, Hive etc
Proficiencient in data pipeline and workflow management tools e.g. Airflow
Experience with data visualization tools like PowerBI, Tableau, AWS QuickSight etc
Experience with the AWS/Azure/GCP data engineering services
Knowledge of AWS services viz., S3, Lambda, EMR, GLUE ETL, Athena, RDS, Redshift, EC2, IAM
OR
Knowledge of Azure services viz., ADF, Azure Synapse Analytics, ADLS Gen2, Azure SQL DB
Very good exposure of working on Data Lakes & Data Warehouses solutions
Excellent problem-solving, communication, and organizational skills.
Proven ability to work independently and with a team.
Ability to guide other data engineers.
Additional Experience
Experience working with data ingestion tools such as Fivetran, stitch, or Matillion.
Good understanding of NoSQL databases like Redis, Cassandra, MongoDB, or Neo4j.
Familiarity with machine learning technologies.
Experience in Java or Scala