Teamware Solutions
Create a free account
One signup unlocks everything for this job:
- Apply to this job and track your application
- See your personalized profile match score
- Generate an AI cover letter for this role
Bengaluru · On-site · 6-9 Yrs · Sep 23
Information Technology Support Services · 1001 to 5000 Employees · Chennai, India
Teamware Solutions, a business division of Quantum Leap Consulting Private Limited, offers cutting edge industry solutions for deriving business value for our clients' staffing initiatives. Offering deep domain expertise in Banking, Financial Services and Insurance, Oil and Gas, Infrastructure, Manufacturing, Retail, Telecom and Healthcare industries, Teamware leads its service in offering skills augmentation and professional consulting services. With over 4000 professionals deputed across India, USA, Middle East, our major clients include Captive IT units, Product Companies and IT Services firms. We achieve our vision by pursuing the following: By making our processes the key foundation of our service offerings; Our processes would be designed and structured to enable speed, accuracy and scale, the three most important elements that our customers expect from our services. By focusing and building on Global Markets and achieving Global scale. By not compromising on our values. Our Values Our employees come first, our customers second. The very purpose and existence of Teamware is for the welfare and wellbeing of its employees. We believe that by ensuring this, customer satisfaction and delight will naturally happen. We shall be honest, fair and reliable in our dealings with external relationships. While pursuing our professional goals, We shall do so by creating a work environment that brings out our best in enthusiasm, creativity, comradeship and above all, fun.
Hiring: Engineering
What employees say
+ Good package compared to competatiors
− No Job security as soon as client release you are out of the company
More reviews on the company profile.
Interview experience · Talent Acquisition
It was good experience the interviewer was very friendly and he asked questions like what is talent acquisition and why do you want to join in teamware and this is overall my interview experience
Average difficulty · India · 107 reports
More interview insightsJob description
Overview
We are hiring a Enterprise Data modeller Experience: 6+ Location: Bangalore ,hyderabad, Chennai, Kolkata, Mumbai, Noida , Gurugam Notice Period: Immediate to 15 Days
Responsibilities
- Design conceptual, logical, and physical data models (ER diagrams, dimensional/star schemas, Data Vault where applicable) for midstream data domains — pipeline scheduling and nominations, volumetric measurement and allocations, gathering and processing, terminal/storage inventory, tariffs and regulatory reporting, and commercial contracts.
- Own the Bronze → Silver → Gold layering strategy in partnership with data engineering: define what belongs in raw/staging vs. conformed business entities vs. presentation-layer facts and dimensions.
- Build and maintain dimensional models (fact/dimension design, SCD Type 1/2 strategy, surrogate vs. natural keys, conformed dimensions across business units) for reporting and analytics consumption.
- Partner with data engineers to translate models into dbt sources, staging models, and marts, and review PRs for adherence to modeling and naming standards.
- Define and maintain the enterprise data dictionary, entity relationship documentation, and column-level metadata (business definitions, valid values, data lineage) for midstream subject areas.
- Evaluate source systems ingested via Informatica IDMC/CDIR and dbt, and model how they reconcile into a single conformed view.
- Lead data model reviews with business stakeholders (commercial, scheduling, accounting, regulatory) to validate that models correctly represent contracts, allocations, and volumetric relationships.
- Support master data management for core midstream reference entities (assets, meters/measurement points, contracts, counterparties, tariff schedules).
- Contribute to data governance: naming conventions, modeling standards, data quality rules, and stewardship processes.
- Assess the impact of new data sources or business changes (new pipeline systems, acquisitions, regulatory changes) on existing models and propose schema evolution strategies that avoid breaking downstream consumers.
Qualifications
- Location: Bangalore ,hyderabad, Chennai, Kolkata, Mumbai, Noida , Gurugam
- Notice Period: Immediate to 15 Days
- Detailed JD:
- About the Role
- We're looking for a Data Modeler to design and govern the data models that power our midstream operations platforms. You'll translate how crude oil, NGLs, and natural gas actually move through gathering, processing, storage, and pipeline transportation into clean, well-documented data structures that support analytics, regulatory reporting, and downstream applications across the enterprise data platform (dbt/Snowflake, IDMC ingestion, Airflow orchestration).
- This role sits at the intersection of data architecture and midstream domain expertise.
- 6+ years of data modeling experience (conceptual, logical, physical), including dimensional modeling and normalized/3NF design.
- Direct experience in midstream oil & gas — hands-on exposure to at least one of: pipeline scheduling/nominations, volumetric measurement and allocations, gas/liquids balancing, terminal or storage operations, or regulatory reporting Strong SQL skills and experience modeling for a cloud data warehouse (Snowflake, Redshift, BigQuery, or similar).
- Practical experience with dbt (or a comparable transformation framework) — understands how models translate into source()/ref() dependencies, tests, and documentation.
- Solid grasp of Kimball-style dimensional modeling (star schema, slowly changing dimensions, conformed dimensions, factless facts) and when to use Data Vault or 3NF instead.
- Comfortable working directly with business SMEs to extract and formalize business rules into a data model — this role requires translating ambiguous operational knowledge into structured schemas, not just implementing a spec handed to you.
- Understanding of data governance fundamentals: metadata management, data lineage, data quality rules, and stewardship.
- Exposure to medallion/lakehouse architecture (Bronze/Silver/Gold) and the tradeoffs of layering conformed business models vs. raw ingestion.
- Prior experience in a data governance or data steward capacity.
Verify General for this role
Free PRACTICE for General adds a verified skill signal that can boost how roles like this rank for you — optional, not required to browse or apply.
Sign up — verify General free →Want match scores and deeper insight? Create a free candidate profile
Job application FAQ
Last updated 30 September 2026
- How do I apply for Enterprise Data modeller at Teamware Solutions?
- Open this job on Feedback AI and sign up free (or sign in). You can apply from the job detail page; match scores and skill gaps appear when your profile is complete. Teamware Solutions may attach structured assessments to interview rounds after you apply.
- Does Feedback AI show a match score for this Enterprise Data modeller role?
- Yes after you add a resume or skills. Match score ranks this role against your profile — skills met, gaps, level, and location — so you prioritise applications where fit is strongest.
- Is Enterprise Data modeller remote or on-site in Bengaluru, Karnataka?
- This listing is marked on_site with location Bengaluru, Karnataka. Confirm details on the job description before applying.
- What skills matter for this Enterprise Data modeller role at Teamware Solutions?
- Key skills for this role include skills listed in the job description. Upload a resume to see which requirements you already meet and which are gaps.