Data and Analytics ETL Architect

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’ Global Capability Centres (GCCs) are strategically located sites that give Astellas the ability to access talent across various functions in the value chain and to co-locate core capabilities that are currently dispersed. Our three GCCs are located in India, Poland and Mexico.

The GCCs will enhance our operational efficiency, resilience and innovation potential, enabling a timely response to changing business demands.

Our GCCs are an integral part of Astellas, guided by our shared values and behaviors, and are critical enablers of the company’s strategic priorities, sustainable growth, and commitment to turn innovative science into VALUE for patients www.astellas.com.

This is a hybrid position and is based in Bangalore, India. 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.

Purpose and Scope:

As a Data and Analytics Architect 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.

Essential Job Responsibilities:

• Data Strategy Contribution: Contribute to the organization’s data strategy by identifying opportunities for data-driven insights and improvements.
• 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 (or equivalent experience.)
• 3+ years of experience using Qlik, PowerBI or equivalent technologies
• Analytical mindset and logical thinking.
• Familiarity with Business Intelligence and Data Warehousing concepts.
• Web integration skills (Qlik Sense).
• Advanced SQL knowledge.
• Understanding of stored procedures, triggers, and tuning.
• Experience with other BI tools (Tableau, D3.js) is a plus.
• Business Intelligence Tools:
• QLIK: Proficiency in designing, developing, and maintaining QLIK applications. Experience with QLIK Sense and QLIKView is highly desirable. Experience working with N-Printing, Qlik Alerting
• Expert 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 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.
• Ensure data security and compliance with privacy regulations (e.g., GDPR).
• Validate access controls and encryption mechanisms.
• 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
• Programming Languages:
• Basic understanding of SQL, Python, or R for data validation
• Data Analysis:
• Knowledge of statistical analysis and data visualization tools (e.g., Tableau, Power BI Posit)
• Pharmaceutical Domain:
• Understanding of pharmaceutical data (clinical trials, drug development, patient records).
• Attention to Detail: Meticulous review of requirements and data quality.
• 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 work effectively with other technical team members to agree best solution
• A self-starter able to work on own but know when to collaborate with wider team to ensure best overall solution.
• Experience working with data warehousing, data modelling and architecture
• Understanding of Qlik, Tableau and or PowerBI architecture or any equivalent technology
• Ability to install, configure and upgrade Qlik/ PowerBI or equivalent systems
• 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 track record with CI/CD pipelines for continuous delivery.
• Collaboration and Communication: Work closely with cross-functional teams, including data engineers, data scientists, and business stakeholders.

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.

"Beware of recruitment scams impersonating Astellas recruiters or representatives. Authentic communication will only originate from an official Astellas LinkedIn profile or a verified company email address. If you encounter a fake profile or anything suspicious, report it promptly to LinkedIn's support team through LinkedIn Help"

#LI-CH1