Job Description
IT is different here. Our work as technology specialists pushes the boundaries of what’s possible in health care. You will build solutions that make a real difference in people’s lives. Driven by the importance of their work, our team members innovate to elevate. We’re encouraged to be curious, collaborate, and turn ideas into solutions that can make health care better for all.The Sr Data Modeler designs, implements, and documents complex data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise data management, business intelligence, machine learning, data science, and other business interests.
If you are ready to make a career out of making a difference, then you are the person for this team.
What You Will Do
•Information Modeling: Creates fully attributed and documented conceptual, logical and physical models.
•Requirement Analysis: Analyzes data to verify business requirements and design the data models.
•Data Architecture: Participates in project specific architectural working groups to provide expertise in modeling. Provides inputs on the data management of data assets in all data stores and governs the storage of data in different layers of the data stores. Provides architectural inputs on the data consumption layers, access and security requirements. Documents data flows from its origination and acquisition points. Oversee and govern the expansion of existing data architecture.
•Standard Query Language: Generates first cut physical model DDL and SQL for views for implementation by the DBA.
•Documentation: Creates, validates, and updates the data dictionary by coordinating with data governance team and business users. Captures business rules for logical to physical mapping in the models. Works closely with the data governance team to define data classification, PHI/sensitive information, and enterprise reference data in Collibra and modeling tool.
•Standards & Process: Facilitates model review sessions. Creates, follows, and revises the data modeling standards and guidelines for different data stores.
•Leading and mentoring - Provide the expert knowledge to other data modelers, reviews work of other modelers to verify it meets enterprise standards and guidelines. Provides inputs on process improvements and maturing the data modeling practice.
What You Bring
• Bachelor's degree or advanced degree (where required)
• 5+ years of experience in related field.
• In lieu of degree, 7+ years of experience in related field.
Preferred Experience
Experience leading other data modelers in a successful full life-cycle enterprise data warehousing effort
Knowledge of Healthcare data
Experience in leading, instructing, directing, assigning and reviewing data modeling work
Exposure working on Data Vault Modeling and Snowflake platform.
Experience and exposure with HL7 FHIR (Fast Healthcare Interoperability Resources) profiles and resources in order to map enterprise data or source data to appropriate FHIR resources.
Working knowledge of ERStudio or similar data modeling tool
Working with JSON
Salary Range
At Blue Cross NC, we take great pride in a fair and equitable compensation package that reflects market-price and our starting salaries are typically planned near the middle of the range listed. Compensation decisions are driven by factors including experience and training, specialized skill sets, licensure and certifications and other business and organizational needs. Our base salary is part of a robust Total Rewards package that includes an Annual Incentive Bonus*, 401(k) with employer match, Paid Time Off (PTO), and competitive health benefits and wellness programs.
*Based on annual corporate goal achievement and individual performance.