Job Summary:

The Data Modeler III is responsible for leading efforts that involve working closely with the business to define, document, and apply business rules to enterprise data.

Essential Functions:

• Responsible for defining business data requirements and creating logical and physical data models
• Assist in the design and development of data standards, policies, procedures, and metadata to ensure accuracy, quality, integrity, and optimization of this data
• Develop enterprise data policies and standards and monitor adherence to these standards
• Guide, mentor, and instruct more junior staff members regarding enterprise data management practices
• Ensure the quality of data submitted to regulatory agencies by developing detailed metadata for submissions
• Design data models for reporting and analytic databases that translate business and regulatory rules and definitions into queryable data structures
• Perform analysis and research to inform end-to-end data warehouse & data integration capabilities
• Develop expertise on one or more insurer-specific data domains, such as claims, care management (CM), utilization management (UM), eligibility, accounting / finance, and population health
• Design data models for development of new transactional systems
• Design data models for development of a data warehouse and data marts
• Reverse engineer data models for existing databases and systems
• Work with data analysts to identify data issues within the organization and assist in the development plans to resolve data issues
• Develop and maintain detailed documentation that provides traceability for all enterprise data back to its source
• Actively participate in projects designed to create record of reference systems for key enterprise data
• Define and adhere to standard metadata naming conventions.
• Develop and maintain Enterprise Data Model
• Perform any other job duties as requested

Education and Experience:

• Bachelor’s Degree or equivalent years of relevant work experience required
• Minimum of eight (8) years of experience in data modeling (conceptual, logical and physical) required
• Minimum of three (3) years of experience with the administration of data and/or experience as a data architect preferred
• Experience in application database development and data warehouse development required
• Experience with Cloud hosted and Data Lakehouse solutions is preferred
• Advanced SQL and / or Python experience (including data modeling, profiling and cleansing, and building complex data sets) is required
• A minimum of two (2) years of healthcare experience is required
• Military affiliation or TRICARE experience is preferred.

Competencies, Knowledge and Skills:

• Expert knowledge of data normalization and de-normalization
• Expert knowledge of data mapping and data dictionaries
• Erwin data modeling software
• Proven ability creating complex data models with applied understanding data modeling and transformation techniques
• Relational & Dimensional database modeling concepts and practices
• Proven ability to write complex SQL queries and/or python code
• Experience with Azure Databricks, SparkSQL, and Azure Data Factory
• Proficient working with transforming and warehousing data from multiple sources, such as operational data stores (ODS), flat file, EDI/HL7, API, etc.
• Communication skills both written and verbal
• Ability to work independently and within a team environment
• Critical listening and thinking skills
• Decision making/problem solving skills
• Excellent customer service skills

Licensure and Certification:

• None

Working Conditions:

• General office environment; may be required to sit or stand for extended periods of time

Compensation Range:

CareSource takes into consideration a combination of a candidate’s education, training, and experience as well as the position’s scope and complexity, the discretion and latitude required for the role, and other external and internal data when establishing a salary level. In addition to base compensation, you may qualify for a bonus tied to company and individual performance. We are highly invested in every employee’s total well-being and offer a substantial and comprehensive total rewards package.

Compensation Type (hourly/salary):

Organization Level Competencies

• Fostering a Collaborative Workplace Culture

• Cultivate Partnerships

• Develop Self and Others

• Drive Execution

• Influence Others

• Pursue Personal Excellence

• Understand the Business

This job description is not all inclusive. CareSource reserves the right to amend this job description at any time. CareSource is an Equal Opportunity Employer. We are dedicated to fostering an environment of belonging that welcomes and supports individuals of all backgrounds.