Senior SQL ETL Developer

Job Description

TREND Health Partners is seeking a qualified SR SQL ETL Developer to assist our Data Team using Microsoft SQL Server Management Studio in performing data extract as well as transform and load operations on large healthcare datasets. Candidates must be familiar with data analysis and using dynamic SQL in ETL operations.

Responsibilities

• Develop and update complex T-SQL stored procedures to:
  1. Ingest data from flat files using BULK INSERT with sizes up to several gigabytes
  2. Map and transform from source tables into common staging table structures
  3. Migrate data from staging tables to production tables across linked servers
• Work with internal and external partners to understand the business needs of each data element and ensure mapped data meets those needs
• Work closely with internal partners to ensure data is mapped and loaded appropriately
• Analyze long running queries using tools such as SQL Server Profiler and SQL Execution Plans to propose solutions
• Implement query performance solutions such as indexes, statistics, partitioning, and chunking operations
• Interpret ad-hoc report requests from internal and external partners and develop required SQL
• Work as a team to support and troubleshoot errors for 100+ data feeds
• Work closely with the application development team to update data and data structures
• Provide analysis, recommendations and feedback to business process owners, leadership team, and the Information Technology department
• Propose automated solutions to repeated SQL development tasks
• Mentor junior resources and perform peer code reviews

Qualifications

• Bachelor’s degree with major coursework in Computer Science or Business Administration/related field required. Equivalent work experience in a similar position may be substituted for educational requirements
• 5+ years using Microsoft SQL Server Management Studio
• 5+ years of experience creating and maintaining complex T-SQL queries, table, functions, triggers, views, and stored procedures
• 5+ years performing advanced ETL development using BULK INSERT or BCP including various dataflow transformation tasks
• Strong understanding of dynamic SQL in a multi-database environment
• Strong ability to monitor and improve SQL performance
• Handle multiple simultaneous tasks and prioritize business needs
• Experience with end-to-end management of implementation, projects, or complex processes taking months to complete
• Proficiency in compiling data, creating reports, and presenting information
• Proven experience working in a fast-paced environment supporting multiple concurrent projects
• Strong written, verbal and customer service skills

Preferred Skills

• Experience with tables containing millions of records, several gigabytes
• Experience with table partitioning
• Experience using agile framework
• Experience with software development life cycle tools such as Red-Gate, Bitbucket, or JIRA
• Experience using a linked SQL server environment