Data Solution Architect
Data Solution Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Responsibilities
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
Requirements:
General Attributes
Advanced SQL skills, familiarity with a variety of DB technologies (oracle, SQL server, etc)
Comfortable with AWS environment and data bricks
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
Employment Type
Full-time
