Connecting to LinkedIn...

Vacancy Details

IT/Software

Senior Back-end Developer - Cork

Contract Type: Contract
Sector:
Location: Cork
Date: 1/07/2017
Job Reference: 87540

Job Description



Our client, an energy company in Cork are currently looking to recruit a Senior Back-End Developer for their site.

Senior Back-End Developer


Role Purpose
  • Reporting to the I-SEM Programme Technical Lead the Senior Back-end Developer will be part of a team responsible for implementing a data analytics and reporting platform for participating in the I-SEM market. This is a technical role focused on defining and implementing solutions in SQL Server 2016.
  • This developer will be developing ETL processes implemented mainly in Microsoft SSIS and will need to work with a variety of complex systems with limited supervision using excellent problem solving skills.
  • The I-SEM market trials begin in Dec 2017 and the developer will perform a key role in delivering solutions to ensure successful Go Live in the new I-SEM market.

Key accountabilities
  • Ability to work closely with Business Analysts and SMEs to understand business requirements
  • Create and validate the ETL design and ensure that technical specifications are complete, consistent, concise, and achievable.
  • Develop ETL code as per the technical specifications and business requirements according to the established designs
  • Exhibit competency in problem solving, data analysis, business rule validation, data integration, data quality, dependency analysis and estimation and delivery of complex SQL Server solutions
  • Design and develop ETL solution using SSIS to copy data from multiple sources to a centralised Operational Data Store and Data Marts
  • Create/maintain design related artifacts i.e. data models , Mapping documents, architecture diagrams, data flow diagrams
  • Participate in system and integration test; identify and remedy solution defects.
  • Monitoring performance and advising of any necessary infrastructure and/or design changes
  • Analysis of source data to assist in preparing iterative design changes, database refactoring, and creating or modifying reference data
  • Experienced in database design with the ability to progress from concept to implementation, creating and maintain documentation including entity relationship diagrams, data dictionaries, and ability to create implementation scripts.
  • Provide SQL Server database, SSIS, and SSRS architecture leadership
  • Effectively communicate SQL Server SSIS architecture and approaches
  • Ability to work and deliver in a very high paced environment with limited information at times to support business needs


Knowledge, Skills & Experience
  • Minimum 5 years' experience of similar roles elsewhere
  • Strong SSIS development and implementation experience essential
  • modular solutions
  • full and delta table loads
  • robust error-handling logging
  • archiving
  • facilitating migration between environments
  • debugging and troubleshooting SSIS processes in production environments
  • packaging and deployment of SSIS solutions using scripts
  • grounded in SSIS best practises
  • incorporating data from a wide variety of data sources e.g. Oracle, SQL Server, external APIs
  • Experience of SQL Server 2016 desirable
  • Experience of Change Data Capture (Oracle & SQL Server source systems) or other replication technologies an advantage
  • Experience of Energy Trading environment is an advantage.
  • Proficient in data modelling, data warehousing concepts and constructs, including star schema data models
  • Proficient performance tuning SQL, including use of explains plans, partitions, hints, etc.
  • Strong documentation skills required
  • Strong ability to work to project deadlines and project plans;
  • Experience in data analytics (Python, R) & reporting desirable including near real time analytics and reporting.





THE COMPANY IS AN EQUAL OPPORTUNITIES EMPLOYER






For further information on this Senior Back-End Developer role in Cork please contact Ros Lomasney on 021 2066287 / Ros@hero.ie
Check out all our open jobs on our HERO Recruitment website - www.hero.ie

Please Note: HERO Recruitment will not forward your details to any company without your prior approval


Share this Job

Our Clients

With a reputation across three decades in the making, HERO Recruitment continues to impress our clients and candidates with our passion and dedication to our craft.

See More

What people say

Our strong reputation for quality placements in key roles has earned us the status of agency of choice. HERO Recruitment’s commitment to superior service is what sets us apart from our competitors and has rewarded us with many exclusive and semi-exclusive client and candidate relationships.  Here is what our clients and candidates say about us…

See More

“I have worked with HERO recruitment (formerly HERO recruitment) for a number of years both within my current and previous position. I have always found HERO recruitment excellent to partner with, the consultants know our industry and cultural fit and can therefore successfully source high calibre candidates to match our open vacancies. I find HERO recruitment very professional to deal with and any candidates I interview who are sourced by HERO always have a positive recruitment experience”.

Moira Faherty,
Human Resources Manager
Chanelle Group

“My very first impression was that I was dealing with a recruitment company who were extremely professional, supportive and knowledgeable of the role for which I was applying. Not only were the responsibilities of the role explained to me in great detail, but they also went to great lengths to really understand the depth of my technical, managerial and leadership experience and capabilities. What impressed me the most was their personal touch in building a strong relationship with me as a candidate and in maintaining regular contact with me on the status of the role throughout the application process”.

Adrian Rice,
Engineering Manager 
Boston Scientific

“HERO have been a key strategic recruiting partner to Hollister ULC over many years. During our continued growth and expansion at our facility in Ballina, Hero have worked closely with us to really understand our recruiting needs, the calibre of talent we are looking for, and the fit for our Hollister culture. HERO have successfully sourced and placed candidates for us into Research and Development, Project / Process Engineering, Supply Chain and key Management roles.  They have a very experienced and professional team, and bring an excellent regional, national and international perspective”. 

Tom Horkan,
Asst. HR Manger
Hollister ULC, Ballina, Co. Mayo

“Merit Medical have partnered with Hero for the past 10 years. During this time we have grown our employee numbers to 630 employees. Our experience of working with HERO is that they have a personal client focused approach, they know the market and they can deliver on the candidates.  The medical device market is competitive and our company success is dependent on the quality of our people, we want the best there is in the market so we can grow and in turn offer development opportunities to our people. 

Mary Collins,
Senior Director, Human Resources Europe
Merit Medical

“HERO Recruitment continues to be a valued partner in supplying high calibre candidates to all three Boston Scientific sites in Ireland. In particular they have been successful in delivering on specific roles for key project scale-ups. HERO has also provided on-site recruitment presence during increased activity when required and consistently operate in a highly professional and competent manner”.   

Lorraine McDonnell,
Senior Talent Acquisition Specialist
Boston Scientific 

“HERO Recruitment were instrumental in sourcing and delivering key talent to the organisation and enabled us to meet our key deliverables within our start-up phase. They thoroughly understood our culture and constantly over delivered on our expectations. Our partnership with HERO Recruitment has without a doubt been  a professional and collaborative one. HERO exceed themselves in all aspects of recruitment and are an absolute pleasure to work with”.

Christine Power,
VP of Human Resources
Pivot

“HERO recruitment is an extension to our talent acquisition team. From hiring strategy meeting to the induction of the right talent, the HERO recruitment team provide an exemplary service. They are knowledgeable about our business needs, responsive and thorough. A true talent acquisition partner”. 


Orla Keady-Giblin,
Human Resources Manager
Ingersoll Rand – Thermo King