
Trend Health Partners
Direct to Hire – Fulltime Position
We offer a comprehensive compensation package which includes competitive salaries, bonus opportunities, highly-valued health insurance, 401K with employer match, paid time off and much more.
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:
- Ingest data from flat files using BULK INSERT with sizes up to several gigabytes
- Map and transform from source tables into common staging table structures
- 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
Other jobs at TREND
Application Developer
Hunt Valley, MD
Development Operations Engineer II
Hunt Valley, MD
Desktop Support Specialist
Hunt Valley, MD
Senior Project Analyst
Hunt Valley, MD
Perks of the Job
Competitive Salary
TREND offers competitive salaries, highly-valued health insurance, 401K and employer match and much more.
Highly-valued Health Insurance
TREND offers a highly-valued health insurance plan to match the high value we place on the health and well-being of our employees.
401k + Matching
Saving for the future is a must and TREND is inspired to be a part of our employees future growth through a 401K matching program.
Paid Time Off
TREND offers a generous PTO package to ensure employees strike the right balance between work and life.
Bonus Opportunities
Many positions offer quarterly bonus opportunities in addition to our competitive salary packages.
Dental, Vision and Much More…
Our benefit package extends well beyond a competitive salary and includes dental, vision and much more.
Perks

Related Job Openings
Application Developer
Hunt Valley, MD
Development Operations Engineer II
Hunt Valley, MD
Location
20 Wight Ave, Suite 150
Hunt Valley, MD 21030
+1 (443) 689-2700