Live Chat

Data Warehouse Developer Job in Columbus, Ohio US

Data Warehouse Developer

McKesson Corporation - Columbus, OH

Posted: 7/30/2021 - Expires: 10/28/2021

Job ID: 230052824


Job Description

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 "" by Glassdoor, a "" by FORTUNE, and our employees, 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.

McKesson is an equal opportunity and affirmative action employer - minorities/females/veterans/persons with disabilities.

Job Summary

Employment Type:
Full Time Employee
Job type:
Federal Contractor
Skill Based Partner:
Education Level:
Bachelor's degree
Work Days:
Mon, Tue, Wed, Thu, Fri
Job Reference Code
Licenses / Certifications:
Display Recommended WorkKeys®Recommended WorkKeys®: