BI & Data Warehouse Data Engineer

• Collaborate with FoundationX Engineers to design and maintain scalable data systems.

• Assist in building robust infrastructure using technologies like PowerBI, Qlik or alternative, Databricks, PySpark, and SQL.

• Contribute to ensuring system reliability by incorporating accurate business-driving data.

• Gain experience in BI engineering through hands-on projects.

Data Modelling and Integration:

• Collaborate with cross-functional teams to analyze requirements and create technical designs, data models, and migration strategies.

• Design, build, and maintain physical databases, dimensional data models, and ETL processes specific to pharmaceutical data.

Cloud Expertise:

• Evaluate and influence the selection of cloud-based technologies such as Azure, AWS, or Google Cloud

• Implement data warehousing solutions in a cloud environment, ensuring scalability and security.

BI Expertise:

• Leverage and create PowerBI, Qlik or equivalent technology for data visualization, dashboards, and self-service analytics.

Data Pipeline Development:

• Design, build, and optimize data pipelines using Databricks and PySpark. Ensure data quality, reliability, and scalability.

• Application Transition: Support the migration of internal applications to Databricks (or equivalent) based solutions.

• Collaborate with application teams to ensure a seamless transition.

• Mentorship and Leadership: Lead and mentor junior data engineers. Share best practices, provide technical guidance, and foster a culture of continuous learning.

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