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:
$92,300.00 - $161,600.00CareSource 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):
SalaryOrganization Level Competencies
Fostering a Collaborative Workplace Culture
Cultivate Partnerships
Develop Self and Others
Drive Execution
Influence Others
Pursue Personal Excellence
Understand the Business
Top Skills
What We Do
Health Care with Heart. It is more than a tagline; it’s how we do business. CareSource has been providing life-changing health care to people and communities for nearly 30 years and we will continue to be a transformative force in the industry by placing people over profits.
CareSource is and will always be members first. Even as we grow, we remember the reason we are here – to make a difference in our members’ lives by improving their health and well-being. Today, CareSource offers a lifetime of health coverage to nearly 2 million members through plan offerings including Marketplace, Medicare Advantage and Medicaid. With our team of 4,000 employees located across the country, we continue to clear a path to better life for our members. Visit the "Life" section to see how we are living our mission in the states we serve.
CareSource is an equal opportunity employer and gives consideration for employment to qualified applicants without regard to race, color, religion, sex, age, national origin, disability, sexual orientation, gender identity, genetic information, protected veteran status or any other characteristic protected by applicable federal, state or local law. If you’d like more information about your EEO rights as an applicant under the law, please click here: https://www.eeoc.gov/employers/upload/poster_screen_reader_optimized.pdf and here: https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf
Si usted o alguien a quien ayuda tienen preguntas sobre CareSource, tiene derecho a recibir esta información y ayuda en su propio idioma sin costo. Para hablar con un intérprete, Por favor, llame al número de Servicios para Afiliados que figura en su tarjeta de identificación.
如果您或者您在帮助的人对 CareSource 存有疑问，您有权 免费获得以您的语言提供的帮助和信息。 如果您需要与一 位翻译交谈，请拨打您的会员 ID 卡上的会员服务电话号码
