[Remote] REMOTE - Data Modeler III - R10204

Note:The job is a remote job and is open to candidates in USA. CareSource is a company focused on enterprise data management, and they are seeking a Data Modeler III to lead efforts in defining and applying business rules to enterprise data. The role involves creating data models, developing data standards, and mentoring junior staff while ensuring data quality and compliance with regulatory requirements. Responsibilities• 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 requestedSkills• 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• Experience in application database development and data warehouse development required• 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• Expert knowledge of data normalization and de-normalization• Expert knowledge of data mapping and data dictionaries• 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• 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• Minimum of three (3) years of experience with the administration of data and/or experience as a data architect preferred• Experience with Cloud hosted and Data Lakehouse solutions is preferred• Military affiliation or TRICARE experience is preferred• Experience with Azure Databricks, SparkSQL, and Azure Data FactoryBenefits• You may qualify for a bonus tied to company and individual performance.• A substantial and comprehensive total rewards package. Company Overview• CareSource provides managed care services to Medicaid beneficiaries. It was founded in 1989, and is headquartered in Dayton, Ohio, USA, with a workforce of 1001-5000 employees. Its website isCompany H1B Sponsorship• CareSource has a track record of offering H1B sponsorships, with 9 in 2025, 39 in 2024, 35 in 2023, 22 in 2022, 37 in 2021, 28 in 2020. Please note that this does not guarantee sponsorship for this specific role.Apply tot his job