Job Title Data Designer – Cloud Data Modernization Experience 5+ Years Employment Type Full-Time Work Mode Hybrid Job Summary We are seeking an experienced Data Designer to support enterprise-scale Cloud Data Modernization initiatives involving migration of legacy data warehouse and ETL workloads to modern cloud platforms. The ideal candidate will have strong expertise in Azure Cloud Databricks Snowflake ETL/ELT design data modeling and data platform architecture. The successful candidate will be responsible for designing scalable data solutions analyzing existing SQL Server-based data warehouse processes defining migration strategies and collaborating with data engineers architects and business teams to deliver secure and high-performing cloud data platforms. Key Responsibilities Design and develop modern cloud data architectures for enterprise data modernization programs. Lead data design activities for migrating on-premises SQL Server data warehouse and ETL workloads to Azure Cloud and Snowflake. Analyze existing ETL processes developed using SSIS and T-SQL and define modernization approaches. Design scalable data pipelines and workflows using Azure Data Factory (ADF) Databricks Self-hosted Integration Runtime (SHIR) Azure Logic Apps Azure Data Lake Storage Gen2 (ADLS Gen2) Azure Blob Storage Snowflake Define data structures mappings transformations and integration patterns. Collaborate with data engineers to implement optimized ETL/ELT solutions. Design data models supporting analytics reporting and AI/ML workloads. Review and optimize data pipelines for performance scalability and reliability. Support implementation of DevOps practices and CI/CD processes using GitHub Actions. Ensure data solutions comply with security governance and quality standards. Collaborate with architects developers analysts and business stakeholders to ensure seamless data flow. Document data designs technical specifications data mappings and transformation rules. Participate in design reviews technical discussions and modernization planning sessions. Required SkillsCloud Data Platforms Microsoft Azure Azure Data Factory (ADF) Azure Data Lake Storage Gen2 (ADLS Gen2) Azure Blob Storage Azure Logic Apps Self-hosted Integration Runtime (SHIR) Databricks Snowflake Data Engineering & ETL ETL/ELT Design Data Pipeline Architecture Data Migration SSIS Migration T-SQL Development SQL Server Data Warehouse Data Transformation Workflow Optimization Data Modeling & Design Data Architecture Data Modeling Database Design Data Mapping Data Integration Patterns Analytics Data Design Programming & Automation Python SQL Scripting Languages Data Processing Automation DevOps & Delivery GitHub Actions CI/CD Pipelines Agile/Scrum Methodologies Source Control Practices Preferred Skills Experience designing Databricks solutions for data engineering and analytics workloads. Knowledge of Lakehouse architecture and Delta Lake. Experience applying AI/ML models and tools to data processing workflows. Knowledge of data governance metadata management and data quality frameworks. Experience with additional cloud platforms such as AWS or Google Cloud. Familiarity with enterprise data security and compliance practices. Experience with Azure or Snowflake certifications. Required Qualifications Bachelor's degree in Computer Science Information Technology Engineering Data Science or related field. 5+ years of experience as a Data Designer Data Engineer Data Architect or similar role. Strong experience designing cloud-based data solutions and modernization programs. Hands-on experience with Azure data services Databricks and Snowflake. Proven experience migrating ETL workloads from on-premises SQL Server environments. Strong understanding of data integration transformation and pipeline optimization. Experience working with cross-functional teams in Agile environments. Strong analytical troubleshooting and communication skills. Preferred Qualifications Azure Data Engineer Associate certification. Snowflake certification. Experience working in healthcare insurance financial services or regulated industries. Knowledge of enterprise data governance and compliance requirements. Experience supporting AI/ML-enabled data platforms. Success Measures Successful design and delivery of cloud modernization solutions. Effective migration of legacy ETL workloads to Azure and Snowflake. Improved scalability reliability and performance of data platforms. High-quality data models mappings and transformation designs. Successful collaboration between architecture engineering and business teams. Work Location Hybrid remote in Remote