Data Warehouse Developer

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