Senior Data Warehouse Engineer

Dublin
2 days ago
Create job alert

Lead Data Warehouse Senior Engineer - Contract

Hybrid Dublin - 2 days
7+ years experience

This is an exciting opportunity for an experienced Data Warehouse Developer to join our expanding IT team responsible for the development and maintenance of our mission critical applications.

Key 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 utilization.
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 analyze 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.

Experience:

Advanced knowledge of SQL including complex stored procedures, functions, query optimization, 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 modeling and dimensional modeling skills (including slowly changing dimensions).
Experience with data quality and data profiling.
ETL/ELT design and development experience.
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
Education & Training

Third Level Qualification in Computer Science / IT or relevant work experience.
MS/Azure certifications desirableCompetencies

Delivery focused with a strong aptitude for team motivation
Highly organised and structured approach to working
Strong analytical skills that ensure projects are delivered to an accurate and high quality standard.
Ability to work effectively in a team environment.
Superb oral/written communication skills.Please can you send me a copy of your CV if you are interested

Related Jobs

View all jobs

Senior Data Warehouse Engineer

Senior Data Warehouse Engineer (Remote/Hybrid)

Senior SQL DBA & Data Warehouse Engineer (Power BI)

Senior Data Modeler — AWS Data Warehouse Migration (Remote)

Senior Data Engineer

Senior Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.

Neurodiversity in Data Science Careers: Turning Different Thinking into a Superpower

Data science is all about turning messy, real-world information into decisions, products & insights. It sits at the crossroads of maths, coding, business & communication – which means it needs people who see patterns, ask unusual questions & challenge assumptions. That makes data science a natural fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & thinking about a data science career, you might have heard comments like “you’re too distracted for complex analysis”, “too literal for stakeholder work” or “too disorganised for large projects”. In reality, the same traits that can make traditional environments difficult often line up beautifully with data science work. This guide is written for data science job seekers in the UK. We’ll explore: What neurodiversity means in a data science context How ADHD, autism & dyslexia strengths map to common data science roles Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data science – & how to turn “different thinking” into a real career advantage.