Data & Reporting Analyst
KennCo, located in Rathfarnham, County Dublin, Ireland
KennCo Underwriting, one of Ireland’s largest insurance MGAs, is looking to hire a Reporting/Data Analyst to work in their busy IT Department. The role is ideal for a dynamic individual who can fit into the Reports Analyst position and has a degree in computer science, information technology, or a related discipline. The candidate should have 3+ years of similar experience in a financial company (or a comparable industry) and be comfortable working with all aspects of the data lifecycle.
Responsibilities & Duties
* Develop, maintain, and optimise SQL queries and stored procedures for reporting and analysis.
* Produce and maintain regular MI reports using Cognos and SSRS, ensuring accuracy and timeliness.
* Extract, clean, and manipulate data from Microsoft Dynamics and other internal systems.
* Support the creation of dashboards and visual reports using Power BI to enhance business insights.
* Conduct ad-hoc analysis to support operational teams, finance, underwriting, and senior management.
* Assist in data validation, data quality assurance, and the automation of recurring reports.
* Collaborate with IT and business users to ensure data integrity across systems.
* Contribute to continuous improvement of MI processes, including documentation and process automation.
Technical Knowledge & Skills
* Proven working experience as a Data Analyst or Business Data Analyst.
* Strong SQL skills (including writing complex joins, subqueries, CTEs, and aggregations).
* Advanced Excel skills (pivot tables, lookups, data analysis functions, charting).
* Experience with data extraction and manipulation from relational databases.
* Knowledge of Power BI, creating and developing new dashboards as well as maintaining and updating existing ones – a distinct advantage.
* Previous experience in the Insurance Industry – a distinct advantage.
* Experience with Microsoft Dynamics (CRM or ERP data structures).
* Experience with Cognos for MI development and report building.
* Familiarity with SSRS for report automation and scheduling.
* Exposure to Power BI (data modelling, DAX, visualisations).
* Basic knowledge of Python or R for data analysis and automation.
* Understanding of insurance industry data (policies, claims, premiums, etc.).
* Familiarity with ETL processes or data warehousing concepts.
* Good quality presentation skills and the ability to communicate with non‑technical stakeholders.
* Good problem‑solving and proven troubleshooting skills.
* Ability to work as part of a team.
Role: Immediate Start, Permanent, full time
Salary: Salary commensurate with experience
Seniority level: Mid‑Senior level
Employment type: Full‑time
Job function: Information Technology
Industries: Operations Consulting
Referrals increase your chances of interviewing at KennCo by 2x.
#J-18808-Ljbffr