TEKenable Ltd

Senior Data Warehouse Engineer, SQL Server, SSIS, Azure

TEKenable Ltd

contract

Posted on:

Location Type: Hybrid

Location: Dublin • Ireland

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AzureETLSQLSSISTableau

About the role

  • - 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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLSSISSQL Server DatabaseData Warehouse solutionsdata modellingdimensional modellingETLELTdata qualitydata profiling
Soft skills
communicationself-starterteamworkoral communicationwritten communication
Certifications
Microsoft certificationsAzure certifications