Data Engineer

ABOUT SONATA SOFTWARE Sonata Software, with over $1.2 Billion Revenue, is a leading AI-first Modernization Engineering company, powered by our unique PlatformationTM framework. Our 6400+ AI Engineers are helping enterprises transform from systems to intelligent business platforms leveraging partner ecosystem to drive speed, efficiency and growth. Our bouquet of Modernization Engineering Services with AI -first approach cuts across Cloud, Data, AI, Dynamics, Test Automation, and Managed Services. Sonata’s AI-led modernization is enabled by a powerful suite of proprietary tools and assets. At the core is the Harmoni.AI Enterprise Platform, which includes AgentBridge-a governance and observability framework; Agent Builder-a development toolkit for fungible agents integrated into enterprise systems; and the Agent Marketplace-an internal ecosystem for modular, reusable agents. Headquartered in Bengaluru, India, Sonata Software has a strong global presence, including key regions US, UK, India, Malaysia, Mexico, Australia, DACH (Germany/Switzerland) & Nordics (Finland). We are a trusted partner of Fortune 500 companies in Banking, Financial Services and Insurance; Healthcare and Lifesciences; Telecom, Media, and Technology; and Retail, Manufacturing and Distribution space. Deep collaborations with partners like Microsoft, AWS, Salesforce, and Snowflake strengthen our ability to deliver cutting-edge AI solutions. Our 30+years of partnership with Microsoft, and being part of the elite Microsoft Inner Circle, places us among the top 1% of global Microsoft partners. Sonata is now among the first companies to earn the Microsoft Frontier Partner Badge Also; Sonata Software is proud to achieve AWS Premier Tier Status in the AWS Partner Network. Job Title: Data Engineer Location: Jersey City, NJ (Hybrid) Duration: 6 Months Contract Experience: 5+ years Position Summary We are seeking a skilled Data Engineer to design, develop, and support modern data platforms and pipelines that power analytics, reporting, and AI-driven solutions. The ideal candidate will have strong expertise in Snowflake, Python, SQL, AWS, Oracle, and Apache Airflow, with exposure to AI/Generative AI technologies. Responsibilities • Design, build, and maintain scalable ETL/ELT data pipelines using Python and SQL. • Develop and optimize data solutions in Snowflake, including data modeling, performance tuning, and automation. • Integrate and transform data from Oracle, APIs, AWS services, and other enterprise systems. • Build and manage workflow orchestration using Apache Airflow. • Develop cloud-native data solutions utilizing AWS services such as S3, Glue, Lambda, and ECS/EKS. • Ensure data quality, reliability, security, and governance across the data platform. • Support AI and analytics initiatives by preparing datasets and building pipelines for ML and Generative AI use cases. • Collaborate closely with architects, analysts, data scientists, and business stakeholders to deliver scalable data solutions. Required Qualifications • Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field. • 5+ years of experience in Data Engineering or Data Platform development. • Strong hands-on expertise in: • Snowflake • SQL (Advanced) • Python (Advanced) • AWS • Oracle • Apache Airflow • Experience designing and supporting enterprise-scale data pipelines and data warehouses. • Strong understanding of data modeling, performance optimization, and cloud-based data architectures. • Excellent analytical, problem-solving, and communication skills. Preferred Qualifications • Experience with Snowpark, Streams, Tasks, and Dynamic Tables. • Exposure to AI/ML, Generative AI, RAG architectures, or vector databases. • Experience with Spark, Kafka, or Databricks. • SnowPro and/or AWS certifications. • Experience in financial services or capital markets environments. Key Skills Snowflake | SQL | Python | AWS | Oracle | Airflow | ETL/ELT | Data Warehousing | Data Modeling | Snowpark | AI/GenAI | Data Governance Ideal Candidate: A hands-on engineer with deep SQL and Python expertise, capable of building scalable cloud-native data solutions while helping enable the organization's AI and analytics strategy. Why join Sonata Software? At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next. Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law.