DataBricks Developer Data Modeler Python, Azure, AWS

Job description

Do you want to be part of an inclusive team that works to develop innovative therapies for patients?

Every day, we are driven to develop and deliver innovative and effective new medicines to patients and physicians.

If you want to be part of this exciting work, you belong at Astellas!

Astellas Pharma Inc.

is a pharmaceutical company conducting business in more than 70 countries around the world.

We are committed to turning innovative science into medical solutions that bring value and hope to patients and their families.

Keeping our focus on addressing unmet medical needs and conducting our business with ethics and integrity enables us to improve the health of people throughout the world.

For more information on Astellas, please visit our website at www.astellas.com .

This position is based in Bangalore, India.

We recognize the importance of work/life balance & believe in optimizing the most productive work environment for all employees to succeed and deliver.

**Purpose and Scope:**

As a Developer specializing in Business Intelligence (BI) and ETL (Extract, Load, Transform) technologies, you will play a crucial role in designing, developing, and optimizing data solutions for our organization.

Your expertise in BI tools and ETL processes will contribute to the success of our data-driven initiatives.

You’ll leverage your expertise in Qlik Sense, Tableau, and ETL technologies such as Talend, DataBricks or dbt to drive informed decision-making within the organization.

Collaboration, leadership, and problem-solving skills are essential in this role.

**Essential Job Responsibilities:**

+ Business Intelligence Tools:

+ QLIK/Tableau: Proficiency in designing, developing, and maintaining QLIK/Tableau applications.

Experience with QLIK Sense and QLIKView is highly desirable.

Experience working with N-Printing, Qlik Alerting

+ Proficient at creating and consuming complex Qlik/PowerBI data models

+ Power BI: Strong expertise in creating interactive reports, dashboards, and visualizations using Power BI.

Knowledge of DAX (Data Analysis Expressions) is essential and Power Automate (MS Flow) or PowerBI alerts.

+ Data Modeling and Integration:

+ Best practice knowledge of modelling data that is to be consumed by QlikSense or PowerBI
+ Ability to design, develop and implement logical and physical data models.
+ Familiarity with data warehousing concepts, including star schema, snowflake schema, and data marts.
+ Understanding of ETL (Extract, Transform, Load) processes and data integration techniques.

+ SQL and Database Management:

+ Proficiency in SQL for querying and manipulating data.
+ Knowledge of database management systems (e.g., SQL Server, Oracle, MySQL).

+ Data Governance and Quality:

+ Understanding of data governance principles, data lineage, and metadata management

+ Experience ensuring data quality, consistency, and accuracy
+ Experience performance tuning BI data models and reports to ensure apps are responsive to users’ needs
+ Proven skill at creating dashboards of pixel perfect quality
+ The ability to work with end users to uncover business requirements and turn these into powerful action orientated applications.
+ Create and maintain technical documentation
+ Ability to communicate and collaborate effectively with other technical team members to agree best solution
+ An initiative-taker able to work on own but know when to collaborate with wider team to ensure best overall solution.
+ Experience working with data warehousing and data modelling
+ Understanding of Qlik, Tableau and or PowerBI architecture or any equivalent technology
+ Ability to install, configure and upgrade Qlik/ PowerBI or equivalent systems
+ Conducting Unit Testing and troubleshooting BI systems
+ Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics
+ Data Validation and Quality Assurance:

+ Execute manual and automated development on data pipelines, ETL processes, and analytical models.
+ Verify data accuracy, completeness, and consistency.

Identify anomalies, discrepancies, and data quality issues.
+ Ensure compliance with industry standards (e.g., GxP, HIPAA).

+ Ensuring Data Security and Compliance with relevant internal, global and or regional regulation
+ Assist users with ad-hoc queries and data troubleshooting.
+ Use analytics to understand root causes and drive decision-making for customer acquisition and retention.
+ Analytical Thinking: Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement.
+ Agile Champion: Adherence to DevOps principles and a proven history with CI/CD pipelines for continuous delivery.

**Responsibilities** :

+ Development of Ownership:
+ Collaborating with senior developers to support key development projects related to our Data Warehouse and other MI systems.
+ Collaborate with senior team members within a multi-skilled project team.
+ Contribute to the efficient administration of multi-server environments.
+ Participate in smaller focused mission teams to deliver value driven solutions aligned to our global and bold move priority initiatives and beyond.
+ Design, develop and implement robust and scalable data analytics using modern technologies.
+ Collaborate with cross functional teams and practices across the organization including Commercial, Manufacturing, Medical, DataX, GrowthX and support other X (transformation) Hubs and Practices as appropriate, to understand user needs and translate them into technical solutions.
+ Provide Technical Support to internal users troubleshooting complex issues and ensuring system uptime as soon as possible.
+ Champion continuous improvement initiatives identifying opportunities to optimize performance security and maintainability of existing data and platform architecture and other technology investments.
+ Participate in the continuous delivery pipeline.

Adhering to DevOps best practices for version control automation and deployment.

Ensuring effective management of the FoundationX backlog.
+ Leverage your knowledge of data engineering principles to integrate with existing data pipelines and explore new possibilities for data utilization.
+ Stay-up to date on the latest trends and technologies in data engineering and cloud platforms.

**­­­­­­Qualifications:**

**Required**

+ Bachelor's degree in computer science, Information Technology, or related field (Master’s preferred) or equivalent experience
+ 3-5+ years’ experience as a Developer or Data Analyst within a Pharmaceutical or working within a similar regulatory environment.
+ Analytical Thinking: Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement.
+ Familiarity with Business Intelligence and Data Warehousing concepts.
+ Web integration skills (Qlik Sense).

Experience with other BI tools (Tableau, D3.js) is a plus.
+ Strong SQL expertise and database design skills.
+ Understanding of stored procedures, triggers, and tuning.
+ Subject Matter Expertise: possess a strong understanding of data architecture/ engineering/operations/ reporting within Life Sciences/ Pharma industry across Commercial, Manufacturing and Medical domains.
+ Other complex and highly regulated industry experience will be considered across diverse areas like Commercial, Manufacturing and Medical.
+ Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics and modelling tools.
+ Technical Proficiency: Strong coding skills in SQL, R, and/or Python, coupled with expertise in machine learning techniques, statistical analysis, and data visualization.
+ Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.

**Other critical skills required**

+ Cross-Cultural Experience: Work experience across multiple cultures and regions, facilitating effective collaboration in diverse environments.
+ Innovation and Creativity: Ability to think innovatively and propose creative solutions to complex technical challenges.
+ Global Perspective: Demonstrated understanding of global pharmaceutical or healthcare technical delivery, providing exceptional customer service, and enabling strategic insights and decision-making.

**Preferred**

+ Experience working in the Pharma/ Lifesciences industry.
+ Experience in storytelling with data
+ Visualization best practices
+ Knowledge/experience using Qlik, or PowerBI SaaS solutions.

**Working Environment**

At Astellas we recognize the importance of work/life balance, and we are proud to offer a hybrid working solution allowing time to connect with colleagues at the office with the flexibility to also work from home.

We believe this will optimize the most productive work environment for all employees to succeed and deliver.

Hybrid work from certain locations may be permitted in accordance with Astellas’ Responsible Flexibility Guidelines.

#LI-CH1

Category FoundationX
Astellas is committed to equality of opportunity in all aspects of employment.
EOE including Disability/Protected Veterans

Required Skill Profession

Other General