DataBricks Developer

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. 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.