Data Analyst

Job Title: Data Analyst

Purpose of the Position:

This position involves performing feasibility and impact assessments, reviewing documentation to ensure conformity to methods, designs, and standards, and achieving economies of scale during the support phase. As a senior Business Analyst, you will also be responsible for stakeholder communication, conducting primary and secondary research based on solution and project needs, supporting new solution design and other organizational initiatives, and collaborating with all stakeholders in a multi-disciplinary team environment to build consensus on various data and analytics projects.

Work Location: Pune/ Nagpur/ Chennai/ Bangalore

Type of Employment: Full time

Key Result Areas and Activities:

1. Data Analysis and Orchestration: Analyze data from various sources, create logical mappings using standard data dictionaries/business logic, and build SQL scripts to orchestrate data from source (Redshift) to target (Treasure Data - CDP).
2. Stakeholder Engagement and Requirement Gathering: Engage with stakeholders to gather business requirements, particularly for data integration projects, ensuring clear communication and understanding.
3. Communication and Team Collaboration: Demonstrate excellent communication skills and strong teamwork, contributing effectively to the team’s success.
4. Stakeholder Management: Manage relationships with stakeholders across different levels, departments, and geographical locations, ensuring effective liaison and coordination.
5. Data Modelling and ETL Processes: Utilize excellent data modelling skills (including RDBMS concepts, normalization, dimensional modelling, star/snowflake schema) and possess sound knowledge of ETL/data warehousing processes and data orchestration.

Must Have:

• Well versed/expert with Data Analysis using SQL.
• Experienced in building data orchestration SQL queries.
• Experience in working with business process & data engineering teams to understand & build Business logic, Data mapping as per the business logic, Building SQL orchestration scripts on top of logical data mapping.
• Ability to review systems and map business processes.
• Process and Data modelling.

Good To Have:

• Experience with Business and data analysis in Pharmaceutical/Biotech Industry.
• Excellent Data Modelling skills (RDBMS concepts, Normalisation, dimensional modelling, star/snowflake schema etc).
• Hands on knowledge with data querying, data analysis, data mining, reporting and analytics will be a plus.

Qualifications:

• 3+ years of experience as core Data Analyst or Business Analyst focused on data integration/orchestration.
• Bachelor’s degree in computer science, engineering, or related field (Master’s degree is a plus).
• Demonstrated continued learning through one or more technical certifications or related methods.

Qualities:

• Self-motivated and focused on delivering outcomes for a fast-growing team and firm.
• Able to communicate persuasively through speaking, writing, and client presentations.
• Able to work with teams and clients in different time zones.
• Research focused mindset.