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)
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.
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.