Data Architect

Sr Data Architect - Snowflake, Coalesce, SQL, Python

Remote

Contract

Who we are: -

At CitiusTech , we constantly strive to solve the industry's greatest challenges with technology, creativity, and agility. With over 8,500 healthcare technology professionals worldwide, CitiusTech powers healthcare digital innovation, business transformation, and industry-wide convergence for over 140 organizations through next-generation technologies, solutions, and products.

We aim to accelerate the transition to a human-first, sustainable, and digital healthcare ecosystem with the world's leading Healthcare and life sciences organizations and our partners.

Here is an opportunity for you to make a difference and collaborate with global leaders to shape the future of healthcare and positively impact human lives.

Our vision: -

To inspire new possibilities for the health ecosystem with technology and human ingenuity.

Job Summary The Data Architect will be responsible for designing, implementing, and optimizing modern cloud-based data platforms. The ideal candidate will possess deep expertise in Snowflake , Coalesce , SQL , Python , Change Data Capture (CDC) , and Azure Data Factory (ADF) , along with strong experience in data architecture, metadata-driven development, and enterprise data integration.

This role requires hands-on leadership in building scalable, lineage-aware, and high-performance data solutions that support analytics, reporting, and advanced business intelligence initiatives.

Key Responsibilities

· Design enterprise data architectures leveraging Snowflake and Coalesce.

· Develop scalable and reusable data pipelines using ADF and Python.

· Implement CDC frameworks and incremental data processing strategies.

· Build metadata-driven and lineage-aware data transformation solutions.

· Optimize Snowflake performance, scalability, and cost efficiency.

· Establish data governance, data quality, and monitoring frameworks.

· Collaborate with business stakeholders, architects, and engineering teams to define data strategies.

· Implement CI/CD deployment processes using Git and DevOps best practices.

· Support data integration across multiple source systems and cloud platforms.

· Drive architecture reviews and technical best practices across data programs.

Required Skills

Snowflake

• Snowflake Data Warehouse Architecture
• Streams & Tasks
• Dynamic Tables
• Data Sharing
• Incremental Data Processing
• Performance Tuning and Optimization
• Snowflake Security and Access Controls

Coalesce

• Coalesce Transform
• Coalesce Catalog
• Coalesce Quality
• Metadata-Driven Data Pipelines
• Data Lineage and Impact Analysis
• Snowflake Integration
• Git-Based Deployment and Version Control

SQL

• Advanced SQL Development
• Complex Joins
• CTEs and Recursive Queries
• Window Functions
• Analytical and Reporting Queries
• Query Optimization and Performance Tuning

Python

• API Integration and Data Ingestion
• Data Processing and Transformation
• Workflow Automation
• ETL/ELT Framework Development
• Error Handling and Monitoring

CDC (Change Data Capture)

• CDC Architecture and Design
• Delta Load Processing
• Timestamp-Based Incremental Loads
• Snowflake Streams-Based CDC
• Real-Time and Batch Data Processing

Azure Data Factory (ADF)

• Pipeline Development
• Data Orchestration
• Parameterization
• Monitoring and Troubleshooting
• Integration Runtime Configuration
• Enterprise Data Integration Solutions

Required Experience

• 10+ years of experience in Data Engineering, Data Warehousing, or Data Architecture.
• 5+ years of hands-on Snowflake experience.
• Strong experience implementing Coalesce-based transformations and data modeling.
• Proven expertise in CDC and incremental processing frameworks.
• Experience designing modern cloud-native data architectures.
• Experience with Git-based deployment and CI/CD practices.
• Strong understanding of Data Governance and Data Quality frameworks.

Preferred Qualifications · Healthcare domain experience preferred.

· Experience with Azure Cloud ecosystem.

· Exposure to dbt as an alternative transformation framework.

· Knowledge of Data Mesh and Modern Data Platform architectures.

· Experience leading large-scale enterprise data transformation programs.