Senior Data Modeler

Diverse Lynx LLC
Pleasanton, CA, United States
2 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Compensation
$124,800 - $135,200
Working hours
Regular working hours

Tech stack

Data Analysis Microsoft Azure Databases Data Architecture Data Dictionary Data Infrastructure Extract Transform Load (ETL) Data Profiling Dataspaces Data Warehousing Dimensional Modeling Python (Programming Language)
+10 more
Migration Manager Standard Sql SQL Databases Virtual Machines Azure Data Factory Data Lakes Pyspark Azure Synapse Analytics Alteryx Databricks

Job description

Seeking an experienced Data Modeler / Data Architect with strong healthcare domain knowledge and expertise in data modeling, SQL, and modern data platforms. The role involves assessing legacy data ecosystems, designing scalable data architectures, and migrating legacy ETL and Alteryx workflows to Azure Databricks., * Assess existing databases, data models, ETL pipelines, Alteryx workflows, and reporting dependencies.

  • Design conceptual, logical, physical, and dimensional data models.
  • Develop target architectures using Azure Databricks, Delta Lake, and medallion architecture.
  • Create source-to-target mappings, data dictionaries, lineage documentation, and migration roadmaps.
  • Convert legacy data workflows into scalable solutions using SQL, Python, PySpark, and Databricks.
  • Perform data profiling, reconciliation, validation, and quality checks.
  • Collaborate with healthcare business stakeholders, data engineers, and analytics teams.
  • Lead technical workshops, proof of concepts, migration planning, and implementation activities.

Requirements

Data Modeling, DataArchitect Data Modeling Tool, Data Modeling, Healthcare, Revenue Analysis, VMS Operating System, Virtual Machine (VM), Database Extract Transform and Load (ETL), Microsoft Windows Azure, Ecosystems, * 10+ years of experience in data modeling and data architecture.

  • Strong SQL and hands-on data modeling experience.
  • Experience with ERwin, ER/Studio, or similar tools.
  • Healthcare domain knowledge, preferably Revenue Cycle Analytics.
  • Azure Databricks, PySpark, Python, and Delta Lake.
  • Experience with Azure Data Factory and Azure Synapse Analytics.
  • ETL migration, Alteryx workflows, data warehousing, and dimensional modeling.
  • Strong stakeholder communication and technical documentation skills.

About the company

Security Notice: Our official website is www.diverselynx.com We do not operate or authorize any other websites representing Diverse Lynx LLC.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…