Data Architect

Sr Data Architect - Snowflake, Coalesce, SQL, PythonRemoteContractWho 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 SummaryThe 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 SkillsSnowflakeSnowflake Data Warehouse ArchitectureStreams & TasksDynamic TablesData SharingIncremental Data ProcessingPerformance Tuning and OptimizationSnowflake Security and Access ControlsCoalesceCoalesce TransformCoalesce CatalogCoalesce QualityMetadata-Driven Data PipelinesData Lineage and Impact AnalysisSnowflake IntegrationGit-Based Deployment and Version ControlSQLAdvanced SQL DevelopmentComplex JoinsCTEs and Recursive QueriesWindow FunctionsAnalytical and Reporting QueriesQuery Optimization and Performance TuningPythonAPI Integration and Data IngestionData Processing and TransformationWorkflow AutomationETL/ELT Framework DevelopmentError Handling and MonitoringCDC (Change Data Capture)CDC Architecture and DesignDelta Load ProcessingTimestamp-Based Incremental LoadsSnowflake Streams-Based CDCReal-Time and Batch Data ProcessingAzure Data Factory (ADF)Pipeline DevelopmentData OrchestrationParameterizationMonitoring and TroubleshootingIntegration Runtime ConfigurationEnterprise Data Integration SolutionsRequired Experience10+ 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.