BI Developer
Arachas Corporate Brokers Ltd
Dublin, County Dublin, Ireland
Information Technology
Working closely with other data teammates and with colleagues across Arachas, the BI developer will work with a variety of data sets to both respond, and deliver on business requests for insights and analysis, as well as working with and interpreting the data sets to proactively design and deliver the analytical output that will support Arachas in our ambitious data strategy.
#ACB
Role Accountabilities And Core Responsibilities
- Build and maintain Power BI semantic models with a strong focus on star schema, snowflake schema, and dimensional modelling.
- Develop and maintain Power BI reports and dashboards.
- Develop complex DAX measures and calculated columns to support advanced analytics and business logic.
- Build and optimize SQL transformations within a medallion architecture (bronze, silver, gold layers).
- Collaborate with cross-functional teams to gather requirements and deliver scalable data solutions.
- Ensure data quality, integrity, and governance across platforms.
- Familiarity with the latest advancements in Power BI such as deployment pipelines, dataflows, composite models, DirectQuery vs Import modes, and integration with Microsoft Fabric.
- Ability to optimize performance, manage workspace governance.
- Demonstrated understanding of how to design and apply RLS policies to ensure data access is restricted based on user roles or attributes, maintaining data confidentiality and compliance across reports and dashboards.
- Prepare high quality management information and present recommendations for implementation/business decisions within strict timelines
- Maintain strong relationships with business stakeholders to ensure that data is interpreted and validated correctly and work with them to refine data outputs
- Develop an understanding of the business and its operations to determine relevant insights for various business stakeholders
- Build and maintain data pipelines using Microsoft Fabric components (Azure Data Factory, Lakehouse, OneLake, Notebooks, Pipelines).
- Bachelor's degree in computer science/information systems/ engineering or maths.
- 3–5+ years of experience as a Data / BI Engineer or similar role.
- Strong hands-on experience with Microsoft Power BI / Synapse / Microsoft Azure / Fabric tools and architecture.
- Proficiency in Power BI, SQL, Nice to have Python (PySpark).
- Experience with Azure Data Services (e.g., Data Factory, Synapse Analytics).
- Solid understanding of data modelling, ETL/ELT, and data warehousing.
- Experienced and independent subject matter expert, capable of working on own initiative whilst delivering best practice solutions
- Possesses a can-do attitude and can get things done, rapidly building an understanding of the Arachas organisation and technical environment.
- Strong relationship builder and capable of credibly managing internal and external executive stakeholders.
- Microsoft certifications in Power BI, Azure Data Engineering, or Microsoft Fabric.
- Experience with performance tuning in Power BI and DAX.
- Familiarity with data mesh or data fabric concepts.
- Exposure to machine learning workflows and AI integrations.
About the company
Company website•Insurance
Arachas is the country’s largest nationwide Insurance broker with over 750 employees at 14 offices located throughout the country.
Our experts provide consultancy on the entire range of insurance products and services for commercial and domestic customers based on our long-standing relationships with clients and providers and unrivalled access to insurance data.
Arachas can also uniquely provide complex insurance requirements via innovative sector-specific schemes.
Arachas is committed to creating an inclusive and diverse workplace and offers flexible working practices. Giving back to our local communities, through sponsorships and charities, close to our values, is important for Arachas and our employees.
One such charity is Cancer Fund for Children, where we are supporting our colleague and brand ambassador, Rory Best on his Miles to Mayo fundraiser to deliver Daisy Lodge, a vital new therapeutic centre for children with cancer and their families.
Arachas is part of the Ardonagh Group, one of the world’s largest independent insurance distribution platforms and a top 20 global broker with a combined workforce of over 10,000 colleagues and a network spanning 200+ locations in more than 30 countries.