Role overview

Qualifications

Proficiency in MongoDB
Experience with MySQL
Knowledge of Snowflake SQL
Good to have Python including ETL frameworks like rivery or informatica

Responsibilities

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

Key facts

Remote from: India
Full time
Senior (5-10 years)
Data Engineer
English

Hard skills

MongoDB MySQL Data Engineering Data Quality Assessment Information Privacy Python (Programming Language) Informatica Mental Health

Other skills

Collaboration
Communication
Physical Flexibility

About the company

3Pillar

3Pillar Global builds breakthrough software products that power digital businesses. 3Pillar is an innovative product development partner whose solutions drive rapid revenue, market share, and customer growth for industry leaders in Software and SaaS, Media and Publishing and Information Services. Leveraging a lean and agile approach, 3Pillar delivers value-generating, digital solutions with specialized product strategy and management, user experience design, as well as software and data engineering expertise across mobile, cloud, and disruptive technologies. For more information on the company and our services, please visit https://www.3pillarglobal.com. For current job openings in North America, APAC, LATAM and EMEA, please visit https://www.3pillarglobal.com/career-opportunities/.

Company details

Company typeLarge

Industry

Company size1001 - 5000

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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 Responsibilities:

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.

Job Description: Data Engineer

NoSQL-to-RDBMS Mapping: Flatten and normalize complex, nested JSON data from MongoDB into structured relational tables.

Pipeline Development: Build and manage reliable ETL pipelines to ingest data from MongoDB, process it via Snowflake, and load it into MySQL.

Database Optimization: Design, index, and tune target MySQL databases to ensure high performance and strict data integrity.

Snowflake Utilization: Leverage Snowflake's variant handling capabilities to efficiently stage, parse, and transform semi-structured data.

Technical Stack: Proficiency in MongoDB, MySQL, Snowflake SQL, good to have Python (including ETL frameworks like rivery or informatica).

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.

Benefits:

At 3Pillar, we create an environment where people can do their best work while maintaining a healthy work-life balance.

Flexibility & Well-being – Our remote-first approach gives you the flexibility to work where you perform best, while prioritizing your well-being and personal commitments.

Global Community – Collaborate with talented colleagues across the globe in a culture built on connection, support, and shared success.

Your Voice Matters – We foster open communication and multiple feedback channels, ensuring every employee has the opportunity to be heard and make an impact.

Growth & Development – Gain exposure to diverse clients, industries, and challenges that accelerate learning and career growth.

Our culture is guided by four core values: Collaboration, Outperform, Respect, and Evolve—the principles that shape how we work, grow, and succeed together.