Data Modeler III

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