Lead Data Engineer / Architect Data Engineer || USC/GC || Local to PST preferred

[Suryangi]

The client is currently using a lift-and-shift approach for their data, but they need to move away from this strategy. They require someone who can take ownership of the architecture, provide guidance on the overall implementation, and then actively roll up their sleeves to execute.

Their current stack includes Databricks, C-Data, and SSIS for ETL and integration, with data coming from TriZetto Facets (membership, clinical, financial, Medicaid/Medicare data).

Additionally, they have extensive Tableau reporting but need to remodel reports for Power BI and move data pipelines into Snowflake. This is not a lift-and-shift project—the data and reporting ecosystem needs to be re-architected for Power BI and Snowflake rather than simply migrated as-is.

 

Candidates must answer these questions in DETAIL- WHERE/WHEN/HOW

·  "Can you describe a project where you transitioned a system from a lift-and-shift approach to a redesigned architecture, and what specific steps you took to modernize the data pipelines?"

·  "How have you implemented or planned Snowflake in a production environment, particularly for healthcare or membership/clinical/financial data?"

·  "What is your experience with re-architecting Tableau reports to Power BI, and how did you handle data modeling changes in the process?"

·  "Can you walk us through how you’ve integrated tools like Databricks, C-Data, and SSIS to consolidate, transform, and deliver data for analytics?"

·  "How do you approach large-scale data remodeling for complex sources like TriZetto Facets, including membership, clinical, and financial datasets, while ensuring data quality and minimal disruption?"

Lead Data Engineer / Data Platform Lead (Snowflake + Power BI)

USC/GC

Remote 

Required Qualifications

• 8–12+ years in data engineering / data platform roles
• Strong hands-on expertise with Snowflake (architecture, performance tuning, data modeling)
• Experience with Power BI (semantic models, reporting, governance)
• Proven experience leading or mentoring teams (formal or informal)
• Experience modernizing or scaling a data platform, including transitioning from lift-and-shift approaches
• Experience integrating Databricks, C-Data, SSIS, and other ETL tools into a modern data stack
• Exposure to healthcare or financial data sources (TriZetto Facets, membership, clinical, financial, Medicaid/Medicare)

Email: sury...@rconsultinginc.com