Data Transformation ETL Specialist

Our mission is to transform complex, raw medical data into a standardized, usable ETL data model that powers advanced analytics and drives clinical scoring. We are seeking a highly analytical and business-minded Data Transformation & Reporting Analyst to lead the transformation and final quality assessment of incoming data, ensuring it aligns perfectly with our standardized model. This role is crucial for maximizing the accuracy of our scoring engines, directly enhancing data quality, and contributing to significant revenue growth.

• Data Model & Transformation Leadership:
  Lead the analysis and creation of source-to-target data mappings for new and existing raw data feeds, with a heavy emphasis on complex medical claims.
• Continuous Improvement:
  Proactively analyze raw data to identify inconsistencies and gaps in current transformation logic. Design and recommend improvements to mapping rules that enhance the robustness and completeness of the data model.
• Data Validation:
  Design and execute robust data quality checks and acceptance testing on the transformed data, ensuring high integrity and clinical/business logic alignment before final loading.

• Business Reporting:
  Develop, maintain, and execute complex ad-hoc queries and standard reports for internal business teams (e.g., Operations, Customer Success) related to data collection, usage, and quality metrics.
• Business Acumen & Translation:
  Serve as the functional expert on the standardized data model, translating complex clinical and operational questions from non-technical stakeholders into efficient data queries and consumable insights.
• Documentation & Governance:
  Develop and maintain consumer-facing documentation for the standardized model, including data dictionaries and business definitions, to drive correct interpretation and use across the organization.

• Experience:
  
  3+ years of experience in data analysis, ETL development, or reporting, specifically within the healthcare, payer, or provider domains.
• Technical Expertise:
  Expert proficiency in SQL for data analysis, complex querying, and validation.
• Industry Knowledge:
  Working knowledge of medical claims data structures, terminology, and workflows (e.g., experience with claims, utilization data, eligibility).
• ETL/Data Warehousing:
  Proven understanding of ETL/ELT processes and data warehousing concepts.
• Reporting Tools:
  Experience creating professional dashboards and reports using BI platforms (e.g., Tableau, Power BI).
• Soft Skills:
  
  Excellent verbal and written communication skills with a proven ability to bridge the gap between technical data and business objectives.