Data Engineer
Kraków
Nr ref.: 2490542
The ACIA is looking to hire a Data Engineer to support the design and development of data solutions that enable the delivery of the ACIA’s analytical objectives.
Responsibilites:
- Work with the Data Engineering Manager and in collaboration with Aon’s business teams to define and deliver data solutions that enable and enhance ACIA’s reporting and analytical capabilities
- Design, develop, test, tune, deploy data pipeline solutions and hand off to support teams to operate
- Interface with key business stakeholders to gather data integration requirements and develop solutions accordingly
- Contribute to the logical/physical design and development of new/existing data marts/models
- Maintain up to date Technical and Operational documentation
- Manage task list and communicate updates to stakeholders and team members following an Agile Scrum methodology
- Work as key member of the core team to support the timely and efficient delivery of critical data integration deliverables
Requirements
- At least 3 years of hands on experience as an ETL/DWH developer with strong knowledge in designing, developing and delivering end-to-end data integration processes for large scale data warehouses
- Experience in design, development and deployment of data warehouses or relational/analytical/multi-dimensional data marts
- Strong understanding of BI principles, architectures and enterprise scale BI solutions
- Experience with enterprise scale ETL/ETL solutions such as SSIS, IBM DataStage
- Experience developing data solutions on AWS (AWS Glue, Spectrum, Redshift, RDS)
- Advanced RDBMS experience particularly Oracle and MS SQL Server including complex stored procedures, functions, query optimization, indexing strategy etc.
- Exposure to and direct experience with AWS Redshift a distinct advantage
- Exposure to DWH appliance platforms such as Teradata, Netezza, MS APS advantageous
- Programming experience; in particular with Python, Perl or SPARK advantageous
- Knowledge of enterprise BI platforms such as Tableau, Qlikview, JasperSoft etc.
- Knowledge of Agile/SCRUM is desirable
- Full project lifecycle experience, from initial concept through to deployment and support.
We offer:
- Diverse and inclusive workplace - we value openness and authenticity and believe in the power of feedback
- Flexible remote work environment
- Employee-appreciation culture (multiple recognition programs)
- The best medical cover on the market with free dental care
- Wellbeing awareness (access to free mental health helpline, Stay-Well Day off, lectures, sports and more)
- Generous benefits package (personal accident insurance, benefit platform for vouchers and more)
- Internal career opportunities, individual development plan, professional development training and resources
- Lots of social events, charity actions and opportunities to integrate with colleagues