View Our Website View All Jobs

SSIS Developer (Data Integration Engineer)

CoverMyMeds is looking for a SSIS Developer to establish scalable, reliable, data movement and integration processes across our analytics environment. This person will work with data analysts, software developers, ETL/database developers, and DBAs/system administrators to create repeatable, scalable solutions that bring efficiency and standardization to our data environment. This person will work cross-functionally to solve a variety of data movement and integration challenges using a variety of tools.

Our Tech Stack

Microsoft SQL Server 2016, SSIS, T-SQL, Python, Git, DbSchema, Azure, Tableau, SSRS, PostgreSQL, Terraform, JIRA, Confluence, UNIX, PowerShell

What You’ll Do

As a SSIS Developer/Data Integration Engineer, you will have broad responsibility for CoverMyMeds’ data warehousing, operational reporting, and analytics initiatives, including but not limited to:

  • Design and execute key framework components to support our analytical infrastructure including but not limited to:
    • Database tooling (creation, deployments, monitoring, automation)
  • Design new and enhance existing repeatable data movement and integration processes
  • Establish a library of resources for different types of data integration/data movement
  • Establish deployment patterns and packaging to enable power users to self-serve data movement and transformation
  • Partner with product and analytics teams during design phases to create effective integration solutions
  • Work with the Data Solutions leadership team to build out an extensible data tiering and access strategy to support the rapid development and implementation of purpose-built data stores
  • Implement and improve scripts that support the monitoring, management, and execution of ETL processes, server and cloud maintenance
  • Design and implement technical controls to measure and maintain data quality
  • Ensure that we have the tools and processes need to meet SLAs and uptime requirements
  • Deliver solutions and products as part of an agile team using agile methodologies
  • Document everything important you do with our data

About You

  • 3-5+ years of experience in a related technical field, ideally inclusive of database administration, database development, data analysis or data architecture.
  • Understanding of RDBMS normalization and denormalization concepts
  • Strong ETL background using technologies such as DTS, SSIS (SQL Server Integration Services), shell scripting, Python or .net/Java
  • Around 2 years of relevant software development experience 
  • Proficient in performance troubleshooting, indexing, SQL optimization, and benchmarking.
  • Fluency in reading and interpreting data models and T-SQL.
  • Mastery of T-SQL, PL/SQL equivalent development.
  • Expertise in high volume, transactional environments with third party business system integrations
  • Understanding of data warehousing concepts and techniques is a plus.
  • Self-motivated with the ability to thrive in a highly creative, collaborative, and dynamic environment.
  • Experience with agile development techniques is a plus.
  • Experience working in the healthcare industry with healthcare data is a plus.

Our company culture is a collection of the unique individuals who represent our mission and values. We are looking for people who are motivated to take on challenges and have a passion for helping others. If you don’t feel you check every box, but have relevant skills that can impact this role, please apply! We can grow together.

About Us

CoverMyMeds, part of McKesson’s Prescription Technology Solutions, is a fast-growing healthcare technology company. Our mission: Help patients get the medications they need to live healthy lives. Our solutions seamlessly connect the health care network to improve medication access, increasing speed to therapy and reducing prescription abandonment for patients like you and me.

We hire ambitious people and make it a priority to invest in them by providing opportunities to grow their careers and connections within the community. On-site culinary team, flexible hours and paid benefits? Yeah, we have those too. But don’t take our word for it. We’ve been recognized as a “Best Place to Work” by Glassdoor, a “Best Company to Work For” by FORTUNE, and our employees have great things to say, too.

CoverMyMeds is an equal opportunity and affirmative action employer. We embrace diversity and are committed to creating an inclusive environment for all employees. Qualified applicants will be considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, disability or veteran status.

Read More

Apply for this position

Apply with
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.

Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status

Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 5/31/2023
Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition. Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson's disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Your Name Today's Date