Senior Data Engineer

Role Overview: As a Senior Data Engineer at iSOCRATES, you will have a pivotal role in uncovering patterns in data sets and creating algorithms to enhance the usability of raw data for the organization. Your position necessitates a broad array of technical competencies, encompassing a profound understanding of SQL database design, proficiency in multiple programming languages, and adeptness in team management. Your primary responsibilities will include devising and implementing production data pipelines within a big data framework, managing data migration initiatives, crafting clean code following Test-Driven Development (TDD) principles, and innovating contemporary data architecture strategies to align with business goals. Furthermore, you will be instrumental in defining departmental priorities, objectives, and goals, as well as fostering collaborations between the Data Engineering department and other divisions within iSOCRATES, as well as external stakeholders. Key Responsibilities: - Design and construct production data pipelines spanning from data ingestion to consumption within a big data environment - Revamp existing legacy code to enhance performance metrics - Oversee the technical facets of data migration activities from on-premises to cloud infrastructures - Author clean and iterative code adhering to TDD standards - Utilize continuous delivery methodologies for deploying, supporting, and managing data pipelines - Innovate and manage contemporary data architecture practices to fulfill business objectives - Develop data models and assess various modeling methodologies - Integrate data quality considerations into day-to-day tasks and delivery processes - Establish departmental priorities, objectives, and goals, and foster service-oriented relationships Qualifications: - Bachelor's or Master's degree in computer science, engineering, or a related field - 4 to 6 years of prior experience in data and analytics - At least 3 years of hands-on experience with MSSQL, Oracle, or MySQL - Profound expertise in SQL and NoSQL databases - Proven track record in executing on-premises to cloud data migration projects - Proficiency in constructing production data pipelines using Python, AWS, or Snowflake - Familiarity with AWS data and analytics services like Redshift, S3, Athena, Glue, and Snowflake - Extensive knowledge of data warehousing, data modeling, ETL, and ELT processes - Holding an AWS Certified Data Analytics Specialist or AWS Certified ML Specialist certification would be advantageous - Exposure to Media & Marketing sectors is considered a plus - Familiarity with GCP and visualization tools would be beneficial - Possess structured thinking abilities with a penchant for data-driven decision-making - Strong aptitude for problem-solving and client interactions - Excellent communication skills and a collaborative team player - Capability to tackle intricate challenges and deliver results under constraints - Willingness to work during late EMEA or ET hours - Openness to working from the Mysore or Bangalore location,