Orion Innovation Logo

Orion Innovation

Data Architect

Posted 15 Days Ago
Be an Early Applicant
Remote
Hiring Remotely in India
Expert/Leader
Remote
Hiring Remotely in India
Expert/Leader
Design and lead end-to-end Azure data platforms, translate T-SQL transformations into optimized Databricks (PySpark/SQL) workflows, build ADF ingestion pipelines, define lake/lakehouse architectures, optimize performance and reliability, enforce governance and mentor engineering teams.
The summary above was generated by AI

Orion Innovation is a premier, award-winning, global business and technology services firm.  Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity.  We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education.

Data Architect

Experience- 12+ years

Location- Kochi, Chennai, Coimbatore, Mumbai, Pune


We are seeking a highly experienced Data Architect with 12+ years of experience in designing and implementing scalable data solutions in Azure environments. The ideal candidate will possess strong expertise in data transformation logic, Azure Data Factory, Databricks optimization, and performance engineering. This role demands strategic thinking, architectural leadership, and hands-on technical depth.


Key Responsibilities

  • Architect and design end-to-end data platforms leveraging Azure technologies.
  • Interpret complex data transformation logic written in T-SQL and translate it into optimized processes within Azure Databricks (PySpark/SQL).
  • Design, build, and oversee data ingestion pipelines using Azure Data Factory (ADF) from source systems to RAW layer.
  • Establish scalable data lake and lakehouse architecture patterns.
  • Collect, monitor, and analyze performance metrics to optimize ingestion and transformation pipelines.
  • Perform advanced performance tuning and optimization of Databricks read/write operations.
  • Ensure high availability, reliability, and scalability of data solutions.
  • Define and implement best practices for data governance, security, and compliance.
  • Provide architectural guidance and mentorship to data engineers and junior architects.
  • Drive technical decision-making and collaborate with cross-functional stakeholders.

Required Skills & Expertise

  • 12+ years of experience in data engineering, data architecture, or related roles.
  • Strong expertise in:
  • T-SQL and complex data transformation logic interpretation.
  • Azure Databricks (Spark, PySpark, Delta Lake).
  • Azure Data Factory (ADF) – end-to-end ingestion pipeline development.
  • Hands-on experience in performance optimization of Databricks read/write queries.
  • Experience analyzing pipeline performance metrics and implementing improvements.
  • Strong understanding of data modeling (OLTP, OLAP, Dimensional Modeling).
  • Experience designing data lake/lakehouse architectures.
  • Familiarity with Azure ecosystem (ADLS Gen2, Synapse, Azure SQL, etc.).
  • Knowledge of CI/CD practices for data platforms.
  • Strong problem-solving and analytical mindset.

Leadership & Behavioral Competencies

  • Proven ability to mentor and guide data engineering teams.
  • Strong ownership mindset with high motivation and accountability.
  • Excellent stakeholder communication skills.
  • Ability to translate business requirements into technical architecture.
  • Strategic thinker with strong execution capabilities.

Preferred Qualifications

  • Azure certifications (e.g., Azure Data Engineer Associate, Azure Solutions Architect).
  • Experience with DevOps and automation in Azure.
  • Exposure to enterprise-scale data modernization programs.

What We Offer 


  • A competitive salary and comprehensive benefits package.
  • The opportunity to work on challenging problems with a talented, diverse team.
  • A dedicated budget for professional development, conferences, and certifications.
  • Flexible working hours and a hybrid work model.
  • A dynamic and innovative work environment where your technical vision will shape the future of our products.



www.orioninc.com

(18) Orion Innovation: Overview | LinkedIn

Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law.

Candidate Privacy Policy

Orion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, “Orion,” “we” or “us”) are committed to protecting your privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) explains:

  • What information we collect during our application and recruitment process and why we collect it;
  • How we handle that information; and
  • How to access and update that information.

Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.


Top Skills

T-Sql,Azure Databricks,Spark,Pyspark,Delta Lake,Azure Data Factory,Adls Gen2,Synapse,Azure Sql,Ci/Cd,Devops,Azure

Orion Innovation Chennai, Tamil Nadu, IND Office

Ambit IT Park, Ambit Park Road Ambattur Industrial Estate, Chennai, India, 600 058

Similar Jobs

14 Days Ago
In-Office or Remote
Ahmedabad, Gujarat, IND
Expert/Leader
Expert/Leader
Information Technology • Marketing Tech • Social Media • Software • Generative AI • Infrastructure as a Service (IaaS) • SEO
Design, build, and govern enterprise data architecture solutions. Define data strategy, scalable data models, and platform standards across on-prem and cloud environments ensuring performance, security, and governance.
Top Skills: Sql,Nosql,Relational Data Modeling,Dimensional Modeling,Data Warehouse,Data Lake,Lakehouse,Cloud Data Architectures,Enterprise Databases,Dama-Dmbok,Mdm,Data Quality Frameworks,Big Data,Real-Time Data Processing,Agile,Devops
Yesterday
Remote
Nānakrāmguda, Rangareddi, Telangāna, IND
Senior level
Senior level
Healthtech
The Principal Data Architect will lead SAP-centric data architecture, focusing on data models and integration, mentoring teams, and ensuring data governance from an offsite location.
Top Skills: Abap CdsDatabricksSap Business Data CloudSap DatasphereSnowflake
7 Hours Ago
Remote
Kalyani Nagar, Pune, Mahārāshtra, IND
Senior level
Senior level
Information Technology • Software
Lead data engineering projects, architect scalable data solutions, mentor junior engineers, and analyze complex datasets. Drive data initiatives and govern data practices in the organization.
Top Skills: Apache AirflowAzure Data FactoryAzure FabricAzure SynapseDbtInformaticaPysparkPythonSnowflakeSQL

What you need to know about the Chennai Tech Scene

To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account