SQL Server SSIS Data Analyst
at Medix

Date Posted: 5/22/2019

Job Description

Medix is currently seeking a talented SQL Server SSIS Analyst for an exciting 6+ Month contract job with one of our best clients in Dallas.

About our client / About this position
With more than 500 locations across the US and Europe, our client is one of the fastest growing companies in outpatient surgical centers and urgent care facilities. They are currently seeking a SQL Server SSIS Analyst to join their Marketing Analytics team. Primary responsibilities will be to work with SQL Server SSIS to Extract, Transform and Load data from a variety of platforms into the SalesForce CRM platform. This role will require strong SSIS, Stored Procedures and a good background in Data Lineage & standardization.

Day to day responsibilities for this SQL Server SSIS Analyst will include:

  • Partnering closely with the Sales and Marketing teams in order to deliver custom analytics for marketing data
  • Extracting healthcare-related data from a variety of source platforms, including Cerner EHR and Call Center (Verint) Data, using SQL Server Integration Services (SSIS)
  • Extensively using SQL Server SSIS for data loads and transformations
  • Writing and maintaining SQL Stored procedures
  • Managing the lineage of source data
  • Assisting in standardizing data during the extraction and transformation processes
  • Monitoring the data loads from external platforms, and managing the downstream processing of all loaded data into Salesforce
  • Assisting in special ad-hoc analysis and questions submitted by the marketing team.
  • Reviewing all operational reports from Salesforce, identifying any anomalies and inconsistencies as it relates to the CRM data
  • Troubleshooting any CRM data related issues.
  • Developing custom SQL queries and SSIS Packages between Salesforce CRM and the SQL Servers
  • Evaluating CRM test plans and cases.

Required Experience & Technical Skills

  • Required Bachelor of Science Degree in Computer Science or a related MIS field
  • Minimum 5 years professional experience
  • Advanced hands-on experience in Microsoft SQL Server Integration Services (SSIS)
  • Advanced T-SQL Scripting (SQL Queries)
  • Advanced SQL Stored Procedures
  • Professional experience working with Microsoft CRM platforms (SalesForce, Dynamics, etc)
  • Experience working with Sales & Marketing departments preferred

Location: Downtown Dallas, TX
Position Type: 6-12 + Months / Contract to Hire
Pay Rate Range: $55 - $65 / hour W2

Additional Information:

As a W2-hourly employee of Medix, you will have the option to enroll in our talent benefits program. This includes several options for Medical, Dental, Vision and & Prescription Drug coverage. In addition, Medix offers an industry best-in-class 401K plan, with employer matching for up to 6% of eligible pay. There is also an accrued PTO / time off plan included at no extra cost.



Reference number: 85025

Job Snapshot

About Us

Medix provides workforce solutions to clients and creates opportunity for talent representing a variety of industries through our Healthcare, Scientific and Information Technology divisions. We have earned our reputation as an industry leader by providing unsurpassed customer service and top quality professionals to our clients.

At Medix we are extremely dedicated to our candidates, providing them with the best advice, support and direction during their job search. We work with all of our candidates personally to understand their skills and aspirations and best match them with opportunities that fit their goals. As we place contract, contract-to-hire and direct hire employment plans, we offer the flexibility to accommodate your schedule and needs.  We will also provide guidance and support during the interview process.  The benefits at Medix don’t stop there. After being employed for 30 days and averaging 30 hours per week for those 30 days, you become eligible for our benefit program.

Are you looking for a new job? Check out these current opportunities: Healthcare Jobs, Information Technology Jobs and Scientific Jobs