Apply Now

Applications processed via employer's online application form

Job Details



Closing Date

2022-01-31 00:00:00


Business Intelligence Analyst (hybrid or remote)

  • About Us


    The world isn’t standing still, and neither is Allstate. We’re moving quickly, looking across our businesses and brands and taking bold steps to better serve customers’ evolving needs. That’s why now is an exciting time to join our team. You’ll have opportunities to take risks, challenge the status quo and shape the future for the greater good.


    You’ll do all this in an environment of excellence and the highest ethical standards – a place where values such as integrity, inclusive diversity and accountability are paramount. We empower every employee to lead, drive change and give back where they work and live. Our people are our greatest strength, and we work as one team in service of our customers and communities.


    Allstate operate a very flexible hybrid working policy that will allow you to design your working week in collaboration with your manager with a blend of remote and office working for NI based employees as well as condensed working patterns (4 day week/9 day fortnight). Employees based in GB will be employed on a permanent remote working contract.


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





    Belfast/Derry- Londonderry/ Strabane/Remote GB



    Your role in the team


    Allstate Identity Protection is seeking a skilled and highly self-motivated Business Intelligence (BI) Analyst to support the Financial Planning & Analysis group. This is an opportunity to use your experience in data analysis, ETL, query authoring, and modeling to deliver insights to decision makers as well as be a key liaison between business groups and the data services team within the information technology department. You will leverage your working knowledge of leading business intelligence software and reporting/visualization techniques to help drive the enterprise BI program forward.

    You are constantly curious which drives you to keep asking questions to seek deeper understanding, and continually incorporate that knowledge into the depth and breadth of your thinking. You have a strong track record of working with unruly data. You challenge conventional thinking and constantly seek out opportunities to optimize, scale, and automate repetitive data processes and reporting efforts. You approach complexity with enthusiasm and imagination, finding solutions where others have not. You have an intermediate to advanced technical background in one or more of the following languages/tools: SQL, Power BI, Power Query, DAX, Excel VBA, Python

    • Build and maintain dashboards, metrics, or reports to identify trends or anomalies.
    • Support new reporting functionality as well as the optimization of legacy models/reports.
    • Consult with business users to identify and understand data sources, data requirements, or data validation standards.
    • Generate professional-quality and easy-to-use dashboards for business groups.
    • Design and implement quality assurance tests and data validation scripts to ensure financial metrics reconcile to source systems
    • Act as a data steward for sensitive financial information and work with data governance and data champions teams to drive data quality and continuous improvement 


    We love what we do, we develop each other, and we have a lot of fun!


    If you’d like to join us, we would love to hear from you.


    So, what are the essential criteria to apply?


    • All candidates must evidence an existing right to work in the UK'
    • Bachelor’s Degree in Business, Engineering, Computer Science, or Mathematics
    • 3+ years’ experience traversing relational databases, enterprise reporting, data analytics, and/or system administration
    • Intermediate to advanced SQL knowledge, or comparable skills in equivalent query language, e.g. Microsoft Power Query
    • Direct hands-on experience working with relational databases and/or semantic models
    • Experience with Power BI, Power Query, DAX, SSAS
    • Detail oriented approach to work with ability to multitask while meeting deadlines
    • Applicants must be willing and eligible to travel to the USA



    We also have some desirable criteria


    • Masters in Data Science or Business Analytics, CPA, CFA
    • Experience working with pulling or working with data from financial systems/ledgers
    • Good organizational and referencing skills related to work papers, financial statements and schedules



    Hours of Work


    • This role may require alignment to US working hours (14.00-22.00) during your training period and were applicable for business needs.


    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.


    Apply Here: 


    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 Monday 31st January 2022

Apply Now

Applications processed via employer's online application form