Senior Data Engineer, EIM

Vena Solutions; Maharashtra; On-site; INR 3,845,976 - 4,720,062; Full time

Job summary

Vena Solutions in Pune is seeking an experienced Data Engineer to design and implement a scalable internal data platform. The role includes building the data warehouse and ETL pipelines, aligning with data governance, and enabling data-driven decision making for our North American team.

You will drive technical excellence, implement MVP-driven delivery, and collaborate with stakeholders to standardize data practices across the organization.

Qualifications

• 4+ years building and deploying data integration (ETL) workflows from multiple sources.
• Experience with cloud data warehouses such as Redshift or Snowflake.
• Strong SQL and Python programming skills.
• Experience with data integration tools: Fivetran, Stitch.
• Ability to design reusable ETL components and pipelines.
• Experience in an agile or scrum environment.

Responsibilities

• Drive execution of the technical vision for the internal Data Infrastructure.
• Elevate technical excellence across the EIM organization.
• Build a source-agnostic data program consolidating data from multiple apps.
• Create MVP-driven, sprint-focused data delivery and backlogs.
• Design and implement scalable data architectures and data models.
• Develop data mapping, ETL rules and validation activities.
• Collaborate with stakeholders to deliver secure, governance-aligned data pipelines.

Skills

ETL workflows

SQL

Python

Data integration

Agile/Scrum

Tools

Redshift

Snowflake

Fivetran

Stitch

Job description

Department: Enterprise Information Technology

Location: India - Resident (0008)

Description

This role will be working out of our Pune office 5 days a week and is required to work an evening shift from 5:00 PM to 2:00 AM IST to support our North American team.

Are you looking to play an integral role in designing and implementing a Data Warehouse from the ground up? Vena has embarked on the journey of becoming a more data-driven organization and we realize that data is one of our most important assets. It’s an exciting time to join our growing Enterprise Information Management team, which is currently working on a large program to fundamentally transform the way we leverage data to drive business outcomes. We are looking for an experienced Data Engineer who will play an integral role in designing, implementing, monitoring and evolving our internal data platform with scale in mind.

We have many critical business systems and an ambitious data strategy to execute against to enable us to unlock value, insights and improve decision-making. The ideal candidate is both a data engineer and leader, who can design and enforce standards, best practices and methodologies, enable scalability of data engineering, quality assurance and analysis, and has strong interpersonal skills and can demonstrate the ability to work with nuanced data concepts.

How You’ll Make An Impact

• Drive the execution of the technical vision of our internal Data Infrastructure.
• Evolve the maturity and the level of technical excellence across your group and the entire EIM organization.
• Build an all-inclusive data program that is source agnostic and brings together data from various business applications to provide product usage, marketing effectiveness, employee retention, LTV, all in one place.
• Create true agility within the data team to work sprint‑by‑sprint and build progressively, embracing the concept of MVP and backlogs.
• Design and implement strategies that will achieve growth and productivity through process automation of existing and new operating models.
• Create data models, data mapping and the necessary ETL design. Build and validate activities for various data integrations.
• Partner with key stakeholders teams to deliver a scalable next generation data architecture, and solid data engineering processes that align with corporate Security and Data Governance.
• Foster data-driven culture and the creation of related competencies and data literacy across the organization.

We’d Love to See

• 4+ years of building and deploying data integration (ETL) workflows from multiple business applications (HubSpot, Salesforce, ADP WFN), databases, flat files, JSON/XML, APIs with proven working experience in an agile or scrum environment.
• Direct experience with Redshift, Snowflake, or similar cloud data warehouse technology. Snowflake is preferred.
• Strong programming skills in SQL, Python and data integration tools such as Fivetran, and Stitch. Fivetran is preferred.
• Skilled in creating source-to-target data mapping and ETL transformation rules.
• Experience developing and/or managing near real‑time data pipelines and fast data architectures.
• Experience with creating reusable ETL framework/components, automated testing, continuous integration and automated build pipelines.
• Excellent understanding of relational and dimensional data modelling.
• The ability to influence through strong communication and interpersonal skills.
• A love of learning, a drive for self‑improvement and a desire to help everyone be better.
• Understanding of complex business processes and subject matter, able to grasp and simplify the expression of complex scenarios in a way that helps business partners get to solutions;
• Customer service minded and strong client interaction skills.
• A top performer with a diligent work ethic and commitment to excellence.
• Interest in AI and willingness to explore AI-driven solutions to enhance performance and drive efficiencies

The annual base salary range for this role is 3,845,976– 4,720,062 INR.

• Our salaries are tailored to roles, levels and locations. Your individual pay within this range is influenced by factors like work location, skills, experience and education. As you progress in your role, your compensation may adapt, offering flexibility for growth beyond initial levels. For specifics, your recruiter will provide details and address any questions during the hiring process.