Business Intelligence Developer

Information Technology
44286 Requisition #
Share this Job

Arthur J Gallagher are developing a number of business intelligence solutions. To support this goal Gallagher are expanding the BI team, initially recruiting two developers who will work alongside experienced business intelligence professionals. The developers will be responsible for design and delivery of solutions to integrate data from line of business applications into data warehouses and marts and the presentation of this data to end users using data visualisation software. You will be able to demonstrate knowledge of data processing approaches, developing extract, transform and load (ETL) code, with strong programming skills including SQL. Training will be provided on the BI tools used in Gallagher’s to the successful candidates.

Key Accountabilities/Deliverables:

  • Assist in the logical and physical design of the business intelligence solutions, deriving technical specifications from established business requirements.
  • Design and deliver ETL packages to implement the functional specification of solutions.
  • Detailed profiling of source system databases to inform business rule cleansing operations.
  • Conduct unit testing and troubleshooting.
  • Carry out peer reviews with colleague developers.
  • Deliver ETL solutions to established AJG development standards and practices.
  • Prepare documentation, including solution design, data dictionaries and release notes.
  • Work closely with the project team to understand the business requirements around existing and proposed processes and systems, developing effective working relationships.
  • Ensure that functionality is tasked and effort estimated to enable effective planning and delivery.
  • Attend daily scrum meetings with development team, weekly and monthly project team meetings as appropriate.
  • Awareness of Service desk issues in order to drive proactive solution provisioning / propose application enhancements / updates
  • Carry out duties following  internal policies and procedures in accordance with applicable laws, rules, regulations, good governance and Gallagher’s shared values, in particular, putting clients at the heart of our business

Person Specification:
  • A degree (2:1 or above) in Data Science and Analytics or Computer Science or 5+ years experience in BI Development
  • Demonstrable knowledge of Business Intelligence / Data warehouse theory (Kimball methodology strongly preferred)
  • Extensive experience in the Microsoft BI Tool-stack on Data Warehousing projects or demonstrable experience in BI and Data Science tools, techniques and technologies
  • Evidence of delivering business intelligence / data solutions, commercially or as part a degree project
  • A strong database knowledge, including maintenance, optimisation, trouble-shooting
  • Client-facing skills, strong analytical thinking, and attention to detail
  • Technical skills including:
    • Dimensional Modelling (Kimball)
    • Knowledge of Microsoft SQL Database, ETL and Reporting tools (2012 or greater)
    • Experience in using Data Visualisation tools such as PowerBI, Tableau, QlikView will be useful
    • Experience in using other database platforms, including Oracle, MySQL will be useful
    • Knowledge of C#.NET, ASP.NET, Python or other traditional coding is highly desirable
    • Knowledge of DAX is desirable
  • Knowledge of one or more formal project management methodologies (Agile methodology experience would be highly beneficial)
  • Working knowledge of source control and use of an software development lifecycle system such as TFS or JIRA would be advantageous
  • Effectively managing own workload
  • Delivering Results
  • Demonstrable drive, self-motivation
  • Determination to achieve results
  • Great customer service
  • Tenacious and self-motivated
  • Ability to lead research and triage of complex problems, tactical and strategic solutions.
  • Team player
  • Supports and encourages change and adapts positively to changing priorities and work demands
  • Able to work under pressure
  • Learns and shares knowledge
  • Able to deliver information with integrity and sensitivity
  • Confident and assertive individual
  • Eligibility to work in the UK

Founded by Arthur J. Gallagher in Chicago in 1927, Gallagher has grown to be one of the leading insurance brokerage, risk management, and human capital consultant companies in the world. With significant reach internationally, we are an equal opportunities organisation who employs over 26,000 people and our global network provides services in more than 150 countries.

Our people partner with businesses across countries and international territories to provide relevant and impactful professional advice. Regardless of what risk and challenges our clients have, we work hard and utilize industry specific expertise to find the best solution and to deliver it with world-class service.

We continue to build on 90 plus years of expertise that spans global industries. No matter the size of the organization we partner with and the challenges presented by the industry, we work tirelessly to provide solutions that maximize value for our clients.

Our values are core to our culture. Passionate service, strategic innovation, and ethical behavior form the basis of how we do business.

We help businesses go beyond their goals. It’s the Gallagher Way.

Our employing entity, Arthur J. Gallagher Services (UK) Limited, is proud to be accredited as a Living Wage employer with the Living Wage Foundation

Similar Listings

Bournemouth, Dorset, United Kingdom

📁 Information Technology

Requisition #: 49471

Bournemouth, Dorset, United Kingdom

📁 Information Technology

Requisition #: 44658

Bournemouth, Dorset, United Kingdom

📁 Information Technology

Requisition #: 48219