Lead Data Analyst

Lead Data Analyst


Melville, New York

Employment Type


Information Technology

Job ID



Executive Alliance is pleased to represent our client who are a fast-growth healthcare technology leader who develops and distribute cutting-edge software solutions to all 340B-eligible healthcare providers and pharmacies that offer patients access to lower cost pharmaceuticals reimbursed by state Medicaid agencies. Their software and consulting services are adapted and customized to each of their client’s needs and are top tier leaders in their field.



They are seeking a Lead Data Analyst with expert SQL skills to work out of their Melville, Long Island, New York headquarters who will lead a team and help drive the company’s data insights and frameworks for their clients.



NOTE: This is an on-premise opportunity located in Melville, N.Y. and is not remote role. This company does not offer U.S. visa sponsorship support to prospective employees.


No C2C’s, please.

Job Description:

Job Summary:


Your primary responsibilities include leading a small team of analysts, writing SQL, tracking issues, investigation and debugging issues. You should be comfortable mentoring team members. You are analytical and a natural problem solver that delivers quality results. This opportunity reports to the Director of ETL and Operations.





  • Mentor Team Members (4-6 Team Members) technical abilities and encourage potential career growth paths
  • Coordinate with Dev and UAT teams to Unit test tickets scheduled for release into Production
  • Own Teams weekly Sprint tasks along with project assignments, and assist where needed to keep tasks on track for completion
  • Execute a specific plan for analyzing the necessary data to secure solutions to clients’ business information needs
  • Communicate data results to the client, with an emphasis on answering the question as opposed to the analytical and reporting processes used
  • Monitor workflow, analyze processes, and make recommendations for improvements
  • Identify, manage, and document ticket requirements for customers
  • Coordinate and test implementations with new customers/vendors, and Implementation team
  • Complete assigned work in a timely fashion
  • Special Projects as needed

Job Requirements:




  • Data Analyst Experience: 3-4 years
  • Ability to write sophisticated SQL queries and an understanding of relational databases (MS SQL). Parsing queries, utilizing window functions, rewriting queries for efficiency, joins, common table expressions, dynamic SQL, etc.
  • Ability to Analyze data and research issues using SQL and Excel- Required
  • Comfortable working with large raw data files ( CSV, TXT, EDI )
  • Analytical Thinker
  • Ability to multitask Tasks/Projects from start to finish
  • Time management and prioritization. Ability to adjust priorities accordingly as they frequently can change when issues arise. Work steadily, actively and consistently to complete assignment within established timeframes
  • Familiar with Jira and Agile Process
  • Experience creating test cases and conducting QA on enhancements/bugs


Big Plus - Healthcare and or 340B Industry Experience:

  • Experience working with EMRs, HL7 interfaces/messages (ADT and SIU), and patient information





  • 401(k)
  • 401(k) matching
  • Dental insurance
  • Health insurance
  • Paid time off
  • Vision insurance



Contact Details:

Ralph Marra
Senior Recruiter