ETL Developer

Job openings
Working at Arnia
Career development

Job description

In this role you will be key in designing and building data models & ETL pipelines in a project developed for a large pharmaceutical company from the UK.

You’ll be helping to exploit the data from multiple data sources to understand & improve complex data journeys, you’ll be involved in development on the new SQL data platform and the integration of new tools, data sources and modelling pipelines.

Requirements:

  • Proven track record in a Data Engineering, Data Management or ETL role.
  • Data modelling & integration development experience.
  • Exposure to a variety of ETL techniques and technologies.
  • Advanced knowledge of scheduling and automation.
  • Data integration development experience using SSIS, ETL frameworks.
  • In-depth SQL knowledge with experience interrogating data from large relational databases.
  • Version control e.g. VSTS/TFS or Git.
  • Experience working with cloud technologies would be beneficial.

Problem Solving & Change:

  • Ability to think outside the box and challenge existing processes and practices.
  • A positive team player that is enthusiastic, energetic and creative.
  • Good communication skills with an ability to convey technical concepts to a non-technical audience.
  • Confident self-starter, with strong attention to detail.
  • Mentor and guide the wider team to transition to adopt a single aligned ETL framework.

Responsibilities:

  • Manage the configuration of a new SQL data platform to enable advanced Analytics & Reporting to be developed and productionised.
  • Collaborate closely with IT and the Data owners to establish data flows into the platform.
  • Deliver value-prioritised analytics projects on behalf of internal customers.
  • Manage ETL development and automation (e.g. setting up scheduled pipelines, identifying efficiencies throughout, championing version control).
  • Develop the ETL framework to create a standardised approach to managing data effectively.
  • Create data models & data flow diagrams to help business understand where our data is stored.
  • Advise on future design approach & principles.
  • An understanding of Management Information/Business Intelligence/Analytics will be an advantage.
  • Work in an agile multidisciplinary team.
  • Design and document data catalogues/dictionary.
  • Develop robust ETL processes to provision and transform data.
  • Act as SME for the SQL Data Platform and its underlying technologies providing support to end users.
  • Develop solution options / proof of concepts to various data requirements.
  • Design and document flexible and practical data warehouse models to recommended industry standards.
  • Develop, embrace and embed best practice ways of working, continuously improving processes and ensuring new approaches are adopted by the team for improved efficiencies.
  • Good understanding of data privacy rules and data regulations.
relocation package
relocation package
competitive compensation packages
competitive compensation packages
flexible working hours
flexible working hours
job rotation
job rotation
performance bonuses
performance bonuses
learning through Arnia Academy
learning through Arnia Academy
attractive projects
attractive projects
medical benefits
medical benefits
trainings
trainings
international work experience
international work experience
referral program
referral program

Here at Arnia, we are a big family – software development engineers, quality assurance engineers, business analysts, system administrators, managers – we all love to do every day what we do the best – creating high quality software solutions and delivering excellent services to our customers and partners.

We believe in customer satisfaction as being the single most important goal we want to achieve in everything we do. But we also believe that we can reach this goal while having fun at work, making friends, and enjoying working together. We have game evenings, nights out and team building events to help us know each other better and spend quality time together. Also, we have a flat organization, with no unnecessary hierarchies and where you reach the management easily.


game evenings

nights out

team buildings
Arnia_business Arnia_office
Arnia_people Arnia_software_office_2
Arnia_software_office_6 Arnia_software_office_14
Arnia_software_office Arnia_software_people
Arnia_software_team_1 Arnia_software_team_3
Arnia_software_team_4 Arnia_software_team_5
Arnia_software_team_7 Arnia_software_team_9
Arnia_software_team_11 Arnia_software_team_13
Arnia_software_team_15 Arnia_software_team_18

In Arnia you will meet very skilled software engineers with rich academicals background, with passion for innovation and continuous education, self-driven and oriented toward results. At the same time, they are people with high sense of humour, fun and informal, that value friendship, trust and a nice working environment.

Excellence is achieved step by step, it is a journey we always take together as a team and as a modern organization. We recognize the value of each individual, we value diversity and we support your development career – your success is our success! We take pride in helping our people to develop their career, continuously improving their skills and their technical knowledge and to fully reach their own development goals.

People are different, they are coming from various cultures and are motivated by different things:

  • The financial interests
  • The career development plan
  • The technologies and the projects
  • The work-life balance
  • The opportunities to travel abroad

relocation package

competitive compensation packages

flexible working hours

job rotation

performance bonuses

learning through Arnia Academy

attractive projects

medical benefits

trainings

international work experience

referral program

We recognize people’s diversity and we try to meet everyone’s goals.

Arnia encourages you to pursuit your own interests, projects and ideas – passion can turn small things into big things – we want to be part of your own individual success. Let us know your ideas and your personal interests and we will find a way to support you.

Not the least, we have class A offices, located in Piata Victoriei – Europa House building, next to the metro stations and to other transportation means. It is very easy to get to work and you will enjoy the quality and the lifestyle of our offices.

And if you like all these, why don’t you join us?

careers-bkg

Whatever role you choose to pursue in our organization, as long as it aligns with our company goals and values, we will support you all the way. We provide for each employee:

  • A clear development plan for your career
  • Mentoring support, to help you grow in our organization
  • Customized trainings and courses
  • Periodical 1:1 meeting with your direct manager and upper management
  • Annual performance reviews
  • Constant feedback and career development support

I joined the Arnia team in 2011 on the XpressEngine project (PHP based CMS, most popular in South-East Asia) and now I’m leading the team that develops our own CMS, Karybu. Also, our PHP team is involved in a lot more projects on different technologies ranging from Magento to WordPress and from Zend Framework to Symfony2. Dan D., PHP Tech Lead @ Arnia

careers-bkg

Also, you will have the chance to mentor other people, to contribute to their growth and to help them with their career development. As a family, we support each other to achieve our best potential and to contribute better to the organization success.

In Arnia we need more than just excellent software engineers – we need highly skilled technical leaders, business analysts, and managers. And they are usually found within our own organization – they are people who showed great skills as individual contributors and choose to follow a leading role. Growing as a leader requires the development of specific skills, such as: people management, social awareness, self-awareness and leadership vision. If you are up to the challenge, we will support you and we will provide the best opportunities to show your talent and dedication.

And if you choose to be a full-time individual contributor, you will get the chance to develop your engineering skills, enrich your technical knowledge and promote to senior levels – it’s up to you and us to find together the best path for your career.

Recruitment process