Senior Technology Analyst (SQL/Python)
Roche Holding AG
4 - 6 years
Chennai
Posted: 10/11/2023
Job Description
As a Sr.Technology Analyst, you will:
- Proactively maintain comprehensive knowledge of sales and claims data and other healthcare/pharmacy datasets, structure, meaning and intended downstream usage of any other data source as needed
- Directly perform and/or oversee the analysis of data acquired into data warehouse using coding or software to profile and standardize the data
- Analyze stakeholder reported data issues, performing root cause analysis, and identifying and implementing appropriate remediation.
- Opportunity to work on the Python / PySpark code enhancements.
- Develop dashboards in QuickSight / Tableau.
- Coordinate with external data vendors to address any data issues, questions and problems in accurate and timely manner
- Analyze new requests for data, identifying the appropriate datasets, and generating database queries and summary data outputs for stakeholders
- Have understanding of quality assurance and data quality principles
- Develop process improvements for data management and data quality activities
- Documenting processes and maintaining data records
- Handling of queries from stakeholders and resolving them.
Required Experience, Skills, Qualification:
- 4-6 years of previous experience working with key pharmaceutical/bio-technology data assets like Sales, Claims and other secondary data.
- Demonstrated experience with data analysis, profiling, data cleansing and standardization Process
- Excellent SQL skills to query database to perform data analysis to further enhance business analysis.
- Ability to demonstrate strong Microsoft Excel skills, including Pivots
- Strong understanding of database concepts and the advanced ability to query data using SQL
- Knowledge of Amazon S3, QuickSight/Tableau, Apache Airflow DAGs.
- Demonstrated ability to rapidly adapt to changing project and strategic requirements
- The position requires strong analytic and organizational skills, the ability to work independently, a high degree of expertise in data management/data quality practices and ability to manipulate data
- Ability to work independently and collaborate with colleagues to accomplish team goals and deadlines
Education:
- Bachelor’s or Master’s Degree (computer science, engineering or other technical disciplines)
About Company
F. Hoffmann-La Roche AG, commonly known as Roche, is a Swiss multinational healthcare company that operates worldwide under two divisions: Pharmaceuticals and Diagnostics. Its holding company, Roche Holding AG, has shares listed on the SIX Swiss Exchange. The company headquarters are located in Basel. Roche is the fifth-largest pharmaceutical company in the world by revenue and the leading provider of cancer treatments globally. The company controls the American biotechnology company Genentech, which is a wholly owned affiliate, and the Japanese biotechnology company Chugai Pharmaceuticals, as well as the United States-based companies Ventana and Foundation Medicine. Roche's revenues during fiscal year 2020, were 58.32 billion Swiss francs. Descendants of the founding Hoffmann and Oeri families own slightly over half of the bearer shares with voting rights (a pool of family shareholders 45%, and Maja Oeri a further 5% apart), with Swiss pharma firm Novartis owning a further third of its shares until 2021. Roche is one of the few companies increasing their dividend every year, for 2020 as the 34th consecutive year.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).