Senior Data Engineer

Open to Singapore citizens or has PR visa onlyAbout Straive:Straive is a market leading Content and Data Technology company providing data services, subject matter expertise, & technology solutions to multiple domains. Data Analytics & Al Solutions, Data Al Powered Operations and Education & Learning form the core pillars of the company’s long-term vision. The company is a specialized solutions provider to business information providers in finance, insurance, legal, real estate, life sciences and logistics. Straive continues to be the leading content services provider to research and education publishers.Data Analytics & Al Services: Our Data Solutions business has become critical to our client’s success. We use technology and Al with human experts-in loop to create data assets that our clients use to power their data products and their end customers & workflows. As our clients expect us to become their future-fit Analytics and Al partner, they look to us for help in building data analytics and Al enterprise capabilities for them.With a client-base scoping 30 countries worldwide, Straive’s multi-geographical resource pool is strategically located in eight countries - India, Philippines, USA, Nicaragua, Vietnam, United Kingdom, and the company headquarters in Singapore. Website: https://www.straive.com/ LinkedinAbout the Role:A “Senior Data Engineer” is mid-level professional leading the design, build and evolution of the inhouse data platforms. You lead the construction of datasets requested by various stakeholders, the build and maintenance of the resulting data pipelines. You closely work in collaboration with our data analysts, data scientist and business application development teams in delivering data solutions.Our hybrid work model is designed to give you the best of both worlds—flexibility and face-to-face collaboration. Employees are required to be present in the office on Mondays, Wednesdays and Fridays each week. This means you’ll be in the office at least three days a week, with the option to work remotely on the other days, based on manager approval and business needs. This approach helps us stay connected as a team while giving you the flexibility to work in a way that suits you.DesignAnalyze relevant internally and externally sourced data (raw data) to generate BI and Advanced Analytics datasets based on your stakeholders’ requirementsDesign data pipelines to curate sourced data into the inhouse data warehouseDesign data marts to facilitate dataset consumption out of the inhouse data warehouse by business and IT internal stakeholdersDesign data model changes that align with the inhouse data warehouse standardsDefine migration execution activities to move data from existing database solutions to the inhouse data warehouse EngineerRegular housekeeping of raw data and data stored in the inhouse data warehouseBuild and maintenance of data pipelines and data platformsBuild data solution prototypesExplore ways to enhance data quality and reliabilityIdentify and realize opportunities to acquire better data (raw data)Develop analytical tooling to better support BI and Advanced Data Analytics activitiesExecute data migration from existing databases to the inhouse data warehousePromote and champion data engineering standards and best-in-class methodologyQualifications:Bachelor’s or master’s degree in Computer Science, Information Technology, Engineering or related quantitative discipline from a top tier university.Certified in AWS Data Engineer Specialty or AWS Solution Architect AssociateSnowflake SnowPro Core Certification mandatory and 5+ years of hands on experience working on snowflake projects.7+ years of experience in data engineering or relevant working experience in a similar role, preferably in the financial industryStrong understanding or practical experience of at least one common Enterprise Agile Framework e.g. Kanban, SAFe, SCRUM, etc.Strong understanding of ETL, data warehouse and BI(Qlik) and Advanced Data Analytics conceptsDeep knowledge of cloud-enabled technologies – AWS RDS and AWS Fargate, etc.Experience with databases and data warehouses - Snowflake, PostgreSQL, MS SQLStrong programming skills with advanced knowledge of Java and/or PythonPractical experience with ETL tools such as AWS Glue, etc.Strong critical-thinking, analytical and problem-solving skillsExcellent communicator with team-oriented approach