Position Summary We are looking for an experienced data analyst that is ready to grow with our company. Essential Functions & Responsibilities Develop and design enterprise data warehouse (EDW) and implementation of extract, transform, and load (ETL) processes for core data elements from benefits administration systems. Design and implement the transformation of data into schema to support group data, eligibility data, and premium billing data, claims data, provider data, and pharmacy claims data. Experience working with SQL database queries, database structures, and stored procedures. Involved in day-to-day load processing for data refresh and updates and troubleshooting of processes. Perform data analysis and validation for reporting, identifying outliers and exceptions within data extractions. Conversion of data into a normalized, unified format from data received from disparate data sources. Experience troubleshooting and managing escalations for production data issues. Identify and Cleanup of junk data. Use Crystal Reports and business objects for reporting and business analysis needs and develop management dashboards for ad-hoc reporting. Develop user interface to allow internal and external vendors to deliver eligibility claims & deliver data extracts. End-user training on all reporting and other applications as needed. Minimum Qualifications Bachelors of Computer Science/IT. Master’s degree preferred. 2+ Years’ experience in complete project lifecycle with a strong emphasis on analyzing requirements, design, development, testing & implementation. 2+ years’ experience in report creation and data analysis using Crystal Reports. 2+ years’ experience working with databases such as Oracle, SQL Server, MS Access. 2+ years’ experience technology support and troubleshooting. Programming languages required: SQL, C++, batch scripting. Strong knowledge of Microsoft Word, Excel, Access required. Must be able to work independently as well as in a team environment with a strong sense of accountability. Excellent written and verbal communication skills required; ability to communicate with individuals of all levels (technical and non-technical). Moderate experience defining and communicating technical expectations and documentation. Experience with VB Scripting & Excel Macros.
By clicking apply you will leave devsnap. Please be careful. You should never have to pay to apply.