Business Systems & SQL Analyst

About Aerogen:
Headquartered in the vibrant city of Galway Ireland with offices around the world Aerogen is proud to be the world leader in acute care aerosol drug delivery. Recognised through multiple MedTech awards and ten-time winner of the Zenith award for Respiratory Care Excellence in North America collectively our employees make a difference to patients lives every day having already reached 20 million patients in over 80 countries.
Our talented and skilled team collaborate to innovate challenge and test not only in relation to our products but every facet of how we work. We lead the way finding innovative solutions to even the most complex problems all in the name of delivering better patient care.
Our business is growing rapidly across the globe and as we grow our core culture of We Care universally connects us. We believe that your ambition and integrity fuels ours and we are committed to supporting our employees to reach their full potential through tangible investment in their careers. Join us as we continue to #discoverbetter.

What is the role
The primary responsibility of this role is to support the development of business systems solutions and applications primarily concerning the ERP system and related components. The business applications include ERP system and labelling software SQL server database management and SQL code writing abilities.
Responsible for supporting and enhancing business applications with a particular focus on the ERP platform (Infor CloudSuite Industrial) and its related systems. This role requires strong SQL expertise to manage databases develop queries and optimize performance while ensuring reliable operation of ERP and labelling solutions

What are the key responsibilities
Handling a range of both technical and non-technical cases at any one time at all different complexities
Business Application Support - database management Big Data Data warehousing solutions ETL tools
Documenting Incident resolution
Co-ordinate users IT Change Controls with relevant stakeholders including Application System Owner Business Process Owner and Software Quality Assurance. This includes preparing Change Controls preparation and execution of Test cases
Aid in supporting ERP IT Infrastructure and relevant systems to meet business requirements.
Monitor the support ticketing system to resolve known errors by means of Knowledge Base Articles and documentation.
Obtain detailed and accurate information relating to how to reproduce incidents using effective questioning and troubleshooting techniques.
Work on own initiative ensuring that tickets are prioritised accordingly.

What education and experience are required
Third level qualification in Computer Science MIS software engineering or equivalent.
Minimum 3 years experience of responsibility for similar sized IT operation in technology & commercial environment.
Experience in ERP systems (e.g. Infor CSI SAP Oracle Workday Dynamics) is desirable
Knowledge of ETL processes data governance and master data management.
Proven experience in BI and analytics within ERP programs.
Excellent stakeholder management and communication skills.

What key skills will make you great at the role
Distinct Advantage if the applicant can demonstrate knowledge and skills in one or more of the following areas:
Working knowledge of the Medical Device industry.
Infor Syteline System (CSI - ERP).
Microsoft SQL Server T-SQL. (Database management)
Python and Java
Data pipeline frameworks
Microsoft Power Platform (Power BI Power Automate and PowerApps).
Atlassian Suite (Jira Confluence).

What is it like to work in Aerogen
Our purpose is to transform patient lives and our ethos is to#discoverbetter. This also translates to how we look after our people. We want talented passionate and engaged people to join Aerogen and build your career with us. We understand that your life evolves through different stages and we are here to support our global team with a range of financial and non-financial rewards and benefits. Theres something for everyone! Here is an idea of what we offer:
Excellent medical care.
Bonus & Pension.
Aerogen Connect our employee led programme which supports our global teams to unite and have fun.
We pledge 1% of profits and time to charities and organisations.

Aerogen is committed to promoting diversity inclusion and equality in the workplace. If you have any difficulty using our application process please contact us by emailing emailprotected. Please include your name and preferred method of contact.