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
Key Responsibilities:
Data Integration & ETL Processes:
* Design, develop, and maintain ETL pipelines using Azure Synapse/Microsoft Fabric.
* Ensure seamless data integration from various sources into the data warehouse.
* Optimize ETL processes for efficiency and performance.
Data Modelling & Warehousing:
* Design and implement a medallion data architecture aligned with business objectives, leveraging Microsoft Fabric, Azure Synapse, Delta Lake, Python (Spark), and SQL.
* Design, develop and maintain robust star schema data models to support business intelligence and analytics needs.
* Establish and implement data architecture, data warehousing and data management principles, standards, and best practices.
* Ensure data integrity, accuracy, and security.
Microsoft Fabric Utilisation:
* Utilise Microsoft Fabric to enhance data processing and analytics capabilities.
* Implement and manage data workflows in Microsoft Fabric for optimal performance.
BI Development:
* Gather and analyse business and technical requirements to design effective data solutions
* Development using full Microsoft BI Stack to build interactive and visually appealing dashboards and reports.
* Working with key stakeholders to define and develop analytical reporting models and data visualisation solutions to enhance business performance monitoring and driving decision-making capabilities
* Using DAX to help develop complex calculations
Performance Monitoring & Optimization:
* Monitor and optimize data processing and storage solutions.
* Identify and resolve performance issues and bottlenecks.
* Ensure high availability and reliability of data solutions.
Collaboration & Teamwork:
* Work closely with BI developers, data analysts, and other stakeholders to understand data requirements.
* Collaborate with cross-functional teams to design and implement data solutions.
* Provide technical guidance and support to team members on best practices and methodologies.
* Mentor team members, fostering a culture of innovation and continuous learning.
Documentation & Reporting:
* Document data workflows, ETL processes, and data models.
* Generate and maintain technical documentation for reference and reporting purposes.
* Provide regular updates and reports on data engineering activities and project statuses.
Required Skills and Qualifications:
Education:
* Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field. Master’s degree is a plus.
Experience:
* Proven experience (5+ years) 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 PowerBI including performance best practices for large data set Views, Dimensions, Cubes, Measures and Partitions
* Proven ability to design and deploy rich graphic visualizations (following corporate design standards) including scorecards and dashboards using functions such as calculated fields etc
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 a plus
* Candidates will ideally have a portfolio of previous PowerBI work to demonstrate visual and functional skillsets.
Working with Cairn Homes:
At Cairn, we believe it is essential that our employees feel valued and appreciated. We therefore offer above industry average remuneration packages with a comprehensive benefits portfolio that’s ready to support you for whatever life brings.
We are delighted to offer a suite of benefits when you join Cairn which include
* Competitive salary
* Performance related bonus
* Pension scheme with matching contributions
* Full health insurance with Irish Life health
* Annual salary review
* Continuous Professional development (CPD) programme & funding
* 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
* Culture Committee
* Talent Development Programmes
* Approved Profit Sharing Scheme (APSS)
* Company vehicle (role dependent)
The Cairn purpose is to build sustainable communities where people can thrive.
At Cairn, it’s not what we build, it’s why we build. It’s about putting down a marker that will stand for generations to come. Creating new communities of connection and belonging for an Ireland where people can thrive. Reshaping, redefining, reinvigorating our place in the world. Building for people, progress, and potential. Because when Cairn build, it’s Built For Good.
#J-18808-Ljbffr