Data / Solution Architect

Cynosure Corporate Solutions; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Cynosure Corporate Solutions in Chennai is seeking a senior data engineer to architect data models, profile sources, and own data quality across environments.

You will lead ETL design, implement change data capture, and collaborate with clinicians, researchers, data scientists, and IT teams to deliver trusted analytics and insights.

Strong SQL, DB tech experience (Oracle/SQL Server), plus AWS and Databricks expertise are required to translate business needs into scalable data solutions.

Qualifications

• Advanced SQL skills and experience with multiple DB techs.
• Experience in ETL, data modeling, and data profiling.
• Ability to translate business needs into data solutions and communicate with stakeholders.

Responsibilities

• Conduct root cause analysis to identify underlying issues and drive solutions.
• Perform frequency distribution analysis to identify patterns in the data.
• Architect target data models providing long-term functional opportunities.
• Design change data capture and audit strategies for data lineage.
• Identify reference tables and design mapping/helper tables for configurable ETL.
• Take ownership of data quality, ensuring accuracy and reliability.
• Collaborate with cross-functional teams to meet business objectives.

Skills

Advanced SQL

DB Technologies

ETL Experience

Data Analysis

Stakeholder Communication

Cross-functional Collaboration

Data Quality & Profiling

Problem Solving

Tools

AWS

Databricks

Oracle

SQL Server

Job description

Cynosure Corporate Solutions | Full time

Cynosure Corporate Solutions is a human capital services company. Our focus is to provide Executive Search, Recruitment, Training, Temporary Staffing services, Statutory Compliance's, and other HR aligned services. We understand the business goals of our clients and their need to align human resources to these goals. We are committed to provide high quality manpower in accordance to global standards and their requirements. Our candidates stand testimony to our professional competency.

We work with clients in IT/ITES, Manufacturing, Automobile, Health, Telecom, Media.

Job Description

• 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 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