Job Description :

The Principal Data Modeler is a highly technical person responsible for the definition, development, implementation, and maintenance of logical and physical data models focusing on Data Warehouse/Data Lake environments.  The Principal Data Modeler is hands on, performing data assessment and profiling, building models whether they are relational or dimensional and then implementing appropriate data structures into the database platform. The Principal Data Modeler writes specifications for the necessary data flow and any engineering transformation.   

This role serves as the lead for the Data Warehouse team and ensures new business requirements are decomposed and implemented in a cohesive end to end design that enables data integrity and quality and best supports BI and analytic capability needs. The Principal Data Modeler partners with ETL engineers, Database engineers, BI engineers, Quality Assurance, Product Owners, business analysts, architects, software engineers and others across teams to achieve project and business goals. 



Specific responsibilities for this role include:

  • Perform data warehouse design leadership, identifying the fit for purpose solutions
  • Perform advanced level data modeling techniques and guide others in best practices
  • Perform advanced data analysis and data profiling and mentor others as needed
  • Create and maintain data catalogue and metadata in order to support and communicate data assets to stakeholders 
  • Develop and maintain ETL specification documentation for data integration development
  • Document and decompose project needs into Agile epics and stories working with the Product Owner 
  • Create, manage and/or provide oversight on team estimates for technical work    
  • Diagnose and resolve complex issues throughout data warehouse environment – security, data issues
  • Drive continuous improvement of process, methods, technologies and services
  • Collaborate with software engineering and business teams to identify dependencies, data flows, assist with testing and overall cohesive of solutions in the environment   
  • Spearhead the development of enterprise standards and guidelines for data modelling and promote across peer group 



Basic Requirements:

  • Bachelor’s Degree in the field of computer science, management information systems, or computer engineering
  • 8 years of experience in a combination of data management and enterprise data warehouse data modeling and architecture roles
  • 8 years of experience in data modeling, meta-data modeling, database design, schema design and/or information architecture practices
  • Significant experience with hands on data analysis and related tools, including strong SQL
  • Proficiency with navigating Oracle DBMS, including schema builds   
  • Significant experience implementing enterprise data warehouse and BI solutions
  • Significant experience in data requirements gathering and facilitation of business data definitions
  • Demonstrated knowledge of ETL processing and proficiency with writing and delivering ETL design specifications
  • Experience leading others including ETL engineers, Data Modelers and other colleagues involved in overall solution dependencies, workflow and scheduling of data dependent jobs     
  • Demonstrated knowledge of data warehouse architectures and best practices 
  • Strong knowledge of master data, data quality and meta data management concepts and practices and the relation to data warehousing and business intelligence    
  • Demonstrated knowledge of BI capabilities and types of reporting


Preferred Qualifications:

  • Appropriate industry certifications, including CDMP or CBIP with a data management or data modeling specialization
  • Experience with related information management disciplines  (e.g. data quality management, metadata management, data governance)   
  • Experience with data engineering for Data lakes and Hadoop technologies
  • Experience with high volume data processing
  • Experience with health care data
  • Experience with data catalogues
  • Experience with Agile



Similar Jobs you may be interested in ..