ETL/SQL Developer / Database administrator

Purpose of the job

The ETL/SQL Developer will be responsible for assisting in the day to day maintenance, development and implementation of critical applications along with reporting projects. This role will also help identify data needs and potential issues. Ideally, this position also takes responsibility for the performance of the databases in the role of DBA. You will be working in an environment where a new BI platform will be implemented based on SAP HANA as well as multiple SQL databases for (self-service) analytics.

Key accountabilities

Core activities:

  • Understand the business requirements to design, develop, build and maintain ETL workflows, SQL applications, database structures and DWH objects following coding standards & processes
  • Design, implement and support DWH projects
  • Interact with business stakeholders to understand DWH and BI requirements
  • Write relational and multidimensional database queries
  • Develop and maintain controls to ensure data quality and integrity
  • Process errors and bugs in the DWH environment and BI process flows
  • Support IT staff and end users in the development, usage and troubleshooting of database driven applications
  • Design, develop and maintain databases using SQL Server technologies, writing T-SQL code including stored procedures, functions and triggers, developing SSIS packages
  • Database maintenance, backup and performance monitoring, tuning and reporting
  • Develop database structure: utilization policies, procedures, security, archiving
  • Disaster recovery design, planning and testing.

Knowledge & skills

  • Bachelor degree in computer systems design, computer science or system engineering
  • Over 5 years of proven experience developing SQL/ETL
  • Strong experience in SSIS development in Microsoft SQL Server 2012/2014 technologies
  • Strong experience in writing and tuning complex T-SQL code including stored procedures and functions and in developing SSIS packages
  • Knowledge of modern data warehousing and OLAP standard concepts, structures and procedures
  • Experience troubleshooting SQL Server, including performance problems, query tuning and optimization, and Windows Server performance problems
  • Technical familiarity with Microsoft Database and other database technologies (secondary)
  • Experience with designing relational and multi-dimensional databases
  • Experience with reporting tools such as Cognos and MS Power BI is a plus

Competences

  • Analytic
  • Accurate
  • Well-organized
  • Service oriented
  • Able to work independently but also in a team
  • Open to new technologies
  • Excellent verbal and written communication skills (English and Dutch)

For further information about this vacancy please contact the Human Resources Department; Nalynie Biekhram human.resource@europoolsystem.com. All applications will be dealt with in the strictest confidence.

#working@EPG