The incumbent in this position will work closely with a team of data modelers, data and business analysts to design and implement data automation processes. This position will be building Extraction, Transformation, and Loading (ETL) processes to support enterprise wide projects. He/she will also perform T-SQL ad-hoc data analysis and QA, perform report development, and create SQL stored procedures and user-defined functions. He/she will be responsible for the ongoing operational stability of the ETL processes, ensuring they are properly monitored and audited to provide data integrity, accuracy and timeliness of delivery. Lastly, he/she will also write business requirement and technical specification documents.

***** CANDIDATES WITH HEALTHCARE EXPERIENCE ARE GIVEN FIRST CONSIDERATION *****

ESSENTIAL DUTIES & RESPONSIBILITIES

* Work with business users to clarify ETL requirements and business rules.
* Design, develop, implement, and assist in validating ETL processes.
* Create and execute unit test plans based on system and validation requirements.
* Troubleshoot, optimize, and tune ETL processes.
* Document all ETL-related work per company*s methodology.
* Maintain existing code and fix bugs whenever needed.
* Ensure that all timelines of loading/validating data are met.
* Ensure smooth functioning of our development, QA, and production environments.
* Collaborate with various functional business units to gather reporting requirements.
* Conduct data analysis; identify issues and recommend and implement solutions.
* Create ad-hoc and automated reporting solutions.
* Performs other related duties and special projects as assigned.

INDIVIDUAL CONTRIBUTOR EXPECTATIONS

* Understands and supports the company mission and its overarching business goals and objectives.
* Acts with integrity, honesty and fairness, remaining mindful of the duty of trust the company has to it employees, and to its providers, employers and members.
* Accepts and adapts to changes in company policy, practice, procedures quickly and positively and proactively supports his/her colleagues in adapting to changes in the workplace.
* Contributes actively and effectively to team discussions, sharing his/her knowledge and expertise willingly and collaboratively.
* Utilizes, supports and communicates agreed upon departmental performance competencies metrics.
* Identifies business process improvements that are aligned with and supportive of business goals and objectives. Provides thoughtful analyses and recommendations.
* Models professional behavior/conduct that remains in concert with the company culture and business values.

CORE COMPETENCIES / KNOWLEDGE & SKILL REQUIREMENTS

* Experience with developing an ETL lifecycle to support enterprise-wide data processing projects (i.e., Enterprise Data Warehouse).
* Strong database-related development skills (complex SQL queries, complex store procedures and user-defined functions in SQL Server 2005).
* Experience in data analysis, data modeling and data mart design.
* Ability to synthesize data from various sources and perform various types of data analysis.
* Familiarity with standard regulatory reporting requirements such as HEDIS measures.
* Familiarity with industry standard health data code sets such as ICD-9/ICD-10, CPT/HCPCS, revenue codes, and NDC (Pharmacy).
* Strong organization, time management and multi-tasking abilities.
* Solid analytical skills and problem solving skills with the ability to formulate and communicate recommendations for improvement.
* Familiarity with EDI/X12 file formats and other industry standards.
* Have the ability to work effectively with others and have good interpersonal skills.
* Be highly organized and work well under pressure.
* Must be willing to accept responsibility and to show good judgment, initiative, and resourcefulness.

EDUCATION, EXPERIENCE & TRAINING REQUIRED

* Bachelor*s degree in Computer Science or equivalent experience.
* 3+Years of ETL developer experience using SSIS or Pervasive tools.
* 5+Years of SQL Server 2005 experience.
* 3+Years of report development using SSRS.
* 3+Years of proven ability to interpret data in order to locate anomalies and recommending corrections plans.
* 3+Years of advanced SQL skills (SQL Server 2005).

COMMUNICATION & INTERPERSONAL SKILLS

* Written:
o Ability to analyze, evaluate and clearly present written information and findings.
* Verbal:
o Ability to clearly and concisely communicate to various levels across multiple business units, internal and external.
* Interpersonal:
o Ability to interact well with co-workers and outside contacts. Embraces change and maintains a positive attitude.

ESSENTIAL FUNCTIONS * PHYSICAL POSITION REQUIREMENTS; MACHINES AND/OR EQUIPMENT USED

* PC literacy required; MSOffice skills (Outlook, Word, Excel, PowerPoint)
* Regularly required to operate standard office equipment (personal computer, photocopy machine, fax machine, etc.)
* Ability to work on a computer up to 7 hours a day.
* Regularly required to sit for long periods of time, and occasionally stand and walk.
* Regularly required to use hands to operate computer and other office equipment.
* Close vision required for computer usage.

***** Must be a U.S. Citizen or Green Card Holder *****