Qureos Mentor

Ignitho Technologies

Role: Data ArchitectJob SummaryThe Data Architect will lead the design and implementation of scalable, high-performance data architectures across both on-premise and cloud environments. This role involves advanced data modeling, SQL development, and ETL design, with a strong focus on data quality, integrity, and strategy. The architect will collaborate closely with cross-functional teams to align technical solutions with business needs, perform in-depth data analysis, and drive the development of robust data models that support long-term organizational goals.Core Competencies<ul><li>Data Architecture &amp; Strategy</li><li>Advanced Data Modeling (Star, Snowflake)</li><li>SQL Development (Partitioning, Stored Procedures, Recursive Queries)</li><li>Data Profiling &amp; Root Cause Analysis</li><li>ETL Design &amp; Implementation</li><li>Cloud &amp; On-Premise Data Platforms (Oracle, Databricks)</li><li>Data Quality &amp; Governance</li><li>Stakeholder Engagement</li><li>Change Data Capture &amp; Audit Strategy</li><li>Cross-Functional Collaboration</li></ul>Roles and Responsibilities<ul><li>Analyze existing data sources to understand data flow, relationships, and usage.</li><li>Design and implement scalable data models following best practices in normalization, denormalization, and dimensional modeling.</li><li>Develop and optimize complex SQL queries, including recursive SQLs and macros, to extract, transform, and analyze data.</li><li>Architect end-to-end data strategies aligned with future-state objectives, focusing on performance, scalability, and flexibility.</li><li>Reverse engineer data models through data profiling, identifying key attributes and relationships.</li><li>Collaborate with business and technical stakeholders to map data patterns to underlying processes and use cases.</li><li>Conduct root cause analysis (RCA) to troubleshoot data inconsistencies and propose effective resolutions.</li><li>Perform frequency distribution and statistical analyses to detect data trends and quality issues.</li><li>Design and implement change data capture (CDC), audit logging, and reference data strategies.</li><li>Define and create mapping tables and helper tables to support flexible and configurable ETL processes.</li><li>Own and ensure data integrity, accuracy, and completeness across platforms.</li></ul>General Attributes<ul><li>Demonstrates intellectual curiosity and passion for uncovering insights in complex datasets.</li><li>Skilled communicator capable of translating technical concepts into actionable insights for diverse stakeholders.</li><li>Engages effectively with clinicians, researchers, data scientists, and IT teams to gather requirements and align objectives.</li><li>Leads deep-dive data analysis initiatives to support data-driven decision-making.</li><li>Collaborates across departments to deliver robust, business-aligned data models and solutions.</li></ul>Preferred Skills<ul><li>Familiarity with data visualization tools (e.g., Tableau, Power BI) is an advantage.</li><li>Experience in the Life Sciences or Pharmaceutical industry is highly desirable.</li></ul>Job Types: Full-time, PermanentPay: &#8377;1,000,000.00 - &#8377;2,500,000.00 per yearBenefits:<ul><li>Flexible schedule</li><li>Health insurance</li><li>Life insurance</li><li>Provident Fund</li><li>Work from home</li></ul>Work Location: In person

Data Architect

Join Ignitho Technologies and explore 1   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

Ignitho Technologies

ABOUT_COMPANY

Data Architect