The Role
Analyzes and reverse engineers data sources, models relationships, identifies data quality issues, and performs root cause and distribution analysis. Designs future-state data strategies, target data models, change-data-capture and audit approaches, reference and mapping tables, and configurable ETL solutions. Collaborates with clinicians, researchers, data scientists, IT professionals, and other stakeholders to translate business needs into reliable, scalable data solutions.
Summary Generated by Built In
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 data-driven decision-making
- Collaborate with cross-functional teams to develop and implement data models and solutions that meet business objectives
Skills Required
- Advanced SQL skills
- Familiarity with database technologies such as Oracle and SQL Server
- Experience with AWS
- Experience with Databricks
- Experience with ETL
- Ability to analyze complex datasets and pursue detailed understanding
- Stakeholder engagement and requirements gathering
- Ability to communicate technical concepts clearly to stakeholders
- Experience leading deep data analysis initiatives
- Experience collaborating cross-functionally to develop data models and solutions
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Cynosure Corporate Solutions is a human capital services company focused on helping clients align their people strategy with business goals. Its offerings include executive search, recruitment, training, temporary staffing, statutory compliance, and other HR-aligned services. The company says it works to understand client objectives and connect human-resource planning with those objectives, supporting organizations’ workforce needs through tailored talent and employment solutions.
.jpg)
