Data Architect SQL Server
Posted on :
14-06-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Job Title: Data Architect (SQL Server)
Location: West Dublin Ireland
Contract: This role is for a 6month engagement (probably 12 months ) with the first 4 weeks requiring the person to be onsite. After that the position transitions to a hybrid model with 2 days per week in the office in West Dublin. Garda vetting is required before starting
Job Specification:
Purpose
Location: West Dublin Ireland
Contract: This role is for a 6month engagement (probably 12 months ) with the first 4 weeks requiring the person to be onsite. After that the position transitions to a hybrid model with 2 days per week in the office in West Dublin. Garda vetting is required before starting
Job Specification:
Purpose
Data Architect to develop an Enterprise Data Warehouse (EDW) using a Kimball model approach.
Scope of Work:
Scope of Work:
Design and build a granular incrementally growable EDW.
Develop necessary Dimensions and Fact tables focusing initially on Inpatient Outpatient and Waiting List data.
Integrate with existing onpremises SQL Server 2019 Enterprise infrastructure.
Link Fact tables to Dimensions using an ER model.
Technical Requirements
Technical Requirements
Utilise Microsoft technologies: SQL Server 2019 Visual Studio SSIS and Stored Procedures.
Implement SQL Agent Catalogue for job scheduling.
Maintain unique prefixes for Staging Transactional and Data Warehouse tables.
Facilitate regular updates and responsiveness to business requirements.
Implement failure notifications and an Audit Table for job execution logging.
Qualifications and Experience
Qualifications and Experience
Proven experience in Data Warehouse design and implementation using the Kimball approach.
Expertise in Microsoft SQL Server technologies SSIS and data visualization tools.
Strong understanding of ER models ETL processes and data quality standards.
Excellent documentation and communication skills.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
