Business Systems Analyst - Philadelphia, United States - IntePros Consulting

Description

IntePros is seeking a Business System Analyst for one of our client's based in Philadelphia, a leading organization in the health insurance industry. This role does have onsite requirements in Philadelphia, PA.

Business System Analyst

Business System Analyst Overview

• The Senior Business Systems Analyst determines business requirements by working with business clients and recommends appropriate business system applications
• Recommends systems criteria and project scope
• Identifies potential problems, performs analysis and implements system enhancements, modifications and upgrades
• Plans and consults with business client on data reporting and trending reports
• Oversees the design and development of user system documentation
• Primary contact to define business system requirements and functional requirements documents
• Performs investigation, evaluation and documentation of system design findings
• Tracks systems performance and reviews problem logs
• Evaluates and analyzes coded data elements and recommends changes needed
• Assures that users understand business system functions
• Performs System testing and assists in User Acceptance Testing
• Works with appropriate training departments to assure technical information is accurately presented
• Mentors Junior resources in the team.

• This Business System Analyst role within the Data Warehouse team requires experience in creating Business Requirement Documents, Functional Requirement Documents and Mapping documents for the development of ETL applications. This role requires extensive SQL experience in writing complex queries across multiple tables, data analysis and profiling skills for the creation of the mapping documents and further discussion with data modelers for the necessary table designs.
• The ideal candidate should have all of the above skills at expert level along with strong verbal and written communication skills to work with various stakeholders, gather and formulate business requirements and translate the same to the technical team.
• Other preferred experience includes Source-to-Target mapping, health insurance knowledge and general data warehousing. The candidate will also be comfortable enough to support testing, production readiness verification and ensuring accuracy after the deployments.
• A minimum of five years' experience in working as Business Systems Analyst
• Strong data analytical and problem-solving skills.
• Data Warehouse experience is highly preferred.
• Working knowledge of at least one database product (Teradata, DB2, Oracle, or other).
• Experience in writing SQL (Structured Query Language) statements.
• Experience in writing Functional requirements and source to target mapping.
• Understanding of data integration and ETL methodologies.
• Exposure to at least one Health Care business area, such as Actuarial, Finance, Underwriting, Claims Processing, Enrollment, or Provider preferred.
• Excellent oral and written communication skills. Effective facilitation and presentation skills are necessary to demonstrate business systems solutions in a clear and concise manner.
• Demonstrated ability to define business systems solutions, make decisions, identify problems, coordinate resources, and implement changes.
• Excellent teamwork.
• Excellent troubleshooting skills.
• Ability to learn new or existing systems quickly.
• Ability to work independently on multiple projects.
• Accountable for adherence to program and project management standards.