Data Engineer

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