Data Modeler

Reporting to: Technical Lead

Who we are:

Orion delivers game changing business transformation & digital product development with agility at scale. With a maturity and scale of 25+ years in the industry, Orion has 6000+ associates working across 13 major delivery centers across the globe! Follow us on the links below to know more! 


The ideal candidate will show interest in mastering and exercise responsibility towards both project and team. The candidate must have strong analytical skills and possess excellent communication skills, both oral and written.

 Key Accountability:

  • Understand and translate business needs into data models supporting long-term solutions
  • Work with the Data warehouse development team to implement data strategies, build data flows and develop conceptual data models
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
  • Optimize and update logical and physical data models to support new and existing projects
  • Maintain conceptual, logical, and physical data models along with corresponding metadata
  • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
  • Recommend opportunities for reuse of data models in new environments
  • Perform reverse engineering of physical data models from databases and SQL scripts
  • Evaluate data models and physical databases for variances and discrepancies
  • Validate business data objects for accuracy and completeness
  • Analyze data-related system integration challenges and propose appropriate solutions
  • Develop data models according to business requirements and best practices
  • Review modifications to existing models to improve efficiency and performance

 Key Competencies:

  • 10+ years of data architecture, data modelling or similar experience
  • Experience using major data modelling tools (examples: Erwin, ER Studio, Power Designer, etc.)
  • Good Hands-on experience in working with Snowflake, SQL Server etc. 
  • Overall 10+ years of experience in Business Intelligence and Data Architecture projects
  • Projects delivered in banking industry will be an added advantage
  • Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.)
  • As a Data and Analytics subject matter expert, you will be responsible to lead, collaborate and produce data and analytics solution architecture and detail data architectures
  • The role requires a hands-on approach to produce data models and high-level design artefacts for data and analytics solution
  • Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data
  • Experience across ETL, SQL and other emerging data technologies with Experience in operations and integrations of various cloud-based analytics environment
  • Experience querying and manipulating data on multiple platforms using multiple methodologies and tools and create conceptual design of the defined data solution
  • Experience using cloud-based Hybrid solution
  • Good understanding of Data Strategy, Data Governance Process etc.
  • Working with Business on storyboarding and requirement elicitation
  • Experience using Agile methodologies and Scrum

Life at Orion APAC

Orion offers an immersive, energetic work environment where employees can innovate. We encourage you to join us at any of our offices in Mumbai, Pune, Kochi, Chennai, Coimbatore, Madurai, or Hyderabad in India or in Melbourne, Australia.

Work Environment

Orion believes in creating a productive, diverse work environment for employees. The ability to solve business problems using technology, pushing the normal and driving a high-performance culture is what brings excitement to Orion. Everyone brings a diverse set of perspectives, work and life experiences, which makes us valuable, both internally and for our clients.  

Growth Potential

No matter where you start, one can go a long way at Orion. As a scale player in the digital transformation space, Orion offers limitless opportunities across digital and custom application development work in various technology stacks and industry domains.

Education Programs

Orion offers many learning opportunities through various certification and proficiency programs to build depth and width in technology, domain, functional, process and Leadership areas.

For technology students, we offer training through our partner institutions and public programs run by our specialists. 

Employee Benefits

Apart from cutting edge work that creates exceptional talent, we offer competitive compensation and benefits that include leave, retirals, medical benefits and comfortable, safe workspaces. We also encourage our employees to maintain a healthy work life balance across all our office locations. 

Keep Connected