Position Details: Data Architect / Solution Architect (JOB CODE - 228)

Description:

Role: Sr.Data Modeler cum Data Architect

Analyzing existing data sources

• Expert understanding of data models and various 1 to many, many to many and other patterns, normalization and denormalization patterns and purposes
• Profile data sources to reverse engineer data model and relationships between tables, identify key fields, and infer meaning of attributes
• Meet with system owners to tie observations of data patterns with business processes and use cases that lead to those patterns
• Conduct root cause analysis (RCA) to identify underlying issues and drive effective solutions.
• Perform frequency distribution analysis to identify patterns and trends in the data.

Architecting data strategy for Future State

• Profile the data sources to identify anomalies, inconsistencies, and data quality issues.
• Take ownership of the data, ensuring accuracy, completeness, and reliability.
• Develop target data model that provides optimal long term functional opportunities
• Design the right change data capture, audit strategy
• Identify where reference tables are necessary
• Design mapping tables / helper tables to support configurable ETL

General Attributes

• Advanced sql skills, familiarity with a variety of DB technologies (orable, sql server, etc)
• Comfortable with AWS environment and databricks
• Experience with ETL
• Demonstrate curiosity and a relentless pursuit of understanding complex datasets.
• Engage with various stakeholders, including clinicians, researchers, data scientists, and IT professionals, to gather requirements and ensure alignment.
• Communicate effectively with stakeholders at all levels, translating technical concepts into clear and actionable insights.
• Lead deep data analysis initiatives to extract meaningful insights and drive data-driven decision-making.
• Collaborate with cross-functional teams to develop and implement data models and solutions that meet business objectives.

Perform an action: