Business Analyst III - Data and Reporting

We are looking for a qualified candidate for the position of Business Analyst III – Data and Reporting Team to participate in requirements, technical analysis, functional specifications, data analysis and mapping of various applications in the data and reporting space for TMNAS and Group Companies.  In this role, the candidate is expected to possess advanced analytical skills and work extensively with data using various tools (articulated below.  A candidate for this position must be able to work in a varied, fast-paced environment as part a service delivery function for TMNA Services (TMNAS) and its Group Companies whereby they can provide technical leadership to a team of developers. The candidate will be expected to work with our business stakeholders, business analysts/data analysts, subject matter experts, architects, development teams and external vendors to analyze and document business/data requirements and data anomalies. A candidate for this position must be able to work in a varied, fast-paced environment as part a service delivery function for TMNA Services (TMNAS) and its Group Companies and is expected to possess advance skills in key areas (articulated below).

Job Responsibilities

• Build effective relationships with all stakeholders, acting as the liaison between the business and the technology teams across TMNAS group companies TMA, PHLY and FICOH.
• Participate in the analysis, requirements, design and implementation of the functional enhancements in the data and reporting area
  • Responsible for the performing data analysis, documenting data requirements, functional specifications and data mapping for multiple integration points.
  • Work with business users to solicit, analyze, and document business needs
  • Work with technical leads, architects, subject matter experts and vendors to elicit and document business/data requirements from source and target applications to support integrations.
  • Responsible for the development and maintenance of SDLC artifacts related to implementation such as data specifications/mapping documents, SOPs, run books, etc.
• Perform data profiling on source data and document data anomalies using tools like IDQ
• Formulate and define objective and scope based on user needs and thorough understanding of business processes
• Participate in on-going operational L3 support and maintenance for implemented integrations (real time or batch)
  • Provide resolution of support and maintenance tickets per established SLAs.
  • Provide resolution of various data issues reported
  • Develop procedures and queries for data analysis and reports. 
  • Maintain the data integrity by establishing, automating and enhancing operational checks, balance routines, reconciliation and maintaining KPIs
• Works with internal business groups on process improvement projects designed to improve business results.
• Define analytics requirements. Work with analytic products to create reports, measure websites performance and analyze the data to provide usability improvements and optimization recommendations
• Work collaboratively with architects, technical leads and subject matter experts of the various upstream and downstream systems responsible for receiving and/or sending data in support of existing systems
• Define acceptance criteria as part of requirements
• Review test strategy and test scenarios for QA resources and provide testing support
• Participate in UAT execution and support end user training, as required for eventual product implementation
• Align to the maintenance and enforcement of SDLC processes, departmental standards, style requirements and all other procedures necessary for data and system integrity.
• Complies with proper internal controls as necessary to conduct job functions and/or carry out responsibilities and/or administrative activities at the Company
• Performs special projects and other duties as needed.

Degree / Licenses and Professional Certifications

• Bachelor's degree in Computer Science,  MIS,  Engineering or a related technical discipline is preferred
• Insurance knowledge/certifications preferred

Experience

• 3-5 years of prior experience focused in data analysis, modeling, profiling and mapping.
• Experience writing business requirements and functional specs. Ability to decompose complex business and data requirements into technical specifications and mapping documents.
• Extensive knowledge and experience of SQL and XML
• Experience working in insurance industry P&C sector
• Experience working with source code repositories (Subversion, Team Foundation Server) and continuous integration/deployment
• Experience and knowledge of Microsoft Office products (Visio, Excel, Word and PowerPoint)
• Practical experience with tools such as Informatica Analyst, Informatica Metadata Manager ,Informatica Data Quality is preferred
• Experience with Data Lake or Hadoop implementations is a plus