Astellas Pharma

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 decisionmaking within the organization. Collaboration, leadership, and problem-solving skills are essential in this role.Essential Job Responsibilities: • Business Intelligence Tools: o 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 o 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: o Best practice knowledge of modelling data that is to be consumed by QlikSense or PowerBI o Ability to design, develop and implement logical and physical data models. o Familiarity with data warehousing concepts, including star schema, snowflake schema, and data marts. o Understanding of ETL (Extract, Transform, Load) processes and data integration techniques. • SQL and Database Management: o Proficiency in SQL for querying and manipulating data. o Knowledge of database management systems (e.g., SQL Server, Oracle, MySQL). • Data Governance and Quality: o 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: o Execute manual and automated development on data pipelines, ETL processes, and analytical models. o Verify data accuracy, completeness, and consistency. Identify anomalies, discrepancies, and data quality issues. o 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: o Collaborating with senior developers to support key development projects related to our Data Warehouse and other MI systems. o Collaborate with senior team members within a multi-skilled project team. o 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.

Job Details

Skills Required

More Details

Easy Apply