Data Engineer
Kraków
Nr ref.: 2482749
Responsibilities:
- 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:
- 3+ years 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:
- the best medical cover on the market with free dental care
- generous benefits package for your wellbeing (multisport cards, insurance, vouchers, and many more!)
- stability of employment and permanent contract after trial period
- brand new office supporting collaboration, flexibility and activity based working
- internal career opportunities and individual development plan
- unique workplace culture - we value openness, honesty and authenticity, so don’t expect formal dress code nor managers hidden behind closed doors
- lots of social events, charity actions and opportunities to integrate with colleagues