Sr. Analytics Engineer, Healthcare Claims Data Platform (Only W2 or Selfcorp)

Job Title: Sr. Analytics Engineer, Healthcare Claims Data Platform (Only W2 or Selfcorp) Location: Remote Position Type: Contract Top Required Skills: 1. Healthcare Data Experience (payer or claims data, membership data transformation) 1. Expert SQL & DBT (modular, tested, production-grade pipelines) 1. Strong Data Modeling (dimensional modeling, semantic layer design, standardized metrics) 1. Cloud Data Warehouse (Snowflake, BigQuery, Redshift) Job Description: What They are Looking for: • Requires strong data experience. - Must understand and work with data. Not concerned about scale. • Primary responsibility is to understand and model data for end-user use cases. • Must Have - Healthcare experience • Must be able to take raw membership data, talk to stakeholders (like a BI person), and create a data model that transforms the raw data into a usable format for the end user. • Will use tools set up by the Data Engineers; must figure out how to use those tools and apply them to specific use cases. • Soft Skills: • Can act as a consultant for multiple non-technical stakeholders. • Able to get a sense of requirements and come up with solutions. • Experience working with stakeholders like Actuaries, Business Analysts, and C-Suite teams. About the Role: We’re looking for a Senior Analytics Engineer who brings deep expertise in data modeling, transformation design, and analytics-focused engineering. In this role, you’ll build and optimize the semantic and transformation layers that power analytics across the organization. You’ll architect dbt models, implement data quality frameworks, standardize metrics, and improve the discoverability and reliability of our analytics ecosystem. You’ll partner closely with data engineers, analysts, product, and platform teams to elevate how the company uses and trusts data. Key Responsibilities • Build and optimize dbt models, dimensional structures, and semantic layers. • Develop high-quality SQL transformations and reusable analytics datasets. • Implement data tests, validation frameworks, and lineage visibility. • Collaborate with data engineers and analysts to productionize pipelines. • Document models, metrics, and business logic for cross-team use. Qualifications Required: • 5+ years of experience in analytics engineering, BI engineering, or data engineering working with AWS. • 3+ years of experience in healthcare particularly demonstrated experience with processing healthcare data • Expert SQL and production-grade dbt experience (core or Cloud) for building modular, tested, and scalable transformation pipelines. • Strong data modeling skills including dimensional modeling, semantic layer design, and standardized metric definitions. • Hands-on experience with a major cloud data warehouse (Snowflake, BigQuery, Redshift, etc.) and understanding of performance optimization. • Familiarity with orchestration tools (Airflow, Dagster, Prefect) for scheduling and operationalizing data transformations. • Solid engineering fundamentals including Git, CI/CD pipelines, testing, and documentation in a modern software development workflow. • Proven cross-functional collaboration with analysts, data engineers, and product teams to translate business needs into scalable data models. Preferred/Nice to have: • Experience building internal developer platforms or data portals • Exposure to Kafka, catalogs, or lineage tools • Experience with Tableau If you believe you are qualified for this position and are currently in the job market or interested in making a change, please email me the resume along with contact details at roshni@nytpcorp.com