8 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 1998. 8 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.
For more on 8 West Consulting visit our website www.8west.ie
We are seeking an experienced Senior Developer with speciality in SQL, leveraging SQL Server and Snowflake. This will be a technically challenging position, working on a major enterprise application. The role will require constant interaction with other developers in the team and project management to develop and maintain a robust, scalable, and performant system.
Essential Responsibilities
- Discover, create and manage new datasets by extracting, transforming, combining and loading data from various heterogeneous data sources and build incremental data products while ensuring data integrity, availability and auditability
- Design, implement and maintain innovative cloud-based data solutions for large and varied datasets on platforms hosted on AWS (native and 3rd party like Snowflake data warehouse), using native services, cloud-capable ETL and other data management tools
- Maintain a hybrid environment that include legacy data technologies/platforms while migrating data, pipelines and products to cloud-based solutions
- Comprehensively handle agile development lifecycle by designing, coding, testing and implementing iterative solutions
- Identify gaps and improvement opportunities in data operations and implement solutions using automation
Technical Profile
Must Have:
7+ years of experience in Cloud data engineering and relevant data technologies- Experienced in Data warehousing, building ETL pipelines, and overall data management
- Demonstrable experience using SQL and knowledge of NOSQL
- Experienced with Cloud platforms and services e.g.-building data lake in AWS, building Cloud based data warehousing solutions like Snowflake, cloud data pipelines using tools like Matillion, Glue etc.
- Experience in streaming data is a plus. Past experiences working on data platforms such as SQL Server using tools and methodologies like SSIS, Stored Procedures etc. are pluses
- Coding proficiency in one or more programming languages (e.g. – Python, Scala, Java etc.) and querying languages (HiveQL, Spark SQL etc.) are nice to haves
- Experience working in dynamic agile and product-based environments
Personal Profile
- Ability to work independently as well as part of team
- Ability to learn new business areas quickly
- Technical degree or equivalent experience
- Excellent written and verbal English communication skills
- Desire to develop your own knowledge by keeping abreast of latest development tools and techniques, attending workshops and reviewing technical publications
- Please note this is a daily rate contract position