Data Solution Architect
Data Solution Architect
Posted on :
01-02-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
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
Requirements:
- General Attributes
- Advanced sql skills familiarity with a variety of DB technologies (oracle 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 datadriven decisionmaking
- Collaborate with crossfunctional teams to develop and implement data models and solutions that meet business objectives
Advanced SQL, Database Technologies,Oracle, SQL Server, AWS , Databricks, ETL (Extract, Transform, Load), Data Analysis, Stakeholder Engagement, Data Modeling
Education
Bachelor s degree
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
