Lead Data Engineer
Roles & ResponsibilitiesThe AWS Redshift Lead is responsible for designing, implementing, optimizing, and managing enterprise-scale cloud data warehouse solutions on Amazon Redshift. The role involves leading architecture discussions, driving data modernization initiatives, ensuring platform performance and scalability, mentoring technical teams, and collaborating with business stakeholders to deliver high-quality analytics and reporting solutions.Key Roles & ResponsibilitiesLead the design and implementation of scalable enterprise data warehouse solutions using Amazon Web Services Redshift.Define overall data architecture, dimensional models, and data integration strategies.Design optimized Redshift schemas including: Star schema, Snowflake schema, Data marts, Fact and dimension tablesEstablish data partitioning, distribution keys, and sort key strategies for high-performance querying.Evaluate and recommend best practices for cloud-native data warehousing and analytics platforms.Design solutions for structured, semi-structured, and large-volume datasets.Support cloud migration initiatives from on-premise data warehouses to AWS Redshift.Required Experience14+ years in Data Warehousing and Data Engineering5+ years of hands-on AWS Redshift experienceExperience leading enterprise cloud migration initiativesStrong experience in performance tuning and optimizationExperience working in Agile delivery modelsExposure to Insurance, Banking, Healthcare, or Retail domains preferredAbout Value Momentum:ValueMomentum is a product engineering and technology services company with 26+ years of experience, specializing in the P&C insurance industry and serving 75+ insurers globally.Our solutions include platforms like Ifoundry, Rating Engine, and BizDynamics, helping insurers accelerate digital transformation. We are strategic partners with Guidewire, Duck Creek, and Insurity, delivering end-to-end implementation services.Headquartered in New Jersey, with global delivery centers across India, Canada, and the UK, ValueMomentum has a team of 6,000+ professionals worldwide.This opportunity is within our implementation practice, where you will work on ValueMomentum-led client projects and deliver impactful solutions