SQL ETL Developer

Job Description

Our Information Technology team is seeking a motivated SQL ETL Developer to perform extracts, transform and load operations on large healthcare data sets. The candidate must be familiar with data analysis and using SQL BULK INSERT operations.

Responsibilities

• Create SQL stored procedures to load and manipulate data into production table structures

• Develop strong business and technical understanding of services and database design
• Work with internal and external clients to understand business requirements and ensure the required business functionality of each data element is met
• Perform T-SQL data profiling, analysis and mapping to ensure data quality and reliability
• Interpret and analyze multi-dimensional medical, provider, pharmacy claims data as well as enrollment data to accurately assess and demonstrate key insights into key trends and opportunities
• Handle new implementation, changes to existing layouts/data load code, automation development, performance optimization and database maintenance like indexing and fragmentation
• Test mapping and code to ensure the data is loaded appropriately
• Ensure data loads are completed and quality checks are performed
• Support defect triaging, fixes and testing

Qualifications

• Bachelor’s degree with major coursework in Computer Science or related field
• Equivalent work experience in a similar position may be substituted for educational requirements
• 3+ years experience using Microsoft SQL Server
• 3+ years experience creating and maintaining complex T-SQL queries, views and stored procedures
• 3+ years performing advanced ETL development using BULK INSERT or SSIS including various data flow transformation tasks
• Ability to complete time-sensitive, multi-dimensional projects independently or as part of a team
• Proven experience working in a fast-paced environment supporting multiple concurrent projects
• Strong written, verbal and customer service skills

Preferred Skills

• Experience with multi-dimensional data modeling
• Experience in SSRS report development