Business Intelligence Analyst

Job Title: Business Intelligence Analyst
Contract Type: Contract
Location: Stamford, Connecticut
Salary: Negotiable
Job list.duration: 6 months C2H
REF: CWS321_1549917947
Contact Name: Connor Wallace-Sims
Contact Email:
Job Published: 5 months ago

Job Description

Position Summary

The Enterprise Technology Business Intelligence Analyst will be responsible for the delivery of reports, visualizations and analytics to support the business operations. This will require: working closely with the Underwriting/Claims/Actuarial & Accounting business units in order to understand their data needs; developing a deep understanding of corporate data sets, including both traditional Data Warehouse and Big Data lakes; helping to define data cleansing and standardization routines; documenting different dataset and transformation rules; and displaying a proficiency in SQL, Hadoop, Excel and the other tools required to fulfill these objectives.

Essential Duties

  • Develop new, and enhance existing, reports using a variety of tools
  • Respond to ad-hoc data requests quickly and accurately
  • Document data sets and transformations
  • Work to clean, normalize, and augment data sets
  • Analyze and document business requirements
  • Identify key performance indicators (KPI)
  • Help shape overall BI/data warehouse strategy
  • Assist in delivering self-service BI capabilities to end-users
  • Review project requests from users
  • Estimate time and cost required to accomplish projects
  • Determine if project requires business process review, creating, or modify of existing programs that access data stored in databases
  • Lead and/or attend specification meetings with project team workers to determine scope and limitations of project. Keep manager informed of activities and situations, which will impact the achievement of corporate, and department goals and objectives
  • Assist in testing and quality control of systems and data
  • Perform other related duties as required to achieve the goals and objectives of the company and department
  • Maintain confidentiality of company-sensitive data

Skills, Knowledge & Abilities

  • Solid understanding of the insurance and reinsurance industry and how technology can be applied to improve the business process
  • Strong inter-personal and communication skills; acting as a business liaison, making presentations, training users, and working closely with management
  • Must have the ability to communicate clearly, concisely to non-technical audiences
  • Demonstrated ability to solve problems quickly and completely
  • Ability to identify tasks which require automation
  • Ability to work independently and as part of a team
  • Solid understanding of a computer technologies and the direction of new technologies
  • Exceptional organizational skills and great attention to detail
  • Ability to plan and organize effectively
  • Ability to handle multiple projects with changing priorities and meet challenging deadlines in a fast-paced environment
  • Experience working with consultants and vendors (a plus)

Technical Skills

  • Advanced knowledge of Excel
  • Data warehousing / database knowledge
  • Visualization / presentation tools such as Tableau, Qlik, Pyramid, etc.
  • Data preparation tools such as Trifacta Wrangler, Paxata, TIBCO, etc.
  • Big Data / Hadoop
  • Ability to develop detailed documentation relating to a business solution
  • Microsoft Office applications and Outlook (or equivalent)
  • Intermediate knowledge of SQL querying


  • Bachelor's degree or equivalent
  • 5 plus years industry experience directly related to the duties and responsibilities specified