Information Analyst (remote working)

Date Opened: Mar 30, 2021

Location: Belfast, GB Derry/ Londonderry, GB Strabane, GB

Company: Allstate Insurance Company


About Us


At Allstate Northern Ireland, we believe it’s more than just a job.  We believe in allowing our people to choose the direction of their careers.  It’s about you, your future and where you want to get to.


Opportunity is the hallmark of the Allstate career experience.  We invest heavily in our employees, offering long term career development, personal growth and investment in new technologies.  Every day is different, with new ideas, challenges, and rewards — no matter which team you join.


We believe that inclusive diversity is crucial to creating a culture of mutual respect where the strengths and talents of each individual are recognised.  We like to leave things better than we found them and deliver results.  We do all of this while having fun and exploring personal passions.


Join our team and you’ll find challenge and reward in a culture of innovation, support and balance.


Allstate operate a very flexible hybrid working model with a blend of remote and office working for NI based employees.  Employees based in GB will be employed on a permanent remote working contract.





Belfast/ Derry – Londonderry /Strabane



Your role in the team


The Information Analyst provides enterprise, product, and project-level technical and business analysis support that produces consistent, accurate, and complete information requirements. You will be challenged with supporting and enhancing the analytic and reporting lifecycle throughout the enterprise. In support of the analytic and reporting lifecycle, this position will create data definitions that follow established standards and guidelines, develop and manage the logical and physical views of data that are consistent with the business objectives, and provide consulting on new developments within the business intelligence space.


The Information Analyst provides a high level of expertise in a focused area of the business.  They will work independently on projects of all degrees of complexity, supporting multiple business units to advance their use of data and analytics.  Through independent analysis and guided design, the role defines, develops, and implements data and business intelligence solutions for assigned business areas.   



  • Provides business knowledge and support for resolving technology issues across one or more areas of the business and across multiple projects for Allstate’s Information Services Group (ISG).
  • Analyzes and translates business, data, functional, and user requirements and/or business rules into analytic and reporting requirements, data models and metadata deliverables by leading and guiding discussions internally with the project team and externally with business and technology partners.
  • Plans, develops and leads information gathering sessions.
  • Constructs and executes complex SQL queries and reviews data profiling results to discover semantics, patterns and value domains of data under analysis.
  • Performs complex data analysis utilizing multiple techniques to determine, document and communicate existing and potential future data relationships, profiles and quality levels; uncover anomalies and variances in data content from expected results.
  • Updates and maintains all logical (conceptual, relational, subject-level and dimensional) data models and other metadata deliverables at multiple levels of detail and functionality for a specific business subject area.
  • Plans, develops and facilitates inspection sessions to validate that modeled data and related metadata deliverables match and satisfy business data requirements.
  • Conducts reviews of physical data model and related technical detail with database administrators and technical developers as part of a single project's development life cycle.
  • Understands, applies, teaches others and drive improvements in the use of corporate metadata development tools and processes.
  • Leads the initiation of new projects through estimation and planning in coordination with other ISG teams and other key stakeholders.
  • Develops and keeps current an approach to data management.
  • Applies knowledge of tools and processes to drive data management.
  • Creates complex technical requirements through analyzing business, functional, and technical requirements.




So, what are the essential criteria to apply?


  • All candidates must evidence an existing right to work in the UK
  • A minimum of 4 years’ experience as an Information Analyst, Business Analyst or similar highly technical role
  • 2 years’ experience building SQL queries
  • General knowledge of relational databases & data warehousing
  • Experience of data modeling




We also have some desirable criteria


  • Hands on experience with dimensional modeling.
  • Prior experience in modeling relational databases.
  •  Experience with Erwin or other data modeling tools
  • Experience with an object-oriented programming language is a big plus



What we offer


As Digital DNA’s Workplace of the Year 2020 winners, we offer a generous benefits package that includes flexible annual leave entitlement, dental and healthcare insurance, an attractive pension package and discounts on gym memberships, public transport and parking.


Allstate invests heavily in your development, as an employee you will have access to multiple world-class learning platforms and courses from our award-winning in-house Learning & Development team.


We pride ourselves in providing clear career paths and opportunities for internal mobility allowing you to further develop within the organisation.


We encourage a better work life balance and you’ll have the opportunity to apply for various flexible working arrangements.




Statement on Fair Employment and Equal Opportunities


Allstate NI wishes to ensure equal opportunity is given to all job applicants.  This company will not discriminate on the grounds of race, gender (including gender reassignment status), sexual orientation, religious belief, political opinion, marital status, age or disability.


We are an equal opportunities employer. We welcome applications from all suitably qualified persons. However, as women are currently under-represented in our workforce, we would particularly welcome applications from women. All appointments will be made on merit.


Applicants should note Allstate NI complete AccessNI background checks on all candidates offered a position.



The closing date for receipt of applications is Tuesday 13th April 2021