01
TRPD-26-06334
Data Engineer
This permanent Data Engineer role focuses on migrating Medical Affairs data pipelines, reporting assets, and business logic into the IMD Hub target architecture. The core requirements are strong Snowflake and Python skills, data warehousing and modeling knowledge, migration and reconciliation experience, and familiarity with data documentation, governance, and production support. Pharmaceutical or Life Sciences domain knowledge is required by the description, with Medical Affairs experience preferred; experience creating STTM artifacts and supporting CI/CD is also important. The structured input specifies a 6–10 year experience band and locations of Bengaluru, Chennai, Cochin, Gurgaon, Hyderabad, Noida, and Pune. Work mode is not specified, and the description does not independently state the experience band, locations, or employment type.
Position summary
- Location
- India
- Workplace
- Hybrid
- Employment
- Full Time
- Experience
- Minimum 6 years and Maximum 10 years
Role overview
Why This Role Matters.
This permanent Data Engineer role focuses on migrating Medical Affairs data pipelines, reporting assets, and business logic into the IMD Hub target architecture. The core requirements are strong Snowflake and Python skills, data warehousing and modeling knowledge, migration and reconciliation experience, and familiarity with data documentation, governance, and production support. Pharmaceutical or Life Sciences domain knowledge is required by the description, with Medical Affairs experience preferred; experience creating STTM artifacts and supporting CI/CD is also important. The structured input specifies a 6–10 year experience band and locations of Bengaluru, Chennai, Cochin, Gurgaon, Hyderabad, Noida, and Pune. Work mode is not specified, and the description does not independently state the experience band, locations, or employment type.
Your Impact
Deliver Enterprise Value
Help organisations solve complex business problems through modern technology, consulting expertise and measurable outcomes.
Collaboration
Work Across Teams
Collaborate with consultants, architects, engineers and client stakeholders throughout the project lifecycle.
Growth
Learn Continuously
Gain exposure to enterprise technologies, certifications, mentoring and real-world project experience.
Career Path
Grow With Ubique
Build a long-term consulting career with opportunities to take on greater responsibility and leadership over time.
Responsibilities
What You'll Be Doing.
Every role at Ubique contributes directly to solving meaningful business challenges for our clients.
02
Re-point upstream and downstream integrations to ensure seamless transition from legacy platforms to IMD Hub.
03
Validate migrated datasets, KPIs, metrics, and reporting outputs to ensure alignment with source systems and business requirements.
04
Create and maintain Source-to-Target Mapping (STTM), data dictionaries, metadata, and technical documentation.
05
Support deployment and operationalization of Facts, Dimensions, Gold datasets, Transactional datasets, and existing reporting assets.
06
Collaborate with business, analytics, and engineering teams to resolve migration, reconciliation, and data quality issues.
07
Support release management, CI/CD processes, monitoring, defect resolution, and production support activities.
08
Drive data quality, governance, automation, and standardization initiatives across the IMD Hub ecosystem.
09
Ensure migrated assets are scalable, maintainable, and aligned with enterprise data architecture standards.
10
Strong expertise in Snowflake (Stored Procedures, Tasks, Data Modelling, Data Pipelines, Performance Optimization, and Data Validation).
11
Hands-on experience with Python, automation frameworks, and CI/CD processes.
12
Strong understanding of Data Warehousing concepts including Facts, Dimensions, Medallion Architecture, Reporting Datasets, and RRDs.
Technology stack
Tools & Technologies.
The platforms and technologies you'll use to build modern, enterprise-grade solutions.
01
Snowflake
Required
02
Snowflake Stored Procedures
Required
03
Snowflake Tasks
Required
04
Python
Required
05
Automation frameworks
Required
06
CI/CD
Required
07
Data pipelines
Required
08
Data warehouse
Required
09
Data warehousing
Required
10
Data modeling
Required
11
Facts
Required
12
Dimensions
Required
13
Medallion Architecture
Required
14
Gold datasets
Required
15
Transactional datasets
Required
16
Reporting datasets
Required
17
RRDs
Required
18
Data migration
Required
19
Data modernization
Required
20
Data transformation
Required
Requirements
Skills & Experience.
We value curiosity, collaboration and continuous learning. If you don't meet every requirement but believe you can make an impact, we'd still love to hear from you.
Essential
Required Qualifications
Snowflake development, including stored procedures, tasks, data modeling, pipelines, optimization, and validation
Python and automation frameworks
Data warehousing, including facts, dimensions, medallion architecture, and reporting datasets
Data migration, modernization, and transformation
Data validation, reconciliation, testing, and root-cause analysis
Source-to-Target Mapping (STTM), metadata, and data dictionary documentation
CI/CD, release management, monitoring, defect resolution, and production support
Data quality, governance, and end-to-end data lineage
Pharmaceutical or Life Sciences domain knowledge, including business rules, KPIs, and reporting logic
Ability to support scalable, secure, maintainable enterprise data products aligned with architecture standards
Preferred
Nice to Have
Specific Medical Affairs domain experience
Experience with IMD Hub or its target architecture
Familiarity with RRDs
What you'll gain
More Than Just A Job.
We're committed to helping every team member grow professionally, personally and technically while working on meaningful projects.
Global Exposure
Collaborate with international clients and multicultural teams on enterprise programmes.
Continuous Learning
Expand your expertise through mentoring, certifications and hands-on project experience.
Career Growth
Take ownership, develop leadership skills and grow your consulting career over time.
Flexible Working
Hybrid and remote collaboration designed around trust and delivering exceptional outcomes.
People First
Join a supportive culture where collaboration, respect and long-term relationships come first.
Enterprise Projects
Work on meaningful technology initiatives for leading organisations across industries.
Apply
Apply for Data Engineer
One page, about two minutes. We only ask for what we actually need to have a first conversation.