Overview
Cairn has a unique opportunity for a skilled and experienced Data Architect to join our expanding IT function with a focus on centralising our Data & Reporting. The ideal candidate will have extensive experience with Microsoft Synapse and Microsoft Fabric, demonstrating strong proficiency in data integration, data modelling, and ETL processes. This is a hands-on role and is crucial in transforming data into insights that help drive business decisions.
This position reports into Cairn’s BI & Data Analytics Manager.
Responsibilities
* Data Integration & ETL
o Design, develop, and maintain ETL pipelines using Azure Synapse/Microsoft Fabric.
o Ensure seamless data integration from various sources into the data warehouse.
o Optimize ETL processes for efficiency and performance.
* Data Modelling & Warehousing
o Design and implement a medallion data architecture aligned with business objectives, leveraging Microsoft Fabric, Azure Synapse, Delta Lake, Python (Spark), and SQL.
o Design, develop and maintain robust star schema data models to support business intelligence and analytics needs.
o Establish and implement data architecture, data warehousing and data management principles, standards, and best practices.
o Ensure data integrity, accuracy, and security.
o Utilise Microsoft Fabric to enhance data processing and analytics capabilities.
o Implement and manage data workflows in Microsoft Fabric for optimal performance.
* BI Development
o Gather and analyse business and technical requirements to design effective data solutions.
o Develop using the full Microsoft BI Stack to build interactive and visually appealing dashboards and reports.
o Work with key stakeholders to define and develop analytical reporting models and data visualization solutions to enhance business performance monitoring and drive decision-making capabilities.
o Use DAX to develop complex calculations.
* Performance Monitoring & Optimization
o Monitor and optimize data processing and storage solutions.
o Identify and resolve performance issues and bottlenecks.
o Ensure high availability and reliability of data solutions.
o Collaborate with BI developers, data analysts, and other stakeholders to understand data requirements.
o Collaborate with cross-functional teams to design and implement data solutions.
o Provide technical guidance and support to team members on best practices and methodologies.
o Mentor team members, fostering a culture of innovation and continuous learning.
* Documentation & Reporting
o Document data workflows, ETL processes, and data models.
o Generate and maintain technical documentation for reference and reporting purposes.
o Provide regular updates and reports on data engineering activities and project statuses.
Qualifications
* Education: Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field. Master’s degree is a plus.
* Experience: 5+ years of proven experience as a Data Engineer or in a similar role. Extensive experience with Microsoft Synapse and Microsoft Fabric. Strong background in data integration, ETL processes, and data modelling.
* Technical Skills: Proficiency in SQL, Python, and other languages for data scripting, transformation and automation. Hands-on experience in implementing data lakes, data lakehouses, and data warehouses. In-depth working knowledge of Power BI including performance best practices for large data sets (Views, Dimensions, Cubes, Measures and Partitions). Proven ability to design and deploy rich visualizations including scorecards and dashboards using functions such as calculated fields.
* Soft Skills: Strong analytical and problem-solving skills. Excellent communication and teamwork abilities. Ability to manage multiple projects and priorities in a fast-paced environment. Detail-oriented with a focus on data accuracy and quality. Familiarity with big data technologies and frameworks. Certification in Azure Synapse, Microsoft Fabric or related technologies is a plus. Candidates will ideally have a portfolio of previous Power BI work to demonstrate visual and functional skillsets.
Benefits
* Performance related bonus
* Pension scheme with matching contributions
* Full health insurance with Irish Life health
* Annual salary review
* Paid maternity & paternity leave
* Free Cairn annual leave days
* Life assurance
* Income protection
* Employee Assistance Programme with VHI
* Tax saver - travel and bike to work
* Talent Development Programmes
* Approved Profit Sharing Scheme (APSS)
* Company vehicle (role dependent)
Job details
* Seniority level: Mid-Senior level
* Employment type: Full-time
* Job function: Design
* Industries: Construction
#J-18808-Ljbffr