Overview8 West Consulting is one of the country's largest software development organisations. Formerly named DeCare Systems Ireland, the company has been operating successfully in Cork city since West Consulting employ a wide range of technologies including Mobile (iOS, Android, Windows), Java SE/Java EE (WebLogic, WebSphere, Spring, Akka, Hibernate, GWT, etc.), Microsoft .NET (ASP.NET, C#, etc.), JavaScript (AngularJS, JQuery, dojo, etc.), various database management systems (MongoDB, Oracle, SQL Server, MySql, etc.). 8 West Consulting provides consultancy and leading-edge software solutions for a wide variety of US, EU and UK based clients in the insurance, healthcare, retail and public sector markets.Position SummaryThe Senior Data Engineer is responsible for designing, developing, and maintaining scalable data solutions across both legacy and modern cloud platforms. The role requires deep expertise in cloud-based data warehousing, strong hands-on skills in Python and ETL pipeline development, and the ability to work in dynamic, agile environments.The successful candidate must demonstrate excellentverbal and written English communication skillsand be able to collaborate effectively with stakeholders across the business.Key ResponsibilitiesDesign, develop, and maintain robust ETL/ELT processes, including pipelines for extraction, transformation, cleaning, pre-processing, aggregation, and loading of data from diverse sourcesDevelop, enhance, and maintain ETL solutionsDeliver across the full agile lifecycle, including design, coding, testing, and deployment of iterative data solutionsCollaborate with cross-functional teams to ensure data quality, integrity, availability, and auditabilityQualifications & ExperienceMinimum 10 years' experience in data engineering with a strong focus on cloud data platformsDeep expertise in Snowflake and SQL Server, including cloud-based data warehousing, ELT/ETL pipeline development, and performance tuningDemonstrated experience building and maintaining ETL processes, ideally using SSIS and SnowflakeStrong proficiency in Python for scripting, automation, and data pipeline developmentStrong background in Git-based workflows (branching strategies, pull requests, CI/CD pipelines)Experience in Visual Studio/VS Code or SSMS (SQL Server Management Studio) an advantageExcellent verbal and written English communication skillsSkills & CompetenciesStrong analytical and problem-solving skillsAbility to complete analysis of large data setsAbility to design scalable, reliable, and high-performance data solutionsClear communicator, capable of presenting complex technical concepts to varied audiencesExcellent documentation and technical writing skillsProactive, adaptable, and able to deliver results in fast-paced environments