Job Description

JOB DESCRIPTIONJob Title: Lead Business IntelligenceJob Location: BangaloreLevel - 6 IAbout Syngene : Syngene ( ) is an innovation-led contract research, development and manufacturing organization offering integrated scientific services from early discovery to commercial supply.At Syngene, safety is at the heart of everything we do personally and professionally. Syngene has placed safety at par with business performance with shared responsibility and accountability, including following safety guidelines, procedures and SOPs, in letter and spirit

• Overall adherence to safe practices and procedures of oneself and the teams aligned
• Contributing to development of procedures, practices and systems that ensures safe operations and compliance to company's integrity & quality standards
• Driving a corporate culture that promotes environment, health, and safety (EHS) mindset and operational discipline at the workplace at all times.
• Ensuring safety of self, teams and lab/plant by adhering to safety protocols and following environment, health, and safety (EHS) requirements at all times in the workplace.
• Ensure all assigned mandatory trainings related to data integrity, health, and safety measures are completed on time by all members of the team including self
• Compliance to Syngene' s quality standards at all times
• Hold self and their teams accountable for the achievement of safety goals
• Govern and Review safety metrics from time to time

Core Purpose of the Role : The purpose of this job is to collaborate with business users to analyze business requirements to develop and manage BI solutions.Role Accountabilities:

• Design, develop and manage Power BI dashboards using data from multiple sources. Perform data quality analysis, validations, dimensional analysis, and data transformation.
• Integrate data sources and develop and maintain data models, database tables, views, and scripts. Write algorithm to extract, transform, load, and merge / link data sources.
• Perform end-to-end dashboard activities starting with requirements gathering, mapping to designing, extracting, transforming, loading, and validating.
• Perform data analysis, data visualization, dashboard development, statistical design and analysis, and data delivery with a strong focus on data quality and accuracy.
• Provide problem resolution and diagnostics on complex system/data issues.
• Collaborate with cross-functional stakeholders to identify, translate, and prioritize business needs into data terms to drive strategies and deliver advanced analytics. Perform data mining using state-of-the-art methods.
• Coordinate with external service providers to get the dashboards implemented as per plan. Verify the designs, architecture, solutions and certify as per best practices.

Syngene ValuesAll employees will consistently demonstrate alignment with our core values

• Excellence
• Integrity
• Professionalism

• Experience: With 9-12 years of working experience with Business Intelligence preferably Power BI

• Education: B. Tech / B.E. / MCA

Skills and Capabilities

• Experience of working with Data Analysis, Power BI and Databases like SQL Server, Oracle etc.
• Experience of developing dashboards using structured as well as unstructured data sources.
• BI Architecture design experience with exp of developing dashboards using data from multiple sources like SAP, Salesforce, QMS, LMS and other transactional systems.
• Experience of managing BI projects in coordination with internal & external stakeholders.
• Experience of working with Microsoft IR (Integration Runtime), Azure Data Factory, Azure data lake, Synapse, Blob storage, SQL. Working knowledge of DAX, MDX Queries, & SSAS.
• Strong knowledge of Object-Oriented Programming and RDBMS concepts.
• Ability to learn and adopt new data-related technologies.
• Solutions-focused, positive approach to problem-solving with the ability to work well both collaboratively and independently.
• Strong attention to details, excellent diagnostic and problem-solving skills.
• Ability to collect and finalize user requirements, ask probing questions to eradicate ambiguity
• Microsoft Power BI certification is a plus.

Syngene International