Technical Business Analyst ( Data Warehousing )

CEIs client is a leader in health insurance who has been named one of Forbes best places to work is adding a Technical Business Analyst to their team in Downtown Philadelphia who is working on Data Warehousing and other enterprise data migration projects. • 6 month contract to hire position • Hybrid role working 3 days per week • $60-65 / HR + Benefits (medical, dental, vision, and 401k). Responsibilities: • Perform Source to Target Data Mapping for customer data integrations. • Examine structure, types, quality, and provide target data analysis, field mapping, and data transformation rules for data conversions. • 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. Position Qualifications: • Bachelor’s degree in Computer Science or Mathematics or Business Administration or equivalent work experience; Master’s in Business Administration is a plus. • A minimum of six years’ experience in working with business technology solutions. • Strong data analytical and problem-solving skills. • Experience in Source to Target mapping. • 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. • 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 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. About CEI: As a trusted technology partner, CEI delivers solutions that help our customers transform their business and achieve meaningful results. From strategy and custom application development through application management - our technology and digital experience services are tailored to meet each unique need of our customers. Our staffing solutions bring specialized skills to complement our customers' workforce and project requirements.