Data Scientist

Location: Stamford, CT (4 days per week onsite)

Duration: 6 month contract to hire

Job Description:

We are seeking a Data Scientist / Developer to join our incentives team. This hybrid role combines strong analytics and modeling expertise with hands-on technical development to support the standardization of incentive models, advanced performance analytics, backend modernization, and the build-out and maintenance of a new web-based incentive portal. You will transform complex sales and incentive data into scalable, accurate solutions that drive better decision-making across our sales channels while working in a highly agile environment that leverages AI tools to increase productivity.

Key Responsibilities

• Design, develop, and maintain complex incentive models, performance metrics, calculation logic, and advanced analytics frameworks
• Integrate data from multiple sources and lead the transition of existing Alteryx workflows into scalable, automated solutions using AWS Redshift and related technologies
• Develop and maintain automated email generation pipelines producing 750K personalized HTML emails per month
• Build and deploy serverless microservices (Lambda, API Gateway) for lightweight data collection and automation tasks
• Build and support backend systems and data integration processes for the new web-based incentive portal
• Standardize incentive structures and performance analytics across sales channels
• Optimize data pipelines, data models, and backend processes to improve scalability, performance, and data integrity
• Develop dashboards, reports, forecasts, and ad hoc analytics to deliver actionable insights to sales leadership
• Collaborate with cross-functional teams to translate business requirements into robust technical and analytical solutions
• Troubleshoot and resolve data quality, modeling, and performance issues
• Work in an AI-first development environment - using AI coding assistants (Kiro, Copilot) daily for code generation, debugging, and data exploration. Contribute to building AI-augmented automation pipelines.
• Work flexibly across analytics, and development tasks in a dynamic, agile environment with shifting priorities

Required Qualifications

• Expert-level SQL skills (T-SQL and/or Redshift SQL), including complex query writing, stored procedure development, performance tuning, and data modeling
• Strong proficiency in Python for data processing, transformation, automation, and building serverless functions (AWS Lambda)
• Experience designing and developing data integration processes, data models, and backend systems
• Demonstrated ability to work with AWS Redshift and S3 in cloud data environments
• Ability to transform business requirements into scalable technical and analytical solutions
• Ability to handle multiple projects and priorities in a fast-paced, agile environment with shifting requirements
• Excellent communication skills – able to explain complex analyses and solutions to both technical and non-technical stakeholders

Required Education

• Bachelor’s degree or foreign equivalent in Information Technology or business related field, or equivalent experience