Data Engineer II focusing on strategic ingestion product for Travelers. Building data solutions and collaborating across teams to support analytic transformation.
About the role
- Senior Data Warehouse Engineer developing ETL processes and data warehouses for hybrid working setup in Dublin. Collaborating with IT teams and stakeholders to implement strategic data solutions.
Responsibilities
- Design and implement ETL procedures for intake of data from both internal and outside sources, as well as ensure data is verified and quality is checked.
- Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilisation.
- Work with business analysts and project managers to develop and refine reporting and analytics requirements.
- Work on complex projects that require both depth and breadth of knowledge in a number of technologies and the business.
- Participate on projects, clarifying the business requirements, performing systems analysis, development and modification activities, as well as related maintenance & support.
- Assist in planning sessions with the business users to analyse business requirements, and provide design recommendations.
- Write concise and clear technical specifications based on analysis of complex business requirements.
- Translate business and technical requirements into business application systems.
Requirements
- Advanced knowledge of SQL including complex stored procedures, functions, query optimisation, indexing strategy.
- 7+ years of experience of SSIS and SQL Server Database.
- Proven track record in delivering scalable and reliable Data Warehouse solutions.
- Strong data modelling and dimensional modelling skills (including slowly changing dimensions).
- Experience with data quality and data profiling.
- ETL/ELT design and development experience.
- Strong communication and self-starter ability
- Ability to work effectively in a team environment.
- Superb oral/written communication skills.
- Experienced in designing, building and maintaining large/complex Data Warehouse systems is desirable.
- Experience with Tableau is also desirable.
- Experience of Azure Data Storage, Azure Data Lakes and Azure SQL DB is desirable.
- Experience of Azure Devops (pipelines, repos, releases etc.) is desirable.
- Microsoft/Azure certifications desirable
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
No Education Requirement
Tech skills
Location requirements
Data Engineer at Tatum focusing on scalable data solutions and blockchain technology. Collaborating with teams to ensure data integrity and manage data infrastructure in a hybrid setup.
Senior Lead Data Engineer at Capital One collaborating with Agile teams and mentoring developers. Leading full - stack development and driving cloud - based solutions for financial empowerment.
Senior Data Engineer responsible for developing data pipelines and collaborating with US business teams. Working at Beghou Consulting, a life sciences company providing advanced analytics and technology solutions.
Data Solutions Architect designing enterprise - scale Azure and Databricks Lakehouse solutions for clinical trials and life sciences data enabling advanced analytics and compliance.
Data Architect at ADEO ensuring interoperability of IT systems through architecture design and data knowledge diffusion. Collaborating with teams to maintain data integrity and quality standards in an international setup.
Consultant, Data Engineer leading end - to - end data solutions and analytics. Collaborating with clients to improve data strategies and deliver actionable insights.
Big Data Engineer developing applications for Synchrony’s Enterprise Data Lake within an Agile scrum team. Collaborating to deliver high - quality data ingestion and maintain data governance standards.
Junior Data Engineer at Opplane working on data - focused solutions for financial services, collaborating on digital transformation projects.
Data Engineer optimizing data pipelines and cloud solutions for GFT Poland. Involves performance tuning, ETL pipelines, and data model development across multiple locations in Poland.