View Our Website View All Jobs

Data Warehouse Developer

Data Warehouse Developers build Data Mart and Data Warehouse solutions that support fast, accurate, and meaningful data insight. You are the go-to expert on scalable and reliable DW/DM architecture, database performance and tuning, and relevant healthcare data requirements.  

Open to 100% Remote candidates

Our Tech Stack 

Microsoft SQL Server 2019, SSIS, T-SQL, Visual Studio 2019, Python, Git, DbSchema, JIRA, Octopus Deploy, Tableau 

 

What You'll Do 

You will have broad responsibility for CoverMyMeds’ data warehousing initiatives. On any day, you might: 

  • Develop and maintain T-SQL stored procedures. 

  • Performance-tune problem queries and aid analysts in optimization through techniques such as reading execution plans, adding indexes, or re-architecting poorly designed queries. 

  • Perform ETL from disparate systems into data marts and analytics models 

  • Work with our product owner, business analyst, and/or stakeholders from our analytics teams to define requirements for development 

  • Deliver data products using agile methodologies 

  • Re-model or re-architect legacy solutions so that they are more suited for the current (ex: Tableau) or future tech stack (ex: Azure cloud environment) 

 

About You 

  • Four-year degree or equivalent experience 

  • Multiple years of experience in a related technical field, ideally inclusive of database development, data analysis and data architecture 

  • A strong understanding of relational architectures and tools. Practical experience using SQL. Diverse experience with other relational database or NoSQL databases is a plus. 

  • 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 (Star Schemas) and techniques is a plus 

  • Basic ETL background using technologies such as SSIS (SQL Server Integration Services), Pentaho Data Integration, Informatica, command line, Python or other technologies 

  • Strong understanding of RDBMS normalization and denormalization concepts 

  • Proficient in performance troubleshooting, indexing, SQL optimization, and benchmarking 

  • 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 

  • Fluency in reading and interpreting data models 

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

Required*
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.
Gender
Race/Ethnicity

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
I IDENTIFY AS ONE OR MORE OF THE CLASSIFICATIONS OF PROTECTED VETERAN LISTED ABOVE
I AM NOT A PROTECTED VETERAN
I DON’T WISH TO ANSWER

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 www.dol.gov/ofccp.

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