Experience in both creating and maintaining complex T-SQL queries, views, and stored procedures
2+ year experience performing advanced ETL development using SSIS including various dataflow transformation tasks.
Ability to create databases and perform database maintenance activities.
Ability to monitor the performance and improve the performance by optimizing the code and by creating indexes.
Ability to backup the databases as per the schedule
Requirement - General
Experience in Healthcare Medical Claims and / or Pharmacy Claims
Proficient with Microsoft Access and Microsoft Excel
Ability to translate business needs into practical applications
Ability to complete time-sensitive, multi-dimensional projects as part of a team
Desire to work within a fast-paced environment
Ability to work in a team environment and be flexible in taking on various projects
Proven experience working in a fast-paced environment supporting multiple concurrent projects
Strong knowledge of Data Warehousing concepts
Strong written, verbal and Customer service skills
Knowledge of healthcare Claims systems and data warehousing concepts
Experience in data modelling
Experience in SSRS report development
Knowledge of running raw and map Quality Checks (QC) to assess for any invalid codes in building warehouses.
Bachelors and 8- 12 years experience or equivalent combination
Masters degree in computer or other healthcare related field, plus 3 years of experience
Data Analyst, SQL Server, SSIS/SSRS, Healthcare Medical Claims, ETL, Data Warehousing