Subscribe:   RSS  RSS   Mail Alerts  Mail Alerts  

Senior Data Modeler - Data Warehouse

Job Category:
Technology Provider
Career Level:
Mid Career (2+ years of experience)
Job Type:
Full Time/Permanent
Company Name:

Company Overview:

Surescripts was founded in 2001 when the pharmacy industry and other collaborators set out to replace paper prescriptions with electronic. Today, we’re the nation’s largest healthcare information network, connecting pharmacies, care providers, benefit managers and technology partners to get the right information to the right place at the right time. We offer industry-leading solutions that digitize manual workflows and use our unparalleled breadth of data to vastly improve healthcare connectivity, patient safety and provider efficiency.


What You’re Like

You have a relentless desire to get stuff done. A true champion of the collective objective, you’re energized by applying your expertise with a group of talented people to achieve something important, together. You’re curious and passionate about new technologies and cutting-edge innovation, and you enjoy pulling together complex pieces of a puzzle to deliver a powerful and meaningful end-product. You’re a translator between people and teams that don’t use the same lingo. You don’t settle for short-term gratification—you’re into long-haul, incremental efforts that require endurance, patience and next-level collaboration.


What We’re Like Surescripts Network Technology and Operations (NT&O) is comprised of smart people who love to work towards a common goal, always delivering and operating innovative, industry-leading solutions to the healthcare marketplace. We pride ourselves on quality work that’s grounded in complete transparency and accountability. When a project goes off the rails—and they do from time to time—we rally around each other to fix it and move on. While our gratification is often the result of a months-long effort, we never tire of delivering a huge result that has an exponentially positive impact on the healthcare system—whether it’s quality, cost or patient safety.


Ok, But Here’s What It’s Really Like

Working at Surescripts NT&O, your thinking cap will always be on. You’ll be challenged by making sure that disparate, cross-functional pieces come together to create a desired result. You’ll work to quickly understand diverse technologies, and establish and maintain relationships with groups who see and talk about things differently. And best of all, you’ll work on solving problems and creating solutions that will make a difference and improve healthcare on a national scale.



The Sr. Data Modeler – Data Warehouse is responsible for defining, developing, and maintaining the data models pertaining to the enterprise data warehouse architecture and its implementation. The Sr. Data Architect – Data Warehouse specializes in the data aspects of architecture and will provide value in the development and delivery of models and meta data to support the data warehouse and business intelligence environment of the enterprise. 

The Sr. Data Architect – Data Warehouse serves as a liaison with IT and Business concerning data warehouse architecture issues for business intelligence systems, and interacts with other members of architecture and teams to facilitate the assessment and continuous improvement of the enterprise data and information resources across the organization.


  • Perform data analysis and data modeling (subject area, logical, physical) for data warehouse and BI solutions
  • Collaborate with development and business teams to understand requirements and define source system data flows 
  • Develop and maintain ETL specifications for data integration development
  • Define and deliver consistent data modeling and data architecture standards, methodologies, guidelines and techniques 
  • Document, implement and maintain the data warehouse data architecture and related business processes 
  • Serve as source of knowledge of data warehouse data architecture industry practices and processes.
  • Participate in the development of enterprise standards and guidelines for data model quality and accuracy to support information management
  • Audit project level data model quality deliverables to ensure that practices and standards are met 
  • Ensure data integrity, consolidation, consistency and meta data development in conjunction with data architecture and information architecture professionals
  • Analyze information and data requirements and understand effects of data inconsistencies 
  • Participate in the development of enterprise data model and data architecture strategy for the organization
  • Define and follow best engineering practices to develop, test and automatically deploy database objects to all environments
  • Identify inefficiencies in current architecture and processes and communicate solutions in a manner that gets support from the teams involved
  • Diagnose and resolve issues throughout data warehouse environment – security, data issues
  • Perform cost and sizing estimates for projects 
  • Collaborate with the product owner and the rest of the agile team to identify epics, stories and estimate effort 
  • Create and maintain data dictionary documents, table and data lineage models and produce artifacts to support project development and communicate project information to customers




  • Bachelor’s Degree in the field of computer science, information systems, or computer engineering and/or 8+ years of equivalent work experience
  • 5 + years of experience in a combination of data management and enterprise data warehouse data modeling and architecture roles 
  • 5 +  years of experience data modeling – logical, physical, relational and dimensional with a major data modeling tool suite 
  • Significant experience with hands on data analysis and related tools, including strong SQL 
  • Working technical knowledge of Oracle DBMS
  • Experience with implementing enterprise data warehouse and BI programs and solutions
  • Experience with meta data management development and implementation, including business definition development and refinement, documentation and storage 
  • Significant experience in data requirements gathering and analysis
  • Understanding of enterprise data management concepts and best practices 


  • Appropriate industry certifications, including CDMP or CBIP with a data management or data modeling specialization 
  • Experience with related information management techniques (e.g. data quality management, metadata management, data governance)   
  • Experience with big data and Hadoop   
  • Experience with Data Stage or other ETL tools 
  • Familiarity with BI tools including Tableau, Microsoft SSRS 
  • Good knowledge of applicable data privacy practices and laws 
  • Experience with database design applications, including SQL Developer, Visual Studio, ERStudio Data Architect, Visio and others