Senior Software Data Engineer (Contract)

About this role

Senior Software Data Engineer (Contract)

This role is Remote

We are more than just a healthcare company; we are a community of professionals driven by the knowledge that our success leads to a positive impact on the communities that we support.

At ComplexCare Solutions, you’ll play a crucial part in innovating solutions that empower health plan members and healthcare providers alike. Our collaborative environment fosters creativity and initiative, ensuring that every idea and effort contributes to meaningful change in the industry. Join us and become a part of a team that turns vision into action, making a tangible impact on the future of healthcare.

Duties and Responsibilities:

• Work with the agile team to participate in agile ceremonies like grooming, planning, standup, retrospective, demos.
• Actively contribute to grooming and standup, create & update tasks, estimate and status.
• Write complex queries, stored procedures, functions, SSIS Packages for various job execution.
• Work with data architects and business analysts to create a logical data model and create DDL scripts for physical model creation.
• Design and develop modern ETL framework utilizing tools like Azure DAtabricks, ADF (Azure Data Factory), MS-SSIS, etc.
• Design and develop ETL pipelines, using SQL, Stored procedures/functions/Notebooks to extract data from various sources and load into warehouse.
• Design STAR or SNOWFLAKE database schema utilizing industry best practices to build Datawarehouse, data marts, views, cubes and data sets/products.
• Design and code various data architecture components like data validation, cleansing, de-duping, Symantec layer etc.
• Design and develop data export frameworks to extract data from the warehouse, transform, pre-aggregate, perform calculations and load into various data marts for Analytics use.
• Design & develop configurable data export framework to extract data from Datawarehouse and data marts to generate reports for internal and ...