Senior SQL ETL Developer

Hunt Valley, md
Apply Now

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:
    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

        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

        info@trendhealthpartners.com

        Follow Us