Data Analyst/ Business Analyst
Bala Cynwyd, PA
Business Analyst III/ Integration Team is responsible for the analysis, integration requirements, functional specifications and data mapping development of integrations for the enterprise applications and various data integration solutions for TMNAS companies. In this role, he/she 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).
- Participate in the analysis, requirements, design and implementation of the functional enhancements and data integration solutions
- Responsible for the analysis, integration requirements, functional specifications and data mapping
- Perform data analysis and create data mapping for multiple integration points.
- Work with business users to solicit, analyze, and document business needs
- Document business/data requirements from source and target applications to support integrations.
- Responsible for the development and maintenance of SDLC artifacts related to implementation
- Perform data profiling on source data and document data anomalies.
- 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 and maintaining KPIs
- Works with internal business groups on process improvement projects designed to improve business results.
- Collaborate with the UI/UX teams to create designs
- 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 may be assigned.
Degree / Licenses and Professional Certifications
- Bachelor Degree (preferably in MIS, IT, or Business)
- Insurance knowledge/certifications a plus
- 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.
- Experience working in insurance industry P&C sector
- Experience and knowledge of SQL and XML
- Experience utilizing data modeling tools such as Erwin, Embarcadero etc.
- 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 or Collibra is preferred
- Experience with Data Lake or Hadoop implementations is a plus
- Knowledge on techniques, principles and concepts in data warehousing
- Strong Knowledge of the data governance and data management concepts and practices
- Strong Knowledge of the concepts, and best practices for ETL development
- Knowledge of activities, tasks, practices, and deliverables associated with soliciting and clearly defining and documenting required business functionality as well as non-functional requirements.
- Knowledge of SDLC and software support and maintenance approaches
- Knowledge of Guidewire Insurance or Data Management products is a plus.
- Knowledge of HP Application Lifecycle Management is a plus
- Strong writing and communication skills.
- Clear communication and comprehension skills
- Excellent problem solving and analytical skills
- Strong customer service orientation (responsive, consultative, collaborative and accurate)
- Proficiency in communicating technical recommendations back to business analysts, subject matter experts and end users.
- Strong interpersonal relationship building skills: able to work with a variety of people and groups in a constructive and collaborative manner.
- Strong analytical ability with the capability to determine the root cause of problems and issues and provide solutions.
- Strategic thinking; Applies organizational acumen to identify and maintain focus on key success factors for the organization.
- Strong drive to execute and deliver
- Ability to juggle multiple, competing, frequently changing time-sensitive deadlines and priorities.
- Ability to work independently and without supervision.
Tokio Marine Group of Companies (including, but not limited to the Philadelphia Insurance Companies, Tokio Marine America, Inc., TMNA Services, LLC and First Insurance Company of Hawaii, Ltd.) is an Equal Opportunity Employer. In order to remain competitive we must attract, develop, motivate, and retain the most qualified employees regardless of age, color, race, religion, gender, disability, national or ethnic origin, family circumstances, life experiences, marital status, military status, sexual orientation and/or any other status protected by law.