Source description
About the role
Work Schedule Other Environmental Conditions Office Summarized Purpose We are offering an outstanding opportunity to join Thermo Fisher Scientific as a Data Warehouse Developer In this role you will focus on designing building and optimizing database-centric solutions that power our analytical and operational data platforms You will play a key role in developing robust scalable data pipelines and warehouse structures -primarily on AWS Redshift supporting data-intensive workloads and downstream reporting applications Education Experience Bachelor s degree or comparable experience in Computer Science Information Science or a related area of study Around 3 years of experience in database development data engineering or a related field Equivalent combinations of education training and experience will also be considered Major Job Responsibilities Design implement and refine data warehouse schemas e g star snowflake models and data pipelines in AWS Redshift or similar RDBMS platforms Build and manage SQL-centric ETL ELT procedures for the processing transformation and merging of data from diverse origins Improve database performance through query optimization and effective data processing Collaborate with stakeholders to translate data needs into scalable and maintainable data structures Support data quality validation and reconciliation processes to ensure accurate and reliable datasets Engage with AWS services including Lambda Step Functions and S3 for orchestrating and automating data workflows Participate in design reviews documentation and testing activities to ensure adherence to quality and compliance standards Collaborate with Operations and DevOps teams to deploy and monitor data workflows using CI CD pipelines where applicable Troubleshoot production issues analyze root causes and propose balanced solutions Leverage AI-assisted development tools to improve query efficiency code refactoring and documentation Knowledge Skills and Abilities Strong hands-on SQL development skills including complex queries window functions joins and analytical operations Mastery in data modeling and grasp of data warehousing principles ETL ELT dimensional modeling slowly altering dimensions Experience working with large relational databases e g Redshift PostgreSQL SQL Server MySQL Oracle Knowledge of AWS cloud services especially S3 Lambda Redshift and Step Functions Familiarity with Python or NodeJS for scripting automation or data workflows based on Lambda Excellent analytical and problem-solving skills with attention to detail Strong communication and collaboration skills in a team-oriented environment Must Have skills Advanced SQL and RDBMS experience - Ability to develop and optimize queries stored procedures and data transformations for large-scale data workloads Data warehousing and ETL ELT - Practical experience designing and maintaining data warehouse environments and data pipelines Practical exposure to AWS services - Hands-on experience with AWS data services like Redshift S3 Lambda and Step Functions Skilled in Python or NodeJS programming - Capable of using a programming language for automation or data integration purposes Data modeling and schema creation - Experience crafting normalized and dimensional schemas for analytics and reporting Good to have skills Exposure to data Lakehouse or big data environments Databricks Snowflake or similar Knowledge of AI-assisted or modern query optimization tools and practices Working Hours India 05 30 PM to 02 30 AM IST Philippines 08 00 PM to 05 00 AM PST Work Schedule Other Environmental Conditions Office Summarized Purpose We are offering an outstanding opportunity to join Thermo Fisher Scientific as a Data Warehouse Developer In this role you will focus on designing building and optimizing database-centric solutions that power our analytical and operational data platforms You will play a key role in developing robust scalable data pipelines and warehouse structures -primarily on AWS Redshift supporting data-intensive workloads and downstream reporting applications Education Experience Bachelor s degree or comparable experience in Computer Science Information Science or a related area of study Around 3 years of experience in database development data engineering or a related field Equivalent combinations of education training and experience will also be considered Major Job Responsibilities Design implement and refine data warehouse schemas e g star snowflake models and data pipelines in AWS Redshift or similar RDBMS platforms Build and manage SQL-centric ETL ELT procedures for the processing transformation and merging of data from diverse origins Improve database performance through query optimization and effective data processing Collaborate with stakeholders to translate data needs into scalable and maintainable data structures Support data quality validation and reconciliation processes to ensure accurate and reliable datasets Engage with AWS services including Lambd
More at Thermo Fisher Scientific