Description
50756-BIDW ETL Designer
Pasadena, CA 91103
Position type: w2
Contact duration: 6months + (strong possibility of extension)
Position Description: Experience in object-oriented design and analysis, Data management ETL design and construct, DBA, Data Modeling, Applications Delivery etc. Extensive experience in full software development life cycle including requirements definition, prototyping, design, coding, testing and maintenance. Strong background in database application development and proven history as a team player.
Required Certification - MCSE Data Platform or MCSE Business Intelligence
Experience Level: 10+ Years.
Skill Set:
Strong MS SQL coding (native and T-SQL), stored procedures, SSIS/SSRS. Additional experience with MS Access and Office Automation (VBA) preferred.
Prior Healthcare financial experience a strong plus.
Top 3-5 required skills
- MS SQL Database Design
- Strong SQL Coding (native and T-SQL)
- MS SQL Services (SSIS/SSRS/SSAS)
Top 3-5 daily responsibilities
- Work with business and technical partners to understand requirements
- Develop SSIS packages for data import per specifications
- Test and Document all processes required for implementation and support of development
Additional Desired skills
- C# or VB.NET
- MS Access
- Office Automation
Type of background you are looking for
- Database-centric application development
- Prior Healthcare financial experience preferred
Size of the team
- 4 Technical Resources on a 30 person team
Information on the project
- Project - EDI Tracking and Reconciliation
- Represents a Business Owned solution for loading Claims from multiple data sources and providing data-modelling and metrics-based reporting for Executive and Operational partners.
Minimum education requirement:
- Masters Degree preferred or Bachelors Degree required plus equivalent work experience.