Position: Data Engineer (Poland)
Company: ControlPay BV
Category: Data Engineer
Experience required: 3y
English level: intermediate

ControlPay is a Global freight audit solution provider. We are trusted Partner between our customers and their carriers. Every year we process millions of transport orders and invoices. Doing this by our own developed programs and supported by customers' service teams we achieve cost saving and visibility in the complex processes of our clients. This makes ControlPay the innovative and fast-growing company, leading the social responsible business on the market.

We are looking for **Data Engineer** to join our team.

**YOU will be involved in:**

• Analysis of existing OLTP DB data models of Oracle/Postgres DB;
• Analysis of existing DWH DB data models of Vertica DB;
• Developing and supporting data pipelines between company Business applications and Data Warehouses;
• Designing architecture and developing DWH structure according to business requirements;
• Developing and maintaining applications and interfaces for accessing data, analyzing and visualization;
• Setup monitoring and guarantee reliability and availability of all services involved into BI infrastructure;
• Providing query, reporting and analysis according to business requests;
• Regularly communication with technical staff to ensure system integrity and security.

**Person we are looking for

YOU need to have:
**
• Proven working experience as SQL DB Developer, Data Engineer.
• Experience working with ETL tools (e.g. Pentaho DI, Talend, Spark ETL);
• Ability to develop and optimize large, complicated SQL statements (Oracle, PostgreSQL, Vertica dialects);
• Experience with modeling and optimizing performance effective data structures;
• Base knowledge in Data Base Administration (e.g. backup, recovery);
• Strong unix user skills;
• Knowledge of English language (Intermediate level or higher).

**Would be a plus:
**
• Experience with Java / Groovy and modern application frameworks (e.g. Spring, Spark);
• Experience with JavaScipt core and visualization frameworks (e.g. d3, highcharts, echarts);
• Business awareness and understanding of business requirements of IT.
**
YOU are:
**
• Detail oriented and focused;
• Problem solver;
• Result oriented;
• Proactive and initiative;
• Able to analyze and think logically;
• Able to work well independently as well as part of a team;
• Able to effectively prioritize and execute tasks in a high-pressure environment;

**What we offer to You:**

• Possibility to work in a hybrid format (office/remote);
• Experience of cooperation in a cross-cultural environment with dedicated professionals;
• Long-term cooperation;
• Competitive compensation level;
• Special Adaptation Training program;
• Health care (medical insurance);
• Sport Communities;
• Team-building activities;
• Comfortable working place with modern facilities.